SUMMARY

• Expert in utilizing ETL tools for data loads, database integration/conversions, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Good experience and understanding of database design, relational integrity constraints, OLTP.
• Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert.
• Experience in enhancing and deploying the SSIS Packages from development server to production server, creating SSIS packages.
• Thorough Knowledge of various SSIS Objects such as Dataflow Components, Control Flow Elements, Connection Managers, Runtime Events, Log Providers, Configurations.
• Experience in working as System analyst for project and good experience in agile methodology execution of project.
• Implemented error handling and roll back process in ETL load.
• Experience in managing various SSIS Package Configurations.
• Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User - defined Variables for SSIS Packages.
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Expertise in Debugging, Error logging, Error Handling and Production support for SSIS.
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Test & Deploy code across various SDLC Environments like DEV, TEST, UA/UT, and Production.
• Expertise in handling various successful Data warehousing Projects.

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer

Responsibilities:

• Design, develop, unit test, debug and document complex ETL processes / Business
• Intelligence solutions, in accordance with the Business requirement specifications using
• Microsoft Visual Studio 2015, Oracle, Microsoft SQL Server 2016, Sybase and other technologies.
• Design logical and physical data models for data management along with creation and maintenance of the production scheduled jobs on need bases using the Microsoft SQL Server 2016 Management tools and Business Intelligence Tools.
• Develop overall ETL architecture including designs on integration standards such as loading, real time/batch, CDC, data validation, parallelization techniques.
• Create/modify Unix scripts to perform various flat file operations and ad hoc execution of ETL workflows/mappings from command line.
• Implement complex logic for file compare, file attributes, emails etc. using Windows command file and VBScript programming.
• Perform variety of in depth data analysis and data validations by writing ad hoc SQL queries on Oracle DB, SQL Server, Sybase etc. for disparate source systems which are complicated in nature.
• Work closely with business analysts, business and IT team members to clarify and refine functional data requirement specifications.
• Responsible of refining and redesigning reports layout and generating interactive visual analytical reports using Microsoft SQL Server Reporting Service (SSRS).
• Create/modify JIL scripts for job scheduling, dependency management and notification processes using CA Workload Automation AE & WCC (Autosys) Tool for monitoring and execution of ETL jobs.
• Creating, monitoring and supporting ETL using Business Intelligence SQL Server Integration Services (SSIS) Analytical and reporting jobs, performing in depth data analysis for daily job abends that occur due to various data issues which results in loss of data integrity and consistency.
• Lead the efforts to do version control for all the code pieces developed by him and his peers using Tortoise SVN as version controlling tool, plan and implement emergency changes and performance tuning of production ETL Jobs, identifying performance.
• Analyze, Create/Modify and Maintain all the necessary documentation like Solution Proposal Document, Data Mapping Document, DFD Data Flow Diagrams from both source and destination environments, Macro and Micro documents for the new development using Microsoft Projects.
• Active participation for onsite offshore co ordination for his project along with the other peers, handling Hierarchical and functional escalations and ensuring that issues are followed until closure.

Confidential

Responsibilities:

• To Involved in analyzing the Existing Tera data Interfaces and Infomatica Etl Process, to arriving best Solutions for the reverse engineering process.
• Creating mappings and logic analysis and provided solutions for meeting the business objective of processing data.
• Involved in requirement gathering and program scoping activities.
• Converted high level business requirements into detailed level by conducting multiple sessions with client.
• Involved in all phases of the project starting from analysis, design, development, testing, UAT and Prod release.
• Involved to back track all informatica jobs to find the source files.
• Involved to correct the sources like flat files, XML's (XSD's), SQL server database, Teradata for Historical load.
• Involved in developing ETL packages in SSIS and developing the stored procedures with business logics.
• Also involved in developing SSRS reports for business decision making process.
• Effectively playing the role of senior consultant in gathering all the requirements in discussion with the business stakeholder.
• Effectively using the TFS Tool to update the assigned User Stories, Tasks for the project.

Confidential

Informatica Developer

Responsibilities:

• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Utilized Power BI (Power View) to create various analytical dashboards along with slicers and dicers enabling end-user to make filters.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• To develop and optimizing Microsoft Power BI dashboards with a focus on usability, performance, flexibility, testability, and standardization.
• Fixing issues in production.