SUMMARY

• Having 10+ years of experience with proven ability in the area of Distributed Multi - tier Application Development, Database Design, Data processing, Production Support on different platforms.
• Extensive experience in Banking, Finance, Telecom and Health care domains.
• Having 1+ years Big Data Ecosystem experience in ingestion, storage, querying, processing and analysis of big data.
• Hands on experience in Big Data ecosystem components like Hadoop MapReduce, Big Data, HBase, Zoo Keeper, Hive, Sqoop, Pig, Flume.
• Good Understanding of Hadoop architecture and Hands-on experience with Hadoop components such as Resource manager, NameNode, DataNode and MapReduce concepts and HDFS Framework.
• Experience with NoSQL databases like HBase.
• Extensive experience in developing PIG Latin Scripts and using Hive Query Language for data analytics.
• Good working experience using Sqoop to import data into HDFS from RDBMS and vice-versa
• Good knowledge in using job scheduling and monitoring tools like Oozie and ZooKeeper.
• Extensively worked in Core Java and object oriented design with strong understanding of Collections, Multithreading and Exception handling.
• Experience in implementing various query-optimization techniques and business rules with relational databases in data warehousing environment.
• Experience in monitoring Performance and Tuning of the database for optimization using Explain Plan, Tkprof Report.
• Extensive experience in Data Analyst role, Involved in clarifying business requirement with customer, data analysis, creating mapping document source to target system in Informatica platform.
• Expertise on PL/SQL that includes Cursors, Bulking techniques, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Materialized Views, Table Indexing, Index Organized Tables (IOT), SQL*Loader, ETL Tools etc.
• Expertise in developing Data Conversions/Migration from Legacy System of various sources (flat files, Oracle, Non Oracle Database) to Oracle system Using SQL LOADER, External table and Calling Appropriate Interface tables and API’s.
• Worked on ETL tool Informatica Power Centre 8.6 using Oracle Data Integrator(ODI) with Oracle 10g database for end to end mapping from legacy database - IMS to oracle database
• Extensive experience in Complex SQL Queries, Dynamic SQL, Analytical function, Oracle Object etc.
• Experience in implementing Oracle Advanced Queuing techniques using AQEnqueue, AQDequeue, AQAgent and AQMessage.
• Experienced in working on UNIX platforms in file-handling and loading files into the Oracle and SQL Server databases.
• Handled large scale Multi-Terabyte databases.
• Skillful problem solver with excellent analytical skills.
• Has good experience in other tools like UNIX Shell Scripting, TOAD, XML, SQL Navigator
• Experience in Data flow Diagram, ER Diagrams using Oracle Designer.
• Experienced in all phases of the System Development Life Cycle (SDLC) and Best Practices (Oracle CDM) and Development Methodologies/Guidelines.
• Accomplished in working with users/upper-level management in translating their business needs into logical systems designs, as well as working in a technical team to implement the designs.
• Have experience in Relational and Dimensional Data modeling, Normalization, Denormalization, Data Architecture

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/8i/7x, SQL-Server, MySQL 5.2

ERP: Oracle Applications 11.5.9 (OM, PO)

ETL Tools: Informatica7.1 & 8.6.0, Ascential Data Stage

OLAP Tools: Crystal Report, Tableau.

Operating Systems: UNIX, LINUX,DOS and Windows XP/2K/NT

Web Technologies: HTML, CSS, JavaScript, XML.

Languages: Java, SQL, PL/SQL, UNIX Shell Script, C, C++

Source Control: Visual SourceSafe, Harvest, PVCS Version Controller

Tools: Toad7/9/10/11, PL/SQL Developer7/8/9/10, SQL Navigator5

PROFESSIONAL EXPERIENCE

Confidential - PA

Senior Oracle Consultant/Hadoop Developer

Environment: Hadoop, Hive, Pig, Mapreduce, Sqoop, Oracle, Java, TIBCO, ETL, Windows, TOAD, SQL, PL/SQL, SQL*Loader

Responsibilities:

