VISHAL SHAH
Senior Business Intelligence Developer
Middletown,CT
Summary
Enthusiastic technical professional with complete understanding of entire software development lifecycle. Highly trained in [Task] and [Task] and known for having talents in [Skill] and [Skill].
Overview
13
13
years of professional experience
Work History
Senior Business Intelligence Developer
American Eagle Financial Credit Union
06.2018 - Current
- Created and maintained strategic, scalable analytics solutions as well as their underlying databases.
- Designed, developed, and maintained strategic business level reports to various business areas.
- Find trends in fraud activity to avoid online and branch fraudster activities.
- Use SavvyMoney to find business opportunities by finding products to offer to existing and probable customers by finding trends in online spending and products they have with other banks.
- Developed ETL packages using SSIS to automate existing reporting and business processes, including loading data different vendors.
- Created ad-hoc reports using moderate to complex T-SQL scripts.
- Created PHP web solutions for providing front end CRM type capabilities.
- Created python scripts to automate download of files from secure vendor websites and SFTP solutions.
- Interface with third party vendors to integrate existing data into the data warehouse.
- Designed systems using best practices to reduce technology debt.
- Provided functional insight in the following areas: SQL Server, SSRS, SSIS, and emerging features.
- Monitored and trouble shot problems with SSIS jobs to ensure they executed properly.
- Provided technical mentorship of Business Intelligence department staff, including reviewing their work, and assisting them with technical challenges.
- Facilitated collaboration and communication with internal business customers to understand data needs, clarified requirements, and established priorities.
- Created thorough documentation of all data designs and programming efforts.
Database Analytics and Reporting Developer
Community Health Center
10.2012 - 06.2018
- In conjunction with IT Management, data owners and business units, developed models, procedures, and protocols in concert with company goals.
- Trained new hires and existing team members on various projects.
- Managed, assigned and tracked ad-hoc data requests among various team members.
- Conversion of existing SSRS reports to Tableau and conversion of SQL ETL (stored procedures) to SSIS.
- Reports and dashboards led to major improvements on various key metrics for quality based care.
- Led the transformation from visit based care to quality based care program of the state (PCMH).
- Defined and generated performance appraisal metrics to increase medical productivity.
- Generated Uniform data system (UDS) and grant reports for the state (Connecticut).(Medicare, Medicaid and uninsured patients).
- Generate reports on HEIDIS measures.
- Analyzed call center data and came up with a system to significantly lower dropped calls from around 15% to 1-2%.
- Met with systems owners, business analysts and end users to define requirements and goals.
- Coordinated the creation and management of dashboard, scorecard, reporting and analysis presentation, structures and data using SSRS and Performance Point.
- Prioritized requests within the data team.
- Designed data visualizations to determine the best way to present data to end users using drilldowns, tables, gauges, graphs, charts and other intuitive graphical add-ons.
- Prepared and delivered reports, analytics and interactive intelligence in systems across the organization.
- Developed and maintain ETL and data warehousing processes and measures.
- Advised managers and stakeholders regarding appropriate, effective, and efficient use of organizational data capabilities and functions.
- Facilitated implementation of improved business intelligence and reporting processes.
- Coordinated post-implementation support, including end-user reviews, for modified and new data visualizations.
- Deployed and maintained reports on to SharePoint.
SQL Developer
Compas Inc
10.2011 - 10.2012
- Hands-on experience with the following MicroStrategy components: Architect Desktop, Schema Objects, MicroStrategy Administrator, OLAP Services, BI Developer Kit, Intelligence Server, Object manager, Narrowcast Server, Report Services and Web, Dashboard.
- Architect and re-architect existing datawarehouse and MS model.
- Develop OLAP ad-hoc reports using Microstrategy.
- Create fully functional dashboards for medical clients.
- Install, Configure and troubleshoot Micrsotrategy projects.
- Maintain and support MSTR reports to facilitate automatic scheduled processing using Microstrategy Narrowcast.
- Translate business requirements into system design.
- Use SSIS to create ETL packages to load datawarehouse with data from publishers and clients.
- Developed efficient ETL mappings by applying standard procedures, unit test and implement ETL routines and preparing supporting documentation.
- Analyzed source data, target data structures and ETL maps to contribute towards troubleshooting of production reporting issues.
- Create and optimize T-SQL scripts to optimize web performance.
- Tune in-house and customer database.Performed tuning for multiple customer website database.
- Create and optimize maintenance plans.
Database Administrator
J. L. B. Trading Corp
10.2009 - 10.2012
- Designed and documented the database using MS Toad.
- Created database schemas, tables, procedures and permissions.
- Created Stored Procedures and triggers supporting the point of sales software being used.
- Performed analysis and sustained capacity and performance requirements.
- Analyzed, consolidated and tuned database for optimal efficiency.
- Performed backup and restore operations, mirroring and replication.
- Developed database utilities and automated reporting directly to customers and vendors as per their requirements.
- Generated reports (Cognos & SSRS) for market & product analysis (SSAS) assisting in business planning.
- Restored and recovered corrupted Access databases.
- Migrated data from SQL Server 2000 to SQL Server 2005.
Education
Master of Science (M.S) - Telecommunication Systems Management
Northeastern University
Bachelor of Engineering (B.E) - Electronics and Telecommunication
Thakur College of Engineering, Mumbai University, JRD
Diploma - Electronics And Telecommunication
Thakur Polytechnic
05.2000 - 05.2003
Skills
Business Intelligence (BI)
Data Visualization
Data Warehousing
Advanced Data Mining
ETL
Data Structures
Data Visualization
Automation Using Python
Information gathering
Problem-solving
Design & Analysis
Pattern/Trend recognition
Timeline
Senior Business Intelligence Developer
American Eagle Financial Credit Union
06.2018 - Current
Database Analytics and Reporting Developer
Community Health Center
10.2012 - 06.2018
SQL Developer
Compas Inc
10.2011 - 10.2012
Database Administrator
J. L. B. Trading Corp
10.2009 - 10.2012
Diploma - Electronics And Telecommunication
Thakur Polytechnic
05.2000 - 05.2003
Master of Science (M.S) - Telecommunication Systems Management
Northeastern University
Bachelor of Engineering (B.E) - Electronics and Telecommunication
Thakur College of Engineering, Mumbai University, JRD