OBJECTIVE:

Looking for aN opportunity As AN INFORMATICA PoweRCEnter 9.5 ETL DEVELOPER WITH TERADATA13, OR HADOOP DEVELOPER( Latin PIG, HIVE, HBASE, SQOOP),sql server ssis,ssas,ssrs.

PROFESSIONAL SUMMARY:

I have over 15 years of experience in software development. Experienced in life cycle development including requirements gathering, analysis, design, development, testing, deployment to production and post - production support in ORACLE ERP APPLICATIONS, INFORMATICA 9.5(ETL) DATA WAREHOUSING, HADOOP DEVELOPMENT FOR BIG DATA SOLUTIONS.

TECHNICAL SKILLS:

ERP Applications: Oracle Financials and HCM R12, Oracle Financials 11i, 10.7 (AP, AR, GL,GL, Fixed Assets, Order Entry, Front End Tools Oracle Developer 2000 (Oracle Reports 2.5/3.x,5.0/6.x), Discoverer (Oracle Browser 1.0, 4.0), Crystal Reports 6.5/8.x, Toad, SQL Navigator, Data Warehouse Informatica 9.5(ETL), Tableau Dashboard knowledge.

Databases: Oracle 7.3, 8.x, Oracle 9i, 10G, MS Access, SQL Server8,12, TERADATA v13

Operating Systems: UNIX, Windows NT, Windows 9x, Windows 2000, Windows XP

SDLC METHODS: AGILE SCRUM and Water fall Methodology

Platforms: Windows, Linux

Languages: Informatica 9.5(ETL),SQL*Plus, PL/SQL, SQL*Loader, sql server ETL TOOL

Job scheduler: Crontab

Reporting tools: crystlal Reports, cognos, sql server reports, Tableau Reports

Hadoop Tools: PIG, HIVE, HBASE, SCOOP, OOZIE. Knowledgeable in SPARK,SCALA,MAHOUT,KAFKA,FLUME

PROFESSIONAL EXPERIENCE:

Confidential

Hadoop developer/Teradata/Informatica developer

Responsibilities:

• Evaluated business requirements and prepared detailed specifications that follow project guidelines required to develop written programs.
• Responsible for building scalable distributed data solutions using Hadoop.
• Importing the data from the SQLServer to HIVE and HDFS using SQOOP for One time and daily solution.
• Worked on Big Data Hadoop environment on multiple Nodes
• Developed MapReduce programs and Pig scripts for aggregating the daily eligible & qualified transactions details and storing the details in HDFS and HIVE
• Implemented Hive tables and HQL Queries for the reports.
• Experience in performing data validation using HIVE dynamic partitioning and bucketing.
• Involved in Extracting, loading Data from Hive to Load an RDBMS using Sqoop.
• Extensive data validation using HIVE and also written Hive UDFs
• Involved in creating Hive tables loading with data and writing hive queries which will run internally in map reduce way.
• Worked on exporting the same to SQLServer, which further will be used for generating business reports.
• Worked in tuning HiveQL and Pig scripts to improve performance
• Good experience in troubleshooting performance issues and tuning Hadoop cluster.
• Load flat files from Hdfs file path to local informatica ( ETL ) file system directories. From here loaded as Source file into Informatica Power Center for transformations and loading processed data into final destination database for further decision making process.
• Used Teadata13 utilities: FastLoad, Multiload, Tpump, Fast EXPORT, BTEQ,TPT
• Used EXPLAIN, COLLECT STATISTICS for TERADATA performance tuning.
• Used Informatica PDO( push down optimization) and SESSION PARTITION for better performance .
• Created procedures, macros in Teradata
• Used Bteq for sql scripts and batch scripts and created batch programs using Shell scripts.
• Developed Apache PIG scripts to process the HDFS data. Created Hive tables to store the processed results in a tabular format.
• Developed the sqoop scripts in order to make the interaction between Pig and MYSQL Database.
• Developed the script files for processing data and loading to HDFS. Written CLI commands using HDFS. Developed the UNIX shell scripts for creating the reports from Hive data.
• Ran cron jobs to delete hadoop logs/local old job files/cluster temp files, Setup Hive with MySql as a Remote Metastore.
• Moved all log/text files generated by various products into HDFS location. Created External Hive Table on top of parsed data.
• Worked on different phases of Data Warehouse development lifecycle from Mappings to extracting data from various sources to tables and flat files. Created Re-Usable objects like Maplets & Re-usable transformations for business logic.
• Worked on Transformations, such as Rank transformations, Expressions, Aggregator and Sequence
• Experienced in working with complex mappings using expressions, routers, lookups, aggregators, filters. Worked on updates and joiners in Informatica, session partition, cache memory, connected lookups and unconnected lookups.
• Used TERADATA 13/Oracle databases for informatica DW tool to load source data.
• Created Teradata schemas with constraints, Created Macros in Teradata. Loaded the data using Fast load utility. Created functions and procedures in Teradata.
• Experienced in writing SQL queries, PL/SQL programming and Query Level Performance tuning.
• Developed and Tested database sub-programs (Packages, Stored Procedures, Functions) according to business and technical requirements
• Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes. Developed Packages, Stored procedures, created roles and granted privileges.

Confidential

Oracle Apps Tech Trainer

Responsibilities:

• Taught Sql, PlSql and Oracle ERP Applications
• Received training in Informatica, Teradata and Hadoop

Confidential, Cary, NC

Senior Software Engineer

Responsibilities:

• Responsible for analysis of production Oracle data extracts and worked closely with business and technical support staff to identify Data Anomalies, Data Trends and other Production Based Data issues.
• Developed and Tested database sub-programs (Packages, Stored Procedures, Functions) according to business and technical requirements
• Formatting data extracts using Excel, and presenting the data extracted to the client management for review. Used Sql Loader for data transfer.
• Involved in providing data from oracle procedures to Oracle Advanced Queues.
• Systems messages are sent to different retails stores throughout the country using to Oracle Advanced Queuing Technology.
• Using UTL FILE utility of Oracle to extract data as a flat file and send it directly to the server. Involved in Performance Tuning, profiling and monitoring of SQL Via Explain Plan, Confidential and SQL Trace .
• Written shell scripts to automate SQL Loader process to load data into the tables. Used SQL Profiler to monitor the server performance, debug T-SQL for slow running queries
• Process change requests through Remedy ticket system, including application wide data changes. Responsible for Deploying changes to production and non-production environments.

Employee

Confidential, Chicago

Responsibilities:

• Lead the Technical team in data conversion for HRMS application( Vacancies, Requisitions, Employee, Applicant, Employee Applicant, Address, SIT, Assignment, Salary, Terminate, Element, Fed Tax, NACHA, State Tax) using SQL Loader.
• Design and develop Custom reports using Oracle Discoverer, developed Interfaces using PL/Sql.
• Sql loader used for data conversion.
• Developed and Tested database sub-programs (Packages, Stored Procedures, Functions) according to stated business and technical requirements.
• Used cost - based approach to calculate execution plan with the lowest cost. Used syntax-based rules to determine precedence
• Gathered Statistics using Analyze command.
• Used the Trace and Confidential for tuning strategy.

Confidential, Chicago

Responsibilities:

• Involved in data conversion for Oracle applications using Sql Loader.
• Created custom interfaces using Sql Plus and PL/Sql.
• Design and develop Custom Reports using Oracle Reports, Sql and Discoverer. Modified Oracle reports using Oracle Discoverer and Oracle Reports.
• Developed test cases and executed tests for database programs such as Packages, Stored Procedures and Functions according to business requirements.
• Tuned PL/SQL code for faster performance.
• Created Indexes in the tables to optimize the PL/SQL scripts.
• Used Rule-based and Cost-based approach on the Sql statements for different scenarios and chosen the best Optimization approach for Sql queries.

Confidential, East Lansing, MI

Responsibilities:

• Participated in the custom development interfaces for custom application using PL/Sql.
• Created custom reports using Oracle Discoverer.
• Created Procedures, Functions and packages with PL/Sql code.
• Created Exceptions to handle errors.
• Created Documentation for interfaces and for data conversions.
• Involved in Performance Tuning, Profiling and Monitoring of SQL Via Explain Plan, Confidential and SQL Trace
• Developed temporary table to load legacy data, validated data in the staging table writing Triggers, stored procedures, Functions and Packages
• Used Toad/Sql Navigator for writing and executing the queries.

Confidential, Indianapolis, IN

Responsibilities:

• Involved in data conversion for Oracle HRMS application Sql Loader. Created custom reports using Oracle Discoverer and Oracle 6i.
• Developed PL/Sql used for interfaces based on functional requirements.
• Involved in Performance Tuning, Profiling and Monitoring of SQL Via Explain Plan, Confidential and SQL Trace
• Converted data from legacy systems using SQL Loader and Unix operating system.
• Registered SQL Loader scripts and interfaces in Oracle Application to get executed from Oracle Application.
• Used Sql Navigator for creating and execution of SQL scripts.
• Developed adhoc oracle reports using Sql Plus for the client management as per requirements.
• Using UTL FILE utility of Oracle to extract data as a flat file and send it directly to reside on the server side.

Confidential, Raleigh, NC

Responsibilities:

• Developed PL/Sql interfaces for 401k and other third party vendors based on functional requirements for Oracle HRMS application.
• Created new reports and modified existing reports using oracle Discoverer.
• Designed and developed PL/Sql procedures and packages for Oracle 11i HRMS.
• Developed and Customized Oracle HR/Payroll Reports using Oracle Reports 6i.
• Registered custom interfaces and packages in Confidential .
• Involved in System Development Life Cycle such as Design, Development, Testing and Deployment to production.

Confidential, Reading & Allentown, PA

Responsibilities:

• Implemented Integrated Circuits Information Solutions for Confidential Technologies by integrating Oracle Manufacturing Applications (WIP, MRP, BOM) from legacy systems using Sql Loader and Unix.
• Data Mapping for WIP, MRP, BOM. Customized Work in Process, Material Resource Planning, Bills of Material conversions and interfaces. For Software Configuration Management used Intersolv’s PVCS. Created Report- Sets for the Manufacturing modules.
• Designed custom reports using Discoverer.
• Created custom interfaces with PL/Sql in Oracle Purchasing and customized oracle reports to suit the client needs.
• Using UTL FILE utility of Oracle to extract data as a flat file and send it directly to reside on the server side.
• Involved in Performance Tuning, Profiling and Monitoring of SQL Via Explain Plan, Confidential and SQL Trace

Confidential, Rocky mount, NC

Consultant

Responsibilities:

• Gathered requirements, created Functional design documents and got approved from the business partners before the development.
• Implemented Account Receivable, GL, Fixed Assets from legacy systems.
• Customized Fixed Assets and Accounts Receivable reports.
• Converted legacy systems into Oracle and interfaced using PL/Sql in Oracle Financials (GL, AP,AR).
• Converted legacy systems into Accounts Payable and Purchase Order using Sql Loader.
• Created SQR reports Oracle Database.
• Created custom inbound and outbound interfaces with PL/SQL.
• Modified Oracle Seeded Reports to suit the client needs.
• Developed data mapping documents to bring data from external systems.
• Developed documents based on Systems development Life Cycle after consulting the client.

Confidential, Greensboro, NC

Consultant

Responsibilities:

• Implemented AP, GL, FA, OE from legacy systems using Sql Plus, PL/SQL and SQL Loader.
• Customized FA, GL & AP reports. Converted legacy systems into Oracle and interfaced using PL/Sql with Oracle Financials.
• Developed interfaces using PL/Sql for oracle purchasing and customized purchasing reports to suit client requirements.
• Extensive usage of SQL Loader to bring in Legacy data into First time Oracle Application users client.

Confidential, RTP, NC/Natlsco, Chicago, IL

Consultant

Responsibilities:

• Implemented Laboratory Management System (HP-LIMS) using Oracle data base.
• Extensive usage of LIMS is Laboratory Information Management System developed by HP.
• Implemented Order Supply Application using Oracle Forms 4.0 and Oracle Reports 2.0.
• Projects in Interactive Voice Response System Projects and Telephone Integration.
• Interfaces using PL/Sql and adhoc reports with Sql plus.

Confidential, RTP, NC

Consultant

Responsibilities:

• Implemented Scientific Work Planning Module and Publication Module using Oracle 6.x & 7.x,
• Developed basic forms and reports using Power Builder.
• Used PL/Sql for interfaces.
• Used Sql Plus to create adhoc reports.