Data Warehouse Integration
Resume:
SreeDevi Akella
Tel: 210-***-****
Email-id: *******.******@*****.***
Summary:
I have over 17 years of IT experience and have been involved in the complete SDLC including analysis, design, development, testing, implementation, and maintenance of application software.
Experience focusing on Data warehousing, Data modeling, Data integration, Data Migration, and ETL process.
Experience in ETL DataStage v8.5/v9.1/11.3/11.7 Extract, Transform and Load legacy data into Data warehouse/Oracle DB.
Experience in dimensional and relational modeling concepts like star schema and snowflake schema.
Experience in creating parallel jobs, sequences, and parameter sets in DataStage and using most of the processing stages including Oracle, Salesforce, ODBC complex flat file, sequential file, Unstructured data, and datasets stages.
Experience in resolving ongoing maintenance issues and bug fixes; monitoring data stage jobs as well as performance tuning of DataStage jobs.
Experience in Migrating Code to different Environments to QA, UAT, and PROD from DEV using GIT Lab.
Experience in working with Job scheduling tools like Autosys and Control-M.
Hands-on experience in using UNIX and Shell commands to create jobs and automate processes.
Experience in developing SQL complex queries and stored procedures.
Experience in production support and providing critical and normal patches for technical and business-related bugs.
Active team player with a commitment to work to meet deadlines, strong communication, good analytical, time management, decision-making, and problem-solving skills.
Good experience in Agile and waterfall Development Methodology.
Actively involved in Quality Processes and release management activities - To establish, monitor, and streamline quality processes in the project.
Involved in code review meetings with Project Managers, Developers, and Business Associates.
Ambitious, self-motivated, able to work independently as well as in teams, possess multi-tasking skills, results-oriented engineering professional.
Good Domain Knowledge in GRC and investment.
Technical Skills:
ETL IBM Infosphere DataStage 8.5/9.1/11.3
Databases SQL, Oracle, Netezza, DB2, Salesforce, SQL Serveer, Snowflake
Tools Putty, SQL Developer, WinSCP, Control-M, Autosys.
Operating Systems UNIX, Windows NT 2003/ 2000/ XP
Microsoft Applications MS Word, Excel, Office Outlook, MS Access, MS Powerpoint, MS Visio
Certifications:
IBM Certified Solution Developer –Info Sphere DataStage v8.5
Certified in Capital markets and Mutual Funds.
Professional Experience:
United Services Automobile Association (USAA) APR 2021 – Till date
Louisville, KY
Role: ETL Lead Developer
Environment: DataStage11.3, UNIX, Salesforce, DB2, Oracle, GitLab, SharePoint, JIRA, Control - M.
Description:
United Services Automobile Association (USAA) is a Fortune 500 Company that focuses primarily on serving present and former members of the U.S. Military and their families, since 1922 and is one of America’s leading insurance and financial services companies. The association offers its 5.6 million members and associate members a wide range of insurance, banking, investment products, and services designed to help them meet their financial security needs. Headquartered in San Antonio, Texas, with offices throughout the United States. Various Products & Services offered by USAA are Auto, Property Insurance, Banking, Investments, Annuities, Life Insurance, Health Insurance, and Financial Planning.
Accurate/Blackline is a web-based database through which businesses can access the data related to the Bank and Enterprise accounts for the reconciliation process. This project is to prepare the files based on the business needs from various data sources to load into the database and to ftp the files to the corresponding locations used by the business.
Responsibilities:
Understand the business requirements and prepare S2T documents.
Develop, test, and deploy ETL processes using IBM DataStage to integrate data from various sources.
Implement data transformation, cleansing, and enrichment processes to improve data quality.
Ensure data integrity, accuracy, and consistency across different platforms.
Work closely with data analysts, business intelligence teams, and stakeholders to understand data requirements.
Troubleshoot and debug ETL failures, job scheduling issues, and database performance problems.
Maintain documentation for data pipelines, ETL processes, and job schedules.
Perform unit testing and provide support during QA and UAT.
Interact with the data modelers to get the tables created in the DBs.
Conduct the code review meetings before sending the code to production and get the signoff.
Ensure all quality-related activities are logged and shared.
Migrating the code to QA and UAT environments and supporting QA and UAT testing.
Performed performance tuning for the faster execution of the jobs.
Developing and testing the Control-M jobs and scheduling in Dev, Test, and PROD environments.
Collaboration with the DI team to make sure the code is migrated to Test and PROD environments.
Support activities after the code migration to production like running the jobs in production, validating the data, and preparing the technical documentation for each release.
Humana Jul 2018 – Mar 2021
Louisville, KY
Role: ETL Lead Developer
Environment: DataStage 11.3, UNIX, Control-M, Netezza, Oracle.
Description:
Humana Inc. is a for-profit American health insurance company based in Louisville, Kentucky which provides both Medicare and Medicaid plans to the members. This project is to develop the database which will be used by the business for analytics and audit purposes. Verifying and processing the claims are also included in the process. Also included the conversion of the business process into an ETL solution.
Responsibilities:
Meet SMEs to get the requirements and prepare S2T documents
Develop, test, and deploy ETL processes using IBM DataStage to integrate data from various sources.
Implement data transformation, cleansing, and enrichment processes to improve data quality.
Understand the existing code to propose the solution for the problem.
Developing parallel jobs, sequence jobs, and the SQLs to load the extracted data from source transform and load to target DB.
Design and manage job scheduling and automation using Control-M to ensure smooth data workflows.
Write complex SQL queries for data extraction, transformation, and loading (ETL).
Monitor and optimize ETL performance, identifying and resolving bottlenecks.
Perform unit testing and provide support during QA and UAT.
Migrating the code to QA and UAT environments and supporting QA and UAT testing.
Support activities after the code migration to production like running the jobs in production, validating the data
Interact with the data modelers to get the tables created in the DBs.
Conduct the code review meetings before sending the code to production and get the signoff.
Verifying the code, running the jobs, and verifying the data loaded in DB after the code is migrated to production.
Prepare the technical documentation after the release.
United Services Automobile Association (USAA) Aug 2016 – Jun 2018
San Antonio, TX
Role: ETL Lead Developer
Environment: DataStage 11.3, UNIX, DB2, Oracle, Control-M
Description:
United Services Automobile Association (USAA) is a Fortune 500 Company that focuses primarily on serving present and former members of the U.S. Military and their families, since 1922 and is one of America’s leading insurance and financial services companies. The association offers its 5.6 million members and associate members a wide range of insurance, banking, investment products, and services designed to help them meet their financial security needs. Headquartered in San Antonio, Texas, with offices throughout the United States. Various Products & Services offered by USAA are Auto, Property Insurance, Banking, Investments, Annuities, Life Insurance, Health Insurance, and Financial Planning.
This project is to develop the Data Mart and Data Warehouse for USAA Bank which holds data related to credit cards, consumer loans, checking and savings accounts, etc.
This project is to develop the processes to move the data from various source systems to the Bank Data mart and the data warehouse to generate analytics on top of the data loaded which is accessible to the business.
Responsibilities:
Meet business to get the requirements and interact with all the related POCs from all other teams to get the required information.
Developing parallel jobs, sequence jobs, and the SQLs to load the extracted data from source transform and load to target DB.
Develop, test, and deploy ETL processes using IBM DataStage to integrate data from various sources.
Implement data transformation, cleansing, and enrichment processes to improve data quality.
Design and manage job scheduling and automation using Control-M to ensure smooth data workflows.
Write complex SQL queries for data extraction, transformation, and loading (ETL).
Monitor and optimize ETL performance, identifying and resolving bottlenecks.
Ensure data integrity, accuracy, and consistency across different platforms.
Ensure all quality-related activities are logged and shared
Perform unit testing and provide support during QA and UAT.
Interact with the data modelers to get the tables created in the DBs.
Conduct the code review meetings before sending the code to production and get the sign-off.
Migrating the code to the PROD environment and performing the support activities after the code migration to production like running the jobs in production and validating the data.
Prepare the technical documentation after each release.
United Services Automobile Association (USAA) Feb 2015 – Aug 2016
San Antonio, TX
Role: Senior ETL Lead
Environment: DataStage 9.1, UNIX, Control-M, SQL Server and DB2
Description:
United Services Automobile Association (USAA) is a Fortune 500 Company that focuses primarily on serving present and former members of the U.S. Military and their families, since 1922 and is one of America’s leading insurance and financial services companies. The association offers its 5.6 million members and associate members a wide range of insurance, banking, investment products, and services designed to help them meet their financial security needs. Headquartered in San Antonio, Texas, with offices throughout the United States. Various Products & Services offered by USAA are Auto, Property Insurance, Banking, Investments, Annuities, Life Insurance, Health Insurance, and Financial Planning.
This project is to automate the existing manual process of creating the Audit Dash Boards to provide near real-time visualization and to improve audit status data and audit execution data to meet regulator expectations.
This project is to Implement Continuous Auditing dashboards to provide management oversight of continuous auditing activities. Meet regulator (Federal Reserve and OCC) expectations for up-to-date audit status, improved close out of audits, and visualization of auditing information. Improve internal management of Audits and reporting to COSA and Audit Management.
Responsibilities:
Extensively worked with Business and Functional Analysts to get the appropriate Requirements.
Creating S2T documents and getting them approved by the business.
Writing Unit and Integration Test Plan documents.
Design and develop the ETL job to extract the data from different sources like DB2, Oracle, and flat files and load it into the target Db2 tables.
Performed code reviews of the developed jobs and fixed the identified defects in the jobs.
Develop, test, and deploy ETL processes using IBM DataStage to integrate data from various sources.
Implement data transformation, cleansing, and enrichment processes to improve data quality.
Design and manage job scheduling and automation using Control-M to ensure smooth data workflows.
Write complex SQL queries for data extraction, transformation, and loading (ETL).
Monitor and optimize ETL performance, identifying and resolving bottlenecks.
Ensure data integrity, accuracy, and consistency across different platforms.
Work closely with data analysts, business intelligence teams, and stakeholders to understand data requirements.
Troubleshoot and debug ETL failures, job scheduling issues, and database performance problems.
Maintain documentation for data pipelines, ETL processes, and job schedules.
Developed ETL parallel and sequence jobs.
Developing control-m jobs and migrating the code to Dev, Test, and PROD environments.
Used Control - M for Executing, Monitoring, analyzing logs, and scheduling the jobs.
Performed performance tuning for faster retrieval and processing of data.
Generating the Business Objects reports to verify the data in the reports.
United Services Automobile Association (USAA) Nov 2014 – Feb 2015
San Antonio, TX
Role: Senior ETL Developer
Environment: DataStage 9.1, SQL, BWise, XLSImporter.
Description:
United Services Automobile Association (USAA) is a Fortune 500 Company that focuses primarily on serving present and former members of the U.S. Military and their families, since 1922 and is one of America’s leading insurance and financial services companies. The association offers its 5.6 million members and associate members a wide range of insurance, banking, investment products, and services designed to help them meet their financial security needs. Headquartered in San Antonio, Texas, with offices throughout the United States. Various Products & Services offered by USAA are Auto, Property Insurance, Banking, Investments, Annuities, Life Insurance, Health Insurance, and Financial Planning.
This Project is to enable the ability to demonstrate compliance with all applicable Privacy laws and regulations and satisfy the expectations of regulators.
Responsibilities:
Responsible for requirements gathering, analysis, and design approach.
Develop, test, and deploy ETL processes using IBM DataStage to integrate data from various sources.
Implement data transformation, cleansing, and enrichment processes to improve data quality.
Design and manage job scheduling and automation using Control-M to ensure smooth data workflows.
Write complex SQL queries for data extraction, transformation, and loading (ETL).
Monitor and optimize ETL performance, identifying and resolving bottlenecks.
Ensure data integrity, accuracy, and consistency across different platforms.
Work closely with data analysts, business intelligence teams, and stakeholders to understand data requirements.
Troubleshoot and debug ETL failures, job scheduling issues, and database performance problems.
Maintain documentation for data pipelines, ETL processes, and job schedules.
Loaded the Risk and controls information for Life, Bank, and IMCO COSAs into the BWise application.
Helped in creating the risk data for the Life and Bank Lines of business.
United Services Automobile Association (USAA) Nov 2013 – Oct 2014
San Antonio, TX
Role: Senior ETL Developer
Environment: DataStage 9.1, UNIX, Control-M, Oracle (SQL Developer).
Description:
United Services Automobile Association (USAA) is a Fortune 500 Company that focuses primarily on serving present and former members of the U.S. Military and their families, since 1922 and is one of America’s leading insurance and financial services companies. The association offers its 5.6 million members and associate members a wide range of insurance, banking, investment products, and services designed to help them meet their financial security needs. Headquartered in San Antonio, Texas, with offices throughout the United States. Various Products & Services offered by USAA are Auto, Property Insurance, Banking, Investments, Annuities, Life Insurance, Health Insurance, and Financial Planning.
In USAA, Enterprise Financial Crimes Management (EFCM) needs to have the ability to monitor data volume, data integrity, and data synchronization per the OCC (Office of the Comptroller of the Currency) 2011-12 guidelines to ensure proper implementation of models, effective systems integration and appropriate use. EFCM data environment has to strengthen the ability to identify suspicious financial activity and maintain compliance with regulatory guidelines.
As part of this project, the existing user interfaces are simplified to make the ECAMS DQ process store the Batch and Real-Time messages and the Monetary transaction events from all source systems into the ECAMS Database so that we will be able to identify the number of messages that failed at ECAMS.
This project allows us to access how many records are processed for a particular day for a particular message type as all the Batch and Real-Time messages and the Monetary transaction events from all source systems are stored in the ECAMS tables for Data quality check. It also helps in protecting the organization against fraudulent activities.
Responsibilities:
Extensively worked with Business and Functional Analysts to get the appropriate Requirements.
Preparing Functional designs, Detailed level designs, and Mapping documents.
Writing Unit and Integration Test Plan documents.
Design and develop the ETL job to extract the data from different sources like DB2, Oracle, and flat files and load it into the target Db2 tables.
Performed code reviews of the developed jobs and fixed the identified defects in the jobs.
Developed ETL Jobs using various Development / Processing Stages (Transformer, Aggregator, Change Capture, Change Apply, Join, Lookup, Modify, Filter, Sort and Merge, Funnel, Remove Duplicate Stage) Debug Stages (Peek Stage, Head and Tail Stage, Row generator stage, Column generator stage, Sample stage).
Involved in developing Test Cases and Performed Unit Testing, End-to-end System Integration testing, and UAT Testing.
Parameterized the variables at the project level.
Used Control - M for Executing, Monitoring, analyzing logs, and scheduling the jobs.
Wrote Shell Scripts to handle pre and post-job runs.
Wrote SQL complex queries for implementing business rules and transformations.
United Services Automobile Association (USAA) May 2011 – Nov 2013
Hyderabad, India
Role: Senior ETL Developer
Environment: DataStage 8.5, UNIX, Control-M, Oracle.
Description:
United Services Automobile Association (USAA) is a Fortune 500 Company that focuses primarily on serving present and former members of the U.S. Military and their families, since 1922 and is one of America’s leading insurance and financial services companies. The association offers its 5.6 million members and associate members a wide range of insurance, banking, investment products, and services designed to help them meet their financial security needs. Headquartered in San Antonio, Texas, with offices throughout the United States. Various Products & Services offered by USAA are Auto, Property Insurance, Banking, Investments, Annuities, Life Insurance, Health Insurance, and Financial Planning.
As a part of the Data Integration strategy for The Dodd-Frank Act implemented in the United States to ensure that all financial institutions should withstand the recession that may come in the future, the data received from various Heterogeneous sources will be loaded into Staging Database for Reports Generation that would be submitted to Federal Reserve Bank.
Responsibilities:
Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
Analyzed the requirements, developed the shell scripts, and was responsible for developing the parallel jobs using Data Stage.
Used Data Stage stages namely Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Funnel, ODBC connector, and Switch stages in accomplishing the ETL Coding.
Responsible for troubleshooting and fine-tuning the performance of the jobs.
Developed the Control-M jobs for all various ETL Flows by setting up the Dependencies using the Control-M tool.
Developed Reusable FTP Scripts to FTP the files from the Windows location to the Hadoop location and archive them a regular intervals.
Environment:
DataStage v8.5, UNIX, Control-M
United Services Automobile Association (USAA) Sep 2010 – May 2011
Hyderabad, India
Role: Senior ETL Developer
Environment: DataStage 8.5, UNIX, Control-M, Oracle.
Description:
USAA is one of the large Financial Services organizations in the USA providing Insurance and Investment services for all military organization members and their family members. At present USAA has many niche services for the market segment of clients and all of them are supported by different portfolio management systems namely Brokerage Services, Mutual Fund Services, Managed Products Services, etc. These systems are in turn supported by different vendors. We need to develop UI components for the IBM Cognos ICM tool which helps the end-users carry out day-to-day operational activities and load the monthly files received from various sources to staging databases.
Responsibilities:
Responsible for gathering and analyzing the requirements.
Developed Reusable ETLs for loading into a database.
Developed an ETL value add which reduced job execution time from 45 minutes to 4 minutes.
Responsible for troubleshooting and fine-tuning the performance of the jobs.
Developed the Control-M jobs for all various ETL Flows by setting up the Dependencies using the Control-M tool.
Developed Reusable FTP Scripts to FTP the files from the Windows location to the Hadoop location and archive them a regular intervals.
American Internation Group (AIG) Aug 2008 – Sep 2010
Hyderabad, India
Role: ETL Developer
Environment: DataStage 7.5.2, DB2, UNIX, Autosys.
Description
AIG is a leading U.S.-based international insurance organization and is among the largest underwriters of commercial and industrial coverage in the United States. Its member companies write property, casualty, marine, life, and financial services insurance in approximately 130 countries and jurisdictions, and are engaged in a range of financial services businesses.
This project is to eliminate the manual process of collating and mailing the policy to the broker by introducing web-based access to search policies and transactions which will give the external users (Brokers) the flexibility of receiving policies in electronic format the next day after issuance, instead of waiting for the policy to arrive via regular mail, reducing the number of days the broker has to wait for the policy. This system will also reduce the number of copies that need to be printed by AIG. In addition, this will also allow a broker to check on the status of their submission and eliminate the need to contact the Underwriter or the Customer Care center, thereby improving and streamlining the overall process.
Responsibilities:
Extracting data from different sources like Oracle, Sybase, and Mainframe DB2 and transforming them using business logic and loading the data to the target warehouse using the Data Stage Built-in Passive stages like ODBC, ORACLE8i, Sequential files, and Hashed files for look-ups.
Good Knowledge in developing ETL jobs and validating and scheduling the same jobs using the Data Stage director.
Unit testing, integration testing, and user acceptance testing are used in my project.
To perform the aggregation operations on the extracted input data and filter the data Using Built-in Active Stages.
Involved in preparing ETL Specification for developing jobs
Involved in compiling, validating, running, Monitoring, and scheduling the jobs using the ETL client tool.
Worked with ETL tool for importing metadata from the repository, new job Categories, and creating new data elements
All file paths must be parameterized to allow runtime flexibility and ease of migration between various server environments.
Contact this candidate