Ashok V. Email & Phone Number

Jacksonville, Florida, United States

Availity.com. April 2021-PresentData Service Providers facilitates billions of clinical, administrative, and financial transactions annually with tools for patient eligibility and benefits, claims status and authorization to facilitate the business side of health care for providers, health insurance and Members.Responsibilities:--Data Analysis, Daily handling Data Reconciliation process, loading the History data and patching missing data in different domains (Claims, Claim status, HL7, Eligibility Benefits, Transactions, ERA and HCSR)--DLQ (Dead Letter Queue data – error handling data analysis) and Patching scheduling on DAG Airflow schedular.---Loaded the history data into different stages in AWS S3 buckets and finally into Redshift database ---Handling the Billing transactions to bill to the customer’s monthly for all the Domains.---Production Support Jobs on AWS Cloud -Apache DAG Airflow, Informatica Power Center -Batch and Realtime Applications.---Development ETL Informatica mappings/sessions/Worklets/Workflows and scheduling on Jams schedular tool.Highlights: ● Production support, Design, Development, ETL Mapping document, Data analysis, Bug fixing issues, Data Quality and Data patching process.Using Informatica PowerCenter, RDBMS (Oracle, SQL Server), AWS Cloud (Redshift, EMR, EC2,S3,DynamoDB,CloudShell) and Apache Air flow scheduling using Task flow API decorators.Jupyter Notebook), Python, pyspark and Scala (Knowledge)● Knowledges on Health HIPAA X12 EDI transaction sets.* Development Python and Scala as required to convert applications from on prem to AWS cloud

Buffalo, New York, United States

*Credit risk system for Commercial Loans exists in Microsoft SQL Server database model,and needs to integrate into the data lake hadoop ecosystem in order to build and deliver CRS Data to multi-stakeholders for Analytics and Reporting.Highlights: •Gap analysis on existing data mart and data lake data to identify the entities,attributes,analyzing and profiling • Design and develop Big Data applications for processing commercial loans data. • Integrated Hadoop into traditional ETL, accelerating the extraction, transformation, and loading into different layers for stakeholders. • Scheduling and creating workflows and objects.Customer Profitability: Upgrade ProjectExisting application integrated different sources: commercial loans ,small business,direct deposits,dealer floor plan and Mortgage loans in hadoop ecosystem built on Cloudera platform with BDM informatica for downstream stakeholders reports and for OFSAA applicationHighlights: • Coordinating with the Production team for source daily ebcdic files into downstream env’s (dev/test/cert/) to test Jobs. • Hands on executing BDM mappings , validating the data at each individual stages with production w.r.t specific business date • Optimized ETL Jobs to improve the performance • Created change control process for production deployment Credit Lifecycle Management : This application is integrated upstreams daily batch files processing into Oracle ,Teradata databases and CRM Sales force with all the financial credit information in order to track for reporting in order to improve the business.Highlights: • Identified gaps in the data processes and drove the improvements via continuous improvement loop (Data process) for performance and scalability. • Data flow diagram, Design document and ETL mapping specification coordinating with Data Analyst team. • Designed, development, test and deploying into production. • Change control process for production deployment.

Greater Detroit Area

Data Engineer/Analyst- Present working on Sales and Mktg 360 ,Responsibilitie : Complete SDLC- analysis, design, development , testing , validation using big data -Hadoop, Hive, Sqoop , Linux, Ftp tools, Data analysis, Data Validation and Power BI for visualization. Projects Done Dr.Mo Dealer sales tracking.MIO: Processing JD Edwards files into tables using ETL –Data stage complete SDLC.Global Business Service: Indirect material Inventory from all 54 for plants North America Region process loading to Aster Database & HDFS to Hive and query using BigSQL also BM Big insights web console for import export Files into HDFS.-Loaded 5 Years History Data -Using Microsoft Team Foundation Server, creating the Test cases for the Project.--Providing technical inputs to team membersEnvironment: Linux, Autosys, SVN Tortoise, IBM Info sphere Data stage (9.1), Oracle, Aster database, Teradata Studio , Microsoft Team Foundation Server, Hadoop 2.2.0,hdfs, Hive, Sqoop, BigSQL & IBM InfoSphere BigInsights Enterprise Edition v3.0.0.0.Responsibilities:Technical Lead -GIF Innovation Team Project :Global Warranty Management conversion from See beyond to Datastage 11.3 – Leading a team of software developers during development including compliance with design development using standard frameworks and coding standards compliance/patterns, analysis, design, development, UAT and end to end testing by automating the processes by developing scripts as part of coding to execute Jobs . -Installation ETL Datastage (7.5, 8.1 8.5), Oracle, db2 client Software’s, SAP integration setting up RFC to call ABAP programs and Code.Interviewed the resources for phone screen and face to face as per Lominger. Environment: Alteryx11.0 ,Power BI, Datastage (7.5.1, 8.1 8.5, 9.1, 11.3),Knime, Oracle, IBM DB2, SQL server, sftp, SAP integration, ftp, Tableau 8.2 Desktop, Solaris and Linux.

Birmingham,Alabama

Worked as ETL Consultant for BBVA Compass after working as full time employee for same Employee.Responsibilities: Design and Development, ETL Mapping spec,Testing & support for below Projects,sdlc for Data mart Projects using ETL Informatica -Design,Development,Testing and Production Support.i) Customer Relationship Management (CRM)- Data Mart Projectii) Non-Consumer Revenue Portfolio (NCRP) – Data Mart Projectiiii) E3 (Mortgage & Insurance) –Data Mart Project.iv) Conversion Project Windows to AIX ETL Jobs.Environment: Informatica Power Center 9.1.0 (Repository Manager, Designer & Server Manager), Oracle 11g, AIX & Windows Env.

