Lohita Chadalavada
****.***********@*****.***
Oxford, MS - 38677
Career Summary:
Versatile IT with around 5+ years of proven Professional experience in Information Technology with specialization in Data Warehousing and Business Intelligence application for Enterprise System utilizing SDCL design methodologies resulting in delivery of quality and efficient business intelligence and data warehousing solutions to companies.
Extensive work experience in the areas of Banking, Finance and Manufacturing industries.
Hands on experience in Defining the development processes, design principals and organizational model for ETL function.
Translate Business Processes into Informatica mappings.
Extensive experience Design and development of CDC process using time-stamping method and Implemented SCD methodologies including Type 2 to keep track of historical data.
Strong experience in Data Warehousing and ETL using Informatica Power Center (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, and Informatica Server), Web Services and Security configuration in Informatica Server (end-to-end).
Extensively worked on the ETL mapping Design, Analysis and Documentation of OLAP reports requirements.
Solid Understanding of OLAP Concepts and challenges with large data sets.
Strong Hands on experience in Optimization of performance tuning in the Oracle SQL Queries like indexing techniques, hints, partitioning and parallel execution process, Explanation plan.
Strong Hands on experience in the performance tuning of sources, transformations, targets, mapping, work lets, work flows and session.
Involved in performance improvement for the transaction load process and optimized the existing SQL queries for performance improvement, used the analytical functions, collection, BULK Collect / FORALL and other method to enhance the performance.
Strong Hands on experience in Deployment of Objects from one environment to other.
Preparation of Low Level Designs (LLD), Run Book, Impact Analysis, Project Milestones and Technical Design Documents.
Strong Hands on experience in the handling of Offshore and on-site teams.
Proficient in creating Unix Shell Scripts.
Strong Hands on experience in File Transfer Protocols (SFTP) and self-motivated able to set effective priorities to achieve immediate and long-term goals and meet operational deadlines.
Technical Skills:
ETL Tools: Informatica PowerCenter/PowerMart 9.6/9.5/9.1.0/8.6.1/8.1/8.0/7.1.3
(Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet,
Transformation, Sessions, Workflows etc.
Tools: Toad, SQLDeveloper, PL/SQL Developer, JIRA (Project Tracking Tool),
MATT (Specs Generation tool), DAC
Languages: SQL, PL/SQL, T-SQL, C, C++, HTML, Unix Shell Scripting.
RDBMS: Oracle 11g/10g/9i/8i, SQL Server 2012/2008R2/2008/2005/2000, Teradata
O/S: MS-DOS 6.22, Win 3.x/XP/95/98, Win NT 4.0, Unix
Modeling: Dimensional Data, Star Schema, Snow-Flake, FACT and Dimensions Tables,
Physical and Logical.
Education:
Masters’ in Computer Science from St. Joseph College, JNTU – 2010.
Bachelors’ in Computer Science from St. Joseph College, JNTU – 2008.
Professional Experience:
Sun Trust Bank, Atlanta, GA Oct’ 2016 to Present
Senior ETL / Informatica Developer
Sun Trust Bank provides investment banking, asset management and wealth management services for private, corporate and institutional clients.
Responsibilities:
Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse.
Interacted actively with Business Analysts and Data Modelers on mapping documents and design process for various sources and targets.
Designing Informatica mappings to load slowly changing dimensions using Lookup, router and update strategy transformations.
Creating Source to staging and staging to warehouse mapping using Designer Transformation like Expression, Router, Filter, Sequence, Generator, Stored Procedure, Connected and Un-Connected Look up etc.
Contributed in developing complex ETL mappings, workflows for three types of mappings, Source to Staging, Dimensions and fact loading.
Involved in performance tuning of the ETL mapping and writing SQL Queries for extracting data from Source systems.
Designed unit test cases for each ETL map and Involved in integration testing and system testing phase of the project.
Developed Shell scripts to populate parameter files automatically before the ETL process starts.
Worked closely with data population source systems and warehouse components.
Defined Target Load Order Plan and Constraint based loading for loading data correctly into different target tables.
Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of whole project.
Environment: PowerCenter 9.6.1, Oracle 12C, SQL, PL/SQL, Shell Scripts, Mainframe DB2, MS Visio, Toad, Windows 2012, Unix.
GE Capital, New Orleans, LA July2014 to Oct 2016
Sr ETL Developer I EDW
GE Capital provides commercial lending and leasing, as well as a range of financial services for health care, media, communications, entertainment, consumers, real estate, and aviation. GE Capital focuses primarily on loans and leases that is underwrites to hold on its own balance sheet rather than on generating fees by originating loans and leases, then selling them to third parties.
Responsibilities:
Define the development processes, design principals and organizational model for Treasury’s ETL function.
Translated Business Processes into Informatica mappings.
Design configuration of Informatica Web Services to automate the eID requests using web services consumer transformation.
Devised and constructed high-performance ETL processes that load a normalized operational data store and dimensional data warehouse.
CDC by using Power Exchange.
Design and development of CDC process using time-stamping method and implemented SCD methodology including Type 2 to keep track of historical data.
Development of new workflow to extract the data from EDW and provide the XML, Flat Files, CSV to the end customer through FTP by writing script at session level.
Deployment of objects.
Involved in performance improvement for the transaction load process and optimized the existing SQL queries for performance improvement. Used the analytical functions, collection, BULK Collect/FORALL and other method to enhance the performance.
Performed code migrations as a part of weekly/monthly change request release.
Troubleshooted, fixed and implemented bug fixes and enhancements within tight deadlines.
Develop high level and detailed level technical and functional documents consisting of Detailed Design Documentation function test specification with use cases and unit test documents.
Execute the test cases for the code changes.
Environment: Informatica Power Center 9.5, Power Exchange, Metadata, (Repository Manager, Designer, Workflow Manager, Workfloz/Monitoy), Teradata, Unix, Oracle 11g, Mainframes, Flat Files, XML, VSAM Files, Sequential Files.
Spirit Aero Systems, Inc. Tulsa, OK Dec 20012 to July 2014
ETL Developer
Spirit Aero Systems, Inc, headquartered in Wichita, KS, USA is the largest non-OEM designer and manufacturer of aero structures for commercial, military and business/regional jets in the world.
Responsibilities:
Designed, Implemented and delivered data warehouse ETL and reporting applications.
Converted the Mainframe Files into Flat Files by defining the structure.
Worked with Project Managers, design lead and solution architect to achieve business and functional requirements.
Analyzed the requirements and accordingly plan, develop, design, test and implemented the functionality and procedure.
Review existing systems to determine compatibility with projected and select appropriate systems, including ensuring forward compatibility of existing systems.
Database development and ETL Process in Oracle 10g.
Formulating the ETL mapping to implement the business logic. Used transformation like Lookup, update strategy, expression, filter, router, aggregate, sequence generator, Implemented Performance tuning at mapping, session level.
Extensively used Lookup cache and persistent cache to make the performance fast.
Used sorter transformation to remove the duplicate record before aggregator.
Followed the required client security policies and required approvals to motve the code from one environment to other.
Developed ETL mappings, transformation using Informatica Power Center 8.6.
Deployed the informatica code and worked on code merge between two different teams.
Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
Actively coordinated with testing team in the testing phase and helped the ream to understand the dependency chain of the whole project.
Environment: Windows XP/2008, Mainframe, Unix, Oracle 10g, SQL Server 2008, Informatica Power Center 8.X, SAP Business Objects.