SUMMARY:

• Around 11 years of IT Experience in end to end Agile project & deliverables using various technologies and understanding the SDLC/AGILE methodologies for smooth project execution.
• Developer with 6+ years of experience on Development and Enhancement/maintenance projects in the areas - Banking and Telecom.
• Offering vast years of experience in Software Development of Data Warehousing projects encompassing Development, Testing and maintenance of Informatica power center as ETL on Oracle, Teradata, Unix and Mainframes.
• A project executor with exposure in handling projects and ensuring delivery of projects within the time & cost parameters; executed multiple key projects involving Data warehousing using various technologies like Informatica Power Center 7.1, Informatica Power Center 8.5.1, Informatica Power Center 8.6 and Informatica Power Center 9.x (Workflow Manager, Workflow Monitor, Warehouse Designer, Mapping Designer, Mapplet Designer & Transformation Developer).
• Development of Informatica mappings using varied transformation logic using filter, expression, router, aggregator, joiner, lookup, and update strategy.
• Lead projects running with development, Testing and production support of data warehousing projects.
• Facilitated onshore-offshore and multi-location co-ordination and work distribution based on the stakeholder requirements and priorities.
• Timely support and maintenance of the production jobs running in production environment.
• Experience in Linux, UNIX, Oracle, COBOL, JCL, VSAM, and DB2 Incident, Change/Release Management in Production Environment, involved in various phases of production support.
• Ability to deliver comprehensive Business Intelligence through integration of BI suite of products (SSAS, SSRS) including MS solutions like MS EXCEL 2007, Microsoft Office SharePoint server (MOSS) 2007, Performance Point Server 2007.
• Knowledge on full software development life cycle (SDLC) starting from collecting business specifications, user requirements, confirming the design decisions regarding data, process, interfaces, reviewing/audit the code and documenting effectively the entire life cycle.
• Lead the projects using Linux, UNIX and IBM Mainframes platform level 1 & 2.
• Expertise in enhancing and Tuning Confidential -SQL, PL/SQL Complex Queries, Stored Procedures, UDF’S, triggers, views, Indexed views and error handling using Try-Catch blocks.
• Skilled in Informatica power center design, development of mappings from varied transformation logic using filter, expression, rank, router, aggregator, joiner, lookup, and update strategy.
• Possess strong communication, relationship management, analytical and problem-solving skills.
• Experience in SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services).
• Developed Informatica Mappings using Designer to extract, transform data according to the requirements and loaded into database from relational sources and non-relational sources.
• Involved in different environments of testing, trouble shooting of Informatica mappings and SQL queries for unit testing and developing test cases.
• Experience in Tuning SQL queries and Confidential -SQL queries, MDX & improving the performance of the queries.
• Experience in integrating various data sources such as Flat Files, Cobol sources, XML, Salesforce, Oracle, Teradata, SQL Server, Share Networks, Webservices.
• Experience in utilizing various transformations like Aggregator, Look Up, Joiner, Update Strategy, Filter, Sequence Generator, Normalizer, Union, Sorter, Router, Stored procedure, http/xml source qualifier/ xml parser/ xml generator/ transaction control/ salesforce lookup/application source qualifier.

TECHNICAL SKILLS:

Databases: DB2, HBASE, Teradata, SQL server 2012/2014, Hive, SQL Server 2012, SQL Server 2000/7, Access, Oracle 11g