Charlotte,Nc

Project: Enterprise Credit Risk Project for Proof Of Concept .Main agenda is to compare and convert existing ETL Informatica & Teradata into ETL-Talend & Netezza (Database).-Undergone training on Talend & Netezza tools.-Environment Setup's -Dev,SIT,UAT & Pre-prod (Instructions for users to access to OS,Databases,Tools).-Support activities- Talend servers.Environment: : Talend, Data Quality Mpx (ELT), Netezza (Database), Informatica (Power Center), Subversion, Perforce Tools.

Bimingham,Alabama

Responsibilities’: Design, Development and Administration:Employee award of the Month 2009.• Estimate the time and resource requirements of ETL development Projects. • Requirements review, design of ETL process flow designs/architecture/framework, creating mapping specifications, walkthroughs, and data profiling of required source systems.• ETL development to meet project objectives, oversight of other ETL developers assigned to effort, unit testing of all developed objects, schedule development of overall process, performance fine-tuning and UAT issue resolution.• Review ETL code/design documents to verify they correctly load data; meet our standards and best practices, and meets business requirements.• Project co-ordination and administrative activities; communicate technical concepts to Project Managers, business analysts and customers.• Deployment Activities from Dev to test to Production, repository objects using Power Center.• Administrative Activities for Informatica (Power Center) Integration and Repository Services.• Support for Installation and applying hot fixes for Informatica Power Center software’s.• New Development/Support/Maintenance for Data marts for Credit Risk (CRDB) , Collections (CollDB), Credit Origination Integration and Navigation (COIN),Treasury Management System (TMS ) , Small Business Accounts (SBA) and Customer Profitability (CPS).• Mentorship and guidance to other Informatica developers on site/offshore with vendors.• 10GB, 50 schemas, 1000 tables,1000 ETL Jobs Daily support.Environment: Informatica Power Center 7.1.5/8.1/8.6/8.6.1 , Power Exchange 8.6.1 ,Data Analyzer, Informatica Debugging Tools ,Oracle 9/10g, Microsoft SQL Server, Unix,Korn Shell UNIX (AIX, Solaris), Erwin, Informatica Integration Services.**Recognized as Best Employee from IT Department from BBVA Compass -2009**

Detroit,Michigan

i) SPOT (Single Point of Truth) – Data Warehouse ProjectData Warehouse with the goal of Single Point of corporate data. SPOT is expected to increase the quality and availability of corporate data and transform the system data into an information tool that drives decision making and addressing several key DCS information technology challenges including consolidated reports from data stored in over 50 different operations systems for DCS business leaders and key decision-makers throughout North and South America.ii) MBC Commercial Vehicle MORIS – Data Mart ProjectThere are two main reasons that Truck Finance (TF) Mercedes-Benz Credit Data Warehouse (MBCDW) , (Management Operational Reporting Intranet Solution) Conversion Project was undertaken. The first reason is a direct result of the Info Lease implementation project currently underway and is further explained below. The second reason is that the MORIS reports were created using a non-standard reporting tool that will create licensing, deployment, and resource issues when considered for widespread corporate use. iii) Dealer Profitability – Truck Finance – Data Mart Project Develop a process for operations management to better analyze the profitability of there Portfolios Use to enhance management’s ability to price business profitability from a different perspective, allow management to identify top sales performers.iv) Optiload Conversion – Feeding sources into the Data Warehouse .Optiload replacement project are to replace the current Production Optiload jobs with Informatica Power Center / PowerConnect (Striva) tools. iv) Financial Toolkit (FTK) - Projects – Data Marts ProjectsDealer ROEBVF (Business Vehicle Finance)Lease-Retail Acquisition ROE (US – CF and MB)Truck Finance Acquisition ROE (US and Canada)Pricing for Performance (US and Canada)Lease-Retail Acquisition ROE (CN – CF and MB)

Mumbai Area, India

-- Process/Methods Department to develop the process documents for Assembly Line--Worked in Uno Car Assembly Line and Body-in-white shop floor.-- Maintaining Bill of Materials update to maintain Inventory in Assembly Line.--Trained in Body-in-White for UNO Car Model in Fiat, Italy. --Incentive calculation for Employees as per Cars Monthly production.--Time Study calculation in Engine Assembly Line.--Trained in learning Italian Language.-- Fox Pro and Dbase languages used the program to calculate Employees monthly incentives based on the Production of the cars for different departments (Body-in-white), Assembly line and Engine transmission

Bachelor Of Engineering, Mechanical

Activities and Societies: Sports : Volleyball, ,Table Tennis ,cricket and 5km Running (won first place)

Post Graduate Diploma, Personal Management And Industrial Relations, Ii

Post Graduated with Diploma in Personal Management and Industrial Relations (PMIR) from Kakatiya University 1992

8-10Th Http://Www.Stgabrielshighschool.Com/, Maths,Science & Social

Activities and Societies: Soccer, Table Tennis

Lkg To 7Th Grade Schooling, Education Of Individuals In Junior High/Middle School Education Programs, Schooling Lkg To 7Th Grade

LKG TO 7th Grade Schooling https://plus.google.com/110064218561578963438/about?gl=us&hl=en