Manager/Data Architect of Data Warehouse/Business Intelligence
Resume:
PARAG R. SHAH
Woburn, Ma *****
****.*****.*@*****.***
EXPERIENCE
Endurance Int’l Group(Burlington, MA)
Mar 2016 to Current
Sr Manager/Data Architect, Business Intelligence
●Create SSIS packages and set a pace for ETL development to increase development speed.
●Implement SSIS best practices for team to follow
●Implement T-SQL code best practices
●Interview, hire and act as a mentor and manager to junior, mid-level, and senior developers for both ETL and BI.
●Ensure deadlines are met and projects stay on track.
●Act as data architect on all projects.
●Work as a member of an agile team and help the team come up to speed with true Agile practices.
●Work closely with finance and sys ops leadership teams to create a reasonable road map.
●Manage 5 FTE’s
oSr ETL Developer, Sr BI Developer, Mid level ETL Developer, Mid level Bi Developer, Data Scientist and a Jr ETL developer
●Manage 3 on-site consultants
●Manage 7 offshore consultants
●Juggle multiple efforts while championing the cause of the BI team.
●Architect 2 MS SQL Server 2016 Environments
oFinance cluster - 2 node active-passive cluster with high availability configured
oBI Cluster - 3 node db cluster using availability groups 2 active 1 passive. Active node for SSRS database plus one active node for analytics and 24/7 access. 2 node SSRS/SSAS cluster.
●Annual budgeting - Manage $4 Mil budget of FTE's, Contractors, Hardware and Software
AmerisourceBergen Specialty Group (Burlington, MA)
Sep 2012 to Mar 2016
Business Intelligence Lead/Manager
●Create Business Requirements Documents and Technical Specs.
●Create SSIS templates to assigned developers to copy and complete projects.
●In charge of professionalization of all data.
●Interview, hire and act as a mentor and manager to junior and mid-level developers.
●Ensure deadlines are met and projects stay on track.
●Write complex T-SQL queries for reporting.
●Create and update ETL jobs using SSIS.
●Act as architect on smaller projects.
●Work as a member of an agile team and backup scrum master.
oOncology Data Team
oFinancial Data Team
oUrology Data Team
●Worked with oncology, urology and financial data.
Bank of America Corporation (Boston, MA)
Oct 2010 to Sep 2012
Sr. Compliance Manager
●Provide leadership and guidance to junior members of the team.
●Evaluate and Implement new business intelligence strategies for Global Compliance Risk.
●Work with Technology team to update and release stored procedures, functions and views.
●Use SQL Server Reporting Services (SSRS) to develop reports, dashboards and scorecards.
●Deploy SSRS reports to Microsoft SharePoint Services.
●Advise Technology on all SSRS decisions as an SSRS Subject Matter Expert (SME).
●Advise Technology to on all SQL Server Integration Services (SSIS) package decisions as an SSIS SME.
●Create Business Requirement Documents (BRD) for new application initiatives.
●Write requirements for infrastructure related to self service reporting.
Bullhorn Software (Boston, MA)
May 2009 to Oct 2010
Sr. Professional Services Engineer
Designing, documenting, and creating customized technical solutions to meet customer software requirements and specifications to include:
●Data Migrations involving conversion of data from various database sources (DBASE, Oracle, SQL Server, FoxPro, Paradox, ACT, Microsoft Access, Outlook) into Bullhorn SQL Server databases
●Data mappings and transformations between Client’s data and Bullhorn system by constructing and executing SSIS/DTS packages.
●Working closely with customers and Professional Services team to ensure comprehensive and accurate transfer of information.
●Work closely with the Manager of Consulting Services to establish SSIS/DTS frameworks and best practices.
●Performing data analysis on client data, and providing feedback to client.
●Writing custom data exports to be run on an Ad hoc basis.
●Writing custom reports using Bullhorns proprietary reporting tool.
●Evaluate new reporting tools to replace Bullhorns outdated proprietary tool.
●Provide leadership and guidance to junior members of the team.
Clearpoint Metrics (Burlington, MA)
Aug 2008 to May 2009
Data Specialist/Implementation Engineer
●Manage 5 client implementations including Estee Lauder, GE, Kaiser Permanente
●Write/Edit tabular, dashboard, and scorecard reports using Eclipse based proprietary software to be run on a subscription basis.
●Installing and upgrading clients using proprietary metrics product.
●Writing data migration scripts to upgrade client data.
●Write/Tune SQL queries (using SQL Server, Postgres SQL, Oracle, and MySQL) to be built into JDBC data adapters.
●Proprietary Software training.
●Interfacing with high level executive management at client sites.
●Assist sales in a pre-sales capacity to bring in new clientele.
Beacon Health Strategies (Woburn, MA)
Jun 2008 to Aug 2008
Senior Report Developer - Contract
●Build Reports in Crystal Reports.
●Deploy reports to Business Objects.
●Run reports and email to business users.
Leerink Swann & Company (Boston, MA)
June 2006 to June 2008
Senior SQL Developer
●Write/Edit reports using Microsoft Reporting Services to be run on Ad Hoc and Subscription basis.
●Producing dashboard reports.
●Created data marts Microsoft SQL Server 2000/2005 for producing Scorecards.
●Designing data feeds using DTS/SSIS to import and format external data for internal use
●Write/Tune views and stored procedures for reporting purposes, and to process imported data.
●Create SQL jobs to automate external data processing.
●Designing and tuning production database tables.
●Manage 8 offshore .NET developers.
EDUCATION:
University of Massachusetts at Lowell
2005: B.S., Management Information Systems
Contact this candidate