Candidates About

                              Srikrishna Battula                                                                                                    

Professional Summary                                                                                                                    

Ø  8+ years of IT experience in analysis, design, modeling, development, implementation and testing of Data Warehousing and Client/Server applications.

Ø  IBM Certified Solution Developer in Info Sphere DataStage V9.1.

Ø  It includes around 8+ years Experience in Data Warehousing Tool Ascential DataStage 6.x, 7.X and IBM InfoSphere (11.3/9.1/8.7/8.5/8.1).

Ø  Efficient in all the phases of System development life Cycle (SDLC) using different methodologies like Agile and Waterfall.

Ø  Designed, tested and migrated DataStage jobs from Development System to Test System and then to Production System for Operational Data Store and Data Warehouse.

Ø  Created master sequence in DataStage to run jobs /exception handling/ email notification etc which basically controlled the number of job runs in the server, success/failure reports etc.

Ø  Extensive experience in dealing with High Volume Data, Performance Tuning, Maintaining, Multiple Job. Developed efficient mappings for data extraction/transformation/loading (ETL) from different sources to a target data warehouse.

Ø  Wrote UNIX Shell Scripts for file deletion, Automation, job run, file processing, Initial Load, batch loads, Cleanup, Job scheduling and Reports.

Ø  Strong Experience in Writing PERL, UNIX Bash and Korn Shell scripts to automate various Processes.

Ø  Expertise in dimensional data modeling, Star schema modeling, Snow flake modeling, fact and dimension table design, physical and logical data modeling using Erwin.

Ø  Technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

Ø  Strong knowledge in OLTP/OLAP Systems, Normalized (OLTP), Demoralized (DW and ODS) models, Dimensional Strategies, Surrogate Key, Star schema, Snowflake schema.

Ø  Experience with relational databases like Oracle 11g/10g/9i, DB2, Teradata v2r12, SQL Server 2005, 2000 and bulk load utilities like Oracle SQL*Loader, DB2 Load, M load, Fast load, T Pump, Fast export. Handful experience in using QueryMan.

Ø  Worked with Oracle PL/SQL Stored Procedures, Table Partitions, Triggers, SQL queries, SSIS, PL/SQL Packages, IBM SQL Procedural Language and loading data into Data Warehouse/Data Marts.

Ø  Good Knowledge on SAP HANA data modeling and creation of Attribute View, Analytic View, and Calculation View, Analytic privilege by using HANA Studio.

Ø  Experience in using testing tools and Job scheduling tools.

Ø  The ability to adapt and learn new technologies and proficient in learning them quickly.

Ø  Strong oral and written communication skills to maintain productive work relationships with management, clients, team members and other groups.

Ø  Collaborated and worked closely within several teams as a highly motivated team leader; coordinated work, lead and trained individuals which resulted in creating a more productive work environment.

    Technical Skills

    Work Experience

Fifth Third Bank/Cincinnati, OH                                                                                             Apr’17 – Present

Sr. ETL Consultant

This main scope of this project is to create single datamart for to get the units,points, balace points and QA points for serveral products coming from EDW. This will empower users to retriew data faster and with better visual capabilities than the current KPI product.

Responsibilities:-

Ø  Worked closely with Business Analysts to understand business rules and requirements in order to  analyze and translate functional requirements into technical specifications to support the deployment of new subject areas or make enhancements to the EDW.

Ø  Involved in analyzing scope of application, defining relationship within & between groups of data, star schema and snow flake schema, Gathering requirements and writing specifications for modules.

Ø  Worked on Data modeling - Star Schema and third normal form.

Ø  Extensively used many database connector stages like ODBC connector, Oracle connector, DB2 connector, DB2 UDB and enterprise stages as well.

Ø  Designed several parallel jobs using Sequential File, Dataset, Join, Merge, Lookup, Remove duplicates, Funnel, Filter, Copy, Column Generator, Peek, Modify, Oracle Enterprise, Aggregator, Transformer Stages.

Ø  Extensively worked on the latest features of Datastage 9.1 like Transformer looping and xml plugins.

Ø  Used Join/Merge/Lookup Stages to replicate integration logic based on the volumes of the data.

Ø  Designed Error handling process and generated Error reports to be sent as email whenever a job was aborted.

Ø  Was involved in full integration testing of all the jobs within each sequence, before migrating to QA environment from development.

Ø  Involved in code migration and code review sessions as part of migration plans.

Ø  Involved in resolving the Quality Center defects raised by (System Integration Testing)SIT and (User Acceptances Testing) UAT teams and documented them as well.

Ø  Designed the logical and physical data warehouse schema. Analyzed source systems and creating a mapping to the target database schema.

Ø  Used Data Stage Sequencer as the sole scheduler to schedule the Data Stage and Quality Stage jobs .

Ø  Extensively worked on production support issues and resolved them on time, and used e-mail task for capturing issues via e-mail along with the session logs.

Ø  Developed UNIX shell scripts for scheduling the jobs and for automation of ETL processes.

Ø  Involved in conducting design and review sessions with various teams.

Ø  Served as mentor and reviewer to fellow juniors in all areas of data warehousing and ETL.

