SUMMARY:

• 8+ Years of IT experience
• 8+ Years of PL/SQL Programming experience
• 4 years of Informatica Power center.
• 4 years of Dimensional Data modeling experience
• 6+ Years of Unix Shell Scripting (Korn,bash,cshell scripting)
• 4 Yrs of Production Support
• 1 Year of Big data /Hadoop experience
• Eight plus (8+)years of IT experience in Data warehousing including Business Requirements Analysis, Design, Development, Testing and Implementation of Business Intelligence applications with RDBMS, Data Warehouse/Data mart, ETL, OLAP, Client/Server environment applications.
• Strong experience in Data Warehousing and ETL Process using InformaticaPowerCenter(Mapping Designer, Repository manager, Workflow Manager and Workflow Monitor),Data mart, OLAP, OLTP.
• Experience in BI Reporting Applications using Business Objects.
• Experience in Defining Testing Methodologies; creating Test Plans and Test Cases, Verifying and Validating Application Software and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC).
• Experience working on End - To-End implementation of Data warehousing applications and Strong understanding of Data warehouse concepts, ETL, Star Schema, Snow flake schema, Reporting, Business Process and Data Analysis.
• Database experience using Oracle 11i/10g/9i/8i/8.x,MS Access 7.0/2000, XML, PL/SQL.
• Well Versed with different SQL Development Tools like TOAD, SQL Developer, PL/SQL Developer. Strong experience with SQL, PL/SQL Coding.
• Well versed with AUTOSYS R11.3
• Implemented efficient and effective performance tuning procedures.
• Profound experience in performing all functions of System Development Life Cycle including writing design documents and Test plans and conduct Unit and System testing.
• Handled Production related Environment and has extensive working experience in Onshore/Offshore model and Onshore Co-ordination effectively communicated and delegated the Development, Maintenance and Enhancement tasks across the IT Team and Business community.
• Excellent problem solving, interpersonal and communication skills with experience working in fast paced, challenging and dynamic environment.
• Flexible and versatile to adapt to new environment and working on new projects and Committed to continuous improvement, excellent communications, and project management skills.

TECHNICAL SKILLS:

Data Warehousing: Informatica PowerCenter 9.5/9.1/8.6.1/8.5/8.1.1/7.1.2.

Dimensional Data Modeling: Dimensional Data Modeling - Star Schema, Snow-Flake Schema, FACT and Dimensions Tables, Physical and Logical Data, Modeling, Erwin 4.5/4.0/3.x.

Database related tools: PL/SQL, TOAD 9.7.2/8.5.1/7.5/6.2 , PL/SQL Developer 9.0.6, and SQL Sever 2008 R2

BI & Reporting Tools: Business Objects (Universe and Reports), OBIEE

Languages & Web Technologies: SQL, PL/SQL, UNIX Shell Scripting, HTML, and XML,TIDAL schedulingMongo DB, Cassandra 4x

PROFESSIONAL EXPERIENCE:

Confidential

Sr. ETL / Informatica Developer

Responsibilities:

• Reviewed data models essentials for the Confidential functionality with data modelling team and data architecture team.
• Created design specifications for Interfaces from ODS data base to enterprise service bus.
• Created interfaces in oracle packages to implement data flow from web methods.
• Developed DDL scripts, DML scripts which ever essential for new tables and pre population of tables and deployed them working with DBA team.
• Created ETL specific oracle packages to load the customer data from various front end systems such as TP, APPAIN .
• Created ETL packages to load the Confidential data pertaining to Pershing file.
• Used both Informatica designer and oracle ETL mechanisms to transport the data from various sources.
• Created Oracle PL SQL packages, procedures, functions, triggers along with BULK LOAD, BULK COLLECT, FOR ALL mechanisms to read data from web services.
• Created Oracle SQL pipelined table functions to transport data.
• Created Oracle PL SQL utility functions to Pivot and Unpivot data dynamically and also created metadata framework to parse XML data using DBMS XMLGEN, XML SEQUENCE utility functions.
• Created complex SQL queries to transpose data and also used it in SQL override transformation.
• Used explain plan utility to mitigate common oracle, processing, sql query related using by applying Hints, using DBMS STATS collection mechanisms.
• Worked on various performance, debugging, production related issues related to Oracle stored procedures by using utilities in oracle.
• Created packages to read XML data from various applications and normalize and load it based on the WSDL contract.
• Leveraged used of Informatica transformations such as web service transformations, Java transformations to handle XML and string related parsing complex scenarios.
• Used various transformations like Lookup, Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, SQL and Union to develop robust mappings in the Informatica Designer to transport the data to reporting data base IRIS.
• Developed mapping parameters and variables to support SQL override and created global parameter files for loading SRC, STAGING, ODS & HIST tables.
• Created oracle packages to overcome normalizer limitation by dynamic transposition of rows.
• Developed mappings to load into Sources, STAGING, ODS and HIST tables
• Developed mapplets to reuse the code related to
• Developed mappings to load the static data into Dimensions
• Used existing ETL standards to develop these mappings.
• Created Java classes to pipe the data from AWS to Hbase, hive and implemented PIG scripts to processed unstructured data .
• Worked on different tasks in Workflows like sessions, event wait, decision, e-mail, command, and scheduling of the workflow.
• Implemented poc using open source databases such as Mong Db and Ellastic search
• Used Debugger to test the mappings and fixed the bugs in the Audit trail datamart.
• Responsible for Optimizing Informatica performance using session logs and applying partitions, indexes at database level.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Will act as one point of contact for Project related issues/escalation and maintain effective communication between the IT and Business teams.
• Scheduled Jobs in Tidal for batch loading .
• Involved in fixing the UAT issues reported by users.
• Effectively managed support and code release activities and also worked on ERFC, RFC as required.
• Involved in monthly release activities related to Confidential phases.

Environment: Informatica Power Center 9.1.0, TOAD for Oracle 9.7.2, Oracle12c, Shell Scripting, Java Scripting, Mongo DB, BIG DATA, AWS.

Confidential

Sr. ETL / Informatica Developer

Responsibilities:

• Responsible for Analysis and development of the new requirements of WAVE IT reporting based on feeds sent by external vendors
• Responsible for estimation of the project and planned for buffer
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor
• Created functional specification documents to outline data flow from sources to targets
• Created the technical specifications and file layouts for downstream feeds
• Used various transformations like Lookup, Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, SQL and Union to develop robust mappings in the Informatica Designer.
• Developed mappings to load the static data into Dimensions
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, event wait, decision, e-mail, command, and scheduling of the workflow.
• Assign the jobs to BATCH and create a flow (Generate parameters values, Batch open, Pre-validation, Stage load, Stage load validation, ODS load, Post validation, HIST Load, Batch Close) for the same. AUTOSYS is used to run the jobs.
• Used Debugger to test the mappings and fixed the bugs
• Handled changes effectively by implementing the change management process at UAT stages
• Responsible for updating status to the client on a weekly basis

Environment: Informatica Power Center 9.1.0, TOAD for Oracle 9.7.2, Oracle11g, IPSWITCH WS FTP 9.0,ER STUDIO 8, SQL Server 2008 R2, AutoSys R11.3, Shell Scripting, OBIEE

Confidential, San Francisco/San Leandro

PL SQL / Informatica Developer

Responsibilities:

• Participated in the High level Architectural discussion of Confidential project.
• Discussed with the Infrastructural groups in the Setup of Confidential Project data bases.
• Raised Art, Remedy tickets, Problem Tickets and worked with DBA group in Installing the Database, allocation of various schema setup, creating the required users in the Confidential database, and also in creating External table directory set up on Unix servers.
• Thoroughly understood the BRD and created FSD for the monthly implementations for various source related data.
• Created Dynamic Data loading mechanism to automate the file loading process to the external tables.
• Responsible for estimation of the project and planned for buffer
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor
• Created functional specification documents to outline data flow from sources to targets.
• Used various transformations like Lookup, Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override and created global parameter files for loading SRC,STAGING, DW & DM tables.
• Developed mappings to load into Sources, ODS, Staging and DM tables
• Developed mappings to load the static data into Dimensions
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, event wait, decision, e-mail, command, and scheduling of the workflow.
• Used Debugger to test the mappings and fixed the bugs
• Prepared migration document to move the mappings from development to testing and then to production repositories
• Will act as one point of contact for Project related issues/escalation and maintain effective communication between the IT and Business teams
• Involved in fixing the UAT issues reported by users
• Handled changes effectively by implementing the change management process at UAT stages
• Responsible for updating status to the client on a weekly basis
• Responsible for tracking the status of project and update the status to the management on monthly basis.