Tools: ETL- Informatica Power Center 9.x/10.x, Supersession, ESP Workstation, Vantive, NMC, Q-Messenger, UMON, AOTS, NETCOOL, UMON,CHGMAN, SQL Server Management Studio, Performance Monitor, Data Transformation Services (DTS, Business Intelligence Development Studio(BIDS), Control-M, ALM, Git, JIRA

Languages: VS COBOL II, JCL, SQL, VSAM, UNIX Shell Scripting

Confidential: SQL, PL/SQL, Shell Scripting

OLAP Reporting Tools: SQL Server Reporting Services (SSRS), SSAS, SSIS, Crystal Reports 9.0/8.5, OLAP, Erwin

Change Management Tool: Tortoise SVN, Visual Source Safe (VSS), Team Foundation Server (TFS), DBUnity

PROFESSIONAL EXPERIENCE:

Confidential, NY

ETL/Informatica Developer

Responsibilities:

• Interacted actively with Business and Data Modelers on Mapping documents and Design process for various Sources and Targets.
• Involved in business requirement analysis and prepared functional requirement documents, Involved in the ETL technical design discussions and prepared ETL high level technical design documents.
• Requirement gathering from Business analyst and developing the detailed design structure.
• Created different mappings and used different transformations like (Source Qualifier, lookup, router, expression, aggregator, update strategy etc.,).
• Involved in developing control-m Jobs using BMC control-m scheduling tool.
• Performed UAT deployments and coordinated PROD deployments.
• Involved in in Unit and System testing.
• Coordinate and track the reviews, documentation, test activities.
• Coordinate with internal and external teams (on site/offshore) to give status updates on daily basis.
• Discussion with customer for prioritizing the changes.

Environment: Informatica Power Center 9.5, ORACLE 11g, UNIX, Control-M, Winscp, Putty.

Confidential, Philadelphia, PA

ETL Developer

Responsibilities:

• Interacted actively with Business and Data Modelers on Mapping documents and Design process for various Sources and Targets.
• Involved in business requirement analysis and prepared functional requirement documents, Involved in the ETL technical design discussions and prepared ETL high level technical design documents.
• Understood the project scope and performed gap analysis on business requirement document, functional requirement document.
• Responsible for requirement gathering, requirement analysis, discussion over the issues for its optimal resolution and working behind translation of the user inputs into ETL design documents.
• Created source to target mapping documents, a document which tells you how the data is flowing between source and target via applying business rules.
• Extracted the full/incremental data, high volume of data sets from files, oracle using Informatica ETL on daily basis to perform analysis and gather statistics over call sample, call attendee, aggregate spend information.
• Developed mappings using various Transformations such as Source qualifier, Aggregator, Expression, Router, Filter, Look up, Joiner, Sequence Generator, and Update Strategy transformations.
• Designed and Implemented Incremental loading process to load data into target tables.
• Documenting the ETL mapping strategies and transformations involved in the extraction, transformation and loading process.
• Implemented SCD1 and SCD2 methodologies in ODS tables loading, to keep historical data in Data warehouse.
• Implemented unconnected lookups in ETL mappings to create foreign key relationship between Dimensions and Fact tables.
• Extensively worked on Performance tuning to increase the throughput of the data load (like read the data from flat file & write the data into target flat files to identify the bottlenecks etc).
• Extensively worked on SQL tuning process to increase the source qualifier throughput by analyzing the queries with explain plan, creating new indexes, partitions and Materialized views.
• Worked with Memory cache for static and dynamic cache for the better throughout of sessions containing rank, lookup, joiner and aggregator transformations.
• Debugged all expression and data validation problems in the mappings with debugger.
• Extensively used Re-usable Objects (shortcuts) like Sources, Targets in all mappings to handle metadata changes efficiently.
• Collected the statistics for each load and implementing the exception handling as part of the load process.
• Worked on performance tests and resolve issues to ensure that the jobs can be run without compromise to the monthly close process/production schedule.

Environment: Informatica Power Center 9.5, SQL Server 3.0.0.4, SQL, UNIX shell Script, Putty.

Confidential, Jersey City, NJ

Sr. Technical Associate

Responsibilities:

• Responsible for requirement gathering, Business Analysis, user meetings, discussing the issues to be resolved and translated the user inputs into ETL design documents.
• Analyzing deeply on applications daily basis and to make a proper conclusion on the batch and online schedule to avoid conflict in scheduling jobs. So, that we can meet our online and batch commitments.
• Resolve problems/exceptions for online and batch applications on Informatica.
• Design Development and code in Informatica power center application. Worked with Power Center tools like Designer, Workflow Manager, Task Developer, Workflow Monitor and Repository Manager.
• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation and Aggregator Transformation.
• Performance optimization of the database and applications, Informatica Objects. Managed and Compiled documentation for all ETL processes active in production.
• Completed documentation of database structures and processer used to move data in and out of the database for future development and explanation of database.
• Provide technical assistance for the Confidential Applications.
• Develop and execute batch jobs and monitor job streams completion to meet batch and online service level commitments.
• Interact with clients and other work groups to co-ordinate delivery.
• Nurture and guide team members to understand business requirements and technical deliverables.
• Handling Teradata job failures, fixing Multiload, Fast load abends.
• Designed the business requirement collection approach based on the project scope and SDLC Methodology.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports.
• Involved in performance tuning and monitoring of Confidential -SQL blocks.

Environment: Informatica on Cloud, Informatica power center 9.x, MS-SQL server, ESP Workstation, Mainframes, UNIX, Teradata Manager.

Confidential, Saint Louis, MI

ETL Informatica Developer

Responsibilities:

• Perform Sanity Checks and validation.
• Resolving service requests and issues appropriately.
• Prepare Problem reports, Request Management (RM), Change Request (CR), RFC Maintain shell scripts.
• Wrote Confidential -SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.
• Involved in performance tuning and monitoring of both Confidential -SQL and PL/SQL blocks.
• Responsible for creating summary Reports, Sub Reports, Drill Down Report, dynamic grouping.
• Used DBCC commands for checking database consistency and fixing data corruption in user databases.
• Done performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks.
• Developed and implemented Backup and Recovery strategies. Day-to-day activities such as backups to the disk and restore the databases and transaction log on production/development servers as per the business needs.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema for developing Cubes using MDX.

Environment: : Informatica power center 7.1/8.5, MS-SQL server, ESP Workstation, Mainframes, UNIX, Teradata Manager.

Confidential

Technical Associate

Responsibilities:

• Monitoring Workflows (ETL jobs in Production and QA environments) and handling the errors associated with them, recovering the failures. Working on the detailed analysis of the existing system to understand the logic implemented in the queries.
• Initiate change request (CR) in AOTS system and hence build a more profound structure in delivering the most accurate data to customers.
• Indulge directly with the business to work on the inputs responsible in reducing the load delays and improving efficiency. Responsible for performance monitoring, resolving issues in RIF QA environment. Responsible for RIF 1.x migration and handled critical issues during the RIF 2.0 ‘Go Live’.
• Understanding and preparing High Level and Low-level Designs. Preparing Business understanding documents for ADR/FSP application.
• Contact with Application KT team and setup meeting sessions with client and KT team.
• Understanding core business to benefit customer.
• Preparing initial estimates by analyzing the requirement and Coding.
• Peer to Peer review of all the deliverables.

Environment: Informatica 7.1/6, Oracle 8i, PL/SQL, UNIX.