Data Manager
Resume:
Vijayakumar Arumugam
***************@*****.***
Deerfield Beach, FL
–Sponsorship Required. (H1B Visa)
Summary
●An accomplished IT Professional with 14+ Years of Overall IT Experience out of which 10 years IT Experience in USA with MS SQL Server versions 2016/2014/2012/2008R2/2008/2005/2000/7.0 using SSIS, SSAS, SSRS HealthCare and Insurance domains.
●Effective in gathering Business Requirements from business stakeholders, analyzing documenting System Requirement specification, Functional Requirement specifications and maintaining requirements.
●Expert in Data Extraction, Transforming and Loading data (ETL) using various tools such as SQL Server Integration Services (SSIS), Informatica Power Center 9.x and DTS.
●Experience in Data Integration with various data sources like Teradata, Oracle, DB2, SQL server and non-relational sources like flat files (CSV, XML) into DW staging area.
●Developed Custom Logging so user can know when a row is inserted in custom logging Table by every SSIS package that executes.
●Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports, and parameterized Reports, drill down reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
●Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, temporary tables, table variables and common table expressions (CTE), Relational database models, data integrity, SQL joins and query writing, Views, Indexes, Performance Tuning, Query Optimization and Validation issues.
●Experience in Repository Configuration/using Transformations, creating Informatica Mappings, Mapplets, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.
●Experience in Cognos 8.4, with Report Studio, Framework Manager, Query Studio, Analysis Studio.
●Extensive experience in Framework Manager, Query Studio and Report Studio for model design, ad-hoc reporting and advanced report authoring.
●Hands on Experience on Data warehouse concepts Normalization and Demoralization.
●Strong understanding of Dimensional Modelling of Star Schemas, Snow-Flake Schemas Methodologies for building enterprise data warehouses.
●Experience in scheduling toll like Control M, Tidal.
●Good understanding of Healthcare Domain Facets Data model and Data Dictionary and familiar on HIPAA and PHI Federal regulations. Strong analytical and problem-solving skills coupled with excellent documentation, verbal and inter-personnel communication skills and ability to acquaint to fast changing skills.
●Team player and self-starter with excellent communication skills, ability to work independently or as a part of team and capable of picking up new skills quickly.
Certifications
●Microsoft SQL Server 2005 Business Intelligence - Implementation and Maintenance (MS-BI)
●IBM Cognos 8 BI Author Certification
●IBM Cognos 8 BI Metadata Model Developer Certification
●Informatica Power Center 8 Mapping Design Certification
Education
●Master’s Degree in Computer Science, Tamil Nadu, India.
●Bachelor’s Degree in Computer Science, Tamil Nadu, India.
●Bachelor of Mechanical Engineering, Tamil Nadu, India.
Technical competencies:
ETL Tools: DTS, SQL Server Data Tools, SQL Server Integration Services (SSIS), Informatica Power Center 9.x ((Designer, workflow manager, Monitor and Repository manager) and Teradata BTEQ.
BI Tools: SQL 2012 Reporting Service (SSRS), Cognos Report Studio 8.4, Crystal Reports.
Data Analysis: SSAS
Data Modelling: MS Visio, ERWIN
Versioning: TFS
Scheduling Tools: TIDAL, Control M
Other Tools: JIRA, Confluence
Database Tools: Oracle Toad, Toad Data Point 3.6, SQL Developer, MS Management Studio, Teradata SQL Assistant
Database: MS SQL Server 2014, Oracle, DB2 (Toad Data Point 3.6)
Professional Experience:
Client: HUMANA Inc - Deerfield Beach, FL May 2019 - Present
Role: Tech Lead / Sr. ETL MSBI Developer
Project: YHA (Your Home Advantage)
Role & Responsibilities:
●Responsible for understanding, analyzing the Requirement, interacting with Business stakeholders for Requirements gathering and clarification, translating Business Requirements into Technical Requirements.
●Designing Data Model and implementing changes in the earlier phase of the project to accommodate business logic.
●Worked on High Level Design of and implementing the complex ETL packages using SSIS 2016 for integrating data using OLE DB connection from heterogeneous sources Excel, DB2, CSV, XML, Oracle, flat file, Text file by using multiple transformations.
●Used SSIS to create ETL packages to validate, Extract, Transform and load data from different Databases to the Data Warehouse and Data Marts.
●Developed Custom Logging so user can know when a row is inserted in custom logging Table by every SSIS package that executes.
●Used notification services to generate error messages and send them to the users through e-mails and text messaging.
●Schedule and maintained routine SSIS packages and alerts using Event Handler in SSIS and SQL Server Agent.
●Created SQL Server Reports based on the requirements using SSRS 2016.
●Worked on Drill through Report links and Hyperlinks to jump to other reports and web pages using Microsoft SQL Server Reporting Services SSRS.
●Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
●Highly proficient in the using T-SQL Scripts in Development and Production environment for SQL Server 2016 for developing complex stored procedures, triggers, tables, user functions, temporary tables, table variables and common table expressions (CTE), Relational database models, data integrity, SQL joins and query writing, Views, Indexes, Performance Tuning, Query Optimization and Validation issues.
●Strong experience in database installation, capacity planning, implementing backup and recovery strategy for application and database.
●Designing the Logical Data Model and Physical Data Model for the new modules.
●Created and scheduled SQL jobs to run SSIS packages on a daily basis.
●Experience in Developing, Deploying and Monitoring Packages for ETL Tasks using SSIS, DTS Import/Export Utility, BCP Bulk Copy Program and DTS Packages.
●Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
Environment: SQL Server 2016, SQL 2016 Server Data Tools SSIS, Visual Studio 2017, SQL 2016 Reporting Services.
Client: Anthem Inc - Norfolk, VA Jan 2017 - May 2019
Role: Senior MSBI & Informatica PowerCenter ETL Developer
Project: Anthem Care Management Platform (ACMP) System for Utilization Management (UM)
Role & Responsibilities:
●Involved in designing, developing and testing of the ETL Extract, Transformation and Load strategy to populate the insurance data from various source systems feeds (DB2 and Teradata, SQL Server, Flat Files, Excel source files, XML files etc.) using SSIS.
●Extensively used SSIS transformations to perform data cleansing and data mapping before loading the data into data marts.
●Used various transformations like Sort, Multicast, Union All, Script Component, Conditional Split, Lookup, Merge Join, OLE DB Command and Aggregate to transform data.
●Created SQL datasets for SQL Server Reporting, Tabular Reports and Ad-hoc Reports.
●Created dynamic and cascading parameters in SSRS to enable/disable the parameters based on user selection.
●Developed different types of Tabular Reports, Matrix Reports (Cross Tab or Pivot), Chart and Graphs reports using the SSRS reporting as per the user’s requirements and deployed in report server.
●Developed Drill-down reports, reports that aggregate data and ad-hoc reports and distribute reports in multiple formats such as Excel, PDF, CSV using SQL Server 2012 Reporting Services.
●Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
●Created SQL Query with Temporary Tables, Table Variables and Common Table expressions (CTE).
●Created SQL Server inline table-valued function and Multi statement Table Valued Function.
●Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
●Used different transformations like Connected & Unconnected Lookup, Connected & Unconnected Stored Procedure, Router, Aggregator, Normalizer, Source Qualifier, Joiner, Expression, Update Strategy, Aggregator and Sequence generator, Transaction Control Transformations to data conversion before loading to Target.
●Wrote pre-session and post-session Stored Procedures/SQL to drop the indexes, to re-create the indexes, and to joins in the database.
●Created Reusable Mapplet for time saving development. Created and Monitored workflows/sessions using Informatica Server Manager/Workflow Monitor to load data into target Oracle database.
●Performed various Performances Tuning activities at Database level (source, target, Look Up) and Informatica level (mapping and session) and database level with T-SQL and SQL Developer and Toad.
●Perform production support for the stabilizing period. Resolving production issue retest and deploy.
●Migrated the workflows from development to testing and UAT environment.
●Scheduled Workflows on the Informatica Server using Informatica workflow Manager.
●Worked on scheduling tool Tidal Jobs.
Environment: SQL 2014 Server Data Tools SSIS, SSRS, Informatica Power center 9.5, Oracle 9i, Teradata SQL Assistant, DB2 (Toad Data Point 3.6)
Client: BlueCross BlueShield of Louisiana (BCBS) - Baton Rouge, LA Nov 2011 - Dec 2016
Role: Sr. MSBI -ETL & SQL Report Developer
Project: BCBALS Medicare & Medicare DataMart System for Enterprise Data warehouse (EDW)
Role & Responsibilities:
●Involved in translating the business requirements into technical specifications and source to target mapping documents.
●Developed a process that loads weekly incoming Inpatient and Outpatient Claims .DAT files that contain claims data for both MEDICARE and MEDICAID for different Markets into SQL database using SSIS packages and generated Control reports using SSRS for different Health Plan Markets.
●Extracted Provider data from Healthcare FACETS using SSIS and loaded into SQL tables, to validate if the rate calculator records in the control report were for active providers or inactive providers.
●Developed SSIS packages to validate the source files and ftp those files for further processing and extensively used SSIS transformations in order to perform data cleansing and data mapping before loading the data into data marts.
●Responsible for the extraction of data from several sources, their cleansing, customization, and loading into a central repository normally called Data Warehouse or Data Mart.
●Created and expanded SSIS packages based on specifications driven by changing business requirements.
●created packages that included a variety of transformations like Execute SQL Task, Script Task, Execute Package Task, File Connection, Derived Column, and for Each Loop.
●Designing the Logical Data Model and Physical Data Model for the new modules.
●Used dynamic parameters in SSRS to enable/disable the parameters based on user selection.
●Developed different types of Tabular Reports, Matrix Reports (Cross Tab or Pivot), Chart and Graphs reports using the SSRS reporting as per the user’s requirements and deployed in report server.
●Created named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions. Used MDX to create calculated members in the cube.
●Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
●Wrote SQL Query with Temporary Tables, Table Variables and Common Table expressions (CTE).
●Created SQL Server inline table-valued function and Multi statement Table Valued Function.
●Worked on Facets Data model and Data Dictionary.
●Worked on scheduling toll Control M Jobs.
Environment: Visual Studio 2012, SQL Server Data Tools SSIS, SQL 2012 Reporting Services and Crystal Reports XI R2.
Client: Cigna-Health Spring - Nashville, TN Jan 2011 - Nov 2011
Role: Sr. MSBI -ETL & SQL Report Developer
Project: FACETS & QNXT Claims System Reporting
Role & Responsibilities:
●Preparation of the Functional Specification Document and Design Document Responsible for the overall project across all the applications.
●As a SSIS Developer, extensively worked in Extracting data from various types sources like Flat Files, Excel.
●As a Microsoft SSIS Developer used its powerful concept of Merge statement and transformed data from staging environment to OLAP.
●Developed ETL Packages using SSIS (Integration Services) for Complex Data Transformations.
●Designed and Developed SSIS packages in order to migrate and transform the data across various servers (Databases) based on business rules.
●Used various tasks like scripts task, Dataflow, Control Flow in creating various packages according to the requirements
●Developed, monitored, and deployed SSIS packages. Monitored Scheduled jobs and alerts. Used different XML configurations depending upon package environments
●As a SSRS developer generated various reports like Tablix, Matrix, Graphs Reports and parameterized reports in SSRS 2008.
●Created Crosstab, Drill-down, Drill-through and Sub-Report using RDL and Improved Report Performance and performed unit testing at time of integration.
●Created SQL objects like Tables, Stored Procedures, and Views which helped in created SSIS packages and in building reports.
●Extracted data from FACETS to various destinations like SQL Server, Excel and flat file.
●Worked on Facets Data model and Data Dictionary.
Environment: SQL Server 2005/2008 Enterprise, SSIS, SSRS 2008 R2, MS VISIO, VB.NET
Client: Ingenix Inc, USA - Chennai, India Dec 2009 - April 2010
Role: MS SQL Server SSIS/ SSRS Developer
Role & Responsibilities:
●Participated in requirement gathering meetings with business analysts and ETL architect to understand Source Data, Data Warehouse data model, Technical Metadata, etc.
●Extensively involved in designing the SSIS packages to export data of Excel spreadsheets and flat files sources to SQL Server Database.
●Schedule and maintained routine SSIS packages and alerts using Event Handler in SSIS and SQL Server Agent
●Developed, scheduled and generated variety of reports like List, Matrix, Drill-Down, Chart and Sub Report and standardize company report by implementing SQL Server Reporting Services SSRS
●Involved in trouble-shooting SSRS reports and maintained proper documentation for future references and used role-based security to control access to folders and reports.
●Used Report Manager to deploy and schedule reports and created groups and users.
●Troubleshooting performance issues, optimizing and performance-tuning queries and stored procedures and providing consultation to other developers.
●Implementing and administering database replication, database mirroring, log shipping.
●Used SQL Server profiler to monitor and trace the events.
Environment: SQL Server 2012/2008 R2/2005 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2008/2003, Performance Point Server 2007, vb6.0, Excel, XML, .NET.
Client: WellPoint, USA - Chennai, India June 2008 - Nov 2009
Role: SQL Server ETL BI Developer (Informatica &Teradata) Developer
Roles & Responsibilities:
●Analyzed the Requirement Specifications and discussions with the client to understand the correct scope of this project and clarifications.
●Designed the Logical Data Model and Physical Data Model for the new modules.
●Worked on Informatica Power Center tool - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets and Transformation Developer.
●Created various mappings using Aggregate, Filter, Join, Expression, Lookup, Update Strategy and Router.
●Extensively used ETL to load data from different databases and flat files to Oracle.
●Designing the temporary/ volatile tables needed to implement the logic
●Develop and maintain technical documentation on WellPoint Knowledge Repository, compile documentation for design changes or creation criteria.
●Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) and Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
●Developed Query for generating drill down reports in SSRS 2005.
●Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
Environment: Informatica Power center 7.1, Teradata V2R5, Teradata Utilities, SQL Server 2005, SSIS, SSRS (Reporting services), SSAS (Analysis Services)
Client: Molina - Healthcare, USA - Chennai, India Oct 2006 - May 2008
Role: SQL Server BI Developer
Roles & Responsibilities:
●Designed and Developed Complex SSIS packages in order to migrate and transform the data across various servers (Databases) based on business rules and load data from different Databases to the Data Warehouse and Data Marts.
●Preparation of the Functional Specification Document and Design Document Responsible for the overall project across all the applications.
●Wrote Complex T SQL and stored procedures and functions.
●Developed system integration and test plans and conducted integration testing for user acceptance.
Environment: SQL Server 2005, SSIS, SSRS (Reporting services), SSAS (Analysis Services), Crystal Reports
Client: Care Voyant - India Apr 2005 - Sep 2006
Role: SQL BI Server Developer
Role & Responsibilities:
●Involved in developing the windows application and core integration process.
●Preparation of unit testing scripts and fixing bugs. Created Database Diagrams. Defined relationship between tables and enforced the referential integrity constraints.
●Developed DTS Packages to transfer the data between SQL Server and other database and files.
●Design and implement the T- SQL queries for Stored Procedures, Complex Queries using Joins & Sub Queries for inserting the customer data, to get the customer details and get the Category Plans.
●Involved in performance tuning of TSQL queries and Stored Procedures.
●Wrote T-SQL statements for retrieval of data.
Environment: Microsoft SQL Server 2000, C#.net, ADO.Net, Crystal Reports
References: Provided upon request…
Contact this candidate