SUMMARY:

• 13 + Years of IT Experience in Analysing, Designing, Developing, Implementing and Testing of software Applications and Currently working as Architect at ILogic - inc, U.S.A
• 3 + years of hands-on experience in Informaitca BDM
• 5 + years of hands-on experience in Big Data/HADOOP Eosystems as well experinced in using AWS Hortonworkds (HDFS,MapReduce,PIG,HIVE,SQOOP,Flume,Oozie,ZooKeeper).
• 7+ years of hands- on experience in software design and development systems in Informatica Power center,Oracle EBS R12, Tera-data/Oracle PL/SQL, Mainframe, Core Java,Python and Unix/Bashscripting.
• Highly experienced IT professional with 13 years of commitment to excellence and the implementation of best practices worldwide specializing in Big Data (Hadoop Ecosystems) and Informatica (ETL).
• Hands on experience on major components of Big Data area.
• Excellent understanding of Hadoop architecture and different components of Hadoop clusters on Hoton works or Cloudera and experied in cloud enviornment(AWS).
• Create and maintain HiveQL warehouse/mysql for Hive analysis.
• Highly experienced in architecting Informatica Big Data Edition in desing, creation of mapping and workflow by leveging Big Data eco-systems.
• Experienced in creation of template using Big Data edititon for data acquisition into Hadoop Data lake enviorrment.
• Experience on python programing and Unix bash scripting in creation of scipts for hadoop enviornment.
• Strong experience in Data structures and various data structures(Array, Stack, Linked list and Tree).
• Extensively used Apache Sqoop for efficiently transferring bulk data between Apache Hadoop and relational databases (Oracle/MySQL).
• Automated sqoop,hive and pig jobs using Oozie scheduling.
• Experienced in working Big Data technologies in cloud enviornment(AWS).
• Configured & deployed and maintained multi-node Dev and Test Kafka Clusters.
• Developed multiple Kafka Producers and Consumers from scratch as per the business requirements.
• Developed POC’s and test cases to benchmark and verify data flow through informatica Big Data Edititon and Kafka clusters.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center and Informatica Big Data Edittion.
• Experience in resolving on-going production and maintenance issues and bug fixes; monitoring Informatica sessions as well improving the performance and fine tuning of mappings and sessions
• Proficiency in developing SQL with various relational databases like Oracle,SQL Server and Tera-data.
• Technically demnostroated and delivered various projects in Informatica ETL by following different meathodologies(Waterfall,Agile,Multi project generation).
• Good working knowledge with various Informatica client tools like Source Analyzer, Mapping designer,Transformation Developer,Repository manager and Workflow manager and exposure to Mainframe and UNIX shell scripting.
• Strong understanding of verticals in Oracle Finace(Oracle EBS modules - AP,AR,PA,FA,OAT and GL).
• Six Sigma Green Belt Certfication from Confidential Appliance & Lighting.
• HCA -Hortonworks Associate Certificted - By Hortonworks

TECHNICAL SKILLS

• Hadoop Ecosystems
• (Hive,Pig,Sqoop,Flume,Zookeeper,Oozie and AWS) and Kafka 5+ years
• Informatica Power Center (ETL) 7+ years
• Informaitca Big Data Editition 10.2 3 + Year
• Oracle EBS R12.2.3 (FA,AP,PA,OAT and VT) 4 + Years
• Python 2.6.6 2+ years
• Core Java 2 + years
• Oracle(11g), PL/SQL 10 years
• Unix Shell Scripting 1 + years

PROFESSIONAL EXPERIENCE

Confidential . U.S

Responsibilities:

• Lead the development, in implementing and take the responsibilities for setting up Informatica BDM from inception to production phase.
• Closely work with Business users, Informatica Product support group and Hortonworks teams in Providing solutions.
• Lead Development team in implementing programs through Informatica BDM mappings and executing them through various execution engines (Hive, Blaze and spark) mode for large volumes of Data-sets (INSERTS/UPDATE).
• Create programs using Informatica BDM mappings & workflows for various data ingestion into Hadoop Data Lake.
• SME(Subject matter expert) in setting up Hadoop configuration (Hadoop cluster, Hive connection) for Informatica BDM and testing Various execution engines of informatica BDE.
• Create programs using Informatica BDM mappings & workflows for various data ingestion into Hadoop Data Lake.
• Developing programs from Simple to complex Map/reduce Jobs using Hive, Sqoop and Pig and scheduling this program through apache Oozie.
• Creating dynamic programs through informatica workflows/mapping, so it can handle various Business model and rules for ingestion of various data sources.
• Develop Programs in Big Data by using Hadoop Ecosystems (HDFS, SQOOP, HIVE, PIG, Zeppelin, Oozie) for file Ingestion and DB Ingestion.
• Develop scheduling jobs through control-m for Informatica programs and hadoop Big Data progams.
• Create Programs in Pig Latin scripts and automating Pig command line transformations for data joins in Data lake..
• Implemented Sqoop functionality for DB ingestion and exporting from Data lake to any Relational sources.
• Designed and demonstrated in creation of the schema parameter file and automated generation of parameter file for various workflows.
• Develop API programing though Java,python and Unix bash scripting for Big Data application.
• Involved in poc phase of the project to bench mark aganist various ETL tools.
• Develop informatica workflow and mapping On cloud AWS in utilization of S3 buckets in reading and writing the data to and from data lake.
• Develop command line programs for code migration from one enviornment to another.

Environment

• AWS Hadoop Distribution: Hortonworks 2.6
• Informatica Big Data Edition 10.2.1, 10.2.0
• Control-m

Confidential . U.S

Responsibilities:

• Worked closely with the business in gather the requirements and converting them into techincal requirements Designed nal design into techincal design
• Extensly worked with Partitions, Bucketing tables in Hive and designed both Managed and External tables in Hive to optimize performance.
• Created and worked Sqoop jobs with full refresh and incremental load to populate Hive External tables.
• Desinged and implemented ABC process from each process as the data is moved from one hop to another and utilize this metrics for the reporting so that business can vizulise loss of data in the pipelines.
• Worked on creation of Oozie workflow for Daily ingestion jobs and export jobs.
• Developed Simple to complex Map/reduce Jobs using Big data Hadoop ecosystems (Hive,Sqoop and Pig).
• Design and Develop Pig Latin scripts and Pig command line transformations for data joins.
• Creating hive tables to the imported data for validation and debugging.
• Experience in using Sqoop to migrate data to and fro from HDFS and My SQL,Oracle and Teradata.
• Designing and creating Oozie workflows to schedule and manage Hadoop, Hive, pig and sqoop jobs for Daily Loads.

Environment

• AWS Hadoop Distribution: Hortonworks 2.5.2
• Operating system: Linux.
• Zepplin DashBoard

Confidential . U.S

Responsibilities:

• Extensly worked with Partitions, Bucketing tables in Hive and designed both Managed and External tables in Hive to optimize performance.
• Created and worked Sqoop jobs with full refresh and incremental load to populate Hive External tables.
• Experience is writting python scripts and unix bash scripting.
• Worked on Pig to do data transformations, event joins, filter and some pre-aggregations before storing the data onto HDFS.
• Worked on creation of Oozie workflow for Daily ingestion jobs.
• Developed Simple to complex Map/reduce Jobs using Hive,Sqoop and Pig.
• Design and Develop Pig Latin scripts and Pig command line transformations for data joins.
• Creating hive tables to the imported data for validation and debugging.
• Experience in using Sqoop to migrate data to and fro from HDFS and My SQL,Oracle and Teradata.
• Designing and creating Oozie workflows to schedule and manage Hadoop, Hive, pig and sqoop jobs for Daily Loads.
• Designed and deployed big data analytics data services platform for Data injection into Hadoop Data lake.

Environment:

• Hadoop Distribution: Hortonworks 2.4.2
• Operating System: Linux
• Informaitca Big Data Edition 10.2.0

Confidential

Responsibilities:

• Extensly worked with Partitions, Bucketing tables in Hive and designed both Managed and External tables in Hive to optimize performance.
• Created and worked Sqoop jobs with full refresh and incremental load to populate Hive External tables.
• Worked on Pig to do data transformations, event joins, filter bot traffic and some pre-aggregations before storing the data onto HDFS.
• Worked with highly unstructured and semi structured data.
• Developed Simple to complex Map/reduce Jobs using Hive and Pig.
• Design and Develop Pig Latin scripts and Pig command line transformations for data joins and custom processing of Map reduce outputs.
• Creating hive tables to the imported data for validation and debugging.
• Experience in using Sqoop to migrate data to and fro from HDFS and My SQL or Oracle.
• Designing and creating Oozie workflows to schedule and manage Hadoop, Hive, pig and sqoop jobs
• Installed and configured Hive,PIG and Zookeeper and other Ecosystems as a part of POC.
• Designed and deployed big data analytics data services platform for the injection to Hadoop

