Amit

Cedar Rapids, IA 847-***-**** adm1wp@r.postjobfree.com

Professional Summary

Twelve (12) years of total IT experience in which Eight plus (8+) years of technical proficiency in Data Integration, operational Data Stores, ETL tool Alteryx, SSIS, and Basic idea of Tableau & Informatica with Insurance (Finance, Retirement Plan& Tax) & Healthcare domains.

Proficient in Alteryx ETL and analytical platform using either preexisting modules or customizing applications to the current task and business rules.

Excellent hands-on Experience in ETL (Extraction Transformation and Loading) by extracting large volumes of data from various data sources using Alteryx & SSIS.

Experienced in Alteryx to prep, blend, and analyze data using a repeatable workflow, enabling deployment and sharing analytics for deeper insights in hours.

Hands on Experience to Create workflow for Data Extraction, Transformation and Data Transfer.

Experience in dealing with various databases like SQL Server, MS Access, and Flat files.

Designed and presented Macro application to both technical and nontechnical personnel.

Developed SSIS packages to import data from various sources and load to operational data store.

Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), Tableau and POWER BI. Periodic reporting is done on a daily, weekly, monthly and quarterly basis which helps the client.

Experience in working with different type Dirty Data from Different sources.

Expertise in data preparation with experience in blending multiple data connections and creating multiple joins across same and various data sources.

Researched data discrepancies and took corrective action hence improving performance and decision making.

Migrated existing Excel manual processes into Alteryx & automate it using Control M to produce required results.

Deployed, tested and scheduled Alteryx workflow using Alteryx Gallery &Control M.

Worked as a project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.

Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.

Interviewed SMEs and Stakeholders to get a better understanding of client business processes.

Experience in SQL (DDL, DML and DCL), Creating, developing new database objects by like Tables, Views, Indexes, Complex stored procedures, function (UDF), cursors using SQL server.

Wrote complex SQL queries, modified stored procedures to efficiently retrieve data from the database

Skills

Software Methodologies: - SDLC, Waterfall, Agile

Others

ETL Tool - Alteryx, SSIS

C#, ASP. Net, JavaScript, SQL, HTML

Databases: MS SQL SERVER, Oracle and DB 2.

Software: MS Office, Visual Studio.NET 2.0/3.5/4.0

Versioning: SVN, TFS, JIRA

Basic MS Office

Reporting Tools: SSRS, Basic idea of Tableau

Job scheduling tool- Control M.

Domain - Insurance, Retirement Plan, Finance, Healthcare

Certification:

Alteryx Designer Core

Alteryx Designer Advanced

Microsoft Certificate70-515

Loma280

Work History

Programmer Analyst DXC Technology Transamerica Life Insurance Cedar Rapids, IA 2016 to Present

Skills - ETL, Control M, Alteryx Gallery Tools: Alteryx, AQT, SQL Server 2008, DB2, Oracle, SVN (Repository)

Projects completed:

Retirement Plan P&L Reconciliation.

Bond Amortization Reconciliation.

DRD.

Tax Premium Reconciliation.

EMM Position Reconciliation.

Roles & Responsibilities:

Assisted business users/Stake holders (Investment, Finance, tax users) in simplifying the tedious excel process by understanding and optimizing the same through Alteryx.

Optimize the process to deliver the reports in seconds which took hours to develop through excel.

Created technical portion of Process Definition Document (PDD) which captures the flow of a business process to be developed within the Alteryx software.

The purpose of this document is to describe the automation of the Forward Starting Swap Bond Amortization process at a detailed level.

Optimized the current state by developing the process which calculates the constant yield amortization for all bonds in the FSS portfolios.

Workflow FSS Bond Amortization process will use the prior period output as an input as well as current data pulled from TIA to differentiate these bonds as new, existing or sold.

Assisted business analyst on high level in understanding how new reporting tool like SSRS, tableau will help in Alteryx process.

Optimized other tax projects like DRD, Divisional Tax Allocation and TEFRA which helped business user by saving 800 hours yearly on excel.

Extensive experience in Extraction, Transformation, and Loading (ETL) data from various data sources into Data Warehouse using Alteryx (Data extraction, blending and Reporting).

Create & automate data Reconciliation workflows using Control M.

Elevated many projects on Production environment.

Worked extensively with database design, normalization and query optimization, worked on stored procedure, views, UDF, T-sql and cursor.

Develop Reports using SqlServer Reporting Services 2008.

28 months of exp on Life Insurance Domain (US based), with Loma 280 certified.

Fix Bugs in Application.

Implement manual testing process at the end.

