SUMMARY:

• More than 14 years of industry experience, strong expertise in enterprise architecture, design & development of Enterprise Data Warehouse, Data Mart, Business Intelligence systems, Data mining solutions.
• Have experience in full development life cycle (SDLC) involving analysis, design, development, testing, implementation and maintenance.
• Have extensive experience in providing solution for performance improvement for high available and high transaction, Real - time data and analytics applications.
• Extensive experience in Business Intelligence development.
• Extensive experience in MS SQL, MS SSIS, MS SSAS (Tabular and Multidimensional), MS SSRS, Tableau, Power BI, R Programming, Informatica Power Center, Informatica Cloud, MDM, Power Shell scripting.
• Extensive experience in designing enterprise data warehouse, data marts, analytical reporting systems, business intelligence applications.
• Extensive experience in data modelling.
• Hands on experience in Data migration from on premise to cloud and vice-versa using AWS and MS Azure.
• Experienced in web technologies, ASP.NET, VB.NET, C#.
• Experienced in relational database design and adequate knowledge in NoSQL DB(MongoDB), Amazon Redshift, Cosmos DB
• Working on POCs in Big Data technologies.
• Exposure to Incorta and ThoughSpot.
• Familiar with AWS and MS Azure.
• Experienced on projects in waterfall and agile methodology.
• Extensive experience in development, maintenance and support projects.
• Extensive experience in client management.
• Good understanding of various project management principles.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Understanding requirement for new business growth and existing enhancements.
• Part of my job role; I was engaged for taking decision on choosing the right tool and technology for end to end BI solution design.
• Heavily involved in design and development of BI solutions using SSRS, Power BI, Tableau, Incort, ThoughSpot and few other BI tools.
• Extending support to other team members for report design best practices using Power BI, Incorta, Thoughtspot, Tableau.
• Involved in data migration from on-prem to Azure cloud.
• I was responsible for maintaining the data ingestion and consumption layers, from all different sources and load them to the data mart.
• Working with multiple internal data providers for data requirement.
• Architecting and development of SSAS tabular model with every month data. Writing complex DAX statements in SSAS tabular model and Power BI reports.
• Guiding and coaching the business users for Power BI usage pattern and best practice, for self-service BI.
• Developed data validation framework for validating the data from SRC to Tabular Model. Successfully implemented source to target validation framework.
• Developed sanity check framework to identify the data drop or mismatch in source.
• Doing process automation.

Technology: MS-SQL, SSAS, SSRS, Power BI, Tableau, SSIS, C#, Informatica Power Center, MS Azure, Sybase, DB2, Netezza, SAS, R Programming, Windows Power Shell, AWS, Incorta, ToughtSpot

Confidential

Responsibilities:

• Understanding requirement for new business growth and enhancement to existing system.
• Analyzing and recommending the changes required in the current systems.
• Evaluating and identifying various technologies available to meet the requirement.
• Extensive use of technologies, like, T-SQL, SSIS, Informatica, Mellissa and few open source technologies.
• Preparing System Architecture and detailed design.
• Real time data extraction using REST Api and SOAP protocol.
• Discussing with third party vendors for various data requirements.
• Designing ETL using SSIS and Informatica Cloud
• Designing business intelligence applications for analysis.
• Design API to interact with third party systems.
• Designing automated systems for data profiling and cleansing.
• Participated in code and design reviews
• Coordinated with multiple vendors from geographically distributed teams for a successful development, testing and deployment.

Technology: MS-SQL, SSRS, SSAS, SSIS, C#, Informatica Cloud, Sales Force, ASP.NET, Power Shell, Teradata

Confidential

Responsibilities:

• Understanding requirement for new business growth and need for scalability.
• Analyzing and recommending the changes required in the current systems.
• Enhance and bug fixing in many legacy applications. Suggesting for long term solutions.
• Upgrading the current system to latest versions and newer technologies.
• Enhancement and supporting the enterprise data warehouse system.
• Coordinated the communication with client and offshore team on daily basis.
• Performed feasibility analysis for migrating a suite of applications between heterogeneous platforms.
• Upgrading the current reporting system to advanced technologies.
• Automate various ETL process for efficient data load.
• Trained the team in new technologies.
• Working towards the stability of applications by enhancing the functionality.

Technology: ASP.NET, C#, Oracle, MS-SQL, SSRS, SSIS, C#, Power Shell, UNIX, SAP BW/BI

Confidential

Responsibilities:

• Leading the team for development and maintenance of the suite of data management applications.
• Resolving and addressing critical issues in the legacy application, within SLA
• Designing data loading processes by writing complex T-SQL statements.
• Analyzing data quality issues and data load issues and providing required solutions.
• Developing applications using ASP.NET and C#.
• Defined the roadmap and the architecture to rewrite a suite of legacy applications.
• Evaluated technical alternatives to overcome the limitations of legacy systems.
• Identified various technologies available to meet the requirement and provided the recommendation new architecture.
• Performed Proof-Of-Concept for the selected technologies.
• Trained the team in new technologies.
• Coordinated the communication with client and offshore team on daily basis.
• Review and manage the changes and meet the Change management board for approval.
• Managing the disaster recovery for suite of applications
• Creating and presenting various management reports to client.

Technology: ASP.NET, C#, Oracle, VB.NET, UNIX Scripting, MS-SQL, SSRS, Crystal Report

Confidential

Responsibilities:

• Leading the technical team for multiple trading applications.
• Analyzing data quality issues and providing solutions.
• Designing ETL systems and analyzing source data.
• Supporting multiple trading applications for business-critical issues during business hours.
• Enhanced the ability of product to support larger Service Bulletins that helped the client to decide on stopping their legacy system and to reduce the overhead.
• Coordinating with various external systems for data issues.
• Creating re-conciliation reports for month on month data match.
• Designing the disaster recovery plan.

Technology: ASP.NET, C#, Oracle, VB.NET, UNIX Scripting, MS-SQL, SSRS, Sybase

Confidential

Responsibilities:

• Analyzing the requirement for new development and future enhancements.
• Developed web application for various E-Learning courses using ASP.NET, C#, SQL, CSS
• Designing sales report for different zone.
• Customize whole applications for different corporate clients.
• Participated on revamping multiple with new design and additional functionality.
• Performed Impact analysis in hosting the application in new application server.
• Prepared detailed design document and developed the system.
• Bug fixing and enhancements as per client requirement.

Technology: ASP.NET, C#, Oracle, MS-SQL, SSRS, SSIS

Confidential

Responsibilities:

• Analyzing the requirement for new development and future enhancements.
• Developed web application and performing unit testing.
• Design the application and customize according to client’s requirement.
• Prepared detailed design document and developed the system.
• Bug fixing and enhancements as per client requirement.

Technology: ASP.NET, C#, VB.NET, MS-SQL, SSRS, SSIS

Confidential

Responsibilities:

• Analyzing the requirement for new development and future enhancements.
• Developed web application and performing unit testing.
• Develop ETL to load from excel files.
• Prepared detailed design documents.
• Bug fixing and enhancements as per client’s requirement.

Technology: ASP.NET, C#, Oracle, MS-SQL