Data Developer

RAMSHANKAR ARJUNRAJA

SENIOR INFORMATICA DEVELOPER

Email : ac6eo2@r.postjobfree.com

Mobile: 201-***-****

Professional Summary:

Over 10 years of experience in Information Technology with technical database design, administration and support and development of large-scale applications in a distributed computing environment

Over 8 years of experience in data warehousing development using various ETL tools (Informatica 8x/9.5)

Experience in working with data warehouses and data marts using Informatica Power center (Designer, Repository Manager, Workflow Manager, and Workflow Monitor)

Extensive experience in analyzing application/system issues to determine the cause of the problem and then collaborates with others to resolve the issue in a timely manner

Expertise in BI / Data warehouse projects involving Informatica

Understanding & Working knowledge of Informatica CDC (Change Data Capture)

Developed Strategies for Extraction Transformation Loading (ETL) mechanism

Extensive knowledge with Dimensional Data modeling, Star Schema/snowflakes schema, Fact and Dimension tables

Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema and Snow flake design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.

Over 4 years of experience as a data warehouse architect responsible to create the Business Intelligence reference architecture and implement the next generation enterprise data warehouse. Created standards and design patterns on data movement, data access, data integration, and other areas in the data warehouse.

Enable the reference architecture and design solutions for several specific data warehouse issues: enterprise key assignment process, data migration and integration, complete ETL audit and catalog process, multi-source (including legacy systems) data acquisition, data archival strategy, and data analysis for business specific applications.

Member of a design team that implemented a canonical data format for the enterprise party and location entities.

Re-engineer some of the current ETL processes to streamline the data acquisition and integration process using Informatics Power Center, PERL and UNIX scripts, and DB2 stored procedures ELT technique.

Work with business partners to define analysis requirements. Guide them through the BI delivery process and layout the business and application architecture road map.

Extensive work with PL/SQL, performance tuning of Oracle

Extensive Unix Shell Scripting knowledge

Hand-on experience in failure Investigation, error tracking, creating bug fix plan, coordinating with all the teams involved, communicating with the client management for all the Production related issues

Strong experience in providing Production Support to various client applications

Extensive experience with relational databases (Oracle 8i/9i/10g/11g, Sql Server 2000/2005)

Experience in Load balancing /optimizing resource usage and defining Environment Variables for performance tuning

Experienced in estimation, planning, Risk Management, finalization of technical / functional specifications, communication management and quality management of the product

Proficient in network installations and troubleshooting

Reliable, responsible, hard-working and good team player.

Strong interpersonal and communication skills.

Technical Skills:

ETL Tools: Informatica 8x, 9.5

RDBMS: Oracle 9.x, 10g, DB2v9x, Sql Server 2000/2005,

Database skills: Stored Procedures, Database Triggers, and Packages

Languages: SQL, UNIX, C, C++, Java,

OS: UNIX, Red Hat Linux, Windows 2000/2003/XP/Vista

Version Control: Visual Source Safe 6.0, CVS, Documentum SmartSpace

Tools: Erwin 3.x, MS Project, MS Visio, Make, Autosys, JIRA, SharePoint,

MAXIMO, Quality Center11.0

Education:

Master of Computer Applications India May 2003

Work Experience:

Client: State of Maryland July 2016 – till

Position: Lead Developer

Project: MHBE (Maryland Health Benefit Exchange)

Responsibilities:

Involved in gathering business requirements, analysis, development and testing and production support of client application.

Involved in creating high level design documents, functional specification documents and change requirement documents.

Worked in EDI 834 and TA1 validation transaction sets.

Supported EDI 834 companion and implementation guides of healthcare EDI formats 834 validation transaction sets.

Hands on experience in Analyzing and testing SOA, EDI and EAI applications.

Hands on experience in reviewing and understanding technical documents such as companion and implementation guides of Healthcare EDI formats 834 and 999.

In-depth understanding of 834 enrollment transactions including Adds, Terminations, Cancellations and Life events

Worked on extracting data from various heterogeneous sources like Oracle, MS Access, and Flat files.

Worked on Programming using PL/SQL, Stored Procedures, Functions, Packages, Database triggers for Oracle and SQL Server.

Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads

Tracked production issues and provided application support in case of job failures.

Involved in handling the production tickets and resolve them in timely manner.

Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level, and the Target Level.

Extensively worked with Source Qualifier Transformation to join the homogeneous sources.

Extensively worked with Joiner Transformation to join the heterogeneous sources.

Extensively worked with both Connected and Un-Connected Lookups.

Extensively worked with Look up Caches like Shared Cache, Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations.

Worked with reusable objects like Re-Usable Transformation and Mapplets.

Extensively worked with aggregate functions like Avg, Min, Max, First, Last in the Aggregator Transformation

Extensively used SQL Override function in Source Qualifier Transformation

Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.

Responsible for migrate the workflows from development to production environment.

Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.

Involved in maintaining the share point portal to upload the documents regularly and store them on share point site.

Coordinate deployment process and issues across various development and infrastructure teams and environments.

Responsible for Performance in Informatica PowerCenter at the Target Level, Source level, Mapping Level, Session Level, and System Level.

Client: State of Connecticut Apr 2014 – June 2016

Position: Lead Developer

Project: CT- HIX (Health Insurance Exchange)

Responsibilities:

Involved in gathering business requirements, analysis, development and testing and production support of client application.

Involved in creating high level design documents, functional specification documents and change requirement documents.

Worked on extracting data from various heterogeneous sources like Oracle, MS Access, and Flat files.

Worked on Programming using PL/SQL, Stored Procedures, Functions, Packages, Database triggers for Oracle and SQL Server.

Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads

Tracked production issues and provided application support in case of job failures.

Involved in handling the production tickets and resolve them in timely manner.

Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level, and the Target Level.

Extensively worked with Source Qualifier Transformation to join the homogeneous sources.

Extensively worked with Joiner Transformation to join the heterogeneous sources.

Extensively worked with both Connected and Un-Connected Lookups.

Extensively worked with Look up Caches like Shared Cache, Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations.

Worked with re usable objects like Re-Usable Transformation and Mapplets.

Extensively worked with aggregate functions like Avg, Min, Max, First, Last in the Aggregator Transformation

Extensively used SQL Override function in Source Qualifier Transformation

Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.

Responsible for migrate the workflows from development to production environment.

Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.

Involved in maintaining the share point portal to upload the documents regularly and store them on share point site.

Coordinate deployment process and issues across various development and infrastructure teams and environments.

Responsible for Performance in Informatica PowerCenter at the Target Level, Source level, Mapping Level, Session Level, and System Level.

Environment: Informatica Power Center 9.5.1, Oracle 11g, TOAD, PL/SQL, Linux, Window XP

State of Illinois, Chicago Oct 2013 –March 14

Senior Lead Developer

Project: Illinois Integrate Eligibility System Conversion

Responsibilities:

Involved in gathering business requirements, analysis, development and testing and production support of client application.

Involved in creating high level design documents, functional specification documents and change requirement documents.

Worked on extracting data from various heterogeneous sources like Oracle, MS Access, and Flat files.

Extensively used SQL Override function in Source Qualifier Transformation

Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.

Responsible for migrate the workflows from development to production environment.

Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.

Involved in maintaining the share point portal to upload the documents regularly and store them on share point site.

Coordinate deployment process and issues across various development and infrastructure teams and environments.

Responsible for Performance in Informatica Power Center at the Target Level, Source level, Mapping Level, Session Level, and System Level.

Environment: Informatica Power Center9.5.1, DB2, TOAD, PL/SQL, Linux, Window XP

Bank of America, NJ, USA Feb 2013 –Oct 2013

Senior Informatica Developer

Project: Legal & Compliance Global Support Services

Responsibilities:

Involved in gathering business requirements, analysis, development and testing and production support of client application.

Involved in creating high level design documents, functional specification documents and change requirement documents.

Worked on extracting data from various heterogeneous sources like Oracle, MS Access, and Flat files.

Worked on Programming using PL/SQL, Stored Procedures, Functions, Packages, Database triggers for Oracle and SQL Server.

Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads

Tracked production issues and provided application support in case of job failures.

Involved in handling the production tickets and resolve them in timely manner.

Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level, and the Target Level.

