Manager Data

Location:

Atlanta, GA

Posted:

November 07, 2019

Contact this candidate

Resume:

Amit Sathvara

Data Architect

Employer: ******@********.***// 609-***-****

SUMMARY:

13+ years of experience in designing, developing and maintaining large business applications such as data migration, integration, conversion, data warehouse and testing which includes 2+ years of experience in Hadoop, Big data ecosystem, AWS web services related technologies.

Experience includes thorough domain knowledge of Business Financial system, Banking, Animal healthcare information technology, Insurance & Reinsure, Pharmacy claims systems, Telecom Industry.

Professional understanding of Software Development Life Cycle (SDLC).

Expertise in data warehousing, ETL architecture, Data Profiling using Informatica Power center 9.6/9.5/9.1/8.6/8.5/8.1/7.1 – Client and Server tools.

Used Informatica Metadata Manager and Metadata Exchange exhaustively to maintain and document metadata.

Through knowledge of Relational & Dimensional models (Star & Snow Flake), Facts and Dimension tables, Slowly Changing Dimensions (SCD)

Hands on experience in implementing Slowly Changing dimension types (I, II &III) methodologies

Experience in integration of various data sources like SQL Server, Oracle, TeraData, Vertica, Netezza, Flat files, NoSQL, DB2 Mainframes into the staging area

Business Requirements review, assessment, gap identification, defining business process, deliver project roadmap including documentation, initial source data definition, mapping, detailed ETL development specifications and operations documentation

Expert in Installation and configuration of Informatica server with Sql server, Oracle and able to handle the Informatica administrator tasks like Configuring DSN, creating Connection Strings, copying & moving mappings, workflows, creating folders etc,.

Experience in complex PL/SQL packages, functions, cursors, triggers, views, materialized views, T-SQL, DTS, and SSIS.

Expert in troubleshooting/debugging and improving performance at different stages like database, workflows, mapping. Experience in writing UNIX shell scripts and Perl scripts

Hands on experience in application development using RDBMS, and Linux shell scripting.

Excellent understanding / knowledge of Hadoop architecture and various components such as HDFS, Job Tracker, Task Tracker, Name Node, Data Node, Resource Manager, Node Manager and Map Reduce programming paradigm.

Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems and vice-versa. Have Got Proven experience leading Team.

Enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability.

EDUCATION:

B.S in Computer Science

MS in Technology Management

TECHNICAL SKILLS:

Data warehousing

Informatica Power Center 9.6/9.5/9.1/ 8.6/8.5/8.1/7.1, Informatica Power Connect for Siebel/SAP/PeopleSoft, Metadata Reporter Data Profiling, Data cleansing, OLAP, OLTP, Star & Snowflake Schema, FACT & Dimension Tables, Physical & Logical Data Modeling, Data Stage 7.x, Erwin 4.0, ER Studio, Dial, SSIS,AWS EMR, AWS Glue

BI Tools

Business Objects XIR2/6.0/5.1/5.0, Cognos, QlickView, Yotta, Tableau

Databases

SQL Server, Oracle 11 g/10g/9i/8i/8/7.3, Sybase, TeraData 6,My SQL, MS-Access, DB2 8.0/7.0, SeaQuest, Vertica, Netezza, Hive (NoSQL)

Languages

XML, SQL, T-SQL, PL/SQL, UNIX Shell Scripting

Operating System

HP-UX11/10/9,IBM-AIX4.0/3.1, Sun Solaris 9/8/7/2.6/2.5, SCO-UNIX, LINUX, Windows XP Professional/2000/NT/98/95

Other Tools

Autosys, Control M, Remedy, Mercury Quality center, Star Team, Lotus Notes, Tidal,Cloud Watch, Lambda

DB Programming & Tools:

RDBMS, Joins, Indexes, Views, Functions, Triggers, Clusters, Procedures, SQL*Plus, SQL*Loader, Export/Import, TOAD, SQL Navigator, Explain plan, SQL Trace, DB Visualizer, Athena

PROFESSIONAL EXPERIENCE:

Cox Communications, GA Sep’18-Present

Data Architect

Description: Cox provides high speed Internet, streaming TV - both live and on-demand, home telephone, and smart home security solutions for its residential customers. The primary objective of the project was to data analysis, create reports of the new launch products.

Responsibilities:

Worked on Amazon Web Services like EC2,EMR,AWS Glue,S3,IAM,Athena,Lambda,Cloud Search,Cloud Watch,Auto Scaling, Elastic Load Balance, AMIs,Amazon RDS DB services.

Good experience on Log Analysis, Maintaining documents of production server error log’s reports.

Automate multiple ETL jobs using AWS Step Functions and AWS Lambda.

Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments.

Established a process of preparing a daily report that provided Cox products customer acquisition, customer transactions like support calls and truck-rolls, and machine learnings on system performance

Automated the above report using Tableau dashboards

Assisted business owners of Video product, Panoramic Wi-Fi, and Device Management in identifying operational issues on system performance and discrepancies on order entry and work orders