Ø  Train and manage developers, advising other groups in organization on ETL Design and development best practices. 

Ø  Involved in cross training with different teams to understand  various applications.

Ø  Involved in production automation and maintenance and also was responsible for troubleshooting issues that arose while upgrading DataStage.

Ø  Played an active role in planning delivery timelines and ensuring that the reports are delivered on time to the customers.

Environment: IBM Datastage 11.3/9.1, Unix Shell Scripting, IBM DB2, Oracle, Tableau, SAP-BO,Jira, Version One, Service Now.     

Albertsons/Safeway, CA                                                                                                           Sep’16 – Mar’17

Sr. ETL Consultant

This project will upgrade the entire Manhattan eCommerce platform in support of a strategic business plan to increase the eCommerce sales to $3.5-5 billion. This will include Manhattan's Store Inventory and Fulfillment (SIF) technology, customizations to meet the business needs, and the customer service Call Center module. The current plans are to run this platform in the cloud and centralize the eCommerce functionality which currently requires eCommerce servers in each store. This Project will create a highly scalable and reliable solution for growing the eCommerce business.

Responsibilities:-

Ø  Worked closely with Business Analyst and Data Architect to design the suitable ETL solutions that supports business/data and technical requirements. 

Ø  Developed Complex Parallel Jobs using Connectors, Parallel stages like Sort, Lookup, Join, Filter, Aggregator, Transformer, Remove Duplicate etc. 

Ø  Developed DataStage Interface jobs as per the source to target mappings and functional specifications. 

Ø  Designed and Build ETL Solutions to automate deployment activities and stream line the interface processes. 

Ø  Worked with various relational Databases Oracle, Teradata, and SQL server as source and target system for developing ETL Job components and debugging data issues. 

Ø  Developed DataStage jobs for executing Customer Application (SQL server) Stored Procedures. 

Ø  Involved in Design, Development and Testing with Safeway Data Warehouse/DataMarts. 

Ø  Developed DataStage Sequences that include looping, restartability and check points. 

Ø  Performed Unit Testing on the ETL components (Jobs/Scripts) make sure that they meet the design criteria and derive expected results. 

Ø  Prepared the Interface Technical Design documents based on requirements/use cases. 

Ø  Promoted and deployed code using ChangeMan DS Release management tool Version control to Perform Code Migration Activities across the environments. 

Ø  Utilized ds job commands for jobs Execution, report job logs and error handling through shell script. 

Ø  Created and Updated Library functions in UNIX scripts for performing various Sanity checks for the files (record count, file comparison, Email notification) also House Keeping activities (File movement, Archival and deletions). 

Ø  Performed historical job runs for data migration to the new retail work force management tool. 

Ø  Provided Technical support for production runs involving Monitoring jobs and fixing the issues. 

Ø  Utilized ESP Scheduler for Scheduling Data Stage and Windows Batch jobs as per the requirement.

Environment: IBM Datastage 11.3/9.1, Unix Shell Scripting, IBM DB2, Oracle, Control-M, Jira, Version One, Service Now.     

Macy’s, San Francisco, CA                                                                                                           Oct’15 – Sep’16

Sr. DataStage Developer

Macy’s is one of the leading retail chains in US. Business wants to develop a process called 

RTO (Real Time Offers).The scope of RTO is to integrate all marketing campaigns of Macys and Bloomindales with existing execution/delivery systems to create DataMart for single enterprise Omnichannel Campaign.

Responsibilities:-

Ø  Interacted closely with the Business Analysts in gathering the requirements and approach to feed SAS stage.

Ø  Worked on the data stage code design and development as per the STMs in populating the database tables.

Ø  Developed different Data Stage parallel jobs. By using data from different sources formatted, Cleaned, summarized, aggregated and transform into data warehouse. 

Ø  Worked extensively on different types of transformations Change capture, Modify, Stored procedure, Peek, Tail, Head, Sequence generator, Aggregator, Column Import, Column Export, Inter Processer, Quality Stage, and FTP Stage. 

Ø  Implemented Change data capture (CDC) to improve operational efficiency and saves time and resources by eliminating redundant data transfer. 

Ø  Implemented Slowly changing dimensions so as to maintain the history data.

Ø  Implemented various partition methods like Hash, Entire, Auto, db2.

Ø  Understanding the existing production systems and associated ETL processes. 

Ø  Extensively worked on transforming text data to XML stages and used Java transformer stages. 

Ø  Used Director for executing, analyzing logs and scheduling the jobs. 

Ø  Performance tuning of ETL jobs for optimum performance and Performed unit testing to the job that are developed and provided to support the code when is it in QA.

Ø  Responsible for Performance tuning of DataStage jobs with proper DataStage partitioning techniques.

Ø  Good experience in analyzing data using Hive.

Ø  Extensively worked on Hive-QL(HQL).

Ø  Developed sequencers to control the job execution of the Datastage Jobs. 

Ø  Created UNIX scripts to automate ETL jobs and handle the file transfer, and to process the ETL job based on the file availability.

