Candidates About

 

Kavitha Paranthaman

     Data Specialist

PROFESSIONAL SUMMARY

Highly effective Leader/Architect with over 12 years of experience specializing in working with Big Data, Cloud, Data, ETL and Analytics platforms.

Offering an array of skills in data platforms, consulting, trend monitoring, IT expertise, data governance, defining data requirements and analytics.

Recognized as a thought leader with expert ability to successfully implement end-to-end architecture and design for big data, cloud, test data management, data warehouse and business intelligence.

 

 

TECHNICAL PROFICIENCIES

Database Modeling and Design	ERWin,  Rational
Data Analysis Tools	Hive, Pig and Hadoop Streaming, MapReduce
Data Transformation	Informatica Powercenter/Data Quality/Power Exchange, DataStage, BusinessObjects, Cognos, Warehouse Builder, Talend,Pentaho,Syncsort
Databases and Tools	MySQL, MS SQL Server, Oracle,PostgresSQL,DB2, NoSQL: HBase, SAP HANA, HDFS, Cassandra, MongoDB, Couchbase db, Vertica, Greenplum, Pentaho and Teradata
Data Collection	APIs and SDKs, RESTful Interfaces
Application Development	PL/SQL, SQL*PLUS
Operating Systems	Windows, UNIX
Cloud	AmazonWebServices,MS Azure, Salesforce
Test Data Management	Informatica ILM and IDQ

 

 

RELEVANT EXPERIENCE

Employer: Ciber Global

Client: Hilton Worldwide                                                                                           June 2014 - Till date

 

Hilton Worldwide is a leading global hospitality company, spanning the lodging sector from luxury and full-service hotels and resorts to extended-stay suites and focused-service hotels. The company’s portfolio includes twelve world-class global brands and an award-winning customer loyalty program, Hilton HHonors.

 

Was part of multiple on-going Projects, Proof of Concepts and Statements of Work (SOW) for Hilton Worldwide. Multiple Projects include Test Data Management, Data Validation for Big data using Hadoop, Spark and HIVE, Tableau/SSRS/Qlik view Reporting, Data Migration from SQLServer to Couchbase/NoSQL on AWS cloud and other AWS Cloud migration efforts.

 

Role – Data Integration Specialist

 

Key Responsibilities:

• Coding, Architecting and Delivering complex projects.
• Understanding and application of modern data processing technology stacks like Spark, Hadoop ecosystem technologies, and others.
• Usage of streaming data architectures and technologies for real-time and low-latency data processing.
• Usage of NoSQL technologies including column family, graph, document, and key-value data storage technologies.
• Understanding of the theory and application of Cloud methodologies (IaaS, PaaS, SaaS), automation, orchestration, cost frameworks, trends and industry-leading private/public/hybrid cloud vendor offerings and interoperability.
• Experience with Amazon Services such as AWS, S3, Elasic load balancing / Block / Relational Database.
• Experience architecting automated data center processes, including provisioning, application and patch management, monitoring and alerting, capacity monitoring and planning, leveraging execution and human approval workflow design and implementation.
• Experience with Business Continuity and Disaster Recover design, planning and implementation for virtualized infrastructures.
• Experience managing and working with configuration management tools (Chef, Ansible).
• Experience in Agile development practices (Kanban & Scrum).
• Understanding of the theory and application of Continuous Integration/Delivery.
• Evaluate and enhance existing data infrastructure in coordination with business initiatives.
• Design fully attributed data models optimized for applications support.
• Design and review database schemas leveraging inherent DBMS capabilities to ensure data integrity, quality and consistency across the enterprise. Conduct data quality initiatives to rid systems of old, unused, or duplicate data (profiling, auditing, cleansing) and database performance tuning. 
• Present recommendations for the selection and implementation of the appropriate tools, software, applications, and systems to support data technology initiatives.
• Translate business needs into long-term information architecture solutions.
• Evaluate effects of regulatory guidelines (such as privacy requirements), compliance-related guidance (such as data retention) and emerging industry standards to determine their impacts on the Enterprise.
• Application of Test Data Management concepts including data growth and data masking. Developed blueprint for data virtualization, data governance, objectives and activities for Center of Excellence (COE).

 

 

 

Employer: Ciber Global

Client: HMS Holdings, Irving TX                                                                              Sept 2012 - May2014                                                Sept 2012 – May 2014

 