• Prepared Technical documentation based on the functional specification.
• Developed Simple to complex Map/reduce Jobs using Hive and Pig.
• Wrote Pig Scripts to generate MapReduce jobs and performed ETL procedures on the data in HDFS
• Processed HDFS data and created external tables using Hive, in order to analyze visitors per day, page views and most purchased products.
• Exported analyzed data to HDFS using Sqoop for generating reports.
• Developed Hive queries for the analysts.
• Worked with data modeler and end users to understand the business and dataflow.
• Extensively worked on stored procedures, Functions, Packages etc. in SQL*Plus.
• Extensively involved with business clients for requirement analysis and to define business and functional specifications.
• Generated SQL scripts to install create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Created the materialized views and also created the partitioning tables.
• Used SQL*Loader to import data from large flat files to Oracle tables.
• Written SQL Scripts and PL/SQL Scripts to extract data from Database.
• Interacted with business analysts to identify and develop business requirements and transform it into technical requirements (Mapping Document) and ultimately responsible for delivering the solution.
• Prepared the Schedules for the Historical Load run and Incremental Load runs.
• Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process.
• Designed, developed and fine-tuned stored procedures. Tuning of SQL queries for better performance

Confidential - IL

Lead Oracle Developer

Environment: Oracle, Java, Oracle Advanced Queue, Windows, TOAD, SQL, PL/SQL, SQL*Loader

Responsibilities:

• Prepared Technical documentation based on the functional specification.
• Created Unit test plans and then debugging and testing the conversion process.
• Created the conversion work flow documents.
• Maintained naming standards and warehouse standards for future application development.
• Worked with data modeler and end users to understand the business and dataflow.
• Extensively worked on stored procedures, Functions, Packages, etc. in SQL*Plus.
• Created AQ related object Queue, Queue Tables, Payloads, Types, enqueue and dequeue.
• Extensively involved with business clients for requirement analysis and to define business and functional specifications.
• Created new database objects like tables, views, indexes and database links tailored to business requirements.
• Generated SQL scripts to install create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Used SQL*Loader to import data from large flat files to Oracle tables.
• Written SQL Scripts and PL/SQL Scripts to extract data from Database.

Confidential - IL

Senior Oracle Consultant.

Environment: Oracle, Java, TIBCO, ETL, Windows, TOAD, SQL, PL/SQL, SQL*Loader

Responsibilities:

• Prepared Technical documentation based on the functional specification.
• Created Unit test plans and then debugging and testing the conversion process.
• Created the conversion work flow documents.
• Maintained naming standards and warehouse standards for future application development.
• Worked with data modeler and end users to understand the business and dataflow.
• Extensively worked on stored procedures, Functions, Packages etc. in SQL*Plus.
• Extensively involved with business clients for requirement analysis and to define business and functional specifications.
• Created new database objects like tables, views, indexes and database links tailored to business requirements.
• Generated SQL scripts to install create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Created the materialized views and also created the partitioning tables.
• Used SQL*Loader to import data from large flat files to Oracle tables.
• Written SQL Scripts and PL/SQL Scripts to extract data from Database.
• Interacted with business analysts to identify and develop business requirements and transform it into technical requirements (Mapping Document) and ultimately responsible for delivering the solution.
• Prepared the Schedules for the Historical Load run and Incremental Load runs.
• Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process.
• Designed, developed and fine-tuned stored procedures. Tuning of SQL queries for better performance

Confidential - TX

Senior systems Consultant

Environment: Oracle, SQL-Server, Java, ETL, Windows, TOAD, UNIX, SQL, PL/SQL, Putty, SQL*Loader, SSH, SSIS

Responsibilities:

• Extensively worked on stored procedures, Functions, Packages etc. in SQL*Plus.
• Extensively involved with business clients for requirement analysis and to define business and functional specifications.
• Created new database objects like tables, views, indexes and database links tailored to business requirements.
• Generated SQL scripts to install create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Created the materialized views and also created the partitioning tables.
• Used SQL*Loader to import data from large flat files to Oracle tables.
• Written SQL Scripts and PL/SQL Scripts to extract data from Database.
• Interacted with business analysts to identify and develop business requirements and transform it into technical requirements (Mapping Document) and ultimately responsible for delivering the solution.
• Worked on extracting data from source systems and transforming the data according to business rules and loading the data into target systems.
• Experience using UTL FILE to load data from Oracle tables into a flat file.
• Designed and developed UNIX scripts using shell.
• Designed and developed new API by using PL/SQL collection objects.
• Maintained naming standards and warehouse standards for future application development.
• Worked with data modeler and end users to understand the business and dataflow.
• Prepared the Schedules for the Historical Load run and Incremental Load runs.
• Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process.
• Designed, developed and fine-tuned stored procedures. Tuning of SQL queries for better performance.
• Loaded Data from huge flat files to Oracle Database tables.
• Used TK-Prof and SQL Trace, Explain Plan to speed up the SQL Statements.
• Analyzed tables and indexes for performance tuning.
• Involved in the implementation of UNIX shell scripts to process the Flat Files.
• Involved in creating Unit test plans and then debugging and testing the Workflows
• Interacted and coordinated with technical and non-technical clients while providing 24/7 production support.

