SUMMARY:

• 9 years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems in Health Care Domain .
• 4 years of strong development experience in various Data warehousing projects with Teradata 13.10
• Worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems.
• Expertise in creating tables, views, macros, procedures and functions and different indexes (PI, SI, JI, AJI,HI, PPI,MLPPI)
• Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics and used Teradata ViewPoint for performance monitoring
• 8 years of expertise in writing large/complex queries using SQL
• 6 years of experience in Data Warehousing and ETL using Informatica Power Center 8.6 and 9.1.
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, Teradata, SQL Server and Flat files.
• Responsible for all activities related to the development, implementation, support and tuning of ETL processes for large scale data warehouses using Informatica Power Center.
• 6+ years of experience in development using Oracle 10g, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Developed Complex database objects like Packages and Triggers using SQL and Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables, DBMS SQL, DBMS JOB and UTL FILE
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS .
• Extensive experience in writing automation scripts for ETL processes using UNIX shell scripting.
• Experience in using various Unix commands like grep, sed, awk
• Good understanding in Data warehouse and Dimension modeling concepts (Star, Snow flake).
• Strong experience on Data Analysis, Requirement Gathering, Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• 4 years of reporting experience with Cognos, BO, Excel(Using VBA and Macros)
• Experience in extracting data and creating SAS datasets from various sources like Oracle database, Access database, Excel and flat files using Import techniques.
• Hands on experience using tools like TOAD, SQL Developer, PLSQL developer, Teradata SQL Assistant .
• Well versed with all stages of Software Development Life Cycle (SDLC) i.e. Requirement(s) gathering & analyzing, Design/redesign, Implementation and Testing.
• Very good in Fast learning, Analytical thinking, decision making and problem solving skills.
• Proficient in preparing high/low level documents like design and functional specifications
• Highly motivated individual with excellent organizational and interpersonal skills.
• Quick Learner and efficient team player with good leadership qualities.
• Excellent interpersonal skills, presentation and communication skills
• Excellent analytical and debugging skills

SKILLS SUMMARY:

Operating System: Windows/Dos, Unix, Linux

Languages: PL/SQL, BTEQ, HTML, Java Script, Shell Script, PHP,VBA, Macros, Java, Perl

Databases: Oracle, Teradata, MS Access, SQL Server 2005

Reporting Tools: Crystal reports, Cognos Impromtu, Cognos Report Studio, Business Objects, Excel

Other Tools: Informatica Power Center 9.0, Teradata SQL Assistant, Toad, MS Visio, Microsoft Project Plan, Open Project, WLM

PROFESSIONAL EXPERIENCE:

Confidential, Foster City, CA and Richmond, VA

Technical Lead

Responsibilities:

• Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
• Used Teradata utilities BTEQ, fastload, multiload to load data and process data
• Created BTEQ scripts to transform data and Fastexport scripts to export data and created views based on user and/or reporting requirements
• Write, test and implement UNIX scripts and write complex SQL queries for data analysis and reporting
• Wrote Teradata Macros and used various Teradata analytic functions.
• Performance tuned and optimized various complex SQL queries using EXPLAIN and Collect Statistics.
• Gathered system design requirements, design and write system specifications.
• Experience on ETL tool Informatica, to load data to Teradata by making various connections to load and extract data to and from Teradata efficiently.
• Coordinated with the business analysts and developers to discuss issues in interpreting the requirements
• Proper deliver of all production activities as per the calendar, Issue analysis and fixing them within the SLA
• System study, Estimation, Designing, Quality Control and Managing a team of 9 offshore resources

Environment: Teradata 13, Teradata SQL Assistant, UNIX, Toad, BTEQ, Informatica 9.1, MLOAD, FAST LOAD, FAST EXPORT, MS Office, Teradata viewpoint, SharePoint, MPP, Business Objects, Putty

Confidential

Technical Lead

Responsibilities:

• Used Teradata utilities Fastexport and BTEQ scripts to transform data and export data
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
• Wrote, test and implement UNIX scripts (Using grep, awk and sed) for automation of entire process
• Wrote Teradata Macros and used various Teradata analytic functions .
• Performance tuned and optimized various complex SQL queries for reports
• Excellent knowledge on ETL tools such as Informatica to load data to Teradata by making various connections to load and extract data to and from Teradata efficiently.
• Generated compliance reports out of SQL server using T - SQL
• Used Perl script for creating complex excel reports and automation and MS Access for adhoc reporting.
• Great Team Interaction, timely delivery and status reporting
• Worked on extracting data and creating SAS datasets from various sources like Oracle database, Access database, Excel and flat files using Import techniques.
• Coordinated with the business analysts and developers to discuss issues in interpreting the requirements

Environment: SQL Server, T-SQL, SAS, MS Access, Oracle, Teradata, Teradata SQL Assistant, Informatica, Perl, SQL, VSS, Outlook, Putty, MS Office

Confidential

Technical Lead

Responsibilities:

• Extensively involved in creating PL/SQL objects i.e. Procedures, Functions, and Packages for data migration from Oracle to flat files which is in turn loaded into DB2.
• Performance tuned SQL queries using Hints, AUTOTRACE and Explain Plan.
• Created Materialized views, Ref cursors, Bulk processing, collections, nested tables.
• Extensively used SQL*LOADER and UTL FILE to load and export data from flat files.
• Created complex Informatica maps and workflows to load data into target database.
• Used complex logic in expression transformation to bring in the looping concept in Informatica.
• Performance tuning of Informatica session to load millions of data into target system maximum efficiency.
• Extracting and moving data from UNIX and created shell scripts for automation and file concatenation
• Creating mapping sheets to document the field mapping and logic from source to target.
• Handling Modules like, Claims, Capitation, Premium Billing Customer Service and Accumulators

Environment: Oracle 9i, UNIX, SQL, PL/SQL, SQL Developer and TOAD, SQL*Loader, Informatica, Crystal Reports, VSS, Outlook, Putty, MS Office, Cognos

Confidential

Technical Lead

Responsibilities:

• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems(oracle 9i,SQL server and flat files) by incorporating business rules.
• Created Informatica mappings and mapplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Lookup, router, Filter, Expression and Update Strategy.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing.
• Tuned the Informatica mappings and sessions for optimal load performance.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Created UNIX shell scripts to customize the server scheduling jobs.

Software Used: Informatica PowerCenter Designer 8.6/8.1, Informatica Repository Manager, Oracle 9i, TOAD,UNIX, PL/SQL,SQL Developer, SAS, Crystal Reports, Cognos, MS OfficeConfidential

Project Lead

Responsibilities:

• Extensive experience with PL/SQL in designing, developing functions, procedures, triggers and packages.
• Implementing the NPI logic in all the existing components- PL/SQL packages, Informatica maps, Crystal reports, Cognos Reports, SAS components, MS Access, SQL Server Components .
• Used complex logic to implement the NPI logic in PL/SQL packages using Ref cursors, PL/SQL Tables, collections, nested tables, Arrays
• Created new process in SQL server DTS for data migration
• Review existing code and design , tune the performance of existing processes
• Scope and Impact analysis, requirement analysis, estimation , Schedule tracking, status reporting
• Production move co ordination of more than 100 process moving into production at the same time.
• Tracking the progress of each process and timely update to management.
• Leading a team of more than 12 members which involved team motivation and co ordination

Software Used: Oracle - PL/SQL, VBA, Access 97/2000, SQL Server - DTS, Informatica, SAS, MPP, Crystal Reports, Cognos, Toad

Confidential

Module Lead

Responsibilities:

• Existing PL/SQL package changes to include the new state requirements
• Created new MS Access, Cognos Impromtu, Crystal reports for new State additions
• Developing, validating and implementing SAS programs and produce derived datasets for analysis and generating & documenting tables, listings and graphs for health care compliance reports.
• Modified Cognos Impromtu Catalog to include the new table and joins to create new Reports
• Have hands on experience in Cognos Report Studio
• TDD Documentation and test case creation as part of this project
• Requirement analysis, Impact analysis, Timely completion of task and Module level task tracking
• Onsite interaction and Proper status reporting as part of Communication management

Software Used: Oracle - PL/Sql, VBA, Access 97/2000, Crystal Reports, SAS, Cognos Impromptu,SAS