SUMMARY

• Over 15+ years of IT experience in Design, Development, Implementation, Support and Maintenance of medium to large scale applications. A team player and self - starter who is capable of adapting quickly to emerging technologies
• Experience in developing applications using Oracle and Data Warehouse tools
• Experience in documenting business requirements, workflows and STTM’s
• Experienced in coding complex ETL procedures using PL/SQL and used SQL*Loader extensively
• Experience in analyzing business metadata and complex business rules
• Experienced in performance tuning of complex SQL queries and redesigning of long running processes in data mart databases
• Experience in database designing with strong understanding of Dimensional Modelling, Star schema and Snowflake schema.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica PowerCenter/PowerMart 10.1.1/9.6.1/8.6.1/ (Repository Manager, Designer, workflow Manager and Workflow Monitor).
• Expertise in developing Mappings and Mapplets/Transformations between Source and Target using Informatica Designer.
• Experienced in using advanced concepts of Informatica like PUSH DOWN OPTIMIZATION (PDO)
• Used Source side, Target side & Full Pushdown Optimization in various projects as needed
• Extensive experience in Extraction, Transformation and Loading of data using Informatica from heterogeneous sources
• Performed optimization and performance tuning to the existing and ongoing business processes in SQL, Mapping and Session level. Debugging and error handling with the help of error logs generated by Informatica. Have effectively used Performance tuning techniques like Pushdown Optimization (PDO) and session partitioning.
• Delegated all transformations of Informatica including lookups, stored procedures, update strategy, mapplets, SQL transformation and others.
• Developed effective working relationships with Business Users as Data analyst
• Excellent interpersonal and analytical skills with strong ability to communicate effectively. Experience in coordinating cross-functional teams.
• Extensive experience in web technologies like PSP, JSP, JavaScript, HTML, DHTML
• Experienced in writing Unix Shell Scripts

TECHNICAL SKILLS

Operating Systems: Windows, Unix, Linux, AIX

Languages: SQL, PL/SQL, C, C++, Java, JSP, XML, PERL and UNIX shell scripts

RDBMS: Oracle 7.x/8i/9i/10g/11g/12c/19c, MS-Access, SQL ServerPostgresql

EBS: Oracle Applications FAH, Oracle BI/XML Publisher

Application Dev Tools: Forms 4.5/5.0/6i/9i, Reports 2.5/3.0/6i/9i, Visual Basic 5.0, Microsoft Visual Interdev 6.0, My Eclipse

Data Modeling Tools: Designer 2000, ERWIN

OLAP Tools: Informatica 8.6.1/ 9.6.1/10.1.1 , Crystal Reports 8.0, TrilliumData Junction, Discoverer, Cognos Impromptu 8.4, Pentaho

Other Tools: SQL * Loader, TOAD, SQL * Station, SQLPALSecureFX, SecureCRT, Rational Clearcase, Rational Clearquest, DOORS, RALLY, JIRA and Visual SourceSafe

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Senior ETL Developer

Responsibilities:

• Involved in supporting the production cases on a daily basis. Analyze the end user requirements and suggest the technical solution on how best those requirements can be implemented
• Involved in designing and implementing the extracts for MSC outreach, Palliative care and ER Steerage programs using Informatica mappings, sessions and workflows
• Involved in gathering the functional and business requirements for all the extract integration interfaces and documentation of STTM’s (source to target mapping)
• Involved in setting up the ABC (automated batch control) framework for all the new projects in Informatica
• Extensively used Informatica Pushdown Optimization feature to shorten the data load time for outbound interfaces
• Coordinated the daily standup and defect meetings and reported the status to higher management on a regular basis
• Extensively involved in writing the SQL queries for better performance

Environment: Informatica 10.1.1, Netezza, Aginity Workbench, Putty, UNIX, SQL *Plus, JIRA

Confidential, Herndon, VA

Senior Informatica/ Database Developer

Responsibilities:

• Involved in designing and structuring of business rules loader process, business rules maintenance screen and attribute mapping to transaction objects for LAI initiative
• Involved in the analysis and design of MJE (manual journal entries) business rules solution for better processing timings and reports to business users on the validation failures
• Involved in gathering the functional and business requirements for all the LAI outbound interfaces and documentation of STTM’s (source to target mapping)
• Extensively involved in writing the stored procedures and SQL queries for better performance
• Involved in designing and developing the ETB (extended trial balance) framework using SQL, PL/SQL for business users to compare the production results to BOT (business operability testing) results
• Redesigned the roll forward process of LAI for better performance by introducing driver and intermediate staging tables
• Extensively used Informatica Pushdown Optimization feature to shorten the data load time for outbound interfaces
• Extensively involved in data analysis PEP (period end processing) event break out for better performance of system during production cycle and this is implemented in Informatica using mappings/sessions/worklets/workflows
• Extensively involved in performance tuning of queries used as part of pre and post SQL’s in Informatica
• Actively involved in redesigning the outbound interfaces in Informatica to use staging tables and then extracting the data to flat files
• Actively coordinated the business test cycle executions in higher environments such as UAT and BOT and reported the daily status to higher management
• Actively involved in the data analysis of production data and present the output in the format required by business users in Tableau dashboard
• Worked closely with business owners to make sure the requirements are converted correctly to functional specifications and the correct logic was implemented in the technical design documents
• Lead the release coordination and deployment activities of the agile releases
• Worked on the design of account roll forward module which is the key component of sub-ledger application to include ledger details and other derived attributes for LAI
• Participated in Sprint Grooming, Planning, Review, Retrospective and Daily Standup Meetings as part of SCRUM process
• Involved in the system generated and manual data attributes analysis of LAI stream which is the inbound interface of SLS
• Worked closely with data modelling team regarding the maintenance of metadata repository for business rules and interface validations
• Involved in data attributes analysis of FDR/ODS stream which is the outbound interface for SLS. This interface sends the journal activity and balances data to reporting data mart.
• Worked with PWC business team on the lookup short names for all events that are coming into SLS from LAI