Confidential - TX

Sr.Oracle Developer

Environment: Oracle, Java, Informatica, Windows, TOAD, UNIX, SQL, PL/SQL, Putty, SQL*Loader, SSH

Responsibilities:

• Extensively worked on stored procedures, Functions, Packages etc. in SQL*Plus.
• Extensively involved with business clients for requirement analysis and to define business and functional specifications.
• Created new database objects like tables, views, indexes and database links tailored to business requirements.
• Generated SQL scripts to install create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Created the materialized views and also created the partitioning tables.
• Used SQL*Loader to import data from large flat files to Oracle tables.
• Written SQL Scripts and PL/SQL Scripts to extract data from Database.
• Interacted with business analysts to identify and develop business requirements and transform it into technical requirements (Mapping Document) and ultimately responsible for delivering the solution.
• Worked on extracting data from source systems and transforming the data according to business rules and loading the data into target systems.
• Extensively used ETL tool Informatica to load data Oracle, MS SQL Server, Flat Files to the target database.
• Extensively used almost all of the transformations of Informatica including lookups, Normalize, Update Strategy and others transformations. Developed sessions using Informatica Workflow Manager.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Experience using SQL*Loader to load data into Oracle tables from a flat files.
• Expert in using Informatica Client tools Repository manager, Designer, Workflow manager and workflow monitor.
• Designed and developed UNIX scripts using shell and Perl.
• Developed Stored Procedures.
• Maintained naming standards and warehouse standards for future application development.
• Worked with data modeler and end users to understand the business and dataflow.
• Developed workflows, Worklets and sessions using Workflow Manager for loading data into target flat files.
• Developed several Informatica mappings, and tuned them for better performance.
• Prepared the Schedules for the Historical Load run and Incremental Load runs.
• Performed extensive debugging and performance tuning of mappings
• Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process.
• Designed, developed and fine-tuned stored procedures. Tuning of SQL queries for better performance.
• Loaded Data from huge flat files to Oracle Database tables.
• Used TK-Prof and SQL Trace, Explain Plan to speed up the SQL Statements.
• Analyzed tables and indexes for performance tuning.
• Involved in the implementation of UNIX shell scripts to process the Flat Files.
• Involved in creating Unit test plans and then debugging and testing the Workflows
• Interacted and coordinated with technical and non-technical clients while providing 24/7 production support.

Confidential - IL

ETL Developer

Environment: Oracle, Informatica, UNIX, Windows, TOAD, PL/SQL Developer, Putty, SQL, PL/SQL, SQL*Loader

Responsibilities:

• Extensively used almost all of the transformations of Informatica including lookups, Normalize, Update Strategy and others transformations. Developed sessions using Informatica Workflow Manager.
• Wrote Stored Procedures, Functions, Packages in SQL*Plus.
• Closely involved in the Data Modeling Design of the MAAS Data mart and some aggregate tables designed especially for the Reporting purpose on specific request of the client.
• Incorporated the model in Erwin, Physicalzed the tables adding indexes. Worked extensively with large amount of data and handled data up to 120million rows.
• Created mapping flowcharts so that it’s easily understandable across business and developers.
• Created mappings, sessions, workflows, batches producing different load ready files and then loading into the table through SQL*Loader.
• Used star schema for the MAAS Data mart and used demoralized tables for the aggregated tables designed for reporting.
• Used Lookup transformation on flat files, Aggregate, Update, Expression, sort transformations. Used parameters at session and workflow level and file lists.
• Designed the procedures for getting the data from all systems to Data warehousing system.
• Expert in using Informatica Client tools Repository manager, Designer, Workflow manager and workflow monitor.
• Used PL-SQL Developer and TOAD to Analyze and test the loaded data of sources as well as Target RDBMS Databases.
• Created UNIX scripts to implement complex ETL jobs, like ftp scripts and scripts to validate the data and make the data reader to Informatica.
• Generated SQL and PL/SQL scripts to install create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Created Database and backup and recovery techniques and Query level optimization.
• Used TK-Prof and SQL Trace, Explain Plan to Speed up the SQL Statements.
• Developed and tested all the backend programs, Informatica mappings and update processes.
• Interacted and coordinated with technical and non-technical clients while providing 24/7 production support.