Enterprise Claims project’s initiative is to provide a comprehensive repository of all claim assets in one location, with consistent structure, validation, load standards and access mechanisms. As such, Enterprise Claims is “another copy” of each application’s claims data but in a single standardized format for ease of access and sharing across different products and downstream applications. A Claims Data Mart on Teradata for the whole Enterprise is to be designed and developed for extensive Data Analytics.

 

Role - Data Warehouse Lead /Architect

 

Key Responsibilities:

 

·         Design, implementation and support the Claims Data Mart.

·         Implement business rules via stored procedures, middleware, Teradata BTEQ and Informatica PowerCenter mappings with Fload,Mload and Tpump functionality.

·         Define user interfaces and functional specifications.

·         Responsible for verifying accuracy of data through data validation techniques and tools.

·         Responsible for maintenance and support of the data mart.

·         Responsible for data warehouse end-to-end implementation processes, from business requirement logical modeling, physical database design, ETL, end-user tools, database, SQL, performance tuning.

·         Demonstrate problem resolution skills.

·         Experience in data warehouse design and data modeling (both relational and dimensional) and development and maintenance of multi-dimensional data models.

·         Application of data warehouse Metadata concepts, tools and different data warehouse methodologies.

·         Expertise in SQL and proficiency in database tuning techniques.

·         Responsible for the ongoing architecture and design of the data warehouse, data mart, and reporting environments.

·         Develop strategies for flexibility and scalability, and played a major role in defining the future technical architecture direction for the business intelligence reporting physical environment.

·         Responsible for proper selection of appropriate hardware, software, tools and system lifecycle techniques for the different components of the end-to-end data warehouse architecture including ETL, metadata, data profiling software, database platform, performance monitoring, reporting and analytic tools.

·         Define and documented the technical architecture of the data warehouse, including the physical components and their functionality.

·         Responsible for setting and enforcing standards and overall architecture for data warehouse systems.

·         Educate project teams on the standards and architecture of each component of the data warehouse architecture.

 

 

 

Employer: IGATE Corporation

Client: State Farm Insurance, IL                                                                              Sept 2011 - Sept2012

 

State Farm Insurance is a group of insurance and financial services companies in the United States. The company also has operations in Canada. The group's main business is State Farm Mutual Automobile Insurance Company, a mutual insurance firm that also owns the other State Farm companies. The corporate headquarters are in Bloomington, Illinois. State Farm is ranked 37th in the 2011 Fortune 500, which lists American companies by revenue. According to the Fortune Global 500, State Farm is also the world's largest mutual "P&C" (property & casualty insurance) firm.

 

Role - Data Integration Specialist/ ETL Lead

 

Key Responsibilities:

• Proposed enhancements and changes to the technical and business solution to meet the new requirements.

·         Engaged with external vendors to develop a new Highly Available Open systems platform for the customer to support new applications (Master) and  move data from the existing platforms(read-only) into the HA environment.

·         Conducted Proof of Concept/ Technology to produce Architectural Design Documents (ADDs).

·         Assisted Project Business Analysts by providing key Design & Data mapping inputs for documenting the FSD. Involved in QA Test plan & Test case review meetings. Worked with Release Management team in migrating the components to QA environment for QA testing. Provided necessary technical assistance in fixing the QA defects.

·         Designed patterns for Data movement and Transformation.

·         Designed the patterns for Data Replication and Data Synchronization of Master and Slave (read –only type) data.

·         Lead the effort to implement Cloud functionality (Sales force) using Informatica Power Center for data movement and transformation (read and write) data to cloud from DB2 and PostgreSQL.

·         Drove an effort on Web Service interaction with Informatica Power Center 9.1 using a WSDL and SOAP UI client.

·         Created data maps for Change Data Capture (CDC) for db2 capability using Informatica Power Exchange 8.6 and DB2 log tables.

·         Lead an effort for Extract, Transformation and Load of XMLs.

·         Used Performance tools to Measure /Monitor Performance of the ETL jobs and loader utilities (EDB loader).

·         Automated scripts for Enterprise Database Loader (similar to Oracle’s PL/SQL).

·         Provided requirements to the team and helped them in design, coding and integration testing.

·         Responsible to oversee daily team activities including hands-on debugging, backtracking and problem solving of critical errors.

·         Provided guidance on coding standards.

 

 

 

Employer: Satyam Computers                                                              Feb 2008 – Feb 2009

Employer: IGATE Corporation                                                              Feb 2009 – Jun 2012

Client: State Farm Insurance, IL                                                      

                                                                                         

The “Enterprise Claims System (ECS)” is a massive data conversion/migration project for State farm Insurance. The goal of the project is to migrate all of State Farm Insurance’s Claims System functionality from the existing legacy HP9000 platform to db2 database with a new front end built using J2EE.

 

