Professional Summary:

• Overall 8 years of IT experience in the Business Analysis, Design, Data Modeling, Implementation, Development and Testing of Applications using wide range of Technologies including Data Warehousing, ETL, Database and reporting systems for financial and Insurance companies.
• Proven track record in planning, building, and managing successful large-scale Data Warehouse and decision support systems. Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging.
• 6 years of experience using Teradata SQL Assistant, Informatica Power Center and other data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export, Exposure to Tpump on UNIX/Windows environments and running the batch process for Teradata CRM.
• Experience working with data modelers to translate business rules/requirements into conceptual/logical dimensional model and worked with complex denormalized and normalized data model.
• Highly experienced in SQL performance tuning and debugging of existing ETL process.
• Experienced in creating complex Informatica mappings using various transformations, and developing strategies for Extraction, Transformation and Loading ETL mechanism using Informatica.
• Extensive experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Normalizer and transformation using various COBOL sources, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Expertise in developing slowly Changing Dimensions mappings using Change Data Capture:Type 1,Type 2,Type 3.
• Well versed with Informatica 8.1 64 bit.
• Well versed in writing UNIX korn shell scripting.
• Experienced in extracting data from different source systems with different schema types and loading into teradata
• Responsible for designing ETL strategy for both Initial and Incremental loads
• Experience in Relational Data Modeling and Dimensional Data Modeling, Star Schema Modeling, Physical and Logical Data Modeling, Erwin 4.0/3.x, Oracle Designer.
• Demonstrate a willingness, interest, and aptitude to learn new technologies and skills

SOFTWARE ENGINEERING SKILLS:

• Development Tools: Microsoft Visual Studio 2005, NetBeans 5.5.1, Eclipse
• Web Technologies: HTML, DHTML, XML, JavaScripts, VBScripts, ASP.NET
• ETL Tools: Informatica Power Center 6,7,8
• Database Tools: Teradata v12, Oracle 11g, SQL Server 2005, MySQL Server, Microsoft Access
• Programming Languages: C, C , Java, Visual Basic.NET, C . NET
• Operating systems: Unix, Red Hat Linux, Windows 98, 2000, XP, Solaris

WORK EXPERIENCE:

Confidential

Teradata/ETL Developer

Responsibilities :

• Handing RIM tickets for Debugging, development and testing them.
• Analyzing , proposing a Business solution for the RIM tickets issued.
• Analyzed in different subject areas such as CLAIMS, MEMBERSHIP.
• Deploying the scripts in to respective environments. TEST, QA and PROD
• Reviewed Informatica ETL mappings/workflows and SQL that populates EDWARD to ensure accuracy of business requirements
• Integrated data in to EDWARD by sourcing it from different sources like SAP, mainframe copy books Cobol files , DB2 and Teradata tables
• Created, optimized, reviewed, and executed Teradata SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables
• Reviewed Informatica ETL mappings/workflows and SQL that populates EDW and datamart Dimension and Fact tables.
• Coding using BTEQ, write Unix scripts to validate, format and execute the SQL's on UNIX environment.

Confidential

Teradata/ETL Developer

Responsibilities :

• Exported files by writing Fastexport script's as well as BTEQ export.
• Responsible for Selecting proper Primary Indexes for the table considering both access of data and even distribution of the data across all AMPS.
• Designed, developed and automated the Monthly and Weekly refresh of the datamart.
• Designed and developed an entire Data Mart from scratch.
• Created a Metrics Data Mart for all related attributes of an Account.
• Preformed loads and exports using sql assistant and OLE Load as well for adhoc requests.
• Written multiple BTEQ scripts and TPT scripts to implement complex logic and to transform data in teradata tables.
• Responsible for understanding the current process of Informatica flow and migrate the Oracle data marts to Teradata data warehouse.
• Worked on data extraction from multiple sources, used various transformations and external loader to load the data into teradata warehouse using Informatica.
• Responsible for performance tuning on targets, sources, mappings and sessions to get maximum efficiency.
• Extensively used Informatica debugger to resolve the issues.
• Implemented Change data capture to keep track of historical data.
• Involved in fine tuning complex queries and properly collecting statistics.
• Had regular day to day interactions with reporting teams and assisted them in building the OLAP cubes
• Created prod docs and submitted to Production support team to properly move the code to prod process.
• Provided application support to the data warehouse. Especially to the portion of the data warehouse which I am responsible for.
• Performed User acceptance testing for all the code and tables which I have developed.
• Involved in the code reviews.

Environment: Teradata 13, Teradata SQL Assistant, BTEQ, TPT, MultiLoad, Fastexport, OLE Load, PL/SQL, Informatica Power Center 9.1.5, Oracle 11g/10g, UNIX and Windows XP.