Environment: IBM Datastage 11.3/9.1, Unix Shell Scripting, IBM DB2, Oracle, Control-M, Jira, Version One, Service Now, Python, Hadoop,Hive.     

State of Indiana (Indianapolis, IN)                                                                                  Jan’12 –Sep’15

Sr. DataStage Developer 

NTT Data has been engaged by the Indiana Family and Social Services Administration (FSSA) to provide application management support for FSSA division of family Resources (DFR) and welfare reform Integrated Database (WRIDB) also known as the Social services Data Warehouse.

The data warehouse receives data files in various formats including text, Excel, mainframe physical sequential files, Access, SQL 2005. Tables and views. Data stage jobs typically load these files into staging tables. Specific sets of data are extracted from staging tables, transformed based on established business rules, requirements, DWH standards and then loaded into core tables of data warehouse. Data from Core tables is summarized and loaded into aggregate tables.

Responsibilities:-

Ø  Used the DataStage designer to develop job to extract, transform and load data from Oracle/ SQL server database into the flat files and warehouse tables.

Ø  Designed, developed DataStage mappings, enabling the extract, transport and loading of the data into target tables.

Ø  Developed job sequencer with proper job dependencies, job control stages, triggers.

Ø  Worked with Business Analyst to minimize the gap between the requirement gathering and code development.

Ø  Involved in the design of the job template that provides the environmental parameters for the subsequent projects.

Ø  Extracted data from flat files Transformed according to the requirement and Loaded into staging schema using various stages like sequential file, Aggregator, Transformer stage, dataset, Look up, Aggregator, joiner.

Ø  Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.

Ø  Exclusively used Stage Variables in transformer stage for the purpose of reusability and to avoid repeated transformation logic.

Ø  Excessively used user defined SQL queries to extract the suitable data from Oracle/SQL Server sources and to perform Join between various tables in the Oracle/SQL Server instance.

Ø  Worked with database administrators (DBAs) to add some hints in extract SQL as required per explain plan of the SQL to gain efficient performance results.

Ø  Implemented exception and error handling to grace fully handle the code.

Ø  Performed unit and integrated testing using the trace mode and peek stage.

Ø  Used DataStage Designer for importing metadata from repository and creating new table definitions and sequential file definitions.

Ø  Automated and scheduled jobs to run at predefined schedule and send the error log report, if any.

Ø  Written shell script to send email failure notification to the required distribution list.

Ø  Developed UNIX Shell scripts and schedule the jobs.

Environment: IBM InfoSphere DataStage 9.1/ 8.1, DB2, Teradata V14, Teradata SQL Assistant 14, Oracle 11g, DB2 and Cognos 10.     

TIAA-CREF (Charlotte, NC)                                                                                                                  Mar’10 –Dec ‘11

Sr. DataStage Developer 

     TIAA-CREF is a Non-Profit Financial Organization for over 90 years serving the Greater Good those in the academic, medical, cultural and research fields plan for and live in retirement. Project is about Data loading of GL BALANCES, Inflows/Outflows Transactions of Participant GL Account’s with the ETL process according to the Business Requirement Documents from corresponding Sources like the EDW, FDW ,DRM & Manual Data files into respective Tables and Datasets.

Responsibilities:-

Ø  Identified business needs, evaluated business and technical alternatives, recommended solutions and participated in their implementation.

Ø  Involved in end-to-end implementation and also involved in coding at the lowest level.

Ø  Analyzed customer data for data integrity and Normal Form standardization .

Ø  Received data from different data sources such as Flat files, Complex flat files and loaded into target as ORACLE.

Ø  Created generic jobs for extraction and loading, using schema files and RCP.

Ø  Enhanced the Job Performance by using proper Partitioning methods and analyzing the resources utilized using Job Monitor. 

Ø  Created Shared Containers to increase Object Code Reusability and to increase throughput of the system.

Ø  Extensively done Data integration of different systems with different logic to bring the common final outputs on per customer per client basis.

Ø  Written several documents like Technical Design Documents, Data Stage standards and best practices documents, Data Stage Naming Conventions document, ETL methodology etc.

Ø  Extensively used Data Stage and Quality Stage Designer to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data using various stages like Standardize, Match Frequency, Reference Match, Unduplicate Match, Survive, Remove Duplicate, Surrogate Key,

Ø  Used Autosys to automate jobs.

Ø  Used UNIX based scripts for Scheduling Jobs and Start Criteria checking.

Ø  Worked on performance tuning of ETL jobs using SQL queries, data connections, configuration files, parameter sets and environment variables.

Ø   Extensively used Job Sequencer to convert complex jobs to easy jobs for better performance and easy maintenance.

Ø  Responsible for monitoring all the jobs that are running, scheduled, completed and failed and troubleshooting the failed jobs.

Ø  Developed test scripts, test plan and test data. Responsible for unit, system and integration testing Participated in UAT (User Acceptance Testing).

Ø  Worked with Production Support team in resolving production issues on time.

Ø  Involved in code migration and code review sessions as part of migration plans

Environment: Information Server 8.0.1, Quality Stage, ORACLE, Shell scripts, UNIX, AIX, Toad, Autosys.    

    Education

     Bachelors Degree in Information Technology