Role - Software Specialist/Tech Lead

 

Key Responsibilities:

·         Analyzed the specifications provided by client.

·         Designed Data Extraction, Transformation and Load scripts Informatica and UNIX scripts.

·         Developed Business Objects (BO) Data model and Reports.

·         Provided Support for Project pilot and rollouts.

·         Responsible for overseeing the Quality procedures related to the project.

·         Assigned day to day tasks to the offshore team and reviewed the end product.

·         Provided support for Integration testing.

·         Designed and developed exception handling, audit balance control and data cleansing as well as standardization procedures.

·         Optimized ETL performance tuning Informatica mappings for large data files by increasing block size, data cache size, sequence buffer length, push down optimization and bulk loading options .

·         Implemented partitioning to improve Session performance. Developed Syncsort scripts to sort/merge data outside the mappings for better performance.

·         Identified and managed data quality issues.

·         Defined a suitable architecture for data integration from multiple, disparate data sources.

·         Tested, validated and implemented conversion components – with SFI’s active participation.

·         Created re-usable code such as Mapplets and Transformations.

·         Used transformations such as Lookup, Aggregator, Transaction Control, Expression, Source qualifier, Application Source Qualifier, Router, Sorter, Joiner, Update Strategy, Normalizer, SQL, Stored procedure.

·         Used Scheduler tool- Control M to execute jobs based on Job Flows.

·         Created database objects like Indexes, Views, and Sequences.

·         Automated load run on Informatica sessions through UNIX corn, PL/SQL scripts and implemented pre and post-session scripts, also automated code execution and logging for metadata gathering.

 

 

 

Employer: Satyam Computers India

Client: WellPoint healthcare networks, MO                                                          March 2006 - Dec 2008

 

WellPoint is a merger between WellPoint Health Networks USA and Anthem pharmacy. WellPoint is currently the nation’s second largest leading health care insurers and a Fortune 500 company. The goal of the Enterprise Data Warehouse (EDW) program is to create a single, authoritative source of operational and analytical reporting for all of WellPoint. The project follows the onsite-offshore model.

 

Role – ETL Developer

 

Key Responsibilities:

• Developed logic and transformation as per the requirement and created mapping documents, developing Informatica mappings and loading data into Target databases.
• Analyzed and created Facts, Dimension tables. Modeled the data warehousing data marts in Star join schema.

• Created Stored Procedures, Triggers and Cursors for data transformation purpose.
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations for the Product Line Profitability Systems to facilitate Daily, Monthly and Yearly Loading of Data.
• Created worklets to run several sessions sequentially and concurrently.

• Monitored the Production loads: In case of failures in test environment, as a first on call, immediate fix to the problem was done. Collaborated with the Implementation team to fix production issues.

 

 

 

Employer: Satyam Computers India

Client: SAMS Motors, TN                                                                                   Aug 2005 - Feb 2006

 

SAM’s motors are involved in sales & service of Honda cars & bikes. Customers and sales & service data is extracted daily from disparate source systems that include MS-SQL Server and flat files source systems. Extracted data is populated into an intermediate staging that is modeled on star-schema. Then data from staging is extracted, cleansed and populated into a target SAAS data mart that is modeled based on star schema. A reporting layer is built on top of SAAS data mart to produce automated sales & service analysis, fore casting and customer reports on a daily basis. Reports are developed using OLAP tool.

 

Role – ETL Developer

 

Key Responsibilities:

·         Performed data cleansing & transformation.

·         Supported user acceptance testing.

• Performed data analysis of the source data coming from point of sales systems (POS) and legacy systems.
• Developed mappings using Informatica 7.X designer to extract data from the source databases and flat files into oracle staging area.
• Developed transformation logic to cleanse the source data of inconsistencies during the source to stage loading.
• Developed re-usable transformations, mappings and mapplets confirming to the business rules
• Extensively used PL/SQL programming in procedures to implement business rules.
• Involved in monitoring the workflows and in optimizing the load times.
• Extensively used Informatica debugger to validate mappings and to gain troubleshooting information about data and error conditions.

 

 

CERTIFICATIONS & TRAINING

·         AWS Well-Architected Training

·         AWS Solutions Architect Training

·         Couchbase NoSQL Training

·         Informatica 8 Certified Developer

·         Informatica 8 Certified Admin

·         Teradata certified Professional

 

EDUCATION:

§  Masters in Computer Application 2005, Osmania University.