Rahul Kumar

E-mail: adhkrk@r.postjobfree.com

LinkedIn Profile URL: linkedin.com/in/rahul-kumar-aerra-510451157

Phone No: 443-***-****

SUMMARY:

•12+ years of experience in Information Technology which includes experience in Business Requirement Gatherings, Analysis, Design, Data Modeling, Database Development, Reports creation, Testing and Implementation of Data warehouse/Business Intelligence using Oracle 8i/9g/10g/11g/12c, SQL Server 2016/2017, Informatica 9.x/8.x/7.x, ODI 12.2.1, SSIS 2017 and Crystal 2011/2008/XI, BOXI R4/R3.

•10+years of professional experience as Oracle SQL/PLSQL developer, Analysis, Design and Modeling.

•8+ years of combined experience in using ETL tools like Oracle Data Integrator, Informatica Power Mart/Center 10.2/9.1/8.6/8.2/8.1, IICS (Informatica Intelligent Cloud Services), Azure Data Factory and SSIS.

•Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

•Expertise with Data Migration, Data Mapping or Table mapping, Data loading and exporting by using Import Export, SQL*Loader and UTL File Utilities.

•Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.

•Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement, published Data model in model mart.

•Experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE.

•Extensively worked on Design, Development, Deployment & Maintenance of ETL process to Extract, Transform and Load (ETL) data from different sources (Flat/Excel/Access/XML SQL/ Oracle) to different targets (DB/Files).

•Worked extensively on Ref Cursor, External Tables, Dynamic SQL, Collections and Exception handling.

•Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.

•Possess strong Conceptual and Logical Data Modeling skills, has experience with JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications.

•Extensive experience working in Agile (Scrum) environment and Waterfall Model.

Dimensional Data Modeling: 4+ years of experience in Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.5/4.0/3.5/3.x, Oracle Designer.

Experience in developing Informatica Mappings/Mapplets using various Transformations and Oracle PL/SQL programs.

Extensive experience working in HP-UX, AIX and LINUX environment and performing file transfers, job scheduling and error handling.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.2/9.1/8.6/8.2/8.1, IICS, ODI 12.2.1, SSIS 2017, Azure Data Factory

Database: SQLServer 2005/2008/2012/2017, Oracle 8i/9g/10g/11g/12c, Azure SQL and MS Access 2003/2010/2013.

Scheduling Tools: Autosys, Crontab, BMC Control M, Cisco Tidal

Operating Systems: Windows 7 and 10 Enterprise, Windows XP/95/98, Windows 2000/2003/2012, Unix/Linux/Solaris.

Business Analysis: MS Project 2000, Business Requirements Gathering, Process flow diagrams, Microsoft Visio.

Languages: C, C++, Java, SQL, PL/SQL, T-SQL, ASP.NET, JavaScript, VBScript and Shell Script.

GUI Tools: Visual Basic 6.0/2010/2017, Developer 2000, Oracle Forms and Reports 10.1.2.3/11.x

Packages & Tools: SSMS v 18.4, TOAD 13.1.1.5/11.6.1, SQL Developer, DB2 Visualizer, SQL Server Profiler, Power shell

Data Modeling/Data Warehousing: TOAD Data Modeler 6.5, Erwin 4.1/3.5.5/3.5.2 (Dimensional data Modeling, Star Join Schema and Snow-Flake Modeling, FACT and Dimension Tables, Physical and Logical Data Modeling. Azure Synapse Analytics.

Business Intelligence: Crystal Reports XI R2/2008/2011/2013, Business Objects 5.x/6.1b/6.5/XI R2/XI 3.0 (Central Management Console, Designer, Desktop Intelligence, Info View, Web Intelligence), Power BI, Tableau

Version Control Tools: PVCS, Tortoise SVN, Team Foundation Server (TFS), GitHub

EDUCATION Qualifications:

Bachelor’s Degree in Information Technology, HITS College of Engineering, INDIA, Nov 2001 – May 2005

Master’s Degree in Computer Science, Towson University, MD, Aug 2006 – Dec 2008

PROFESSIONAL EXPERIENCE:

Crown Castle, Canonsburg, PA

Sr.ETL developer May 2018 – Present

Responsibilities:

Design ETL process using IICS between On-prem and cloud-based applications and apply transformation rules before loading data to the target system.

Modify existing PL/SQL procedures and convert them to ODI(ETL) Platform by using the new features within ODI to improve the performance of data loading into different target tables and in turn achieve the goal of near real time data within Operation data store.

Using Visual Studio SSDT 2017 to build SSIS packages to move data from transactional databases to a data warehouse environment for reporting.

Create an integration service catalog to deploy SSIS packages and to have dynamically setup source and target connections with in the catalog.

Using ODI tool to get data from external vendors with the help of rest API calls and apply certain transformations before loading them into target tables and manage pushing the data out to external vendors with the help of rest API service calls.

Environment: Oracle 12c, SQL, PL/SQL, ODI 12.2.1, SQL Server 2017, SSDT 2017, SSMS 18.4, Toad 13.1.5, SQL Developer 18.3, Windows 10 Enterprise, SVN, Win SCP, Linux, Tiger VNC Viewer, Team Forge, ODI, Informatica (IICS), Azure Synapse Analytics, Java, Oracle Golden gate 11.1.1, Azure DevOps, TOAD Data Modeler v6.5, Microsoft Dynamics D365 CRM.

USPTO, Alexandria, VA Jan 2017 – Apr 2018

Oracle Application DBA

Responsibilities:

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Extensively used bulk collection in PL/SQL objects for improving the performance of PL/SQL Programs.

Performed performance tuning of the queries and logic used in the existing Java applications using Explain Plan, TKPROF and AWR.

Recommended certain changes to the SQL Queries used to improve performance of the long running queries and what type of changes can be made to the logic used in some of the procedures for better performance and throughput.

Environment: Oracle 11g/12c, SQL, PL/SQL, Toad 11.6, SQL Developer 4.1.3, Windows 7 Enterprise, SVN, Crystal Reports 2011, Win SCP, Linux, Agile (Scrum), Java, Oracle Golden gate 11.1.1, CA Erwin Data Modeler Mart v9.5.0.

College Board, Reston, VA

Sr. Oracle Developer / Analyst Apr 2016 – Dec 2016

Responsibilities:

Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Intensive data analysis on the error log tables to ensure that the clean data gets in the table created.

Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.

Performed Data analysis and Data Profiling using Complex SQL on various source systems.

Environment: Oracle 11g, SQL, PL/SQL, Toad 11.6, SQL Developer 4.1.3, Windows 7 Enterprise, SVN, Crystal Reports, IBM Clear Quest, JIRA, Win SCP, Data Flux, Linux, Agile (Scrum), CA Erwin Data Modeler Mart v9.5.0.

Federated Investors Warrendale, PA July 2015 – Mar 2016

Sr. Application Developer/ Analyst

Responsibilities:

Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements. Created shell scripts to automate repetitive database processes.

Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.

Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.

Developed the Logical Data Model (LDM) & PDM and assisted the DBA to create the physical database by providing the DDL scripts including Indexes, Data Quality checks scripts and Base View scripts, keeping adherence to database optimization.

Environment: Oracle 10g / 11g, SQL, PL/SQL, Toad 11.6, SQL Developer, SSRS 2012, Windows 7 Enterprise, C#.NET, VB 6.0, PVCS, XML, Excel VBA, Edit Plus, Control M v8.0/7.0, Linux, TFS (Team Foundation Server), Attachmate Reflection.

Lincoln Financial Group, Omaha, NE June 2011 – June 2015

Lead Application Developer

Responsibilities:

Developed Logical/ Physical Data Models using ER Studio tool across the subject areas based on the specifications and established Referential Integrity of the system.

Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level. Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.

Involved in the upgrade of Oracle 9g to 11g and then validate the applications against Oracle 11g.

Responsible for the successful migration of shell scripts from AIX to Linux Server.

Environment: Informatica 9.0.1, Bugzilla, Oracle 10g / 11g, SQL, PL/SQL Toad 11.6, Crystal Reports 2011/ 2008, VB 6.0/2010, ASP, Windows XP Professional, Java/J2EE, Erwin, VB 6.0, PVCS, Tortoise SVN, Info View, Edit Plus, Autosys, Unix, HP-UX/AIX/LINUX.

Wachovia, Winston-Salem, NC Nov 2009 – May 2011

Sr. SQL, PL/SQL Developer

Responsibilities:

Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.

Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.

Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams.

Responsible for dealing with ADW (Active Data Warehouse) which houses several databases and then based on the request pertaining to each database generate reports.

Environment: Oracle 10g, Informatica 8.6, Crystal Reports 2008, Windows XP, UNIX, MS Access, SQL Server, DB2 Visualizer, Crystal Enterprise 10, Xcelsius and PL/SQL.

Nexgenser, Chantilly, VA

Sr. SQL/ Business Objects Developer

Feb 2009 – October 2009

Worked as a Database developer supporting both the data needs and the business reporting requirements.

Syswiz Technologies, India

PL/SQL Developer

Aug 2005 – July 2006

Contact this candidate