Performed ad-hoc data analysis on processes that impacted customer acquisition, activation and provisioning of accounts and devices, discrepancies with account setup, and customer support issues

Performed analysis of variances in actuals vs. forecast for customers getting Video product, Panoramic Wi-Fi, and Contour Streaming Player (Set Top Box)

Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports using flatfiles, relational database, hive and Splunk data.

Created Ad-hoc report using Microsoft office ( Excel, PowerPoint)

Analysis real time data of specific programs and provided audience measurement ad-hoc report.

Environment: AWS EMR, Cloud Watch, AWS Glue, Athena, RDS,IAM, EC2, Lambda,Oracle 11g, Splunk, Hadoop, Hive, Tableau, Microsoft office

Beacon Health Options, GA Jan’18-Aug’18

ETL Lead

Description: Beacon provides administrative services in support of Georgia’s Department of Behavioral Health and Developmental Disabilities (DBHDD). The primary objective of the project was to migrate future state and legacy data to the Beacon System.

Responsibilities:

Manage end-to-end complex data migration, conversion and data modeling

Participate in quality management reviews as outlined in the Verification and Validation Overview

Ensure security in reporting and data warehousing

Delivering innovative BI & Data warehouse solutions

Worked on Data Profiling, data analysis and mismatch analysis

Support deployment of solution, cut over planning and execution activities

Expert in SQL, PLSQL and PLSQL Tuning

Define the migration strategy and plan

Environment: SQL server 2008 R, MySQL, IDSS (Infosys In home ETL Tool)

Merial, GA Aug’16-Dec’17

Sr. Informatica Developer

Description: Merial is the Animal Health subsidiary of Boehringer Ingelheim. The primary objective of the project was to construct an aggregated data warehouse (DWH) for analytics and reports used by business, risk management, asset management groups.

Responsibilities:

Worked with the business and data analysts in requirements gathering and to translate business requirements into technical specifications.

Created number of complex Mappings, Mapplets, Reusable Transformations, Workflows, Worklets, Sessions using Informatica Power center 9.0.1 to implement the business logic and to load the data incrementally.

Extracted the data from the Flat files, CSV file, Oracle databases into staging area and populated onto Data warehouse.

Used Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process. Used Debugger to test the mappings and fixed the bugs.

Worked on Performance tuning at source, target, mappings, sessions, and system levels.

Migrated ETL objects from DEV to UAT to PRD environments using Repository Manager.

Worked on the UNIX scripts for running the workflows and threshold check for the incoming files.

Prepared ETL Design-Document and Implementation Plan documents.

Involved in Unit Testing and created various test cases and reviewed and fixed issues in the ETL code.

Supported UAT and resolved issues. Also, worked on CR’s (change request) by the business.

Prepared Support Turnover documents in Production Support, for some interfaces.

Environment: Informatica Power center 9.5, Oracle 11g, SQL Server, Sun Solaris UNIX Shell Scripts, Tidal, and Remedy.

AT&T, GA Jan’16-Jun’16

Sr. ETL Developer/ Data Modeler

AT&T is an American multinational telecommunications corporation provides both of mobile telephony and of fixed telephony in the United States, and also provides broadband subscription television services. Southeast Construction and Engineering (SECE) PMO Reports aim is to keep projects on schedule, maintain effective communication across project teams, manage quality assurance, and deliver on budget in South East region. It improves client satisfaction with timely and actionable field reports; transmit field reports from the project site, without the need to re-type notes; reduce inspector overtime expenses; improves the quality of information captured in field reports and punch lists; reduces time to compile daily, weekly, and monthly reports, manages change order requests proactively.

Responsibilities:

Created prototype reporting models, specifications, diagrams and charts to provide direction to system programmers.

Involved in Architecture and design of Data extraction, transformation, cleaning and loading.

Involved in Requirement gathering and source data analysis for the Data warehousing projects.

Involved in the Logical and Physical design and creation of the ODS and data marts.

Involved in Analysis & Marketing Team to make business decisions

Prepared Technical documents for all the modules developed by our team.

Interacting extensively with end users on requirement gathering, analysis and documentation

Documented methodology, data reports and model results and communicated with the Project Team / Manager to share the knowledge

Imported Data from relational database into SAS files per detailed specifications

Carried out data extraction and data manipulation using PROC SQL, PROC SORT, PROC REPORT to create preferred customer list as per business requirements

Developing T-SQL queries, triggers, functions, cursors and stored procedures

Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008 R.

Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications

Created views to restrict access to data in a table for security.

Created datasets in T-SQL, stored procedures for SAS Reports

Experience in performance tuning and optimization of queries and stored procedures.

Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Environment: SQL server 2008 R, T-SQL, SSIS, SSRS, Windows Server 2008R, SAS BI Dashboard, Visio

Hewlett-Packard, GA Mar’13-Nov’15

Sr. ETL Developer / Lead

The client is implementing enhancements into the existing Enterprise Data Warehouse.

