Raji Msm Email & Phone Number

Irving, Texas, United States

HMS compares Eligibility insurance coverage information from Insurance carriers with Medicaid or Medicare claims. If a match is found and third-party coverage is confirmed, HMS will recover the money for the Medicaid and Medicare programs, since they are the payor of last resort.Responsibilities:●Actively involved in interacting with business users to record user requirements andBusiness Analysis.● Parsing high-level design spec to simple ETL coding and mapping standards.● Worked with PowerCenter Designer tools in developing mappings and Mapplets toextract and load the data from flat files, Oracle database and SQL server database.● Maintained warehouse metadata, naming standards and warehouse standards for futureapplication development.● Created the design and technical specifications for the ETL process of the project.● Used Informatica as an ETL tool to create source/target definitions, mappings and sessions toextract, transform and load data into staging tables from various sources.● Responsible for mapping and transforming existing feeds into the new data structures andstandards utilizing Router, Lookups Using Connected, Unconnected, Expression,Aggregator, Update strategy & stored procedure transformation.● Performance tuning of the process at the mapping level, session level, source level, and thetarget level.● Created Workflows containing command, email, session, decision and a wide variety of tasks.● Tuning the mappings based on criteria, creating partitions in case of performance issues.● Performed data validation after the successful End to End tests and appropriate errorhandling in ETL processes.● Resolving the tickets based on the priority levels raised by QA team● Scheduled batch and sessions within Informatica using Informatica scheduler and alsocustomized pre written shell scripts for job scheduling.

Detroit, Michigan, United States

TCF Bank-This project object is to build report and dashboard in residential mortgages, andhome equity loans area which are falling under Consumer Banking segment Relevant data wasintegrated from various source system using ETL Informatica tools. Reports and Interactive dashboardsResponsibilities:Analyze business requirements, technical specification, source repositories and physical datamodels for ETL mapping and process flow.● Created the Detail Technical Design Documents which have the ETL technical specifications forthe given functionality, overall process flow for each particular process, Flow diagrams, Mappingspreadsheets, etc.● Worked extensively with mappings using expressions, aggregators, filters, lookup, joiners,update strategy and stored procedure transformations● Designed and implemented ETL mappings and processes as per the company standards, usingInformatica.● Extensively worked on complex mappings which involved slowly changing dimensions.● Developed several complex mappings in Informatica a variety of PowerCenter transformations,Mapping.● Analyzed the existing mapping logic to determine the reusability of the code.● Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.● Involved in extensive performance tuning by determining bottlenecks at various points liketargets, sources, mappings, sessions or system. This led to better session performance.● Created Unit test plans and did unit testing using different scenarios separately for everyprocess.● Involved in System test, Regression test and supported the UAT for the client.● Performing ETL and database code migrations across environments using deployment groups● Involved in end-to-end system testing, performance and regression testing and data validations.● Unit test and support QA and UAT testing for database changes● Created batch scripts for automated database build deployment.● Used prewritten scripts to run informatica workflow.

Lansing, Michigan, United States

Auto-Owners Insurance Group is among the nation’s largest insurers and providesinsurance to nearly 3 million policyholders. The company is represented by 48,000 licensed agents in26 states and offers multiple lines of insurance including life, home, auto and business. The object ofintegrated data mart is to enable improved decision-making, and strategic plansResponsibilities:● Worked with business users to get the requirement and to involve in complete SDLC of thisproject● Analyzed source data and gathered business requirements from the business users and sourcedata team● Created Technical Design Document from business requirements document (BRD).● Analyzed business and system requirements to identify system impacts.● Created the Detail Technical Design Documents which have the ETL technical specifications forthe given functionality.● Prepared source to target mapping and conducted meetings with the business to understanddata / transformation logic.● Analyzed the existing mapping logic to determine the reusability of the code.● Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.● Done the extensive performance tuning by determining bottlenecks at various points liketargets, sources, mappings, sessions or system. This led to better session performance.● Created Unit test plans and did unit testing using different scenarios separately for everyprocess. Involved in System test, Regression test and supported the UAT for the client.● Performing ETL and database code migrations across environments using deployment groups.● Populating the business rules using mappings into the target tables.● Involved in end-to-end system testing, performance and regression testing and data validations.● Managed performance and tuning of SQL queries and fixed the slow running queries inproduction.● Created batch scripts for automated database build deployment.● Used prewritten scripts to run informatica workflow.