OBJECTIVE:

To be employed in a firm where I can put my technical skills to use in enhancing the system and in development that will boost the company’s productivity

SUMMARY:

• Over 8 years of IT experience in Design, Development, Testing and implementation of the software applications using the Data Warehousing Technologies and Web Development technologies
• Excellence in implementation and following of Software Development Life Cycle and Dimensional modeling techniques using Star and Snow - flake Schema Modeling
• Proficient in using Erwin, Ab Initio and Informatica tools
• Extensively worked on Data Extraction, Transformation and Loading with Oracle, DB2 using Informatica Power Center
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica
• Good exposure to Java scripts for test case development and Big Data MapR programming model
• Expertise in one or more query languages: SQL, Pig, HiveQL
• Experience in developing data models which will serve both OLTP and OLAP functionality
• Experience in Insurance, Financial, Healthcare, Industrial Sector Data warehousing projects and Integration projects
• Hands on experience in Oracle database development using PL/SQL, Stored Procedures, Functions, Triggers, Views, Indexes and Cursors.
• Strong analytical and conceptual skills in database design and implementation of RDBMS concepts.
• Good exposure to OLAP reporting tool Tableau
• 3 Years of Shell scripting using sed, awk programming Ftp’ing files, split large files to process, archival process, running jobs in background, system load monitor etc.
• Responsible for implementing QA testing methodologies and best practices for the various development and production support projects
• Excellent in writing complex SQL queries and tuning them for performance
• Experienced working on Agile Methodology projects

TECHNICAL SKILLS:

ETL Tools: XInformatica Power Center 9.x/ 8.x/7.x/6.x/5.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server), Informatica Data Quality IDQ, Power Exchange 8.0, Repository, Metadata, Data Mart, SSIS, SQL Server, SSIS, SSRS, SSAS

Reporting Tools: Tableau

Scripting Languages: JavaScript, Unix Shell Scripting, SQL, PL/SQL, UNIX Shell Scripting, Perl Scripting, Java 2.0

Tools: Microsoft Office, MS Visio, ERWIN, SQL*Plus, SQL*Loader

Programming: C, Cobol, HTML, Perl

Operating System: MS-DOS, Unix, Windows 95/98/NT/2000/XP/Vista/7

Databases: Oracle 8i/9i/10g, SQL Server 2005/2008, PL/SQL, DB2, Netezza, Teradata 13.0

Languages: C, C++, Java, HTML, Java Script, XML

Testing Tools: HP Quality Center 10/9.2, Test Director 8.0, Microsoft Test Manager, HP Quality Center/ALM Suite, QTP, LoadRunner, Selenium IDE, SOAP UI

WORK EXPERIENCE:

Confidential, Phoenix, AZ

Senior ETL Developer

Responsibilities:

• Participate in all the brain storming sessions with the development team, Canadian team, the management team and walkthroughs
• Understand the business functionality in detail
• Test and validate the Legacy system data and files and maintenance of daily, monthly and yearly
• Effectively used various commands to run the Informatica mappings in UNIX Scripts
• Validate the data from the data sources through each step of the extract and transformation process including final load in the data warehouse
• Extensively used Informatica power center for extraction, transformation and loading process
• Create and ran Sessions & Batches using Workflow Manager to load the data into the Target Database
• Use Erwin to model and generate DDL
• Work closely with the rest of the team to create ad-hoc Tableau reports to support timely business decisions and project work
• Provide better support for page control through the ‘Keep Together’ options for both individual report sections, as well as entire report groups
• Perform code migration from development to the other environments
• Develop Interface Programs, PL/SQL Scripts and complex Packages using Oracle, SQL Plus, XML and Toad
• Involved in requirement gathering and data analysis for reporting from business users. System study, interaction with users & management of the system
• Create & test various overtime and absence time reports developed per week using Tableau functionality like Queries, Filters
• Involved in Unit testing, Integration testing, UAT by creating test cases, test plans and helping Informatica administrator in deployment of code across Dev, Test and Prod Repositories

Environment: Informatica Power center 9.6, PL/SQL, Erwin 4.0, MS Visio, SQL Navigator, UNIX, SSRS, HP Quality Center 10, SQL, Shell Scripting, Autosys, putty

Confidential, Phoenix, AZ

Database Developer

Responsibilities:

• Thoroughly understand the business requirements to automate data coming from multiple sources
• Identify data sources and prioritize the source systems design new lookup tables based on the requirement
• Involved in brain storming sessions with business teams and the subject matter experts
• Establish data mapping rules to produce data elements which are not in the original source data
• Involve in Balancing and Control design to check for duplicate files, missing files timeliness, missing country level data and compare the amount totals between source and aggregated values
• Design Control table for determining Duplicate File and missing file checks, Latency check table for periodically performing checks on all files if they were received and within expected time and design staging tables for mapping source data
• Involve in creating Detail Design document
• Involve in designing the daily and monthly cutoff data rollup process for different source systems
• Worked with Meta-Data Driven Informatica mappings to pull the data from different Sources and load to Data mart
• Multiple levels of grouping and predefined sort orders that need interactive sorting to be marginal at best
• Built ad-hoc reports using SQL Server Reporting Services
• Check for missing data, negatives and consistency
• Record Count Verification against source and target
• Worked on SSRS functionalities which enable business team to change lookup data through write back capability

Environment: Informatica 9.1, PL/SQL, Erwin 4.0, MS Visio, SQL Navigator, UNIX, SSRS, HP Quality Center 10, T-SQL, Autosys, putty

Confidential, Phoenix, AZ

Database Developer

Responsibilities:

• Analyze data requirements and the impact of changes on several applications
• Involved in validating mapping of data values from HIPAA to data containers in the system
• Create and maintain technical design documentations of Data Analysis, Source to Target Mapping, Application Configuration, and ETL process flow
• Designed Conceptual/Logical/Physical data models using ERwin
• Interface with business users, developers and testers to identify potential issues and recommend solutions
• Perform UNIX shell scripting to automate jobs, day-to-day maintenance and monitoring jobs
• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle
• Created graphs using components like reformat, sort, dedup sorted, filter by expression, partitioning component like partition by key, round robin, expression, departitioning component like gather, merge, concatenate., replicate, join, join with db, rollup, continuous components.
• Involved in performance tuning of Ab Initio graphs using mutifile, compressed flow, partitioning on keys
• Involved in various data store operations like creating sandbox, code check-in, code checkout, creating project parameters according to the environment settings for this application
• Created mockup data for the dev environment to test the business functionality

Environment: Ab Initio, Oracle 9i, DB2, PL/SQL, Erwin 4.0, MS Visio, SQL Navigator, UNIX, Tableau, HP Quality Center 10, SQL, Shell Scripting, Autosys, putty

Confidential, Richmond, VA

Senior ETL Developer

Responsibilities:

• Responsible for analyzing design and preparing graphs to perform specific task which forms a part of the project
• Wrote new complex stored procedures and optimized the existing code
• Performed data staging, dynamic partitioning in order to increase performance of the project
• Created Ab Initio graphs using components like reformat, sort, dedup sorted, filter by expression, partitioning component like partition by key, round robin, expression, departitioning component like gather, merge, concatenate., replicate, join, join with db, rollup, continuous components
• Responsible for performance tuning of Ab Initio graphs using mutifile, compressed flow, partitioning on keys
• Involved in various EME data store operations like creating sandbox, code check-in, code checkout, creating project parameters according to the environment settings for this application
• Created mockup data for the dev environment to test the business functionality

Environment: Ab Initio, PL/SQL, MS Visio, SQL Navigator, UNIX, HP Quality Center 10, SQL, Shell Scripting, Autosys

Confidential, Connecticut

ETL Developer

Responsibilities:

• Setup meetings with team members to discuss data model changes
• Created logical and physical data models as per the requirements
• Prepared matrix based responsibility chart for the team
• Supported for System testing, UAT testing, and preproduction testing
• Handled critical data issues in System Testing, UAT, environments in the process of recovery
• Responsible for Querying Database and work on ETL and cleansing tool
• Measured Data Quality dimensions/metrics for several subject areas
• Used PLSQL stored procedures to load data
• Performed tuning of queries in Teradata
• Involved in Querying Database and extensively worked on ETL and cleansing tools
• Analyzed Data Quality metrics score results after data profiling
• Performed Data Validation to ensure accuracy and quality of data
• Worked on EME repository for check in and checkout of graphs
• Created metric reports using Cognos

Environment: Oracle 10g, PL/SQL, Erwin 4.0, MS Visio, SQL Navigator, UNIX, Tableau, HP Quality Center 10, SQL, Shell Scripting, Autosys, putty