PROFESSIONAL SUMMARY:

• Overall 7+ Years of experience in all phases of Software Development Life Cycle (SDLC) Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation Support and Maintenance.
• Broad technical management experience encompassing project leadership, software development, product lifecycle management, and user experience.
• Knowledgeable in multiple technologies, including programming languages, product performance metrics, problem solving techniques, database migration tools, and software engineering tools
• Engaged in design, development and testing of methods, processes, and systems to consolidate and analyze diverse data sources to generate actionable insights and solutions for client services and product enhancement
• Strong experience in performance tuning, debugging and error handling of mappings, sources and targets for better performance and determining the performance bottlenecks.
• Extensive database experience and highly skilled in Oracle.
• Expertise in using Relational and Dimensional Modeling techniques like Star, Snowflake Schema, Fact and Dimensional Tables.
• Implemented complex business rules in Informatica by creating Reusable transformations to reduce the development time and complexity of mappings.
• SCD Management including Type 1, 2, 3, Hybrid Type 3, De - normalization, Cleansing, Conversion, Aggregation, Performance Optimization etc.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling and production support.
• Experience in integration of various data sources like Oracle, DB2, SQL server and MS access and non-relational sources like flat files into staging area.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server and Oracle PL/SQL.
• Created Tableau dashboards to display the data for data analysis purpose.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Experience in creating pre-session and post-session scripts to ensure timely, accurate processing and ensuring balancing of job runs.
• Knowledge in developing reports using Business Intelligence tools like Business Objects.
• Experienced in Agile /Scrum based system development.
• Maintained outstanding relationship with Business Analysts and Business Users to identify information needs as per business requirements.
• Enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability.

TECHNICAL SKILLS:

Software: Informatica ETL Tableau Hadoop Hive Mule Soft Qlikview Crystal Reports

Languages: Proficient in SQL PL/SQL UNIX Shell Scripting HTML

Databases: Oracle RDBMS MySQL SQL Server Management Studio

Tools: JIRA Git HUB MS Visio

Analysis: Business Process Modeling Sequence Diagrams Gap Analysis Decision Modeling Data Mapping

Testing Tools: SQL*Plus Rational Clear Quest Rational Test Manager HP Quality Center 11

Methodologies: Agile/ Scrum, Waterfall

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TX

Sr. Informatica Developer

Responsibilities:

• Converting the existing Oracle PL/SQL packages/ procedures which load the data, into Informatica workflows for an efficient management and monitoring.
• Providing support to existing PL/SQL packages/procedures for business changes and also monitoring the daily jobs.
• Developing Oracle Views for easy access to the Tableau dashboards to display the data for data analysis purpose.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Developing workflows to load the data into BDR (business data repository) from different sources through Informatica and MuleSoft
• Experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions data modeling.
• Gathering requirements for new workflows to load the data for different projects like Genscape, ERCOT, DTN etc. which are typical data sources for estimating the usage.
• Being a part of Data Analytics team involved in end-to-end lifecycle of Power Generation Project, AMI data load, from requirement gathering to reporting.
• Developed Informatica workflows for the Genscape, ERCOT and DTN data loads.
• Gather the requirements and define the objective of the database, Gather Data, organize in tables and specify the Primary Keys, Create Relationships among Tables for Relational Database Design.
• Fine tuning the existing Pl/SQL packages for a better performance and reducing the time to load the data.
• Deployed HDInsight clusters and developed SQOOP Scripts to import / export data between SQL Server and clusters.
• Created HIVE tables on HDFS data and wrote HIVE queries to access them
• Implemented Java Web application, which queries HIVE DB and then compared the results with traditional relation DB.
• Performed data analysis by using Hive to retrieve the data from Hadoop cluster, SQL to retrieve data from Oracle database.
• Administering Informatica tool to provide access to different users and also for the upgraded the version from Informatica 9.6.1 to 10.1.1.
• Coordinating with the DBA team for table performance and developing the strategy for granting roles to different users in the enterprise.
• Creating data driven alerts on Oracle to alert the business users according to the requirement by creating different Oracle Procedures.
• Providing Informatica Production support to the enterprise for business changes and also monitoring as well as alerting the status of the daily workflow runs.

Confidential, Boston, MA

Informatica Developer

Responsibilities:

• Collaborated with Business analysts for requirements gathering, analysis, ETL design and development for extracting data from the heterogeneous source systems like MS SQL Server, Oracle, flat files, XML files and loading into Staging and Data Ware House Star Schema.
• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD
• Devised a POC to demonstrate how HADOOP can be integrated with existing data warehouse to improve the performance.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Involved in massive data cleansing prior to data staging.
• Used informatica Web Services to support the feeds.
• Designed and developed ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Lookups, Aggregator, Java, XML, Ranking, Mapplets, connected and Unconnected stored procedures / functions / Lookups, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers were extensively done.
• Created complex mappings with shared objects/Reusable Transformations/Mapplets using mapping/Mapplet Parameters/Variables.
• Created sequential/concurrent Sessions/ Batches for data loading process and used Pre & Post Session SQL Script to meet business logic.
• Configured workflows with Email Task, which would send mail with session, log for Failure of a sessions and for Target Failed Rows.
• Perform code reviews and executing unit testing.
• Worked with UNIX shell scripts extensively for job execution and automation.
• Used SQL tools like Query Analyzer and TOAD to run SQL queries and validate the data.
• Extracted data from various sources (Flat files, SQL Server, DB2 Databases)
• Experience on implementation of Web Service providers and consumer transformation
• Worked on importing WSDL, SOAP request, XML files
• Tuning the Mappings for Optimum Performance, Dependencies, Batch testing Batch Design and TWS scheduling.
• Worked in Agile/Scrum environment.
• Prepared test scenarios and test cases in HP Quality Center and involved in unit testing of mappings, system testing and user acceptance testing.
• Performed Configuration Management to Migrate Informatica mappings/sessions /workflows from Development to Test to production environment.
• Performed workshops on Informatica cloud.

Environment: Informatica Power Center 9.5, Oracle 11g, Toad 10.1.1, SQL 2012 R2, Control-M, Flat Files, DB2, on Z/OS, UNIX, HP Quality Center, Agile/ Scrum, QTP

Confidential, Plano, TX

Informatica Developer

Responsibilities:

• Worked with Data Modeler to understand the business requirements and business rules
• Prepared ETL Specifications to help develop mapping.
• Extracted data from various sources (Flat files, SQL Server, DB2 Databases).
• Designed and developed Informatica Mappings and sessions based on business user requirements and business rules.
• Worked extensively on Source Analyzer, Mapping Designer, and Warehouse Designer Developed several Mappings using corresponding Sources, Targets and Transformations, Web Services.
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Created mappings to read from Flat files, RDBMS and to load into RDBMS tables.
• Based on business Rules Debugged code, tested and validated data after processes are run in development.
• Prepared and maintained mapping specification documentation.
• Modified the existing mappings for the updated logic and better performance.
• Developed Logical Data Flow Diagrams in Visio for every mapping that is developed. Assisted QA Team to fix and find solutions for the production issues.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.

Environment: Informatica 9.1, DB2, ERWIN, Oracle 10g, SQL Server 2012, Visual Basic.Net, MS Access, Business objects 6.5, Toad, SQL, UNIX, Java, Windows 2000, HP Quality Center.

Confidential, Sunrise, FL

ETL Informatica Developer

Responsibilities:

• Gathered business scope and technical requirements.
• Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files and Oracle (source) to Oracle (target).
• Created different transformations for loading the data into targets using various transformations.
• Created reusable transformations and Mapplets to use the transformation logic in multiple mappings.
• Worked on Repository manager to create and manage user profiles.
• Wrote Data loading stored procedures, functions using PL/SQL from Source systems into operational data storage.
• Scheduled Sessions on the Informatica Server using Informatica workflow Manager.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Involved in fine tuning queries for better performance (includes indexing and pre-joining and materializing views).
• Created views and altered some of the dimensional tables to satisfy their reporting needs.
• Created reports like, Reports by Department, Reports by Supplier, Reports by Period, Demographic reports and Comparative reports.
• Modified old crystal reports by adding new business requirements using SSRS and Create reports in SQL server using SSRS as per the requirements provided by the Front End users.
• Created different types of reports such as Master/Detail, Cross Tab and Chart.
• Used Analyzer and Explorer to view reports from different prospect like Slice and Dice and Drill down.
• Worked on Unstructured Data Transport UDT.
• Involved in Unit testing, System testing to check whether the data loading into target is accurate, which was extracted from different source systems.

Environment: Informatica 9.1, XML, DB2, Workflow Manager, Informatica Power Connect, Workflow Monitor, Ms-Access 2007, Ms-Visio, Oracle 9i, SQL Server 2000, PL/SQL Developer, Business objects 6.5,Toad, Windows 2000.

Confidential

Informatica Developer/ Admin

Responsibilities:

• Gathered business scope and technical requirements.
• Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files and Oracle (source) to Oracle (target).
• Created different transformations for loading the data into targets using various transformations.
• Created reusable transformations and Mapplets to use the transformation logic in multiple mappings.
• Worked on Repository manager to create and manage user profiles.
• Wrote Data loading stored procedures, functions using PL/SQL from Source systems into operational data storage.
• Scheduled Sessions on the Informatica Server using Informatica workflow Manager.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Involved in fine tuning queries for better performance (includes indexing and pre-joining and materializing views)