Environment

• Cloudera: Clouder Distrubtion(CDH 4)
• Operating System: Linux

Confidential Lighting.

Responsibilities:

• Involved in design and development phases of Software Development Life Cycle (SDLC).
• Developed data pipeline using Flume, Sqoop to ingest users behavioral data and purchase histories into HDFS for analysis.
• Used Pig to perform data validation on the data ingested using scoop and flume and the cleansed data set is pushed into HBase.
• Used Hive to analyze data ingested into hadoop environemnt and compute various metrics for reporting on the dashboard.
• Developed job flows in Oozie to automate the workflow for pig and hive jobs.
• Loaded the aggregated data onto MYSQL from Hadoop environment using Sqoop for reporting on the dashboard.

Environment

• Cloudera: Clouder Distrubtion(CDH 4)
• Operating System: Liunx

Confidential Lighting

Environment:

ETL Tool: Informatica Power Center 7.x/8.1.1/8.5.1/8.6.1/9.6

Data Modeling Tool: Erwin 4.5

RDBMS: Oracle 9i/10G/11G

BI Tools: Business Objects 6.5

Others: Mainframe, Unix

Tools/Utilities: TOAD and PL/SQL Developer

Responsibilities:

• Implemented several critical Informatica ETL load modules and worked closely with business clients to drive down closing defects to zero.
• Extensively worked in ETL code using Informatica tool in order to meet requirements for extract and transformation and loading of data from source to target tables.
• Extensively worked on Flat file source, target mapping, Source Qualifier,Aggregator, Lookup, Filter, Sequence generator, Router, Union, Update strategy etc., by implementing business rules and interfaced with various legacy source systems(Mainframe).
• Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.
• Created reusable transformations to load data from operational data source to Data Warehouse and involved in capacity planning and storage of data.
• Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in the Mapping Designer.
• Used various transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic.
• Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Implemented restart strategy and error handling techniques to recover failed sessions.
• Used Unix Shell Scripts to automate pre-session and post-session processes.
• Fine-tuned the process to improve Data Extraction, Data process and Load time.
• Extensively worked on complex SQL Queries involving multiple tables with joins.
• Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads.
• Worked on Mainframe JCL and datasets to extract data from Legecy system into informatica.

Confidential Lighting

Environment

ETL Tool: Informatica Power Center 7.x/8.1.1/8.5.1/8.6.1/9.6

Data Modeling Tool: Erwin 4.5

RDBMS: Oracle 9i/10G/11G

BI Tools: Business Objects 6.5

Others: Mainframe, Unix

Tools/Utilities: TOAD and PL/SQL Developer

Roles & Responsibilities

• Design, development of mappings, transformations, sessions, workflows and ETL batch jobs, shell scripts to load data into Sources and Targets using Informatica, PL/SQL, Unix Shell scripts.
• Demonstrated technical expertise in migrating the configurations from one instance to other instance.
• Providing permanent fixes for the all break-failures items/issues as a part of production support.
• Provided permanent fix for discount in VT, which lead to simplify entire VT discount process for PA/FA/AP project.
• Expertise in debugging the Sql and PL/SQL to identify the issues and fix them so that the transaction are processed smoothly to GL through VT.
• As a SME Ensured day to day operations/jobs are smooth and simplified entire VT process by fixing critical issue (eg: VT discounts,Asset Merge and progress payment), which lead to improve 800 hrs of IT productivity annually.
• Fine tuned the VT process by creating error report when there are failures so that business team will notified.
• Responsible for all activities related to the development/enhancements, testing and implementation.
• Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages in Oracle.
• Created request set and there incompability so that there would not be any conflicts between the requests/set when there are outage.
• Closed 35+ VT external support request by working with VT external team, which lead to be stabilized the system within 6 months after the GO-LIVE.

PROJECT Title - VOPS (VEHICLE ORDER PROCESSING SYSTEM)

