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