SUMMARY

• 8 years of Software development, testing and production support experience in business domains like Healthcare and Education .
• Moderate experience in Test Data Management processes, Data masking and de - identification
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server
• 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 .
• 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 SSRSSupported 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 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.
• Have Strong knowledge on MuleSoft Integration tool
• 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.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Provided 24/7-production support for Tableau users.
• Experience in developing Web based applications using Java and J2EE
• Sound knowledge of web applications using JSP, Servlets and JDBC
• Strong experience of frameworks Spring, Struts, Hibernate.
• 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

Integration Tool: MuleSoft

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

BI Tools: MS SQL Business Intelligence, Business Objects, SSAS

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

PROFESSIONAL EXPERIENCE

Confidential

ETL Informatica Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modelling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Confidential

ETL Informatica Developer

Responsibilities:

• 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
• Identify ways to increase efficiency of production support - Find solutions that allow operations to better do their job without involving development resource time
• Provisioning the right quality of data for testing team and loading test data from one testing environment to another
• Deep, technical knowledge of both Tableau Desktop and Tableau Server from an administrative and a consultative standpoint
• Write Shell script running workflows in Unix environment
• Extensive experience in Tableau Server and Tableau Desktop in various versions of Tableau 9.x/10.x
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow