We provide IT Staff Augmentation Services!

Developer Resume

Franklin Lakes, NJ

SUMMARY

  • Closely Mentored by Confidential Consultants to deliver high quality, high performance ETL Applications.
  • In - depth and comprehensive knowledge and experience in full life-cycle for enterprise data warehouse including business analysis, data model, source-target mapping, ETL implementation, BI report, and production support.
  • Solid data knowledge and data application experience in diversified business areas, such as customer, operating, planning, and revenue management.
  • Hand-on ETL architecture experience in design and implement ETL complex system with Confidential and AIX Unix platform, ETL system and data file archive, backup and restore strategies, and ETL system maintain, performance benchmark, tune-up, and upgrade.
  • Proficient in Shell Script and Perl programming or scripting in UNIX environment.
  • Independently completed and involved projects with Confidential ETL tool.
  • Experienced in developing complex Confidential graphs in data warehouse environment using Multi File System (MFS) to take advantage of parallelism.
  • An Excellent resource that can adjust into a fast paced, time critical project who can deliver bottom line results with superb quality and performance.
  • Over 5 years of Information Technology experience in software development, designing and implementing with major focus on Data Warehousing, Business Intelligence and Database Applications.
  • 5 years of experience in RDBMS like Oracle
  • Strong knowledge of Data Warehousing concepts and Dimensional modeling like Star Schema and Snowflake Schema
  • Used Conduct>IT for job scheduling wherein created several plans using resources.
  • Very Good Programming skills using UNIX/Shell Scripts and PL/SQL for Automation of ETL process.
  • Team oriented and ability to understand and adapt to new technologies and environments faster. Good at analysis and troubleshooting.
  • Excellent analytical, programming, written and verbal communication skills.

TECHNICAL SKILLS

Data Warehousing: (GDE 3.0.5.3/1.15/1.14 /1.13/1.12 , Co>Op 3.1.2.5/2.15/2.14/2.13/2.12 ), Informatica 8i/7i

Reporting Tools: Business Objects 6.5/XIR2, Cognos 8.0 Series

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and Dimension Tables, Pivot Tables

Testing Tools: Mercury QTP, Mercury Quality Center

RDBMS: Oracle 10g/9i/8i/7.x, MS SQL Server 6.5/7.0/2000/2005/2008 , Sybase, Teradata, MS Access 2003

Programming: UNIX Shell Scripting, Korn Shell, C Shell, Bourne Shell, Bash, SQL, SQL*Plus, PL/SQL, TOAD, C++

Web Technologies: JavaScript, HTML 4.0, and DHTML, Java, J2EE

PROFESSIONAL EXPERIENCE

Confidential, Franklin Lakes, NJ

Developer

Responsibilities:

  • Worked with project manager and ETL developers for Pharmacy claims management process: as technical lead, designed all ETL procedures including job flow, Confidential graph standard, data integration, ETL test plan and data archive, backup, and recover strategies, tracked the projects status, and audited the production promotions.
  • Worked as one of the technical lead to handle claims management process
  • Worked on claims processing, pharmacy contracts and benefit management.
  • Involved with pre-live data and environment for testing the claims and work with the rejects.
  • Created graphs to test claims for rejection and support system to handle it.
  • Production deployment activities.
  • Unit testing, System testing, Integration testing and Peer review of code.
  • Participating in the code review calls with the SME and business.
  • Creating Technical design documents which are used as the ETL specifications.
  • Working with production support team to handle tickets on claims reject
  • Guiding offshore team on development and domain knowledge.
  • Participating in the offshore call for understanding and review of the technical specification document.
  • Participating in the daily status call with the clients

Environment: Confidential (GDE 3.0.5.3/1.15/1.14 , Co>OS 3.1.2.5/2.14/2.15 ), Teradata, Shell scripts, Perl, UNIX, FileZilla

Confidential, Bannockburn, IL

Developer

Responsibilities:

  • Worked as technical lead for Pharmacy Benefit Management Intervention (PBMI).
  • Created ETL Production Support System, which provides common processes and template jobs and tracks all production support steps.
  • Throughout involved in Confidential upgrade from V2.15 to V 3.x
  • Converted the Unix shell script to Confidential plan
  • Involved in enhancement and testing the new Confidential environment.
  • Designed and deployed the Extract, Transform and Load process, using Confidential by studying the business requirements from the business users and interacting with business analysts.
  • Involved in setting up of sandboxes and maintaining sandbox parameters.
  • Generated DB configuration files for source and target tables.
  • Worked with source files and generated dml’s using Confidential utilities.
  • Developed generic graphs for taking care of repeating activities.
  • Used Confidential functions for improving performance of Confidential graphs.
  • Used Debuggers and Watchers to test and examine the behavior of the components.
  • Involved in code review and performance tuning of ETL graphs.