Client: Confidential .

Designation: Assoicate - Projects

Environment:

• ETL Tool: Informatica Power Center 6.x/7.x
• Front-end: Business objects(518/WEBI 274)
• RDBMS: Oracle 9.2.0.7
• Languagues: SQL, PL/SQL and Unix
• Others : Mainframe , Java and HTML
• Tools/Utilities: TOAD and PL/SQL Developer

MOCA

MOCA is a sale and sold pipeline analysis tool designed to support future decision-making and the implementation of Targeted Product Offering (TPO).MOCA is a key tool to support the implementation, sustainment of TPO.MOCA provides a high level management summary to help track the performance of TPO by reporting average days on lot over time.MOCA helps identify Best Sellers by reporting entities and features in combination - helping us understand more about the vehicles the customers are buying.MOCA provides sold pipeline information to help indicate 'true demand by showing what was sold

Environment

ETL Tool: Informatica Power Center 6.x/7.x

Front-end: Business objects(518/WEBI 274)

RDBMS: Oracle 9.2.0.7

Languagues: SQL, PL/SQL and Unix

Tools/Utilities: TOAD and PL/SQL Developer

Others: Mainframe , Java and HTML

EXECNET

ExecNet is a European Sales Executive Information System (EIS), which provides high level sales information (summary data) for business decisions.

The information is presented in a user friendly environment which allows quick and effective access. The information is updated daily.The ExecNet system is based on open Internet technologies, and developed by Sales Reporting Systems, part of European Marketing Sales Service (previously European Marketing & Sales Systems).

Environment:

• ETL Tool: Informatica Power Center 6.x/7.x
• Front-end: Business objects(518/WEBI 274)
• RDBMS: Oracle 9.2.0.7
• Languagues: SQL, PL/SQL and Unix
• Tools/Utilities: TOAD and PL/SQL Developer
• Others : Mainframe , Java and HTML

SEER

SEER is a 'windows-driven' reporting and analysis application showing pipeline, stock and sales data. It is available in 21 markets.

SEER is a flexible,easy-to-use tool for creating reports and locating vehicles, which can be tailored for use within each country to reflect local business need.

The data held within SEER is derived from information held on central databases and downloaded every working night to a dedicated server within each 'user' market.

This provides many advantages. The data is always up-to-date, and is consistent with the existing central systems.

Also, being 'on-line', you can view and print out report immediately.

SEER is very easy to use. Screens and reports can also be exported to Excel enabling you to tailor the information to your own business requirements.

Environment:

• ETL Tool: Informatica Power Center 6.x/7.x
• Front-end: Business objects(518/WEBI 274)
• RDBMS: Oracle 9.2.0.7
• Languagues: SQL, PL/SQL and Unix
• Tools/Utilities: TOAD and PL/SQL Developer
• Others : Mainframe , Java and HTML

TELEIMMAT

Tele-Immat is a vehicle registration system only used by Confidential dealers in France. The primary driver for the Tele-Immat application was new legistration from the French Government, which requires all foreign importers (large volume producers) to develop a system that will allow dealers to submit electronic registration requests for passenger cars and light commercials. There is also a requirement that all customers be provided with Fichier de concordance document which describes the specification and equipment details of the vehicle that they are buying.

Environment:

• ETL Tool: Informatica Power Center 6.x/7.x
• Front-end: Business objects(518/WEBI 274)
• RDBMS: Oracle 9.2.0.7
• Languagues: SQL, PL/SQL and Unix
• Tools/Utilities: TOAD and PL/SQL Developer
• Others : Mainframe , Java and HTML

Responsibilities:

• Involved in the ETL technical design discussions and prepared ETL high level technical design document.
• Involved in the analysis of source to target mapping provided by data analysts and prepared function and technical design documents.
• Knowledge in Full Life Cycle development of Data Warehousing
• Experience with dimensional modeling using star schema and snowflake models.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow
• Extracted data from mainframe, high volume of data sets from data files, Oracle using Informatica ETL mappings/SQL PLSQL scripts and loaded to Data Store Area.
• Created complex Informatica mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator and Router transformations to extract, transform and loaded them into database.
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Expertise in scheduling Informatica jobs using Informatica, Windows scheduler.
• Fixing production issues and bug and working with the Business team for the enchancements.