New cubes that are added will enable the client to identify loyal customers and serve them better. It will also help them to analyze and implement strategies to expand their customer base and provide better deals to the existing ones. The data will also be funneled to various calculation engines and data-marts needed for internal reporting.

Responsibilities:

Experience in Data Warehouse/Data Mart design, System analysis, Database design, ETL design and development, SQL, PL/SQL programming.

Created mapping between the databases and identified the possibilities of incorporating the new business rules with the existing design.

Created prototype reporting models, specifications, diagrams and charts to provide direction to system programmers.

Prepared High level design (HLD), LLD, Project functional Specification Document and Business Requirement documentation (BRD).

Participated in Design team brainstorm and user requirement gathering meetings.

Played the lead role in Designing and implementing Pricing Analytics, Best Customer and Finance Master Data Alignment Services Data marts.

Experience in managing the delivery of data extracts from the data sources to the warehouse and downstream applications.

Experience in requirement gathering and database design and implementation of star-schema, snowflake schema/dimensional data warehouse using Erwin.

Played the role of a Data warehouse architect in the Business Intelligence Enterprise Architect group for providing data architectural strategies.

Experience in Architecture and design of Data extraction, transformation, cleaning and loading.

Involved in Requirement gathering and source data analysis for the Data warehousing projects.

Involved in the Logical and Physical design and creation of the ODS and data marts.

Converted the Business rules into Technical Specifications for ETL process.

Involved in all phases of SDLC from requirement, design, development, testing, pilot, training and rollout to the field users and support for production environment.

Implemented mapping techniques for Type 1, Type 2 and Type 3 slowly changing dimensions.

Developed ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center.

Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.

Worked on Informatica Power center 9.5/9.6 Tool – Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, Worklets and Reusable Transformation.

Wrote scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance for data access.

The design document was finalized through conduct of design walkthroughs, and independent review by the user. Prepared Technical Specifications for all the utilities, as per the company's standards.

Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the Informatica mappings.

Designed and developed Hadoop system to analyze the SIEM (Security Information and Event Management) data using MapReduce, VSQL, and Sqoop

Migrated data from SQL Server, Sea Quest (HP internal Database) to HBase using Sqoop.

Configured various big data workflows to run on top of Hadoop and these workflows comprise of heterogeneous jobs like VSQL, Sqoop and MapReduce.

Ability to adapt to evolving technology, strong sense of responsibility and accomplishment.

Prepared Technical documents for all the modules developed by our team.

Environment: Erwin, Informatica Power Center, Metadata Manager, SQL server 2008, SeaQuest Database (HP Internal DB), Dial (HP Internal ETL Tool), Yotta (HP Internal Reporting tool), Hadoop, Vertica, VSQL, Sqoop, MapReduce

Time Warner Inc., Manhattan, NY Oct’12-Mar’13

Sr. Informatica Developer

Description: Time Warner Inc., a global leader in media and entertainment with businesses in television networks, film and TV entertainment and publishing, uses its industry-leading operating scale and brands to create, package and deliver high-quality content worldwide through multiple distribution outlets. The primary objective of the project was to read the data from Netezza and generate and send the XML file to Kenexa 2xBrassRing by invoking web services.

Responsibilities:

Worked with the business and data analysts in requirements gathering and to translate business requirements into technical specifications.

Understand and discuss the ETL requirements with the Business Unit and preparing the detail design documentation according to the standards.

All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica power center designer and workflow manager. Ver. 9.1

Used the transformations like Expression, Lookup, Source Qualifier, Transaction Control, XML Generator, Web Service, XML Parser, Joiner, etc.

Extracted the high volume dataset from the XML, Netezza Relational Tables and xml targets.

Used Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process.

Use debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations and Create Mapplets that provides reusability in mappings.

Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.

Monitor and troubleshoot batches and sessions for weekly and Monthly extracts from various data sources across all platforms to the target database.

Data Validation has been done for various sources to target mappings.

Migrated ETL objects from DEV to UAT to PRD environments using Repository Manager.

Provided support and quality validation thru test cases for all stages Unit and Integration testing.

Prepared ETL Design-Document and Implementation Plan documents.

Involved in Unit Testing and created various test cases and reviewed and fixed issues in the ETL code.

Environment: Informatica Power Center 9.1, SQL Server, Oracle 9i, Netezza, Remedy.

Credit Suisse, Raleigh, NC Feb’11-Aug’12

Informatica Developer

Description: Credit Suisse Asset Management division is one of the largest publicly traded global asset management firms in the world. The primary objective of the project was to construct an aggregated data warehouse (DWH) for analytics and reports used by business, risk management, asset management groups.

Responsibilities:

Worked with the business and data analysts in requirements gathering and to translate business requirements into technical specifications.

Created number of complex Mappings, Mapplets, Reusable Transformations, Workflows, Worklets, Sessions using Informatica Power center 9/8.6.1 to implement the business logic and to load the data incrementally.