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

TECHNICAL SKILLS

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

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: s: 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 Membership, Claims, Capitation, Premium Billing Customer Service and Accumulators

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