Data Developer

Vamsi Kamani

503-***-**** ******@*****.*** Phoenix, Arizona 85085 linkedin.com/in/kamani/

Drives organizational success by optimizing development life cycles, improving data integration, and elevating team performance.

Data Integration ǀ Data Warehousing & Architecture ǀ Business Intelligence Informatica PowerCenter SQL Server ǀ SDLC

Project Management: Led ETL Development teams in multiple projects both on and off site. Responsible for ETL architecture, development and administration.

Application administration: Led Informatica PowerCenter and IDQ upgrade with zero downtime at Cancer Treatment Centers of America by creating migration plan, pre and post validation checklists.

SDLC Process Improvement: Eliminated all production bugs for 99% of releases and improved release management of code by introducing a peer review process at Cancer Treatment Centers of America.

Enterprise Data Management: Removed data availability bottlenecks and improved data staging process through ETL architectural changes.

Informatica PowerCenter, IDQ, EDC,

SQL, PL/SQL, SSIS

Batch scripting, Python, AWS

Data Modeling, Embarcadero

Tableau, OBIEE, Business Objects

Salesforce data Integration

Development Best Practices

Job Scheduler (TIDAL, Unix Scripts)

Offshore Team Management

Professional Experience

Sr. ETL Lead Developer/Administrator, Cancer Treatment Centers of America 06/2015 – Present

Led developers in Data Services team, including offshore team; for Operational Data Storage, Data lake and Data mart projects. Ensured scalable development by reviewing ETL architecture for development and using reusable design approaches. Administered Informatica PowerCenter and related products; oversaw daily ETL operations management. Achieved strategic alignment in collaboration with business analysts, dashboard developers, and data modelers on data discovery, requirement analysis, and data and design needs. Trained new hires on development standards.

Saved ~$90K and improved data quality needs by researching, suggesting, and negotiating for a limited, accelerated Informatica Data Quality package that provided real-time data verification. Provided training to team on new tool set.

Increased development team efficiency by standardizing the development cycle and improving requirements gathering in collaboration with business analysts; implemented ETL code standards and design specification documents, peer review process and migration checklist.

Successfully delivered Operational Data Storage project (Agile) with zero SLA breaches; coordinated with 8 developers.

Implemented DBAmp tool to replicate data from Salesforce to staging database.

Oversaw Data Lake project to map data from multiple sources including SQL Server, Oracle, Salesforce, flat files. Established, provided training and ensured compliance to SLAs for all data in Datalake for use by downstream applications.

Met project deadlines and goals by leading two-week Sprints and daily Scrum meetings. Recommended software and tools, including enterprise data catalog. Improved team efficiency by assigning developer tasks based on individual strengths.

Prevented object naming conflicts during development phases by implementing shortcuts for source and targets, versioning option and creating Informatica development naming standards.

Created run books and part of on-call team for production release, support and maintenance.

Led Informatica PowerCenter and IDQ upgrade project and responsible for administration of the product.

Lead ETL Developer, EDMC 12/2010 – 06/2015

Led developers at EDMC; coordinated development and led administration for 2 enterprise projects; used Waterfall strategies. Finished high-level architecture of ETL jobs for new development; facilitated easy code migration and scaling for more campuses. Standardized data; improved workflows and increased execution speed by identifying and resolving delays. Designed required staging and cross reference tables for ETL development by collaborating with data analysts.

Ensured timely project completion and optimized Informatica workflow performance by suggesting use of IDQ mappings and persistent cache use, improvements in folder structure and re-usable objects, updated naming standards, and revised documentation.

Improved data availability SLAs by speeding up issue resolution; provided faster data access. Fine-tuned data collection for hybrid models by collecting complete requirements and collaborating with business analysts.

Eliminated inter-job delays by replacing PowerCenter’s scheduler with TIDAL’s to cater to workflow dependencies. Inspired other application teams within the organization to shift to TIDAL.

Boosted data and lead quality by guiding data improvements.

Technical Lead, Perficient/University of Phoenix 05/2010 – 12/2010

Coordinated development with the global delivery center, business analysts, and business users as lead ETL developer; led daily Scrum meetings with offshore teams; oversaw delivery of requirements. Supported production release cycles for several projects. Monitored daily development progress. Standardized development efforts and delivery models.

Improved offshore team coordination by clearly conveying scope, business requirements, and changes in the data flow. Assisted developers with ETL design and architecture.

Completed development on time and effectively managed project scope by going beyond requirements; ensured team members had a complete understanding of environmental and business requirements during the design process.

