Close Close Preview

Your amazing online presence is right this way.

Create your profile
Capture who you are, what you do, and where you're going. All in one place.

Sathindra Kamepalli

Sathindra Kamepalli

Lead Application Developer

Catamaran

Lead Application Developer at Catamaran

Message
MENU ☰

Catamaran

Lead Application Developer

Career medium 02

Deloitte Touche Tohmatsu

Senior Systems Engineer

- Worked on the Deloitte's Global Client Intelligence data warehouse and data mart re-architecture and ETL tool replacement projects and also supported and maintained current products.
- Led development projects, monthly maintenance releases including managing time, resources, scheduling, estimating; design and development of code, provided code design to other team members for development, provided code reviews.
- Developed DataStage Server, Parallel and Sequence jobs
- Used Schema File and Run-time Column Propagation methodologies to load data from files.
- Used Type 2 Slowly Changing Dimension technique to capture historical data ( Change Data Capture Stage).
- Improved and optimized SQL and DataStage performance.
- Developed, maintained and supported DecisionStream ETL jobs.
- Created SQL Server Databases, Stored Procedures, Views, Tables, Triggers, Partitions, Indexes.
- Developed, supported and maintained Cognos Report Studio reports and Cognos Framework Manager.
- Provided support to Product, QA, BA and Operations teams.
- Maintained Design, Source-Target Mapping, Unit Test, Deployment and Support Guides.
- Worked with Virtual teams in a global delivery model.
- Mentored team members.
- Created DataStaging coding standards, naming standards and best practices guide.

Career

Walgreens Health Initiatives

Sr. Developer/Sr. Programmer Analyst

- Worked on various projects at Walgreens Health Initiatives (WHI) for Pharmacy Benefit Management, including replacing old Pharamcy, Prescriber, Drug and Enrollment data load process with new DataStage jobs.
- Worked as a development lead to manage projects, tasks, schedules, timelines and deliverables.
- Designed and Developed jobs for daily , monthly, yearly and ad hoc batch loading process.
- Designed and developed file level, record level data quality checks and data quality reporting.
- Created QualityStage and DataStage jobs to cleanse data, and improve the quality of data , maintain data integrity and enforce referential integrity and cardinality standards. Included reject handling, error handling and exception handling.
- Developed Data masking and Data shuffling algorithms to hide sensitive data.
- Created PL/SQL scripts, including Stored procedures, functions, packages; SQL loader utility for bulk loading and SQR scripts for reporting.
- Developed UNIX shell scripts to invoke, check data connections, run SQL scripts, email notifications, FTP/SFTP files.
- Participated in design and code reviews.
- Provided production support.
- Provided training and support guides to the team on the new products developed.
- Developed coding standards, naming standards, templates and was part of the committee created to improve the quality of the products developed.

Career medium 05
Career
Career medium 03

BJC HealthCare

Sr. ETL/Datawarehouse Developer (Consultant)

- Worked on the Supply Chain Management Analytics project to provide real time access to relevant, fact based information that allows them to make informed decisions.
- Created the datawarehouse (Type 2 SCD) and data marts (Star Schema/3NF) in IBM DB2 database, including database tables, views, functions, stored procedures, materialized query tables.
- Participated in design sessions for Database, ETL process, CognoFramework & CognosReport designs.
- Created technical specifications and design documents based on the functional specifications.
- Analyzed data using Informatica DataProfiling (Auto Profile and Custom profile).
- Created Informatica mappings, reusable transformations, mapplets, sessions, command tasks, using various transformations like Source Qualifier, Normalizer, Expression, Connected/Unconnected Lookups, Router, Filter, Aggregator, Update strategy.
- Developed UNIX scripts for file watching, log data loads and email success/failure and other notification alerts, FTP/sFTP to get data from different servers.
- Developed data cleansing, reject , exception and error handling processes.
- Loaded data from different sources , Flat File, VSAM, DB2 and Oracle and into Flat File, DB2 and Oracle targets.
- Used Informatica scheduling and IBM Tivoli Worload Scheduler (using pmcmd) to schedule jobs/workflows.
- Developed SQL scripts for SQL overrides in Informatica mappings, Cognos reports and for automating database testing and to run data quality checks.
- Analyzed explain plains to create database indexes, improve performance of poorly performing jobs.
- Mentored junior team members, on boarded new team members, managed tasks , estimates and scheduling.
- Created templates for design, source-to-target mapping, unit test, deployment and support documents.

Career

United Online

Sr. ETL Developer (Consultant)

- Worked on the design and development of Classmates.com data warehouse project, which involved building a new data warehouse using Netezza and Informatica.
- Gathered business requirements from business analysts and worked with data modelers to design a star schema data base.
- Used NZLOAD capabilities to load event log files and other flat files into staging tables.
- Used NZSQL to query the Netezza database and validate the data.
- Developed UNIX shell scripts to run the NZLOAD process, send email notifications.
- Designed and developed transformations to clean, modify and transform data for integration.
- Used Informatica Power Center Scheduler to schedule jobs.
- Unit Tested the mappings and SQLs and worked with other team members for Integration testing, System testing and User Acceptance testing.
- Developed templates for design and testing documents.
- Managed team of junior developers and reviewed their work.
- Managed tasks, and heavily involved in estimation and scheduling.