Providing post release support in all instances, including transferring knowledge to internal customers, and occasionally to external customers.

Mentoring junior developers and collaborating with peers with a goal of continuous improvement.

Working in Agile environment & sprint using JIRA for Epic/project/Jira ticket.

Programmer Analyst CSC Transamerica Life Insurance Cedar Rapids, IA 2014 to 2016Technologies: SSIS, C#, ASP.NET, ADO.NET, AJAX, SQL Server 2008 Tools and Web Server: Visual Studio 2012, VSS (Visual Source safe), SQL Server 2008 Created customer friendly user interfaces using ASP.NET, and C# along with ADO.NET.

Understand the already written Stored Procedures & manipulate according to new requirement.

Worked on SSIS Packages.

Arrange calls / meetings with business/client.

Crete the Unit test cases.

Involved in sprint planning & task breakdown process.

Application Developer CSC Pacific Life Insurance CA 2011 to 2014

We generate the Illustration.

Illustrations are policy projections that explain guaranteed and non-guaranteed policy benefits in future years or during lifetime of policy.

Policy projections can be generated for New Business policies or Inforce policies and are presented to the customer to explain features/benefits of Life Insurance Product.

The Illustration is based on the riders, product and concept we have selected.

The web application is built in four layers.

Presentation layer, Controller, Business Layer and Data Access layer and full Oops concept is followed.

To access the Inforce policy data we have implemented the WCF service, which takes the policy ID as an input and in return the policy detail in XML format.

Technologies: C#, ASP.NET, SQL Server 2008 Tools and Web Server: Visual Studio 2010, Team Foundation Server, And SVN.

Created customer friendly user interfaces using ASP.NET, C# along with ADO.NET and SSRS Reporting.

Written Stored Procedures for manipulation of information.

Arrange calls / meetings with business/client.

Worked on SSIS Package.

Software Engineer, Mind fire Solutions India 2008 to 2011

Healthcare (Mind fire Solutions) Client eDerm - DermCare provides US based eDerm Clinics to manage their Requirement according to CCHIT recommendation.

Is a Practice management system where each practice can manage their data according to their locations. It provides the mange Record of patient according to their appointment/visit and then responsible for their billing records.

It provides rich Fee’s setup facilities according to provider or insurance or retail fee.

Electronic claim services also provided in this application.

Project Modules: Registration Module Scheduling Billing EHR Technologies: Visual Studio 2008/2010, C#, JavaScript, Ajax and Html, SQL 2008, Windows 2003 and IIS Tools and Web Server: Visual Studio 2010, Team Foundation Server I have played a key role right from development and customization phase of application.

During my association with this project, I have been involved in activities from Design to development.

Now this application is ready to go on production from Jan 2010.

Following are the main activities I have been involved for:

Interacting and Requirement gathering from Client.

Writing Stored Procedures, UDF, Views, applying indexes.

Implementing fee setup for cpt's in Application.

To provide user to add/Edit charge/ CPT/ ICD/ Insurances on patient's visit.

Claim Generations of Insured Visit.

To handle patient’s unapplied credit.

Providing facilities to Apply Payment/Refund /Adjustment on patient visits/Extra Charges.

Providing Deposited and Un-deposited Transactions.

Providing a Batch Payment Concept.

Working on Billing Reports using sqlserver2008 reporting services.

Implementing both front end as well as Back-end Changes.

Manual Testing at the end.

Integration of EHR & Billing Module.

Created all billing reports through SSIS.

Healthcare (Mindfire Solutions) Client Medappz - Medappz is a leading CCHIT Certified application in US Healthcare for Practice Management System.

It Provide facilities to clinics to manage patient's Electronic Medical Record according to CCHIT Recommendation.

It had six major Modules Registration, EMR, Scheduling, Billing E-Claim and Reports.

It is also providing electronic claim (e-claim) for insurance-based billing.

Project Modules: Registration Module Scheduling Billing EHR Technologies: Visual Studio 2008/2010, C#, JavaScript, Ajax and Html, SQL 2008, Windows 2003 and IIS Tools and Web Server: Visual Studio 2010, Team Foundation Server I have worked in this project in customization phase of application.

During my association with this project, I have been involved in activities from Design to production support.

Right now, this application is on production.

Following are the main activities I have been involved for:

Managing the billing Module and database.

Responsible for answering of client's query related to database.

Handling unapplied credit, payment, Adjustment and Refund on patient visit.

Education

Master of Computer Application Computer Engineering Hindu Institute of Mgt (Maharishi Dayanand University) - 2008

References

Can be furnished whenever required.

Contact this candidate