We provide IT Staff Augmentation Services!

Technical Lead Resume

Foster City Ca And Richmond, VA

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

Hire Now