Environment: Informatica 9.6.1/10.1.1 , Oracle Applications FAH Release 12, Oracle XML Publisher, Oracle 11g/12c, PL/SQL, TOAD, SQL*Loader, Rational Clear Quest, Putty, Rational Clear case, UNIX, SQL *Plus, Tableau, JIRA, Rally, Autosys

Confidential, Manassas, VA

Senior Database Developer/Database Administrator

Responsibilities:

• Provided Architecture for High Availability of Oracle Databases using Oracle Dataguard, Database Cloning, Oracle Flashback and RMAN Backup and Restore Strategy using Backup sets and Image Copy.
• Developed utilities for Oracle Controlled Takeover and Disaster takeover between Primary and Standby Databases in a Dataguard environment using PERL.
• Developed Oracle Flashback scripts in PERL for oracle database flashback on primary, standby or a failed primary database.
• Implemented Oracle RMAN Backup and Restore Strategy using Backupsets to take FULL, Incremental Level 0 and Level 1 backups and automating the process through crontab with SKIP READONLY tablespaces option in a Dataguard environment.
• Implemented Oracle RMAN Image Copy Backup and Restore strategy.
• Provide Database Administration for Schema changes, Data Modelling and Application Maintenance. Provide Application enhancements in Store and Forward Application using SQL and PL/SQL.

Environment: Oracle 11g, SQL, PL/SQL, Active Dataguard, Streams Advanced Replication, UNIX, Korn Shell Scripting, PERL Scripting.

Confidential, Rockville, MD

Senior ETL Programmer/Application DBA

Responsibilities:

• Involved in designing and structuring of book management, product catalog and proposal generation modules
• Worked extensively on Stored Procedures, Functions and Packages in Oracle 11g using PL/SQL
• Actively involved in requirements gathering, high level design, detail design and code review meetings
• Worked closely with business owners to make sure the requirements are converted correctly to functional specifications and the correct logic was implemented in the technical design documents and code
• Lead the release coordination and deployment activities of the project
• Worked on the design and development of book caching process which is critical for the brokers to access their data on a daily basis
• Worked extensively on SQL Performance Tuning and Code Optimization
• Involved in the proof of concept evaluation for Oracle Streams and implemented this to replicate the data synchronously between two databases
• Involved in the design and implementation of multi threaded processing during ingestion process using oracle scheduler and windows
• Participated in Sprint Grooming, Planning, Review, Retrospective and Daily Standup Meetings as part of SCRUM process
• Loaded the flat files for NFS Clients into database tables by applying transformation logic using Informatica
• Extensively used the mappings/worklets/workflows/sessions/transformations in Informatica
• Extensively used I nformatica Pushdown Optimization feature to shorten the data load time for inbound/outbound interfaces
• Worked closely with DBA group in re-organizing the tablespaces and setting the data modeling standards

Environment: SCRUM, Oracle 11g, PL/SQL, TOAD, Windows XP, SQL*Loader, MS Visual Studio, Putty, JIRA, UNIX, SQL*Plus, Oracle Streams, Informatica 8.6.1

Confidential, Reston, VA

Senior Oracle Apps / Database Developer

Responsibilities:

• Involved in designing and structuring of reporting data model and developing ETL processes in PL/SQL to transfer data from Oracle FAH to Reporting Tables
• Worked extensively on Stored Procedures, Functions and Packages in Oracle 11g
• Actively involved in requirements gathering, high level design, detail design and code review meetings
• Designed, developed and reviewed the front-end oracle applications concurrent programs
• Worked closely with business owners to make sure the requirements are converted correctly to functional specifications and the correct logic was implemented in the technical design documents and code
• Lead the release coordination activities of the project
• Worked on the design and development of account roll forward module which is the key component of sub-ledger application. The asset level balances by accounting period are being computed in this module
• Involved in data analysis of different streams that are supposed to be brought onboard to SLS system
• Worked extensively in tuning the SQL queries for better performance as there were SLA’s to meet
• Involved in design of Extraction, Transformation and Loading (ETL) of the data in the data warehouse for Oracle 11g database
• Worked extensively on Performance Tuning and Code Optimization
• Providing 24/7 Support for Functional, Regression, Integration, Load, Performance and UAT testing
• Designed and developed the reports using Oracle XML Publisher
• Involved in designing and developing the data definitions (XML) and templates (RTF) for reports
• Designed the solution for migrating the data definitions and templates across environments using XDO Utility
• Lead the release coordination activities of the project
• Involved in the proof of concept evaluation for Exadata server with Oracle team

Environment: Oracle Applications FAH Release 12, Oracle XML Publisher, Oracle 11g, PL/SQL, TOAD, Windows XP, SQL*Loader, Rational Clear Quest, Putty, Rational Clear case, UNIX, SQL *Plus