PROFESSIONAL SUMMARY:

• A result oriented and dedicated professional wif over 9 years of good experience in Software Development using .Net, SSIS, SSRS & ERP, MS Dynamics AX and MS SQL Server 2005/2008,2012,2014, SSDT 2012, Tableau & Power BI reporting and Visualization tools.
• Currently working as Senior Project Engineer.
• A fast learner holding a good knowledge of Manufacturing domain, ERP and ITIL processes.
• Efficient in Data Center consolidations and Application Rationalization, Tools - Remedy, Core Ftp, Putty, HP PPM and Toad and well versed wif Microsoft Office.
• Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Report on SSAS Cube and using SSRS to develop Drill-down, Drill-through And Cascading reports.
• Successfully completed M.S-Computer applications (Integrated Learning Programme in Software engineering) from BITS Pilani University in 2016
• Upgrade excel, crystal, SSRS and custom .net web-based reports to POWER BI reports.

TECHNICAL SKILLS:

Languages: C#, .Net 3.5

Database: MS SQL, MS SQL Server 2005/2008/2012/2014, SSDT 2012, 2015

ERP suite: MS Dynamics AX

Reporting Tools: SSRS, Tableau, Power BI

ETL Tools: SSIS

Analysis tools: SSAS, MDX

WORK EXPERIENCE:

Confidential

Senior software Engineer\offshore Lead

Technology: MS SQL Server 2017, SSDT 2015

Responsibilities:

• Mentor and support other members of teh team (both on-shore and off-shore) to assist in completing tasks and meet objectives.
• TEMPEffectively communicate technical information to on-shore and off-shore team members and to non-technical audiences.
• Troubleshooting production problems and enhance power BI reports.
• Strong technical experience wif design, development, Data modeling, application performance tuning, and unit/integration/performance testing.
• Implementation on teh migration of teh MSBI (SSAS tabular models and SSRS reports), crystal reports to Power BI cloud.
• Designed Power BI data visualization using cross tabs, Charts and Bars.
• Developed custom reports and deployed them on server using power BI.
• Designed and Implemented ETL Work flows from discrete Source systems to Target Systems as per teh business requirements
• Extract Transform and Load (ETL) data from flat files, Excel and direct DB connections using TNS names.
• Implementing business logics as transformations using data mapping sheets by creating data base objects like Stored Procedures, Views, Functions and Cursors

Confidential

Senior Project Engineer

Technology: MS SQL Server 2014, SSDT 2015

Responsibilities:

• Support and enhance power BI reports from multiple data sources.
• Implementation on teh migration of teh MSBI (SSAS tabular models and SSRS reports), crystal reports to Power BI cloud.
• Designed Power BI data visualization using cross tabs, Charts and Bars.
• Developed custom reports and deployed them on server using power BI.
• Designed and Implemented ETL Work flows from discrete Source systems to Target Systems as per teh business requirements
• Extract Transform and Load (ETL) data from flat files, Excel and direct DB connections using TNS names
• Implementing business logics as transformations using data mapping sheets by creating data base objects like Stored Procedures, Views, Functions and Cursors

Confidential

Technology: MS SQL Server 2012, Oracle 11g, Visual Studio 2015(.Net), Power BI

Responsibilities:

• Develop and support .Net applications (Customer statements and adhoc reports).
• Generated ad-hoc reports in excel power pivot and shared them using Power BI to teh Business users for strategic planning and decision-making.
• Used power query to pivot and un-pivot teh data model for data cleansing.
• Designed and Implemented ETL Work flows from discrete Source systems to Target Systems as per teh business requirements
• Extract Transform and Load (ETL) data from flat files, Excel and direct DB connections using TNS names
• Implementing business logics as transformations using data mapping sheets by creating data base objects like Stored Procedures, Views, Functions and Cursors
• Generating and publishing reports for data validation
• Developed post migration Reconciliation and Data integrity queries to achieve high quality work
• Involved in post migration Business discussions wif SMEs for Business Sign-offs
• Involved in SIT/UAT/Integration UAT and Production support
• Knowledge in Defect management tools like JIRA and HP-ALM
• Preparing ETL design documents and Run books for Technical auditing
• Maintain good relationship wif Infra, Design, Build and Development teams.

Direct to Contractor

Confidential

Technology: SSAS, MDX, C#

Responsibilities:

• Created and Designed Data Source and Data Source Views and configured OLAP Cubes (Star and Snowflake Schema) using SSAS.
• Extract Transform and Load (ETL) source data into respective target tables to build teh required data marts.
• Involved in Dimensional Data Modeling and Cube partitioning in SSAS.
• Had experience on teh Reports module of teh project as a developer on MS SQL Server 2012(using SSRS, T-SQL, scripts, stored procedures and views).
• Configured Dimensional modeling for End-User from Hierarchy perspectives.
• Created/Developed Drill down reports, Cross-Tab reports, Parameterized reports & Summary reports by Using SSRS.
• Extensively involved in teh SSAS storage and partitions, and Aggregations, calculation of queries wif MDX, Data Mining Models, developing reports using MDX and SQL.

Technology: C# .Net, MS Sql Server

Responsibilities:

• Develop and support .Net applications for retail stores custom reporting.
• Support and development of Sql server reports in production
• Identify teh scope of development and performance tuning.
• Designing integration wif various systems using SSIS.
• Working on enhancements of SSIS packages.
• Support MSTR Reports (ex- Scorecard, Retail sales reports).
• Automating SSRS report snapshots wif batch scripts.
• Support and development of crystal reports. (using C#.net)
• Authoring and creating teh story, Dashboards and Visualization on Tableau server.
• Support .Net Applications.
• Installing and configuring SSRS and SSAS
• Configuring, administrating and troubleshooting SQL jobs & maintenance plans, database mail, operators, alerts, DTS packages, data import/ exporting, DTS migrating using SSIS.
• Refresh Production backup to lower environments and detaching and attaching teh databases,
• Designing and implement database, Tables, Views, Store procedures and triggers, custom alerts.
• Automating regular task in SQL server

Confidential

Technology: C#.Net and MS Sql Server

Responsibilities:

• Handled Development, Design Change and Enhancement activity for teh Change Requests and Application Code Change.
• Created newly required flows for teh requirements from teh Customer in SSIS and deployed teh reports requested by teh Customer in SSRS.
• Managed escalations to ensure flawless flow in teh areas of Order Processing (SCM) and guided teh team in case of priority issues.
• Ensured that all teh reported incident tickets are closed wifin SLA.
• Helped resolving customer issues reported & coordinated between teh teams if teh issue was a multi-team dependent.
• Involved in production and deployment activities of application from test to QA and then production.
• Gathered requirements for new applications and enhancements (New Proposal/Project) and took care of analysis, design, development and deployment of applications.
• Responsible for working wif teams, vendors and other business collaborates and made sure that all areas of teh release are properly managed.
• Delivered critical deliverables to teh customer on time and ensured that teh review reports reflect teh status of teh team (WSR, MMR and QBR).

Confidential

Technology: MS Dynamics AX, MS Sql Server

Responsibilities:

• Investigated and resolved teh root cause of all teh issues faced by users on day-to-day basis, daily activities like monitoring automated batch jobs, preparing TSGs for teh same as well KB articles, which help teh customer to troubleshoot teh issue on their own.
• Handled data corrections for Assets.
• Thoroughly Business Analysis & Requirement Gathering
• Documentation of Business Requirements
• New Functionality Developments as per Requirement
• Testing of functionalities developed and deploy teh same