Extensively worked with Source Qualifier Transformation to join the homogeneous sources.

Extensively worked with Joiner Transformation to join the heterogeneous sources.

Extensively worked with both Connected and Un-Connected Lookups.

Extensively worked with Look up Caches like Shared Cache, Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations.

Worked with re usable objects like Re-Usable Transformation and Mapplets.

Extensively worked with aggregate functions like Avg, Min, Max, First, Last in the Aggregator Transformation

Extensively used SQL Override function in Source Qualifier Transformation

Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.

Responsible for migrate the workflows from development to production environment.

Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.

Involved in maintaining the share point portal to upload the documents regularly and store them on share point site.

Coordinate deployment process and issues across various development and infrastructure teams and environments.

Responsible for Performance in Informatica Power Center at the Target Level, Source level, Mapping Level, Session Level, and System Level.

Environment: Informatica Power Center9.x, Oracle 11g, TOAD, PL/SQL, Linux, Window XP

Bank of America, NJ, USA Oct 2012 – Jan 2013

Senior Informatica Developer

Project: ARCTIC Re-Platform.

Responsibilities:

Extracted data from various heterogeneous sources like Oracle, SQL Server, MS Access and Flat files.

Experience on working with complete Software Development Life Cycle of the application.

Provided production support for daily data processing of the clients Customer, Pharma related data.

Involved in writing UNIX and Perl scripts for data parsing, manipulation and updating.

Responsible for development, testing and support of the application.

Involved in monitoring and maintenance of the Unix Server performance.

Involved in creating database tables, views, triggers.

Worked with PL / SQL to create new stored procedures and also modify the already existing procedures as per the change requirements from users.

Created many PL/ SQL batches and executed them through Unix Shell scripts

Handled production related issues and tickets for resolving them in time.

Created bug fix plans and worked on change requirements.

Worked with Client tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.

Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.

Solid Expertise in using both connected and unconnected Lookup Transformations.

Extensively worked with Joiner functions like normal join, full outer join, master outer join and detail outer join in the Joiner transformation.

Worked with Session logs and Work flow logs for Error handling and troubleshooting in Dev environment.

Used Debugger wizard to troubleshoot data and error conditions.

Responsible for Best Practices like naming conventions, and Performance Tuning.

Responsible for migrate the code using deployment groups across various Instances.

Optimized SQL queries for better performance.

Worked with Agile method.

Created pre sql and post sql scripts which need to be run at Informatica level.

Responsible for Unit Testing of Mappings and Workflows.

Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.

Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.

Environment: Informatica Power Center9.x, Oracle 11g, TOAD, PL/SQL, Linux, Window XP

Bank of America, USA May 2010 –Sep 2012

Informatica Developer

Responsibilities:

Involved in gathering business requirements, analysis, development and testing and production support of client application.

Involved in creating high level design documents, functional specification documents and change requirement documents.

Involved in creating solutions for continuous builds

Involved in Developing In-house custom tools to improve day-to-day. Monthly processes

Create and manage custom applications for software deployment.

Involved in maintaining the share point portal to upload the documents regularly and store them on share point site.

Coordinate deployment process and issues across various development and infrastructure teams and environments.

Worked on extracting data from various heterogeneous sources like Oracle, SQL Server, Teradata, MS Access, and Flat files.

Worked on Programming using PL/SQL, Stored Procedures, Functions, Packages, Database triggers for Oracle and SQL Server.

Developed scripts to create Java based web reports.

Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads

Worked on writing Unix shell script programming for running automated backend processing.

Tracked production issues and provided application support in case of job failures.

Involved in handling the production tickets and resolve them in timely manner.

Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level, and the Target Level.

Extensively worked with Source Qualifier Transformation to join the homogeneous sources.

Extensively worked with Joiner Transformation to join the heterogeneous sources.

Responsible for the Data Cleansing of Source Data using LTRIM and RTRIM operations of the Expression Transformation.

Responsible for migrate the workflows from development to production environment.

Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.

Responsible for Performance in Informatica Power Center at the Target Level, Source level, Mapping Level, Session Level, and System Level.

