We provide IT Staff Augmentation Services!

Technical Lead Resume

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

Hire Now