PROFESSIONAL SUMMARY:

• Around 13+ years of IT experience in the field of Data Architect, Database Development, ETL, DBA, Data Analyst, Oracle PLSQL, ETL Development, Data Modelling, Data Warehousing and Data Marts.
• Designed & developed OLTP and OLAP applications using Oracle, PL/SQL and ETL (Informatica).
• Extensive knowledge with ER and Dimensional Data modelling (Star Schema/snowflakes schema, Fact and Dimension tables).
• Thorough understanding of Normalization and De - normalization concepts and hands on experience in designing Normalized Databases and De-Normalized Databases for transactional and analytical systems.
• Experience working as a data modeler and Data Analyst, database design and data modelling (physical and logical) using ERWIN and sqldeveloper datamodeller.
• Experienced in Oracle 8i, 9i, 10g & 11g,12c, SQL *Plus, PL/SQL.
• Experience in ETL using Informatica PowerCenter 9.5/9.1/8.6/8.1/7.1
• Extensive experience in relational database development from creating complex database queries to advance PL/SQL, packages, procedures, functions and triggers to implement business logic.
• Extensively used the advanced features of PL/SQL like Performance hints, CURSORS/REF CURSORS, PLSQL Records, PLSQL Tables, Bulk Collect, Dynamic SQL, Exception Handling, XML Type.
• Good understanding of the Oracle database related utilities and tools like Oracle Hints, SQL* Loader, EXTERNAL TABLES, MATERIALIZED views, PARTITIONING.
• Excellent knowledge and hands on experience in sqltools like SQL navigator, TOAD, Oracle SQL Developer and plsql developer.
• Sound knowledge of debugging complex PL/SQL Code.
• Performed DBA tasks like managing users and security, schema objects, such as tables, indexes, views and monitoring and tuning performance
• Expertise in SQL tuning and have knowledge of oracle tuning tools like EXPLAIN PLAN, AUTO TRACE, SQL TRACE, TKPROF, DBMS MONITOR, STATSPACK, AWR Reports.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Developed Strategies for Extraction Transformation Loading (ETL) mechanism.
• Informatica PowerCenter tools such as Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected Connected Lookups, Aggregators, XML transformation, etc.
• Experience in developing Sessions tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow Worklet Designer.
• Experience in using the PDO (Push down optimization), CDC (Change data capture) mechanism.
• Experience in debugging mappings. Identified bugs in existing mappings by analysing the data flow and evaluating transformations using debugger.
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions.
• Good experience in documenting the ETL process flow for better maintenance and analysing the process flow.
• Hands on experience in Business Objects using BO Xi R3 Designer, Universe Builder, Desktop Intelligence, and Web Intelligence Rich Client.
• Proficient in UNIX Operating system, commands and shell scripting. Good knowledge of advance features like grep, awk, sed ect.
• Sound experience in projects analysis, designing and development in Airline, Pharma Industry.
• I have worked on all phases of a project SDLC in Waterfall, RAD, AGILE and manage service mode.
• Well versed with Elicitation Techniques like SRS, FRD, POC, Use cases, PRL for Requirements Gathering.
• Good experience in creation of project documents like Estimation Sheet (ballpark and FPA), HLD, Technical Specification, LLD, Project Plan, Test Case and test results, Project Matrixes, Status report, IRR etc.
• Aware of the incident and change management Process (plan phase, build, implementation phase and back-out method).
• Well versed with the coding standards and SNG as far as PLSQL code and ETL (Informatica) is concerned. Deployed naming standard to the Data Models at enterprise level and followed company standard for Project Documentation.
• Knowledge of version control tools like CVS and SVN.
• Have experience in development of housekeeping and archiving scripts.
• Strong experience in delivery and Production Support activities (jobs scheduling, monitoring, troubleshooting). Working experience with on and offshore model.
• Have experience with working in offshore/Onsite model. Worked with global clients.

TECHNICAL SKILLS:

Technologies: Oracle, SQL, PL SQL, Informatica Power Center 7x,8.x,9.x, Unix/Linux shell scripts, business objects

Databases: Oracle 7,8,8i,9i,10G, 11G,12c

