SUMMARY:

• Very motivated and experienced IT Strategist with track record of design and development of successful BI solutions incorporating a wide range of tools and technologies.
• Exceptional leadership qualities that align with the business process, program and culture
• Oversee and lead all phases of project lifecycle, from concept to delivery, change management, and assessment of end - user needs while efficiently resolving IT issues
• Experience with several large full life cycle BI projects
• Expert in BI Dashboard and Reporting
• Exemplary track record of success in planning and execution

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Senior Database Architect, Business Intelligence & Analytics

Responsibilities:

• Responsible for the System Integration for Business Intelligence Solutions Leading the BI team for Architecture, Modelling, implementation and maintenance Setting the strategy and vision for a consolidated business model that integrates into overall ITSM strategy Taking leads in design and development of several dashboards for finance, sales and supply chain Collaborating with IT business partners and Project managers for ongoing projects and new requirements
• Managing infrastructure and human resources for BI
• Developing logical and physical models to facilitate new business requirements. Develop and manage the annual IT budget for BI Application Services Utilizing agile and waterfall software development methodologies Automating legacy manual reporting and analysis processes

Environment: IFS ERP System, Pivotal CRM, SQL Server, SSAS, SSIS, Power BI, BO, Oracle 10g, Tableau

Confidential, Boston, MA

Lead BI Architect

Responsibilities:

• Lead the DW/BI effort to help business drive self-service BI tools.
• In charge of production analysis and database servers.
• Designed relational and dimensional databases and workflow process.
• Developed logical and physical models to accommodate business requirements.
• Developed huge data cubes using Microsoft Semantic model tabular SSAS.
• Modelled new additions to the warehouse in snowflake schema.
• Tweaked existing ETL packages for performance and scaling.
• Owned the responsibility of all SSAS tabular servers and Cube development.
• Implemented Tableau on premise server and Power BI on cloud.

Environment: SQL Server, SSAS, SSIS, Tableau, ERWIN, Power BI, DAX

Confidential, Weston, MA

BI Solutions Architect, Data Analytics

Responsibilities:

• Designed the repositories to capture compliance data from several systems.
• Worked with PMs and BAs to understand business requirement.
• Analyzed data sources and comparing with legacy systems to resolve mapping issues.
• Involved in gap analysis exercise between new and legacy DW objects using SSIS.
• Analyzed gaps between requirement and availability.
• Developed several dashboards with many compliance requirements for Federal and States.
• Involved in designing the future process of globalizing the compliance analytics system.
• Gathered reporting and analysis requirement and made judgment for best representation.
• Involved in reconciliation of compliance reports against source data before submission.
• Mentored junior developers and interns in understanding technology and business.

Environment: Oracle 12c, SQL Server, SSIS, SSRS, Business Objects 4, SharePoint, Tableau, Informatica, SQL developer, Visio, Siebel, Veeva MDM

Confidential, Southborough, MA

Senior DW Developer/Analyst, Data Intelligence (HCM System)

Responsibilities:

• Participated in complex data analysis and reporting for core HR System.
• Actively involved in HCM (Human Capital Management) migration from PeopleSoft to SAP SuccessFactor.
• Analyzed data sources and comparing with legacy systems to resolve mapping issues.
• Involved in data mapping exercise between new and legacy DW objects using SSIS.
• Designed ODS data model and multi-dimensional models for Cubes.
• Designed/reviewed data warehouse workflow process for performance upgrade and overhead reduction.
• Liaised with product managers and end-users to better understand the requirement.
• Frequently met PMs, BAs and stake holders for product issues.

Environment: SQL Server 2012/2014, SSIS, SSRS, SSAS, Visual Studio 2013, SharePoint, Power BI

Confidential, Wellesley, MA

Senior BI/Analytics Consultant

Responsibilities:

• Assisted solution architect for BI and data warehouse design and development.
• Planned the migration process from On Premise to Cloud (both PaaS and IaaS).
• Designed and developed data model for BI Application. Assisted the application development team in database fine-tuning.
• Involved in Data base administration including performance tuning and maintenance plans.
• Developed ETL packages to migrate SQL Server data to AZURE.
• Coordinated with DBA and Infrastructure team to ensure smooth operations.
• Used Confio and other 3rd party tools to monitor performance and troubleshoot issues.