Confidential, NY

Oracle PL/SQL Developer

Environment: Oracle, Java, UNIX, Windows, TOAD, PL/SQL Developer, Putty, SQL, PL/SQL, SQL*Loader

Responsibilities:

• Generated SQL and PL/SQL scripts to install create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Extensively involved with business clients for requirement analysis and to define business and functional specifications.
• Experience using SQL*Loader to load data into Oracle tables from a flat files.
• Generated SQL and PL/SQL scripts to install create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Written SQL Scripts and PL/SQL Scripts to extract data from Database.
• Designed and developed UNIX scripts using shell and Perl.
• Developed Stored Procedures.
• Maintained naming standards and warehouse standards for future application development.
• Developed several Informatica mappings, and tuned them for better performance.
• Prepared the Schedules for the Historical Load run and Incremental Load runs.
• Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process.
• Designed, developed and fine-tuned stored procedures. Tuning of SQL queries for better performance.
• Responsible for supporting production and development environments.
• Error Handling & Debugging SIT (System Integration Testing) Bugs.
• Modifying & Creating PL/SQL Procedures, Functions, Packages, Triggers, and SQL Queries for Reports.
• Wrote Stored Procedures, Functions, Package in SQL*Plus.
• Created Database and backup and recovery techniques and Query level optimization.
• Used TK-Prof and SQL Trace, Explain Plan to Speed up the SQL Statements.
• Participated in quality assurance testing, code reviews, and new system integration / implementation planning.
• Develop and implement new interface.
• Developed standard reports as per user requirements.
• System level Testing, Unit Level Testing and Module Level Testing.
• Wrote UNIX shell scripts to automate the backup of the database.

Confidential, CA

Oracle PL/SQL Developer

Environment: Oracle, Java, UNIX, Windows, TOAD, PL/SQL Developer, Putty, SQL, PL/SQL, SQL*Loader

Responsibilities:

• Extensively involved with business clients for requirement analysis and to define business and functional specifications.
• Interacted with business analysts to identify and develop business requirements and transform it into technical requirements (Mapping Document) and ultimately responsible for delivering the solution.
• Exposure to Oracle E-Business Suite in PO, OM modules.
• Development and Customization of Reports, Conversions.
• Creation of Value sets in various Modules of the application.
• Defining Concurrent Programs, Request Sets and Executables.
• Concurrent Programs, PL/SQL API’s.
• Experience using SQL*Loader to load data into Oracle tables from a flat files.
• Created the necessary stored procedures, triggers for the implementation.
• Written SQL Scripts and PL/SQL Scripts to extract data from Database.
• Designed and developed UNIX scripts using shell and Perl.
• Maintained naming standards and warehouse standards for future application development.
• Prepared the Schedules for the Historical Load run and Incremental Load runs.
• Performed extensive debugging and performance tuning of mappings.
• Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process.
• Designed, developed and fine-tuned stored procedures. Tuning of SQL queries for better performance.
• Responsible for supporting production and development environments.
• Fine tuning the SQL Queries to improve the speed of program execution.
• Coordinated with users to ensure that the User Acceptance Testing is done successfully.
• Extensively worked on PL/SQL and wrote necessary scripts.
• Ensured that the programs, scripts, procedures fully tested to ensure bug free performance.
• Preparation and Review of Documentation of programs.
• Requirement analysis and discussion with client for clarification of the requirements.
• Responsible for Off-shore and On-site support.
• Complete responsibility of deliverables as well as the production support.

Environment: Oracle, ASP, Windows, TOAD, PL/SQL Developer, SQL, PL/SQL, SQL*Loader