SUMMARY:

• Over 13+ years of IT experience in Databases like Oracle, MY SQL Aurora, MS SQL Server, RedShift Database, Teradata and UDB DB2, Data warehousing tool Informatica Power Center and Data Modeling Tools like Erwin.
• Involved in requirements gathering, analysis, design, development, and maintenance of data warehouse/data mart using RDBMS applications on UNIX environment.
• Experience in handling both on premise and on Cloud (AWS) ETLs.
• Worked with managers to give work estimates and advised on design.
• Extensively Worked on Informatica Components - Source Analyzer, Target Designer, Transformation Developer, Mapplet/Mapping Designer, Workflow Manager and Workflow Monitor.
• Thorough understanding of Performance tuning in Informatica by identifying the source/target/ mapping bottlenecks.
• Extensively made use of Parameter Files, Mapping Parameter/Variables, Session Parameters/Variables and different Tasks like Command, Email, Session and Decision.
• Good Experience in Informatica Data Quality and Informatica power exchange change data capture.
• Good experience in Oracle e-business suite applications release R12, 11i, Accounts Receivables (AR), Accounts Payable (AP), Inventory (INV), General Ledger (GL), Service Contracts (OKS), Advanced Pricing and Installed Base.
• Strong programming experience in creating Procedures, APIs, Packages, Functions, Triggers and other database objects using SQL and PL/SQL in Oracle 12c, 11g, 10g, 9i and Oracle 8i.
• Documented business rules, functional and technical designs, test cases, and user guides.
• Involved in creating the Oracle Database Objects like Tables, Indexes, Views, Synonyms, Triggers, Stored Procedures, Functions and Packages.
• Extensively used MY SQL Aurora Work Bench, Teradata Queryman and MS SQL Server Query Analyzer to check the data consistency in the tables and for performing Adhoc Queries.
• Thorough knowledge of Oracle Utilities Export, Import and SQL*Loader.
• Well Versed with different tools like TOAD and AQT for accessing/development of Databases.
• Involved in optimization of SQL using Partition Tables, SQL Optimizer Hints, Clusters and Dynamic SQL using Execute Immediate and REF Cursors.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in multidimensional modeling.
• Well versed with Data Warehousing concepts with an emphasis on full life cycle implementation of Data Warehousing projects.
• Worked with Control-M tool to schedule Informatica jobs.
• Expertise in creating Unix Shell Scripts to run the PL/SQL Procedures, FTP the files, Compressing and Merging files, Date Increment logic using AWK command and automating the monthly/weekly load with the required job sequence.
• Well versed in creating Detailed Design, Test Plan, Change Request, Maintenance and Check List documents using ITIL best practices.
• Hands on experience in Agile sprint process/JIRA/Servicenow.
• Team player with creative problem solving skills, quick learning skills, self-starter with good communication skills and ability to work independently or as part of a team.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Shell Scripting and C

RDBMS: Oracle 9i/10G/11i/12c, MYSQL Aurora Database, Redshift DatabaseMS SQL Server 7.0/2000, Teradata 5.0, UDB DB2

ERP/CRM: Oracle Apps R12, 11i

ETL Tools: Informatica 10/9.1/8.5/7.1

Reporting Tools: Business Objects XI/6.5.1

Interfaces: Teradata Queryman, VI Editor, Toad 9.0.0, AQT 6.1.7, Microsoft Visio, MS SQL Server Query Analyzer, Web Methods 6.5

Configuration Management Tools: Clear Case, Quick Base, Perforce

Operating Systems: Windows 2000/XP/NT Server, HP-UX 11.11

Platforms: Amazon Web Services (AWS)

PROFESSIONAL EXPERIENCE:

Confidential, Sterling, VA

Senior Informatica/Oracle Developer

Environment: Informatica 9.1/10, Oracle 10g/11i/12C, Oracle Applications 11i, SQL*Plus, PL/SQL, AWS (Amazon Web Services Platform), Redshift, MY SQL Aurora, UNIX Shell Scripting, Toad

Responsibilities:

• Involved in Requirements Gathering and Business Analysis.
• Worked on Cloud (AWS) ETLs to load data to target Redshift database.
• Created mappings using Informatica Transformations like Expression, Source Qualifier, Filter, Joiner, Aggregator, Connected/Unconnected Lookup, Router, and Update Strategy.
• Created various sessions, workflows and tasks using Informatica workflow manager.
• Developed scripts in Oracle using procedures, functions and packages for processing business logic in the database.
• Performance tuning in Informatica by identifying the source/target/mapping/session bottlenecks.
• Generated SQL and PL/SQL scripts to create and drop database objects including: tables, views, indexes, constraints, sequences, partitions and synonyms.
• Source data files from client were analyzed using Informatica Data Quality.
• Performed adhoc queries on MY SQL Aurora/Redshift Database to check for data consistency and to get store/offer/asset/pricing setups using MY SQL Workbench.
• Created oracle objects and PL/SQL scripts for high performance and quick response times.
• Implemented power exchange change data capture (CDC) for oracle and SQL server sources to deliver accurate and timely data to users.
• Lead a team of developers onsite/offshore, assigned, advised and analyzed work.
• Performed adhoc queries in Toad/SQL*Plus to validate the data loaded in the oracle tables.
• Unit testing of the code written using various SQL Scripts.
• Fulfill complex ad-hoc Oracle SQL query/reporting requested by business users.

Confidential

Responsibilities:

• Analyze the sales load process for each client to create and maintain the client profile such as client details, file details, claims process details, client contact details.
• Coordinated with users, and monitored the process on a daily basis.
• Worked with product managers to give work estimates and advised on design.
• Developed various mappings in Informatica using transformations like Joiner, Filter, Lookup, Normalizer, Expression, Router and so on to extract, transform and load the source data into files for reporting purposes.
• Improved the Informatica mapping performance using SQL overrides.
• Used Informatica Workflow Manager to create, schedule, sessions and send pre and post session emails to communicate success or failure of session execution.
• Informatica Data Quality was used to check for source data consistency.
• Configured and developed different database objects
• Developed Packages and customized functions and Triggers based upon the business logics.
• Used Bulk Collect feature and partitioning of tables to improve performance
• Created various packages/procedures for the sales load process.
• Verified the sales load for each client for the contracts creation, claims creation and retrieval of contract information at the Oracle backend tables and at the Oracle Applications Contact Center/PEGA/Portal call flow.
• Played a key role to successfully rollout 90+ clients to the NEW sales load process with minimal errors.
• Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time.
• Perform unit testing and assist in integration and end user testing
• Perform troubleshooting to fix production defects; prepare and support configuration management releases and post install validation.

Confidential

Responsibilities:

• Auto load functionality was implemented using Oracle PLSQL.
• Procedures, views, packages, global temporary tables were created.
• XML’s were generated using oracle procedures for use in cross environmental auto load to DEV, QA/UAT and PROD.
• Confidential portal data was verified for any missing relevant data in all the tabs before auto load starts.
• Implemented features in oracle to auto load for possible combinations of new data and existing data.
• Involved in creating the Oracle Database Objects like Tables, Indexes, Views, Synonyms, Triggers, Stored Procedures, Functions and Packages.
• Error logging was done and the ability to restart from the failed step based on the environment it was loaded from was handled through oracle PLSQL.
• Many existing issues from manual load were resolved as nothing can be edited manually once the auto load process starts.
• Improved the templates load efficiency by automating the load process.
• Templates data accuracy was managed by adding some simple validation rules for inserts/updates/upload from excel feature.
• Cross environmental load with just a button click, error logging and restart auto load from failed step are few challenges to mention.

Confidential

Responsibilities:

• Participated in business meetings to understand the requirements and functionalities.
• Various mappings in Informatica were developed using various transformations like Joiner, Filter, Aggregator, Router, Update Strategy, Connected/Unconnected Lookup, Expression, and Normalizer to implement the business logic from the existing Stored Procedures.
• Mapplets and Reusable Transformations were used in Informatica to prevent redundancy of transformation usage and maintainability.
• Created tasks and workflows in the Informatica Workflow Manager and monitored the sessions in the Informatica Workflow Monitor.
• Involved in performance tuning of the Informatica at mappings and session level.
• Responsible for communicating with the QA/UAT team and users.
• Developed various API’s with complicated business logic embedded in it.
• Generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, sequences, synonyms
• Documented business rules, functional and technical designs, test cases, and user guides.
• Creating and modifying cursors, stored procedures, triggers and Packages using PL/SQL.
• Responsible for integrating the system with billing gateway and portal teams.
• Involved performing additional tasks, Design, Release management, Code review, User communication, Analysis
• Verified various cases such as contracts created, contracts billed for the first time and subsequent billing, contracts terminated, contract status
• Involved in Performance tuning of complex database queries.

Confidential

Responsibilities:

• Worked with the business to assess requirements and Implement solutions for the flat rate matrix.
• Various procedures/packages were developed to extract data from Source to targets.
• API to Lookup flat rate matrix was created to get the flat rate on the basis of the key data elements.
• Performed various data checks if client is included/excluded from flat rates/insert new rules/update rules by checking conflicts based on category, brand, product size, effective date, service type and client.
• Provided ability to view/maintain/modify the flat rate matrix.
• Provided ability to get the eligible claims for flat rates and comparison against the flat rate matrix.

