Hari Krishna Kakarala                                                                                                                                                             Anuj@Technocraftsol.com

Teradata/ETL Developer                                                                                         614-664-7817

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.

·         7 years of experience using Teradata SQL Assistant, DataStage 8.x/7.x and other data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export, and 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.

·         Expertise in building Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Multidimensional Model, Star and Snowflake schema design.

·         Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool DataStage (Ver8.0/7), designing and developing jobs using DataStage Designer, Data Stage Manager, DataStage Director and DataStage Debugger.

·         Expertise in developing slowly Changing Dimensions mappings using Change Data Capture: Type 1,Type 2,Type 3.

·         Experience in Mapping Server/parallel Jobs in DataStage to populate tables in Data warehouse and Data marts.

·         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

EDUCATION:

• University Of Maryland, MD                                                                                              Dec’2008                

MS in Computer Science

GPA: 3. 8/4. 0

• Andhra University, India                                                                                         Apr’2005       

BS in Computer Science and Engineering

GPA: 3. 8/4. 0

SOFTWARE ENGINEERING SKILLS:

·         Programming Languages:    C, C++, Java, Visual Basic.NET, C#. NET

·         Database Tools:                     Teradata v12, Oracle 11g, SQL Server 2005, MySQL Server, Microsoft Access

·         ETL Tools:                            Datastage 8.x/7.x

·         Web Technologies:                HTML, DHTML, XML, JavaScripts, VBScripts, ASP.NET

·         Development Tools:               Microsoft Visual Studio 2005, NetBeans 5.5.1, Eclipse

• Operating systems:             Unix, Red Hat Linux, Windows 98, 2000, XP, Solaris

WORK EXPERIENCE:

BLUE CROSS BLUE SHIELD, Richardson, TX

Teradata/ETL Developer                                                                                                   April 2014 – Present

Responsibilities:

UST-GLOBAL at Wellpoint, Richmond, VA

Teradata/ETL Developer                                                                                                                   Dec 2013 –March 2014

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)
• Scheduled job runs using DataStage director, and used DataStage director for debugging and testing.
• Integrated data in to EDWARD by sourcing it from different sources like SAP, mainframe copy books (Cobol files), DB2 and Teradata tables
• Extensively used DataStage Tools like Infosphere DataStage Designer, Infosphere DataStage Director for developing jobs and to view log files for execution errors
• Used Quality Stage to check the data quality of the source system prior to ETL process.
• Coding using BTEQ, wrote UNIX scripts to validate, format and execute the SQL’s on UNIX environment.

Verizon, Tampa, FL

Teradata/ETL Developer                                                                                                             June 2011 – Nov 2013

Responsibilities:

·         Created a Metrics Data Mart for all related attributes of an Account.

·         Designed and developed an entire Data Mart from scratch.

·         Designed, developed and automated the Monthly and Weekly refresh of the datamart.

·         Responsible for Selecting proper Primary Indexes for the table considering both access of data and even distribution of the data across all AMPS.

·         Exported files by writing Fastexport script’s as well as BTEQ export.

• 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.
• Worked with Datastage Manager for importing metadata from repository, new job Categories and creating new data elements.
• Designed and developed ETL processes using DataStage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database.
• Excessively used DS Director for monitoring Job logs to resolve issues.
• Involved in performance tuning and optimization of DataStage mappings using features like Pipeline and Partition Parallelism and data/index cache to manage very large volume of data.
• 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, IBM DataStage 8.0, Oracle 11g/10g, UNIX and Windows XP.

Liberty Mutual, Dover NH                                                      

Teradata/ETL Developer                                                                                                      Dec’ 2010 – May’ 2011

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)
• Extensively worked on DataStage jobs for splitting bulk data into subsets and to dynamically distribute to all available processors to achieve best job performance.
• Integrated data in to EDW by sourcing it from different sources like SAP, mainframe copy books (Cobol files), DB2 and Teradata tables
• Used DataStage maps to load data from Source to target.
• Worked on troubleshooting, performance tuning and performances monitoring for enhancement of DataStage jobs and builds across Development, QA and PROD environments.
• Monitor the daily ODS data staging and handling any infractions in the process.
• Coding using BTEQ, wrote 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, IBM Information Server DataStage 7.5, SQL Tools, PL/SQL, Windows Vista

Capital One, McLean VA                                                      

Teradata/ETL Developer                                                                                                     Sep’ 2009 – Nov’ 2010

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
• Monitored and posted information about database usage statistics for CDSS
• Coding using BTEQ SQL of TERADATA, write Unix scripts to validate, format and    

      execute the  SQL’s on UNIX environment.

• Defined and implemented approaches to load and extract data from database using DataStage
• Involved in design, source to target mappings between sources to operational staging targets, using DataStage Designer
• Performed ETL coding using Hash file, Sequential file, Transformer, Sort, Merge, Aggregator stages compiled, debugged and tested.
• Extensively used stages available to redesign Data Stage jobs for performing the required integration.
• 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, DataStage 7.0, Windows XP

Capital One, Richmond VA                                                      

Teradata Data Analyst                                                                                                         Jan’ 2008 – Aug’ 2009

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
• Coding using BTEQ SQL of TERADATA, write Unix scripts to validate, format and    

      execute the  SQL’s on UNIX environment.

• Wrote code for fastload to handle large flat file uploading.
• 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.
• 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, 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.

References available upon request