Environment: Informatica Power Center 7.1.x, 8.6,Oracle 10g & 11g, PL/SQL, Toad, Unix, Erwin 7.1,Windows XP, Autosys,

Acxiom Digital, India Sep 2009-Apr 2010

PL/SQL Developer

Responsibilities:

Monitored ETL process activity and utilization, with particular strengths in performance tuning highly transactional data integration package in both the development and production environments.

Coordinate production change requests and production releases.

Troubleshooting load failure issues and data quality issues on a day to day basis.

Used Informatica Debugger to troubleshoot data and error conditions.

Maintain documents for all the Development work done and error fixings performed.

Worked with UNIX commands and used Unix shell scripting to automate jobs

Wrote Unix (korn shell scripts) to backup the log files in QA and production

Performed Unit and Integration testing and wrote test cases

Worked extensively in defect remediation and supported the QA testing

Involved in periodic maintenance of environments by applying patches and content upgrades

Involved in code migration for versioned repositories

Involved in taking repository backup and restoring it, starting and stopping Informatica services and worked with pmcmd commands.

Environment: Informatica Power Center 8.1, Informatica Power Exchange, Teradata, PL/SQL, SQL*Plus, SQL*Loader, Toad, UNIX, Windows XP, Erwin 4.0, Cognos 8.3.

Durban Municipal Corporation, Durban, IR Dec 2006- Sep 2009

Data Analyst

Responsibilities:

Extensively worked with SQL queries. Created Cursors, functions, stored procedures, packages, Triggers, views, materialized views using PL/SQL Programming.

Extensively worked with performance tuning of Oracle

Extensively used Oracle partitioning (range/hash/list), indexes (bitmap, B-tree, reverse key, etc) and various join types (hash joins, sort merge, nested iteration join) to improve the performance.

Sourced data from Teradata to Oracle using Fast Export and Oracle SQL Loader

Created load scripts using Teradata Fast Load and Mload utilities and procedures in SQL Assistant.

Participated in Design, Development and Implementation of a Reporting system for Business management using Cognos impromptu and Powerplay and configured various components (Transformer/Powerplay).

Creating ad-hoc reports/ Migrating reports from Cognos Impromptu

Environment: Ramco virtual works 2.0 Oracle 9i, PL/SQL, Toad, Erwin 3.5.2, ReportNet 1.1, UNIX, Shell Scripting, Windows XP, MS-Access.

ITC – IBD (INTERNATIONAL BUSINESS DIVISION, India APR 2005- Dec 2006

Database Developer

Responsibilities:

Assist data modeling using Erwin 3.5.

Analyzed the Specifications and identifying the source data needs to be moved to data warehouse.

Involved in Database design, entity relationship modeling and dimensional modeling using Star schema.

Developed and modified UNIX shell scripts to reset and run Informatica workflows using pmcmd on UNIX Environment. Conversant with the Informatica API calls.

Worked extensively with mappings using expressions, aggregators, filters, lookup, update strategy and stored procedures transformations.

Created flexible mappings/sessions using parameters, variables and heavily using parameter files.

This project is intended to load and extract Procurement, Order Management, and Accounting data from Oracle database.

Create test cases for the above projects in providing error free solution. Monitored Workflows and sessions using Workflow Monitor.

Improved session run times by partitioning the sessions. Was also involved into database fine tuning (creating indexes, stored procedures, etc), partitioning oracle databases.

Setting up Batches and Sessions to schedule the loads at required frequency using Power Center Server manager.

Used Informatica Version Control for checking all the versions of objects, used in Mappings and Workflows to track the changes in Development, Test and Production environments.

Develop technical documents in ease of improvements on existing code.

Involved in data conversion, migration, integration quality profiling tasks.

Worked with Agile method.

Worked on several data mart projects as a senior data warehouse architect, was involved in complete system development life cycle, starting from requirement specifications to delivering the tested product.

Creating ad-hoc reports/ Migrating reports from Cognos Impromptu

Environment: Ramco virtual works2.0 Oracle 9i, DB2, MSSQL Server 2005 PL/SQL, SQL*Plus, SQL*Loader, Cognos 7 Series, Toad, UNIX, Windows XP

Contact this candidate