Environment: Informatica Power Center 8.6.1, TOAD for Oracle, Oracle10g, Erwin 4.0, PL/SQL Developer 9.0.6, Shell Scripting, OBIEE

Confidential, California, CA

PL/SQL, UNIX, SQL Developer / Support

Responsibilities:

• Participated in Requirements gathering, planning and technical issues discussion phases of the project and frequently interacting with business users for Basket shipment optimization project
• Created new API’s to implement Business logic and also modified existing API’s to enhance the logic.
• Created PL SQL packages to implement the SCMT logic which is used for loading various surcharges.
• Used pipe lined table functions to improve the performance while materializing collections as and when needed.
• Created procedure and functions in the API’s to implement Consolidated BOX level weight limit logic.
• Used various collections Such as PL/SQL tables, Nested tables for implementing Confidential logic.
• Implemented various constructs relating to packaged collections and Object type references in PL/SQL.
• Created packaged references and Packaged Cursors to implement business logic.
• Used constructs such as BULK COLLECT, FOR ALL to reduce context switching wile using collections.
• Created SQL loader CTL files for loading various surcharges and to handle Adhoc requests.
• Used Cursors for processing the data and also used Collections for handling the data while processing.
• Bulk Binds and Records processing were handled for improvising the performance of processing.
• Used window functions such as Row Num (), Dense Rank () for deciding the ranking logic while picking up the best distributor.

Environment: Oracle 10g, Soloaris 11x, Toad 9.1, Remedy 7X

Confidential, Philadelphia, Pennsylvania

PL/SQL, UNIX Developer / Production Support

Responsibilities:

• Successfully accomplished 21.CFR PART 11 training, GMP, GOOD DOCUMENTATION PRACTICES modules essential training.
• Developed various interfaces to support data feeds to SMS application.Created subroutines using PRO*C for the PASSPORT application to meet the new change requests.
• Wrote new PRO*C programs to implement the business logic for validating the Practitioners and facility data.
• Worked on SQL loader scripts to Extract, transform and load the data in the Sample Management system.
• Developed PL/SQL Packages that implement the part of mapping of data to the Database tables.
• Worked on collections such as PL/SQL tables, Varrays, Nested tables, also used BULK collect, FORALL constructs to reduce the context switching and enhance the performance.
• Used UTL FILE utility to perform file I/O operations on various files which were needed to be loaded and processed into the database. Processed CLOBS, BLOBS for data extraction and data transformation by using the DBMS LOB package.
• Created Shell scripts to process the dependent jobs and also to perform SFT, FTP Jobs.
• Processed files using sed, awk,regular expressions to remove extra feeds and remove special charecters from files before loading.
• Created indexes such as Bitmap and Binary tree, function based indexes to improvise the performance.
• Extensively used EXPLAIN PLAN utility to leverage and optimize SQL .
• Used Unix Shell scripts using K-shell to automate the process of running jobs/batches using Crontab scheduling and process the feed files.

Environment: Oracle 10g, UNIX Sun Solaris 10x, Toad 9.1,, ERWIN 4.x, SMS 2.1,VSS,TWS job scheduler,PRO*C,C++,PERL 5.12,Change Point, Remedy

Confidential, New Jersey, NJ

Sr. Oracle PL/SQL Developer / Production Support

Responsibilities:

• Worked on the migration project involving integration of Organon Clintrace with AERS (CARES 1.3) for Global pharmacovigilance integration.
• Effectively used SQL loader Utility to load various Mapping files of Pregnancy Exposure cases, Product Repository Mappings, Gravidity and Parity, Codelist Mapping into AERS (CARES 1.3)
• Created packages which have various stored procedures and functions to do the process of transformation of data while migrating from CLINTRACE to AERS(CARES 1.3)
• Classified various direct, indirect and direct mapping with transformations to ease the process of migration involving complex business logic.