Environment: SQL Server 2012/2014, SSRS, SSAS, Redgate SQL Toolbelt, Microsoft Azure, Visual Studio 2013, Visio

Confidential

Senior BI Consultant, IT Security and Compliance

Responsibilities:

• Designed Logical and Physical data model for Data warehouse.
• Collaborated with other security teams for source data analysis.
• Faced internal/external customers for product requirements.
• Worked extensively with Universal Configuration Management Database Adhered to SOX compliance and other IT security protocols.
• Designed all technical high level workflow documentation and customer presentation.
• Developed KPI Dashboards, scorecards etc. for analytics.
• Developed and implemented ETL processes using SSIS for regular data load to warehouse.

Environment: SQL Server 2012, SSIS, SSRS, SSAS, MS Dynamics 2011, Windows 2008 R2, Visual Studio 2012, MDM

Confidential, Billerica, MA

Principal DW/BI Engineer

Responsibilities:

• Took leadership in designing the BI/DW.
• Designed Logical and Physical data models for Data warehouse.
• Collaborated with CRM developers' team for application knowledge.
• Faced internal/external customers for product requirements.
• Developed high level KPI Dashboards for business analysis.
• Applied technical knowledge in all areas of BI architecture.
• Responsible for design and implementation of high performance, scalable BI Architecture.
• Provided leadership to the development team and BAs.
• Coordinated with technical operations team to ensure smooth operations.

Environment: SQL Server 2012, SSIS, SSRS, SSAS, MS Dynamics 2011, MDM, ERWIN, Visio

Confidential, Quincy, MA

Manager, EDW & BI Analytics

Responsibilities:

• Managed the data warehouse team and relevant operation.
• Designed and implemented ETLs from various systems.
• Provided technical leadership to the team for efficient BI solutions.
• Project Management through SDLC.
• Evaluated 3rd party IT solutions for BI requirements.
• Managed a team size of 8 people from development and Project Office.
• Kept track of change management and product release.
• Conducted performance reviews of all sub-ordinates periodically.

Environment: SQL server 2008 R2/2012, SSAS, SSRS, Oracle 11i, Qlikview, Visio, MicroStrategy, SharePoint 7

Confidential, Boston, MA

Data Warehouse & Report Developer

Responsibilities:

• Worked as Tech-lead Data Warehouse and BI team.
• Designed and developed several data marts.
• Redesigned the reporting environment and maintained BI documents.
• Regularly involved in key data analysis and discrepancy investigation.
• Supervised/mentored other BI and database developers.

Environment: SQL Server 2000/2005/2008, SSRS, SSIS, SSAS, Visio, MS DynamicsCRM, TOAD Analysis

Confidential, Boston, MA

Senior BI Analyst

Responsibilities:

• Analyzed the legacy database to come up with logical physical data model plans.
• Helped off-shore team in carrying out database tasks for application development.
• Designed and developed ETL plans for database migration.
• Developed business reports (incl. ad-hocs) and data warehouse loading comparison reports.

Environment: SQL Server 2000, Informix, Informatica, Erwin, DTS, SSIS, Charles River IMS, Metavante, Oracle, DTS, SSIS, Crystal Reports

Confidential, Boston, MA

Senior Systems Engineer

Responsibilities:

• Sole responsibility of CRM reporting environment based on Siebel CRM and other data sources.
• Development, administration and maintenance of enterprise reporting system.
• Liaised between business analysts and developers.
• Developed Oracle Financial concurrent programs and packages.

Environment: Windows XP, Crystal 10, Oracle eBusiness, Oracle 9i/10g, SQL Server 2000, Siebel 7.8, SharePoint, PVCS

Confidential, Boston, MA

Database Devekoper

Responsibilities:

• Designed and developed financial reports showing fund performance Helped off-shore team in carrying out database tasks for application development.
• Deveoped ETLs for database migration from various sources Developed business reports (incl. ad-hocs) and data warehouse loading comparison reports.

Environment: SQL Server 2000, SSIS, Charles River IMS, Metavante, Crystal Reports, iAvenue