Confidential

Teradata/ETL Developer

Responsibilities:

• Create , Execute and Manage source views for workflows which are used for the Data Mart Loading phase.
• Handing Mantis tickets for Debugging, development and testing them.
• Deploying the scripts for all developers in to respective environments. TEST, QA and PROD
• Reviewed Informatica ETL mappings/workflows and SQL that populates EDW and data mart Dimension and Fact tables to ensure accuracy of business requirements
• Integrated data in to EDW by sourcing it from different sources like SAP, mainframe copy books Cobol files , DB2 and Teradata tables
• Created, optimized, reviewed, and executed Teradata SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables
• Reviewed Informatica ETL mappings/workflows and SQL that populates EDW and datamart Dimension and Fact tables.
• Monitor the daily ODS data staging and handling any infractions in the process.
• Coding using BTEQ, write Unix scripts to validate, format and execute the SQL's on UNIX environment.
• Wrote code for fastload to handle large flat file uploading
• Create and move data to a UDB DB2 database for some of the reporting purposes.

Environment: Teradata 12, BTEQ, Query man, Multi load, fast export, Informatica 8.6, SQL Tools, PL/SQL, Windows Vista

Confidential

Teradata/ETL Developer

Responsibilities:

• Create, Run and manage processes and reports for Branch Operations.
• Repaired and created SQL/UNIX scripts for business monitoring.
• Extracted data from different source systems with different schema types and loaded into teradata
• Developed Informatica mappings which includes data validations and error handling mechanism
• execute the SQL's on UNIX environment.
• Coding using BTEQ SQL of TERADATA, write Unix scripts to validate, format and
• Monitored and posted information about database usage statistics for CDSS
• Extensively used various transformations like Source Qualifier, Joiner, Aggregators, Connected Unconnected lookups, Filters, Router, Expression, Rank Union, Normalizer, and Update Strategy Sequence Generator.
• Developed Informatica mappings to load the data in to Oracle /DB2 targets
• Helped program VB script for excel report refresh automation
• Handled QI for dual controls and peer reviews in Branch Operations SQL programming for high-priority reports
• Worked with Requirements Analysts and Subject Matter Experts to identify, understand and document business needs for the data flow Work.
• Involved in segmentation of raw data
• Designed, developed, altered and executed the SQL queries for conversion of reports to point to new database.

Environment: Teradata 12, BTEQ, Query man, Multi load, fast export, Informatica 8.6, Windows XP

Confidential

Teradata Data Analyst

Responsibilities:

• Create, Run and manage processes and reports for Collections Business
• Supported Collections Specialty team, particularly 3PDM business, and Liquidate
• Conducted data pull sprints for Internal Audit reports and OCC requests
• Repaired and created SQL/UNIX scripts for business monitoring
• Developed monitoring reports for Business MBR Process
• Automated business partners reports to develop efficiency and more appropriately handle TD lag.
• Monitored and posted information about database usage statistics for CDSS
• Wrote code for fastload to handle large flat file uploading.
• execute the SQL's on UNIX environment.
• Coding using BTEQ SQL of TERADATA, write Unix scripts to validate, format and
• Highly experienced in SQL performance tuning and debugging of existing ETL process.
• Helped program VB script for excel report refresh automation
• Handled QI for dual controls and peer reviews in CDSS SQL programming for high-priority reports
• Worked with Requirements Analysts and Subject Matter Experts to identify, understand and document business needs for the data flow Work.
• Involved in segmentation of raw data
• Designed, developed, altered and executed the SQL queries for conversion of reports to point to new database.
• Involved in tuning the existing and new SQL queries in collaboration with SQL helpdesk to minimize execution and data load time.
• Created volatile tables, temporary tables for intermediate processing to avoid space constraints
• Used Teradata data manipulation, data Interrogation, Data definition, SET operations, date and time processing commands.
• Adhered to Teradata best practices in creating and dropping tables, views, joins Indexes' and appropriate use of collect statistics command
• Extensively utilized Unix Shell scripts embedded with SQL queries in executing jobs

Environment: Teradata 12, BTEQ, Query man, Multi load, fast export, Informatica 8.6, Windows XP

Electronics Corporation of India Limited ECIL , India Engineering Trainee: Aug'2004 Jan'2006

Responsibilities:

• The purpose of this project is to create a Material management system for the customers and vendors to sell inventory, order supplies and handle a number of management activities like selecting a quote, tracking inventory and outstanding purchases etc.
• Obtained two months industrial training and worked on a Material Management System purchase process project using ASP.NET and SQL Server 2005 at ECIT.
• Developed SQL queries using SQL Server 2005 to create the database for inventory.
• Designed a web-based application using ASP.NET as front-end.