Data Modelling: Erwin, sql developer modeller, ER Model, Dimensional Modelling

Estimation Technique: Functional Point Analysis and ball park

Service Management: HP Service Center 6, Peregrine

Monitoring Tool: Control M, Patrol alerts, 24*7 calloutsFramework and Methodology: Project Management Framework, ITIL Service Management, Agile methodology

Scheduling: Control-M

Mail Servers: Lotus Notes, Microsoft Outlook, office 360

Testing Tool: HP Quality Centre Tool, ALM

Version Control: SVN, CVS

Other tools: Filezila, merge, sqldeveloper, sql*plus, sqlnavigator, toad, sqltools, visio, sharepoint.

PROFESSIONAL EXPERIENCE:

Confidential, California

Lead PLSQL/ETL Developer

Responsibilities:

• Created/Updated of ETL architecture design flow to pull source data into warehouse/ DataMart.
• Extensively interacted with business users/Business Analyst in understanding business application, business data flow, data relations and the various logistics processes.
• Took part Data model (dimensional modelling), component architecture diagram and DSD.
• Did the data profiling of source and analysis of the fact, dimension, summary and reporting tables created.
• Developed Extraction, Transformation, and Load (ETL) scripts utilizing SQL, PL/SQL utilities and provide solutions to critical issues enhancing performance and productivity to the project.
• Wrote complex PLSQL programming with loop, CASE statement process flow, exception handling, records, collection, DML operations, complex XML/XSD structure, data retrieval using cursor and BULK COLLECT / FORALL, collections, packages, database triggers etc.
• Used architectural based tuning like Summaries and aggregations and technology based Performance tuning like Table partition, hints, indexes.
• Worked closely with the DBA team to ensure all the database objects are properly implemented and standards and guidelines of the company followed.
• Parallel PLSQL programming for the testing of ETL scripts. Batch runs were done over ETL(informatica) and parallel PLSQL scripts and minus query run over targets to test the ETL.
• Parallel SQL queries to test the Cognos reports produced.
• Involved in writing UNIX shell scripts to run and schedule batch jobs.
• Worked as onsite/offshore co-ordinator.
• Followed quality process and extensively used ALM quality tool used by the client.
• Used SVN for configuration management.
• Took part in design, code review and testing (Test strategy, Unit and System testing).
• Perform and maintain database security (create and maintain users and roles, assign privileges)
• Creation the business metadata as required by the business.
• Ensure that BI standard and guidelines followed in the delivery process and code.
• Ensure User acceptance test and live implementation goes smoothly.

Environment: Oracle 11g, SQL, PLSQL, sql*Loader, SQL *Plus, sql developer, Informatica 9.5, Korn Shell script, Control-M scheduling, sqldeveloper datamodeller, Visio, XML, XSD, cognos reporting, SVN.

Confidential

Database Architect

Responsibilities:

• Worked for both delivery and production support projects.
• Working with the business to define requirements and business Use Cases
• Define Project deliverables, milestones, SLA’s and acceptance criteria.
• Defining the methodology, standards and procedures to be used in the development of the new system.
• Ownership and management of project, issues and resources
• Frequent meetings/workshops with Client/ end user for scope and feasibility analysis
• Provide status reports to Senior management, Key Business Managers and Client.
• Communicating with the Client and understanding the requirement, Create SCS, Give Estimation using both ball park and functional point analysis.
• Create Technical Specs, PRL, HLD, LLD, Project metrics, data modeling, database design and ETL design.
• Did the data profiling of source and analysis of the fact, dimension, summary and reporting tables created.
• Design and development of the feeds in and out of the warehouse using PLSQL and ETL (informatica).
• Developed complex packages, functions and procedures to convert and parse data from XML files to multiple database tables.
• Development of mapping and workflows.
• Creating plsql stored procedure.
• Database management. Worked extensively on the performance tuning of the batch processing.
• Part of the team which monitoring and maintenance of around 500 batch jobs.
• Do Change Management, Emergency and Release management.

Environment: Informatica 9.1, Oracle, PLSQL, UNIX shell scripting, tableau

Confidential

Database Architect