Environment: Confidential (GDE 3.0.5.3/1.15/1.14 , Co>OS 3.1.2.5/2.14/2.15 ), Oracle 10g, Shell scripts, Tidal, SQL, PL-SQL, Ms-Office, Perl, UNIX, Toad, FileZilla

Confidential, Deerfield, IL

Developer

Responsibilities:

  • Used Ab-Initio to Extract data from source systems, cleanse, Transform, and Load data into databases.
  • Responsible for creating Confidential graphs for landing the validated source data received from various customers in multifiles and creating Lookups for cross reference.
  • Designed and developed Confidential graphs for transforming various data feed to fit into dimensional model of the target, using complex components.
  • Also used Confidential Partition and Departition components to enable parallelism.
  • Used UNIX Environment variables in various .ksh files, which comprises of specified locations to build Confidential Graphs.
  • Responsible for code review and performance tuning of Confidential graphs designed by various developers.
  • Performing transformations of source data with Transform components like Join, Dedup, Sort, Reformat, Filter-by-Expression, Rollup.
  • Implemented Lookups, In-memory Joins and Rollups to speed various Confidential graphs.
  • Wide usage of Lookup files while getting data from multiple sources and size of data is limited.
  • Modified the Confidential components parameters, utilize data parallelism and thereby improve the overall performance to fine tune the execution times.
  • Debugging Confidential graphs using Flow Watchers.
  • Responsible for writing shell scripts (wrapper) to schedule the jobs in the development environment.
  • Developed UNIX scripts and Confidential components.
  • Used sub graphs and parallel execution features using multifile systems.
  • Tuned graphs for better performance. Created functional and unit test cases and executed the same. Also, created a production support document, High level design and Detail design documents
  • Wrote the UNIX Shell scripts to run the graphs after receiving the files from different regions and also to generate the data load reports and Error Handling reports to get the data load statistics like, how many records read from the input file, no of rejected records, no of error records and the reason to reject the record, no of records that are inserted and updated in the database.
  • Wrote the Stored procedures using PL/SQL.
  • Worked on the EME which used as the version control tool.
  • Involved in unit testing, integration testing and troubleshooting.
  • Involved in documentation and code review.
  • Provided post production support.

Environment: Confidential (GDE 1.15/1.14, Co>OS 2.14/2.15), Oracle 10g, Shell scripts, ESP, SQL, PL-SQL, Ms-Office, Windows NT and UNIX

Confidential, Deerfield, IL

Developer

Responsibilities:

  • After understanding the functional requirements wrote the Technical design documents which are used as the ETL specifications.
  • By using the ETL tool Confidential, extracted the data from source XML’s and the flat files received from the systems based on the pre-defined mappings.
  • Designed and developed the Confidential graphs for the ETL process to load the data into the Oracle database tables.
  • Metadata mapping from legacy source system to target database fields and involved in creating Confidential DMLs.
  • Extensively used Partitioning components like Partition by Expression, Partition by Round Robin and Partition by Key to increase data parallelism.
  • Used EME for Version Control
  • Developed SQL queries for cross verification of data again ETL Transformation rules.
  • Worked in EME environment for source code control.
  • Wrote the Test cases to perform the unit testing and Integration testing to verify the data and the complete ETL process.
  • Worked on Performance tuning of the Confidential graphs.
  • Performed the Level I support Level II production support.
  • Used the Scheduling tool Autosys to run the jobs automatically. Wrote the Autosys scripts and installed them and scheduled the jobs.
  • Worked with Infrastructure team to migrate the code into different environments and for the code review.
  • Wrote the UNIX Shell scripts to run the graphs after receiving the files from different regions and also to generate the data load reports and Error Handling reports to get the data load statistics like, how many records read from the input file, no of rejected records, no of error records and the reason to reject the record, no of records that are inserted and updated in the database.
  • Wrote the Stored procedures using PL/SQL.
  • Worked on the EME which used as the version control tool.

Environment: Confidential (GDE 1.15/1.14, Co>OS 2.14/2.15), Oracle 9i/10g, EME, SQL, PL/SQL, SmartStream, UNIX, Windows 2000/XP, Autosys, Oracle 10g, Shell Scripting, QC 9.2

Hire Now