Lead Developer, AAA 11/2008 – 05/2010

Prepared complex Informatica mapping documents and workflows with mapping designer and workflow manager. Reviewed deployment schedule, migration, and testing for PowerCenter upgrade (8.1.1 to 8.6.1). Worked on project for XML files integration; performed requirements analysis, captured and processed XML files, made data presentable. Collaborated with DBA team to optimize query performance in Informatica workflows.

Received performance-based contract extension from 3 months to 1.5 years. Led and assigned tasks to 2 developers after reviewing ETL design for project delivery. Rapidly adapted to new tools. Used Power Exchange for AS400 as a data source.

Ensured adherence to SLAs, improved performance of time-consuming mappings, and resolved real-time issues by placing limitations on the amount of data processed and improving mapping filter conditions.

Identified and led improvements in SQL query, session performance, and reliability at a database level with the database administration team. Improved inter-table data integrity and eliminated data duplicity by using integration testing.

Lead Developer, HP 03/2007 – 11/2008

Updated naming standards and technical documentation as Informatica administrator. Oversaw daily ETL progress and data cleansing for revenue-sharing reports of large data. Processed customer data while creating a custom service solution. Created a sales management reporting database after analyzing reporting requirements.

Improved performance by ~40% by creating partitions for concurrent data loading; managed increase in the data quantity. Scheduled routine tasks for the design and maintenance of warehouse metadata and target schema design, star schema.

Identified data quality requirements to determine data cleansing rules for enterprise data.

Lead Developer/Informatica Administrator, IBM/GM 05/2006 – 03/2007

Supervised 15 onsite and offsite developers; prevented scheduling conflicts and eased code migration to production. Improved performance by creating pre- and post-SQL functionality to create/drop indexes. Acted as Informatica administrator. Addressed production issues with steady state team to meet SLA on data requirements.

Enhanced performance of 10-member offsite team by training developers on new tools. Created schedules and accountability for work.

Improved daily scheduling and coordination of Informatica workflows through Siebel DAC tool.

Senior Developer, Amerigroup Corporation 01/2006 – 05/2006

Worked extensively with XML files and created complex mappings according to business requirements with mapping designer. Validated XML files by creating schema files from Java serial file model. Consolidated, cleansed, integrated, and customized data. Collaborated with end-users for user requirements and analysis.

Provided information for strategic business decision-making by exporting data from SQL Server 2000 to flat and Excel files.

Ensured ETL development adheres to naming and code standards.

Developer/Administrator, Cingular Wireless 08/2005 – 12/2005

Assisted in post-merger data integration of two large organizations. Built design-specific mapping documentation with business analysts; enabled data migration onto a common system and maintained data integrity by introducing data source ID. Developed new procedures to meet data integration needs.

Ensured ETL development adheres to naming and code standards.

Responsible for creating and updating users, user groups, folders and permissions for multiple project teams.

Developer, Ohio Savings Bank 01/2004 – 08/2005

Consolidated all data into the warehouse. Developed and documented process for upgrade from Informatica version 5.1. to 7.1.2. Improved end-user response time by enabling access to data marts for specific types of data. ETL development using Mapping Designer, Workflow manager. Created mapping documents and production support documents.

SQL/Informatica Developer, Manulife Financials 10/2004 – 01/2005

Met business requirements by creating Informatica mappings with various transformations. Executed Informatica Workflow Manager tasks (sessions, email notifications, and scheduling); maintained warehouse metadata, naming standards, and warehouse standards.

Education / Certifications

PowerCenter Cloud Hybrid Certification, Informatica 2017

Master of Science, Engineering, University of Alabama 2004

Bachelor of Engineering, University of Madras 2001

Technical Skills

Data Warehousing: Informatica Power Center 10.2.0/9.5.1/8.6.1, Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor, Informatica Data Quality, OLAP, OLTP, SQL Plus, Informatica Power Analyzer, Power Exchange, Informatica Analyst, Informatica Metadata Manager.

Databases: Oracle 11g/10g/9i/8i/7i, Teradata V2R5/V2R4, DB2 8.0/7.0, PL, SQL Server 2019, 2016, 2014, MS Access 2000/97/7.0.

Job Scheduling: Tidal, Siebel DAC.

Data Modelling: Erwin, Embarcadero ER/Studio.

Business Intelligence: Tableau, OBIEE, Business Objects

Bash, Python, Windows Batch scripting, AWS.

Contact this candidate