| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate
Candidate's Name
(Mobile: PHONE NUMBER AVAILABLEEmail:EMAIL AVAILABLE
STATUS: U. S. CITIZEN________________________________________________________________________________________OBJECTIVE: Looking for an opportunity as an Informatica, Power center 9.5 ETL Developer with Teradata13, Hadoop Developer (Latin Pig, Hive, HBase, Impala, Sqoop) Oracle SQL, Oracle PLSQL, Oracle 19c, Oracle APEX, OBIEE REPORTS, Tableau reports, Oracle APEX, Peoplesoft query manager or support, QLIK, Power BI,AWS, AZURE DATA BRICKS WITH SQL, SQL Server, T-SQL
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, 10.2(ETL) Data Warehouse, Hadoop Development for Big Data Solutions.
TECHNICAL SKILLS:
AWS: KNOWLEDGE OF S2 &S3 STORAGE & DIFFERENT CLOUD STORAGE LOCATIONSGLOBALLY, LAMBDA, REDSHIFT DW, AURORA DB.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, SQL Developer, Data Warehouse Informatica 9.5(ETL), Tableau Dashboard knowledge.
Reporting Tools: Crystal Reports, Cognos, Sql server reports, Tableau Reports, OBIEE, QLIK & Power BI.Hadoop Tools: PIG, HIVE, HBASE, SCOOP.Databases: Oracle 7.3, 8.x, Oracle 9i, 10G,12C, MS Access, SQL Server8,12, TERADATA V13 , NETEZZA, DB2, IBM Studio v4.1.3Operating Systems: UNIX, Windows NT, Windows 9x, Windows 2000Methodologies: Agile and Waterfall
Platforms: Windows, Linux
Languages: Informatica 9.5v(ETL), 10.2v, SQL*Plus, PL/SQL, SQL*Loader, Sql Server ETL Tool
EDUCATION:M.S., Computer Science, Jackson State University, Jackson, Mississippi, 1986
M.S., Food Science & Technology, Alabama A & M University, Huntsville, Alabama, 1982B.Sc. Agriculture science, Andhra Pradesh Agriculture University, 1977PROFESSIONAL EXPERIENCE:TCS, GENMAB /New Jersy Jan 2023 Mid May 2023INFORMATICA Analyst/plsql developerGathered requirements from the client, Attended daily meetings to validate the medical drugs validation to for realease. Documents created for power center source integration.Did develop many transformations to EDW. Supported the work done by me & team.Oracle 19c, new tables created, developed new procedures, functions, packages &triggers, tuned the queries with explain plan &dbms-profiler & Power BI reports.TCS, CARY,NC Feb 2022 to jan 2023Client:Met Life InsuranceCARY, NCData Transmission AnalystSETTING UP Data Transmission Setup for Inbound & Outbound Insurance Enrollment Tramsmissions for a variety of customers. Check the the status of customer files placed in Met life servers. Take care of customer issues for enollment data files used Informatica MFT TOOL.Did many transformations in Power center for the enrollments. Oracle 19C to validate enrollment data. new tables created, developed new procedures, functions, packages &triggers, tuned the queries with explain plan & Power BI reports.SETUPS are done in IBM customized app for Met Life. Created adhoc reports in Power BI.TCS, ERWING,TXClient: CITI GROUP May 2021 DEC.2021TDM Specialist, NAQE Validated and assigned daily Ticket s through Citi Group Apps. Oracle19C Sql scripts written for data validation. New tables created, developed new procedures, functions, packages &triggers, tuned the queries with explain plan & Power BI reports.Did develop many power center transformations to validate customer accounts.
Poer BI reports.TCS, Irving, TX
Client: CITI Group, Dec 2020 - April 2021
Migration of Datastage ETL jobs to Talend ETL jobs. Developed Power BI reports. oracle 19C database for development. Oracle Plsql procedures, function, packages were developed.TCS, Irving, TX
Clint: Bank of America, Pennington, NJ Aug 2020 - Nov 2020Oracle plsql developer
Developed Oracle Plsql procedures to validate data in Sql Server to insert data into Oracle 12C Audit tables. New tables created, developed new procedures, functions, packages &triggers, tuned the queries with explain plan. Customer validation reports were developed in Power BI.Apex Systems, Charlotte, NC
Client: Bank of America May 2019 August 2019
Application Architect V / Informatica developer Involved in Data migration project from Netezza v7.0 to ExaData v12 for data source to Data warehouse project. Migrated Teradata tables to Exadata as data source for Informatica. ARIBA procurement data migration for Vendor Data Warehouse, Vendor Administrative Data warehouse
Data source prep for Power center v10.2.
Oracle Apex reports were created. Oracle 19C db for development. Power BI reports.Computer Aid Inc, Harrisburg, PA
Client:High Mark Inc, Aug 2018 - Sept 2018
Informatica Analyst / programmer Worked on power center10.1v to transform DB2 source data to DB2 warehouse.
Created expression transformation to validate null value columns and data format columns by using user error & abort functions to error out & rollback data.
Created Maplets for reusable for different mappings.
Fixed non- fatal errors by fixing the transformations.
Involved in tuning by implementing push down optimization & session partitioning.
Fixed bottleneck issues in Informatica executions of workflow sessions.
Provided in expertise in session properties for source & targets & error handling issues. Ran batch jobs in Unix to run PMCMD to execute workflows using Cron jobs.
Oracle Apex graphical reports were created. Oracle 19C data as source data for informatica. Developed web app applications in Oracle APEX.FREELANCING in Hyderabad, India Aug 2007 - Dec 2009 Oracle Apps Tech Trainer Taught Sql, PlSql and Oracle ERP Applications
Received training in Informatica, Teradata and Hadoop
Global Knowledge, Cary, NC Senior Software Engineer Oct 2003 - July 2007
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.
Extracted data into Excel and presented to client and 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, TKPROF and SQL Trace. Developed 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. Processed change requests through Remedy ticket system, including application wide data changes. Responsible for Deploying changes to production and non-production environments.
Oracle APEX development. Source .csv files to create visual web apps reports.Oracle Corporation,
Senior Principal Consultant July 1998 - Nov 2002
Client: City of Chicago , Chicago Nov 2001 - Nov 2002 Responsibilities:
Lead the Technical team in data conversion for HRMS Applications (Vacancies, Requisitions, Employee, Applicant, Employee Applicant, Address, SIT, Assignment, Salary, Terminate, Element, Fed Tax, NACHA, State Tax) using SQL Loader. Designed and developed 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. Used the Trace and TKPROF for tuning strategy.
Oracle CorporationClient: Chicago Public School System, Chicago Aug 2001 - Nov 2001
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.
Oracle Corporation
Client: Michigan State (Welfare Department) East Lansing ,MI Dec 2000 - July 2001
Responsibilities:
Participated in the custom development interfaces for custom application using PL/Sql. Created custom reports using Oracle Discoverer. Developed Procedures, Functions and packages with PL/Sql code. Created Exceptions to handle errors. Documented for interfaces and for data conversions Involved in Performance Tuning, Profiling and Monitoring of SQL Via Explain Plan, TKPROF and SQL Trace. Developed temporary table to load legacy data, validated data in the staging table writing Triggers, stored procedures, Functions and PackagesOracle CorporationClient: American Trans Air, Indianapolis, IN May 2000 - Nov 2000
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, TKPROF 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 ad hoc 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.
Oracle CorporationClient: Wake County School System, Raleigh, NC Aug 1999 - April 2000
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 AOL. Involved in System Development Life Cycle such as Design, Development, Testing and Deployment to production.
Oracle Corporation
Client: Lucent Technologies, Reading & Allentown, PA July 1998 - July 1999
Responsibilities:
Implemented Integrated Circuits Information Solutions for Lucent Technologies by integrating Oracle Manufacturing Applications (WIP, MRP, BOM) from legacy systems using Sql Loader and Unix. Worked in 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. Involved in Performance Tuning, Profiling and Monitoring of SQL Via Explain Plan, TKPROF and SQL Trace. Using UTL_FILE utility of Oracle to extract data as a flat file and send it directly to reside on the server side.ASC, Inc.Client:FFM, Inc., Rocky mount, NC Feb 1997 - June 1988
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.
Bellcan ServicesClient: Unifi, Inc., Greensboro, NC Nov 1995 - Feb 1997
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.
WTW, Inc., RTP, NCClient: Natlsco, Chicago, IL Nov 1994 - Oct 1995
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. Developed Interfaces using PL/Sql and adhoc reports with Sql plus.
CDSIClient: US EPA, RTP, NC Sept 1993 - Oct 1994
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.
Saint Augustine s College, Raleigh, NC Aug 1988 - July 1993 Assistant Professor Taught computer courses to undergraduate students. (COBOL, FORTRAN, MIS, and SYSTEMS ANALYSIS & DESIGN).
Saint Paul s College, Lawrenceville, VA Aug 1986 - July 1988 Assistant Professor Taught Computer courses to undergraduate students.
|
