SUMMARY:

• 14+ years of experience in IT industry, involved in development.
• Presently working at Confidential as Sr Datawarehouse Architect.
• Customer focused and provides solutions which best suits to customer needs.
• Expertise in Agile, Waterfall methodologies.
• Excellent skills in leading the team and mentoring Team - tracking tasks, providing solutions, reporting to the stakeholders, implementation (coding).
• Strong hands-on experience of designing ETL code using SSIS. Expertise in end to end ETL design.
• Extensive experience in end to end solution design for data warehousing projects.
• Experience in developing business reports using Tableau, PowerBI, SSRS.
• Experience in Master Data Services (MDS 2012, 2014).
• Strong hands-on expertise in writing SQL, T-SQL and PL-SQL in SQL Server and Oracle.
• Experience in requirement gathering/analysis & project estimation.
• Ability to work in a team as well as independently and quick at mastering new concepts and applications.
• Hardworking motivated team player with excellent communication & interpersonal skills.
• Trained on Python.
• Good exposure to handling the process related activities during the project execution.
• Facilitate, participate and lead meetings with customers and establish a strong working relationship.
• Being flexible in performing technical and managerial role as situation demands.
• Implemented multiple end to end Guidewire ETL integration, conversion and reporting projects.

TECHNICAL SKILLS:

Databases: MS-SQL Server 2014/2012/2008 R2, Oracle.

ETL Tools: SSIS.

Analytical / Reporting Tools: Tableau, SSRS, SSAS, PowerBI.

MDM Tools: Microsoft MDS (2014, 2012).

Languages: C#, ASP.NET.

Other: Autosys, Trained in Python.

WORK EXPERIENCE:

Confidential

Responsibilities:

• Requirement gathering/analysis.
• Designing and developing Datawarehouse for capital markets division within Confidential .
• Designing and developing ETL packages for loading data from multiple data sources.
• Design and develop analytical reports using Tableau, PowerBI and SSRS.
• Conduct daily sprint calls.
• Attending sprint planning and demos.
• Project estimation and analysis.
• Assigning tasks to team members and tracking the status.

Technology: SQL, SSIS, SSRS (2012, 2014), Tableau, Power BI, MDS 2014.

Confidential

Responsibilities:

• Designing and developing ODS/Reporting layer to ClaimCenter OLTP system.
• Designing and developing ETL packages for converting data from legacy system to GuideWire ClaimCenter.
• Designing and developing ETL for various insurance integrations.
• Attending sprint planning and demos.
• Requirement gathering/analysis.
• Project estimation and analysis.
• Assigning tasks to team members and tracking the status.

Technology: SQL, SSIS 2012, Oracle 12C, SSRS, PL-SQL

Confidential

Technical Lead

Responsibilities:

• Designed / Created Model, Entities and Attributes.
• Created business rules to implement NOT NULL constraints.
• Created subscription views.
• Developed ETL packages to load data into MDS via EBS (Entity Based Staging).
• Developed master data manager (a .Net utility) which consumes the MDS WCF services. This tool creates entities, attributes, business rules (Optionally) and domain based attributes (Optionally) by reading data model (Excel spread sheet / DDL script).
• Developed an ASP.Net web application which does basic CRUD operation on MDS as a POC.
• Worked on deployment utility.

Technology: MDS 2012, SSIS, SSRS, MS SQL Server 2012.

Confidential

Technical Lead

Responsibilities:

• Maintain the applications owned.
• Develop / design all new developments using SSIS / SSRS.
• Lead and guide junior resources for project completion.
• Follow proper Confidential guidelines and coding standards.
• Ensure all the quality control documents are in place.
• Communicating status to clients on regular basis.
• Developing ETL packages using Informatica.

Technology: SSRS, SSIS, SQL Server 2008, Pro-Clarity

Confidential

Sr. Software Engineer

Responsibilities:

• Developing the required database objects as per the standard requirements.
• Providing the required reports to the client.
• Providing required queries to offshore team for their SSRS report development.
• Testing understanding of the requirements.
• Developing SSIS packages and scheduling them as job.
• Identifying opportunities for code reusability.
• Coordinating with other teams / offshore team and getting the work done.
• Effectively communicate with Teammates and Clients on Project related issues. Contribute towards People Development, Process, Quality and Assets.
• Creating Functional Documents (FD's), Functional Mapping Documents (FMD's) and Technical Documents (TD’s) for the code developed.
• Communication project status to project leads on regular basis.

Technology: SQL Server 2008, SSRS 2008, SSIS 2008.

Confidential

Developer

Responsibilities:

• Understanding Requirement, Development and Testing.
• Designed middle layer and data access layer for the application.
• Worked extensively on stored procedures and user defined functions.
• Designed and developed DTS packages.
• Development of UI and Business Components using C#.
• Involved in unit testing and regression testing for this module.
• Bug Fixing and Enhancement on the deployed applications.
• Handled contact support issues for the module.
• Conducted KT sessions on functionality of the module to the new joiners.

Technology: C# ASP.Net, SQL Server 2000 and 2005.