Jan 2015 – Sep 2021 · 6 yrs 8 mos · Hyderabad Area, India

• Creating and maintaining one of the biggest multi terabyte bigdata warehouse solution for Microsoft product keys data, it has all data for a product key pertaining to key production, distribution, activation, blocking etc .
• Lead interaction with business stakeholders , architecture decisions for current process, designing modified business process in accordance with DW/BI solution
• Environment: DevOps ,Cosmos (Big data ) SQL Azure , Azure Data lake , BIML , Azure Data factory , MS-SQL 2014 , SQL Server management studio, SSIS, SSRS,SSAS, TSQL , Stored Procedures, C #, Reporting Services, R , Azure ML for Machine learning, databricks, scala , spark ,python .
• Getting insights from data using Azure ML and other tools

Feb 2011 – Dec 2014 · 3 yrs 10 mos · Gurgaon

• Worked as Engineering manger maintaining diverse teams of 10-12 engineers (Infrastructure support, DBA, .Net developers) for India and US regions. My job included support existing data application, develop new applications, data modelling, designing, developing resolve any database related issues as a senior database consultant.
• Environment: MS-SQL 2008, 2005,2012, SQL Server management studio, SSIS, SRS,SSAS, Teradata ,TSQL , Stored Procedures, C #, Reporting Services.

May 2008 – Feb 2011 · 2 yrs 9 mos

• : Worked as Sr. Consultant / team lead maintaining a group of 2-3 people worked on both OLTP and OLAP systems. My job includes designing, developing ETL using SSIS, testing and deploying custom data application, data modelling, worked on change requests, developing of framework, provide support and resolve any database related issues as a senior database consultant.

Dec 2006 – Jun 2007 · 6 mos · Germany

• Worked on SCM (Supply Chain Management) and PSI (Purchase Sales and Inventory) systems integrated with Systems like SAP R3, SAP APO, I2DP and DASH. Panasonic Europe is maintaining whole Purchase, Sales and Inventory for whole of the Europe
• Job Profile: Worked as Techno functional Consultant for Panasonic Europe. My primary job included client interaction, design, development, maintainace, conducting preliminary feasibility studies, initial testing and implementation
• Environment:
• VB 6.0, VB.NET, MS-SQL, TSQL ,DTS, Stored Procedures, Reporting Services, SQL Server management studio, SSIS, Crystal Reports, Triggers Oracle (PL/SQL) and UNIX.
• Roles and; System Study, Coding and Maintenance.
• Worked on new projects and change requests by users.
• Production support, solving user problems both technical and functional.
• Environment: MS-SQL 2005, SQL Server management studio, SSIS, SSRS,SSAS, TSQL , Stored Procedures, C#,Reporting Services and VB.Net, SQL compare etc

Jul 2005 – Nov 2006 · 1 yr 4 mos

• Project Summary
• Worked as Software Engineer in Newgen Software Technologies Limited (CMM level 4) is a global leader in Business Process Management (BPM), Document Management (DM), Workflow and Imaging solutions, having presence in more than 20 countries through it's global sales, professional services and support organizations, as well as it's Partner network of resellers and system integrators.
• Job Profile: Worked as Software Developer on Omni flow which Is a platform-independent, scalable Business Process Management solution that enables automation of organizational business processes. Built using open technologies, it has seamless integration abilities allowing it to be introduced into any IT infrastructure. I worked as a Team Member, in all the phases of system design and development including detailed specification, conducting preliminary feasibility studies, testing and implementation.
• Automation of Claims Project(Max New York Life Insurance)
• Worked on a project of Max New York Life Insurance A complete workflow system for automating the Max New York Life Insurance Policy Claim procedure.
• Environment:
• VB 6.0, MS-SQL , Crystal Reports, NGF MS-SQL 2000,Newgen Omni Flow, Oracle Newgen Omni Docs,XML, Newgen Omni Capture.
• .
• Roles and; System Study, Coding and Maintenance.
• Involved in high-level design and software development.
• Making Auto Utilities to fetch data from world known Insurance Solution Database (Ingenium).
• Understanding requirements interfacing with client, team lead for mapping requirement and finalising specifications.
• Handling smooth implementation of the application.
• Interacting with team members to ensure smooth progress of project work.
• Handle Product Release to the client.
• Ensuring adherence to quality norms throughout the development & implementation process.
• Project Account Opening Module (Deutsch bank)
• Worked on project of Deutsch bank of account opening procedure.