Confidential

Responsibilities:

• Worked closely with the business community to assess business needs for ETL process, define requirements and Implement solutions for the Confidential .
• Provided ability to support configurable warranty functionality.
• Created Oracle backend packages that will be called via web-services from the Portal front end.
• Written various test cases to ensure proper functionality and tested it through Portal and web services.
• Verified various cases such as contracts created, update unknown products when customers call the customer care representatives and retrieval of contract information from the Oracle Applications Contact Center.

Confidential

Responsibilities:

• Creating and modifying cursors, stored procedures, triggers and Packages using PL/SQL
• Responsible for integrating the system Creating Synonyms, Sequences, tables, Views, PL/SQL tables and Records.
• Developed procedures to provide Blue Realm with the ability to create consumer and contract if not already created in NEW system for particular service plan and registration information provided.
• Provided functionality to support auditing and logging for production support and reports.
• Wrote various test cases to test the entire Blue Realm functionality through web service calls.

Confidential

Informatica/Oracle Developer

Environment: Informatica 8.5/7.1, Oracle 9i, SQL*Plus, SQL*Loader, PL/SQL, Unix Shell Scripting, MS SQL Server, Teradata, Queryman, Query Analyzer, UDB DB2, Windows 2000

Responsibilities:

• Requirements Gathering and Business Analysis.
• Involved in the Data Modeling and populating the business rules using mappings.
• Performed adhoc queries on Teradata and MS SQL Server Database to check for data consistency using Queryman/ Query Analyzer.
• Created PL/SQL stored procedures, packages and SQL scripts in Oracle as per requirements from the PGPP user team to extract data from the sources MS SQL Server and Teradata.
• Data was extracted from spreadsheets and then loaded into Oracle tables using SQL Loader.
• Used DTS designer to extract, transform and consolidate data from disparate sources.
• Various mappings in Informatica were developed using various transformations like Joiner, Filter, Aggregator, Router, Update Strategy, Connected/Unconnected Lookup, Expression, and Normalizer to implement the business logic from the existing Stored Procedures.
• Mapplets and Reusable Transformations were used in Informatica to prevent redundancy of transformation usage and maintainability.
• Unix Shell scripts were written for automating the monthly load process by incrementing the mapping parameter/variable values and then updating the parameter file and used Informatica's command line administration functionality (PMCMD).
• Created tasks and workflows in the Informatica Workflow Manager and monitored the sessions in the Informatica Workflow Monitor.
• Involved in performance tuning of the Informatica at mappings and session level.
• Analyzed the business requirements for ETL process.
• Involved in querying the Source Teradata tables using Queryman tool.
• Developed various Informatica mappings using transformations like Joiner, Filter, Lookup, Normalizer, Expression, Router and so on to extract, transform and load the source data into files for reporting purposes.
• Improved the Informatica mapping performance using SQL overrides.
• Used Informatica Workflow Manager to create, schedule, sessions and send pre and post session emails to communicate success or failure of session execution.
• Created UNIX shell scripts to ftp the source files, update the mapping parameter values in the parameter file, compress and merge the extract files.
• Created UNIX shell scripts to automate the ETL process that would load the data periodically.
• Analyzed the existing system and done modifications to implement new logic.
• Documenting the requested system enhancements.
• Developed PLSQL scripts in Oracle using procedures, functions and packages for processing business logic in the database.
• Coordinated with source system users, and monitored ETL process on a daily basis.
• Utilized SQL loader, export/import utilities for data load and transformation.
• Extensively worked on creating Triggers for data security.
• Ran the SQL scripts through UNIX shell scripts.
• Performed adhoc queries in Toad/SQL*Plus to validate the data loaded in the oracle tables.
• Unit testing of the code written using various SQL Scripts.
• Provided Production Support and Maintenance by adding new features as and when required.
• Analyzed the requirements and created a logical model of the Oracle database and represented the entity hierarchy and relationship using ER diagrams.
• Data was extracted from two source systems (MO Data Warehouse and Facets), transforming and loading the staging/ Data mart/ Summary tables using Oracle stored procedures and SQL Loader.
• PL/SQL procedures were developed in Oracle to gather statistics of the tables after insert/update/delete.
• Involved in creation of Oracle Indexes, Views, Triggers, Stored Procedures and Functions.
• Created SQL scripts to validate the data loaded into the tables at every stage using Toad/SQL* Plus.
• Created triggers to call the SQL scripts for data validations that would fire immediately after the data is loaded into the tables.
• Made performance improvements to the Oracle database by building Partitioned tables, Index Organized Tables and Clusters.
• Created UNIX shell scripts to execute the PL/SQL procedures and to automate the process.