Career medium 01
Career
Career medium 01

AXA Equitable

Sr. Datawarehouse Developer (Consultant)

- Worked on Campaign Management Project which involved getting data from different campaigns for reporting and tracking results.
---- Developed Informatica mappings, mapplets, transformations and workflows.
---- Worked with Flat file sources and Oracle database target.
---- Interacted with Business Analysts and End users during requirements gathering and various testing phases (Unit, Integration, Quality Assurance andUser Acceptance) of the project.
---- Improved and optimized mappings for performance and efficiency.
---- Created various documents during different phases of the project life including - Source-to-target mappings, mapping design documents, unit test plans, support guides.

- Involved in the support and maintenance of the Client Assignment System (CAS) project. ( Worked on the development of the project in a previous contract).
--- Ran daily quality checks to ensure quality of the data being loaded via the ETL process.
--- Improved the process to handle data discrepencies and rejects.
--- Improved the performance of the mappings.
---- Added enhancements to the process to email daily , weekly and monthly reports and email outages to the appropriate parties using UNIX shell scripting.
---- Modified current mappings based on change in requirements and/or for defect fixes.
--- Created Support documents for Operations team.

Career

Wachovia, A Wells Fargo Company

ETL Developer (Consultant)

- Worked on Strategic Retirement Initiative project that is aimed to meet client's retirement needs through smart, integrated solutions and provide expert advise. The metrics and scorecard initiative allowed management to take a holistic view of the retirement services across product groups, business segments and delivery channels.
- Worked with analysts to identify reporting needs, and gather requirements.
- Involved with the data modeling and used Erwin data modeling tool.
- Used Type 2 Slowly Changing Dimension to capture historical data.
- Loaded previous historical data from various sources , like MS Excel Spreadsheets, Text files, MS Access databases into a single integrated database (Oracle).
- Designed and developed mappings and transformation logic to load data into the database.
- Worked with Siebel Analytics Dashboards to check for data accuracy and for integration testing purposes.
- Created design, process flow, unit test , source-to-target mapping documents.

Career medium 05
Career
Career medium 05

AXA Financial

Datawarehouse Developer (Consultant)

- Worked on integration project to Client Assignment System (CAS) Integration Project to extend the functionalities on AXA-CAS to MONY ( Mutual of New York)
---- CAS presents branch managers and branch operations manager with an internet based application to facilitate the active management of associates' book of business with the main objective to automatically generate assignment recommendations when certain situations occur.
---- Designed and developed Informatica mappings using different transformations
Modified mappings by replacing hard coded data with logical queries, variables and parameters for efficiency
---- Altered existing mappings developed for AXA-CAS to incorporate MONY-CAS logic
---- Created unit test data, test cases and test plans.
---- Included performance and load testing as part of the unit testing prior to deployment.
---- Data extraction included flat file sources in DB2/MainFrame and Oracle DB and data loading was done into Oracle database.

- Worked on Information Management Integrated System (IMIS) project to prepare data for the business users, for ad hoc querying and reporting (using Business Objects tool) purposes.
---- Interacted with end user for requirements gathering
---- Included data cleansing logic in Informatica mappings to improve the quality of data.
---- Worked with flat file and database sources and targets
---- Used various transformation including stored procedure transformations, connected and unconnected lookups.
---- Documented Process flows, Source-to-Target mappings and Unit test plan
---- Involved in performance tuning and optimization of database queries and Informatica mappings.

Career

DW Practice

Datawarehouse Developer (Consultant)

- Consultant/Contractor at multiple client sites, including MetLife (Charlotte, NC), TIAA CREF (Charlotte, NC) , Delta Airlines ( Atlanta, GA), AT&T (Alpharetta, GA).
- Designed and developed ETL processes in Informatica Power Center, using different transformations ( aggregate, join, look up , filter, router, normalizer), reusable mapplets, sessions/batches, workflows/ worklets.
- Analyzed and developed data cleansing logic for data from multiple data sources - Oracle, DB2 databases, Cobol files and other flat files and load data into flat file or databases.
Involved in debugging, troubleshooting and performance tuning of Informatica mappings.
- Interacted with other teams and hands on experience with the tools like Erwin for Data Modeling, Cognos and Business Objects for Reporting.
- Developed test cases and test data from business rules for unit testing.
- Automated unit testing process for multiple testing purposes.
- Interacted with Business Analyst team and Quality Assurance team during various stages of the project.
- Supported teams during Production deployment and post production implementation.

Career medium 01
Career

All Saints' High School, Hyderabad,India

Bangalore University

B.E., Computer Science, Computer Engineering

Little Flower Junior College, Hyderabad, India

University of North Carolina at Charlotte

M.S., Computer Science