SUMMARY:

• Over 7 years of Software development, testing and production support experience in business domains like Healthcare and .
• Expertise in Test Data Management processes, Data masking and de - identification, Subsetting.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server
• Expertise in ETL Informatica
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and Informatica services.
• Data Loading Experience in SQL Server 2012 using Informatica ETL and Experience in developing packages in Informatica and DTS according to task.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports .
• ETL, data profiling, data quality and clean ups for Informatica packages.
• Experience in developing , monitoring, extracting and transforming data using DTS/ Informatica , Import Export Wizard, and Bulk Insert .
• Work is performed in a typical office environment
• Use MDM suite of tools to design, develop, optimize and support MDM for various domains. Lead the performance tuning of existing processes
• Manage the partnership with Data Integration Hubs around data modeling, data mappings, data validation, hierarchy management and overall security. Provide continuous enhancement and review of MDM matching rules, data quality and validation processes
• Develop, optimize and support Informatica PowerCenter components to provide MDM ETL processes for data extraction, transformations and loading of data
• Used various ETL tools like Informatica /DTS for data flow from source files like XML, Excel, Tables, and Views to other databases or files with proper mapping
• Create/manage Projects, Database Views, Data Sources and Data Connections using SSRS Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Experience in using Informatica tools like Import and Export Wizard, Package Installation, and Informatica Package Designer.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using Informatica /DTS utility.
• Experience in ETL processes involving migrations and in sync processes between two databases.
• Experience in Microsoft Visula C# in script component of Informatica
• Experience in creating configuration files to deploy the Informatica packages across all environments.
• Expert in generating writing parameterized queries, drill through reports and formatted SQL server Reports in SSRS 2012/ 2015/2008 R2 using data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Defining data warehouse (star and snow flake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services.
• Worked with report manager for deploying the reports across all the environments.
• Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.
• Experienced in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS.
• Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2012/ 2015/2008.
• Ability to handle Multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters. Ability to learn/migrate to different platforms, applications and Languages quickly.
• Experience in preparing technical specification documents.
• Good experience working in both development and maintenance projects.

TECHNICAL SKILLS:

Operating Systems: Win 2000/NT/2003/2008 server.

RDBMS: MS SQL SERVER 2015/2012/2008 , MS Access, Oracle8i/9i.

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management. Studio, SQL Server 2005, Query Editor, Reporting Server, Ms-Access.

ETL Tools: MS SQL Server Integration Services (SSIS), Informatica Master Data Management and Informatica Power center

Reporting Tools: MS SQL Server Reporting Services (SSRS), Tableau Reports

Programming Languages: Java, C#, XHTML and XML.

PROFESSIONAL EXPERIENCE:

ETL Informatica Developer

Confidential, New Jersey

Responsibilities:

• Data generation for the creation of data synthetically
• Subset production data from multiple data sources
• Involved in the creation and deployment of the reports using SSRS and configuring the SQL Server Reporting Server
• Design, Develop and Test ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 9.x
• Work in a fast-paced environment, under minimal supervision providing technical guidance to the team members
• Responsible for database schema design, extensive T-SQL development, integration testing and other projects that may be necessary to help the team achieve their goals
• Working closely with Onshore and offshore application development leads
• ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 9.x
• Identify efficiencies and ways to improve design and development processes
• Configured match rule set property by enabling search by rules in MDM according to Business Rules
• Worked on data cleansing using the cleanse functions in Informatica MDM
• Identify ways to increase efficiency of production support - Find solutions that allow operations to better do their job without involving development resource time
• Provides Informatica MDM HUB development support and detailed technical knowledge of Informatica MDM products
• Provisioning the right quality of data for testing team and loading test data from one testing environment to another
• Developed Tableau workbooks from multiple data sources using Data Blending.

ETL Informatica Developer

Confidential, New York

Responsibilities:

• Involved in discussions with the product team to understand requirements.
• Analyzed Test Scenarios from Requirements and wrote test cases
• Developed test cases for Unit testing by using Junit
• Performed Smoke, Functional and GUI Testing
• Performed Regression testing
• Tested the Application in different stages from QA, Staging and Production
• Generated periodic reports using SQL stored procedures.
• Involved in cloning production database to setup up staging environment and updating student’s LastName, DOB, passwords with dummy values, update educators/parents
• Develops PowerCenter Workflows and Sessions, and also sets up PowerExchange connections to database and mainframe files
• Develops logical and physical data flow models for ETL applications
• Provide System and Application Administration for Informatica PowerCenter and PowerExchange
• Designs, develops, automates, and supports complex applications to extract, transform, and load data
• Identifies and manages interfaces, service levels, standards and configurations
• Involved in discussions with the product team to understand requirements.
• Involved in life cycle of software development including designing, developing, testing
• Scheduled and maintained daily and monthly loads of OMS, Orders, Objectives and Adjustments data through jobs, tasks, and alerts.
• Developed features using Spring Framework by implementing MVC, and rest APIs.

Confidential

Java Developer

Responsibilities:

• Develop web application using Struts Framework.
• Responsible for developing Action Class.
• Develop user interfaces using JSP, HTML and CSS.
• Involved in coding to persist data with Hibernate.
• Implemented Hibernate Mapping Docs and Persistence components.
• Involving in Implementation and integrating new online functionalities using Springs Framework Writing Mapping document in Hibernate.

Confidential

Java Developer

Responsibilities:

• Develop web application using Struts Framework.
• Responsible for developing Action Class, form beans.
• Develop user interfaces using JSP, HTML and CSS.
• Created struts-config files and resource bundles using struts framework.
• Involved in coding to persist data with Hibernate.
• Implemented Hibernate Mapping Docs and Persistence components.
• Involving in Implementation and integrating new online functionalities using Springs Framework Writing Mapping document in Hibernate.

Confidential

Associate Software Engineer

Responsibilities:

• Develop web application using Struts Framework.
• Responsible for developing Action Class, form beans.
• Implement MVC design pattern with Struts framework.
• Develop user interfaces using JSP, HTML and CSS.
• Used struts validation framework for performing front end validations.
• Created struts-config files and resource bundles using struts framework.
• Involved in coding to persist data with Hibernate.
• Implemented Hibernate Mapping Docs and Persistence components.