Responsibilities:

• Worked for both delivery and production support projects.
• Working with the business to define requirements and business Use Cases.
• Manage the team. First point of Contact between the team, Client, Business, Product owner, 3rd party and stakeholders.
• Provide status reports to Senior management, Key Business Managers and Client.
• Communicating with the Client and understanding the requirement, Create SCS, Give Estimation using both ball park and functional point analysis.
• Create Technical Specs, PRL, HLD, LLD, Project matrices, data modelling, database design and ETL design.
• Created UNIX shell scripts to automate data loading, extraction and to perform regular updates to database tables to keep in sync with the incoming data from other sources.
• Did the data profiling of source and analysis of the fact, dimension, summary and reporting tables created. Wrote complex SQL queries to extract data from various source tables of data warehouse.
• Created various Function Based Indexes to significantly improve performance.
• Created tables, Correlated sub queries, Nested Queries, Views for Business Application Development.
• Experience in Partitioning Framework. Created List, Range partitions to store Transaction and Historical Data.
• Designing and building early window prototypes for the application
• Development of mapping and workflows.
• Database management, Creation of Objects like tables, views, sequence, Indexes, synonyms etc.
• Designing universe and BO reports.
• Perform tuning for packages and other PLSQL code by using hints, explain plan, and other database level tuning.
• Did incident and Change Management, Emergency and Release management.

Environment: Informatica 9.1, Oracle, PLSQL, business objects, unix shell scripting.

Confidential

Database Architect

Responsibilities:

• Worked for production support projects.
• Provide 24x7 Production support.
• Create Technical Specs, PRL, HLD, LLD, Project matrices, data modelling, database design and ETL design.
• Involved in creation and modifications of UNIX Perl scripts which includes calls to various business processes that are executed using Oracle stored procedures, functions, triggers, packages and DML operations.
• Designed and developed Oracle objects such as Tables, Views, Indexes, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL, Materialized Views, External tables and Dynamic SQL.
• Used concepts like Partitioning, Partition pruning, Index by Tables, Bulk Collect, Pipelined Functions, Insert All, Global Temporary tables.
• Performance tuning
• Wrote Database triggers for audit and to implement complex business logic.
• Created Purge process to remove or archive data older than the required span.
• Proficiently used debug feature in SQL Navigator, TOAD for debugging plsql programs
• Did incident and Change Management, Emergency and Release management.
• Developed test plan documents for all back end database modules.

Environment: Oracle, PLSQL, business objects, unix shell scripting.

Confidential

Database Architect

Responsibilities:

• Worked for both delivery and production support projects.
• Manage the team. First point of Contact between the team, Client, Business, Product owner, 3rd party and stakeholders.
• Provide status reports to Senior management, Key Business Managers and Client.
• Communicating with the Client and understanding the requirement, Create SCS, Give Estimation using both ball park and functional point analysis.
• Create Technical Specs, PRL, HLD, LLD, Project matrices, data modelling, database design and ETL design.
• Extensively worked on Oracle Packages, Triggers, procedures and functions using PL/SQL, SQL, SQL Navigator and PL/SQL Developer.
• Loading data using SQL Loader, External table and UTL FILE package.
• Development of mapping and workflows.
• Created UNIX shell scripts to automate data loading, extraction and to perform regular updates to database tables to keep in sync with the incoming data from other sources.
• Wrote Database triggers for audit and to implement complex business logic.
• Database management .
• Performance tuning, Test case preparation.
• Do Change Management, Emergency and Release management.
• Provide 24x7 Production support. Handled Production and UAT issues and manage the same in issue log.
• Resolving daily tickets, monitoring and support applications after monthly patching.
• Performed unit test on the developed code to ensure that its bug free. Developed test plan documents for all back end database modules.
• Created Purge process to remove or archive data older than the required span.

Environment: Oracle 11g/12c/10g/9i, SQL, PLSQL, sql*Loader, SQL *Plus, Oracle forms and reports, sql developer, Informatica 9.5, Korn Shell script, Control-M scheduling, Erwin, sqldeveloper datamodeller, Visio, XML, XSD, External tables, Essbase, excel macro.