SUMMARY:

To pursue a challenging career as a lead BI Professional and to contribute in the design and delivery of high quality Decision Support Systems, that can deliver data and report in “easy & efficient” way per client business requirements.

PROFESSIONAL SUMMARY:

• Microsoft Certified IT Professional in Business Intelligence Development and Maintenance with 12 years of rich implementation experience in BI technologies that includes experience on ETL, Data quality and reporting
• Technical Lead/ Program manager with a combination of communications and technical skills to lead the evolution and development of the project.
• Strong understanding of Data quality, Master data management and Data warehousing concepts. Knowledge in Data mart development, ER Modeling and Data - Flow Modeling
• Strong skills and experience in Microsoft BI stack, SQL, Integration & Analysis Services and Power BI.
• Handled architecture design and implementation of data-driven systems / reporting solutions on Microsoft Azure technologies including Azure SQL, Azure Data Factory, Azure analysis Services, Sql Data Warehouse and Cognitive Services.
• Developing ETL platform to acquire and integrate data from diverse sources like Azure Sql Server, Azure Blob Storage, Azure Data Lake or COSMOS, Azure Databricks, SQL Server, flat files etc.
• Hands on experience in Big Data technologies like Azure Databricks, ADLA or COSMOS.
• Leading software design, Code reviews to ensure consistently high level of design and implementation
• Experience in Azure Cost Management solution that helps you monitor and control Azure spending and optimize resource use
• Record of success with program management in the software industry with strong knowledge of Agile best practices.
• Scrum Master for the team, running daily standups, sprint retrospectives and owning the overall engineering process for the team.
• Experience working with Azure DevOps (formerly VSTS) as a system administrator
• Work with users and stakeholders to gather feedback, clarify requirements, create user stories with acceptance criteria and prioritize work.
• Persuasive communication skills to clearly explain technical topics to business users and Demonstrated skills using data and analytics to make smarter business decisions

TECHNICAL / TOOLS SKILLS:

Databases: MS SQL Server 2016/2014/2012/2008 , Azure Sql Database, Azure Sql Data Warehouse

Cloud Technologies: Azure Data Factory, Azure Blob Storage, Azure Data Lake Storage, Azure Data Bricks, Azure Logic Apps, Azure Web Search, Azure cognitive Services

Database Tools: SSMS, Business Intelligence Development Studio (BIDS), SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, Database Engine Tuning Advisor

Reporting Tools: Power BI, SQL Server Reporting Servickinges (SSRS), Microsoft Share Point (PPS)

Data Modeling: ERWIN, SSAS (multi-dimensional & tabular model), Azure Analysis Services (AAS)

ETL Tools: SQL Server Integration Services (SSIS), Azure Data Factory (ADF), Informatica

Operating System: Windows 2010/7/8.1/8/7 , Windows Server 2008 R2

Applications / IDE: Visual Studio 2017/15/13/12/10 , Adobe Photoshop, MS-Office, MS-Project

PROFESSIONAL EXPERIENCE:

Confidential

Project Lead

Technology: Azure Sql Server, Azure Data Factory, Azure analysis Services, Azure Data Bricks, Power BI

Responsibilities:

• Planned, Lead and executed the transition of the project from the previous vendor team.
• Lead the requirement gathering meetings, writing/reviewing of requirements, interaction with business consultants and stakeholders.
• Involved in writing / reviewing the Requirement documents, High level design documents and Low level design documents.
• Lead the Dev team and handled architecture design and implementation of data-driven systems / reporting solutions on Microsoft Azure technologies.
• Involved in source data analysis and identified business rules for data migration and for developing data warehouse data marts.
• Scrum Master for the team, running daily standups, sprint retrospectives and owning the overall engineering process for the team.
• Work with users and stakeholders to gather feedback, clarify requirements, create user stories with acceptance criteria and prioritize work.
• Involved in design and lead the implementation end to end data from data acquisition, ETL, data model and reporting.
• Developed ETL platform to acquire and integrate data from diverse sources like Azure Sql Server, Azure Blob Storage, Azure Data Lake or COSMOS, Azure Databricks, SQL Server, flat files etc.
• Wrote complex transformations in Azure Data Bricks with basic knowledge in python
• Designed tabular model using SSAS cubes, Created Hierarchies, Aggregations, partitions, calculated members and KPIs in Dimensional Modeling and implemented row level security.
• Developed Power BI reports and dashboards from multiple data sources with standardized UX

Confidential

Technology Lead

Technology: Azure Sql Server, Azure Data Factory, Azure analysis Services, Power BI

Responsibilities:

• Facilitate requirement gathering interviews, conduct workshops, issue clarifications, review documentation
• Lead the estimation, review the estimates and communicate to all the stakeholders
• Participate in creating application architecture document to provide deliverables in line with architectural requirements.
• Applying architectural and engineering concepts to design a solution that meets operational requirements, such as scalability, maintainability, security, reliability, extensibility, flexibility, availability and manageability
• Create the azure based Architecture of the interaction insights platform where the audio files are stored in azure blob storage and the metadata in azure sql database.
• Create a role based presentation layer based on azure active directory.
• Involved in design of the speech to text model by creating the customized language models and acoustic models tailored to the application and users using Microsoft Custom Speech Service.
• Design the ETL workflows for the end to end data flow including executing the RCBS downloader to extract the audio files and the metadata associated with them as json files. Apply business logic throttling, decrypt and store required audio files in azure blob storage and parse the metadata from the json files and store them in the azure sql database.
• Designed tabular model using SSAS cubes, Created Hierarchies, Aggregations, partitions, calculated members and KPIs in Dimensional Modeling and implemented row level security.
• Developed Power BI reports and dashboards from multiple data sources with standardized UX
• Involved in design the presentation layer for the application to sign in to the platform with Microsoft Active Directory credentials and have role based access to play or pause or resume or forward or rewind the selected calls audio recordings.
• Design the custom acoustic model based on the sample audio files and their correct transcripts to create a speech to text endpoint specifically for the application which can provide speech recognition services to all the audio recording ingested through the etl workflows.
• Serve as the interface between the developers and the customer
• Act as a mentor for the developers on the team
• Communicate technical issues or decisions effectively to PM and Sponsor by using business terms
• Communicate interdependencies across multiple team within own area, drives convergence across these teams to ensure smooth functioning of the teams

Confidential

Technology Lead

Technology: SSIS 2012, Sql Server 2012

Responsibilities:

• Leading the DevOps team for Developing SSIS ETL packages for data flow mainly from COSMOS.
• Perform analysis of the features and performance of the existing data mart and develop solutions for the improvement of the business reporting needs or performance of the same using Sql server and SSIS.
• Developed ETL platform to acquire and integrate data from diverse sources like Azure Sql Server, Azure Blob Storage, Azure Data Lake or COSMOS, Azure Databricks, SQL Server, flat files etc.

Confidential

Technical Lead

Technology: SSIS 2012, SQL Server 2012

Responsibilities:

• My role included leading the team of ETL developers, to perform data analysis of the existing legacy ERP system and come up with transformation rules for the new SAP ERP system. Developing the ETL logic using SSIS 2012 and help the SAP team load the same into the new ERP system. I was also involved in the QA activities.

Confidential

Product Technical Lead

Technology : SharePoint 2010, SSAS 2008, PPS 2010, SQL Server 2008

Responsibilities:

• My role was in the implementation of the ITSM management SLA management module modules across various clients.
• My responsibility included working with Tech architects and functional consultants to perform the feasibility analysis for implementation of the product in the client network and infrastructure.
• Implement the generic frame work of the product in SharePoint 2010 using MSBI technologies.

Confidential

Product Developer

Technology: SSAS 2008, PPS 2010, SQL Server 2008

Responsibilities:

• My responsibility included working with Tech architects and functional consultants to finalize the generic dimensional model and build them in SQL server 2008, populate sample data into the model using SSIS ETL.
• Design the MDBMS with relevant cubes and dimensions build them in SSAS 2008 and create the required dashboards with scorecards and reports in SharePoint 2010 using Performance Point Services.

Confidential, New York

ETL Developer

Technology : SSIS 2005, SQL Server 2005, Oracle 9i, TOAD

Responsibilities:

• My responsibility included gathering users requirements, analysis, design, development, testing and then user .
• Worked extensively on data warehouse design that includes designing different fact and dimension tables in SQL server 2005
• Developing SSIS 2005 packages to extract data from Oracle Source perform relevant transformations and load the data into fact and dimension tables (SCD-2).
• Developing views and stored procedures for reporting purposes and tune SSIS packages for optimal performance.
• Configure packages using SSIS configurations, setup logging, error and event handling and package transactions; implement scalability and reusability.
• I was involved in unit testing, user and production support.

Confidential, New York

ETL Developer

Technology : SSIS 2005, SQL Server 2005, DTS, SQL Server 2000

Responsibilities:

• My responsibility included gathering users requirements, analysis, design, development, testing and then user .
• Developing SSIS 2005 packages to migrate existing DTS 2000 packages to SSIS object model; by making relevant changers in the existing stock tasks.
• This would extract data from Computron flat files perform relevant transformations and load the data into fact and dimension tables (SCD-2).
• Developing views and stored procedures for reporting purposes and tune SSIS packages for optimal performance.
• Configure packages using SSIS configurations, setup logging, error and event handling and package transactions; implement scalability and reusability.
• I was involved in unit testing, user and production support