Navin Mishra Email and Phone Number

Work With Business Users and Managers to understands the business needs and design the data model to fulfill the needs.Provides the Optimal ETL Solution to extract and load the data from different source system to EDW.Designing the High Level ETL Dataflow.Designing ETL Reference ETL Pattern.Create the Technical Design Specification Document.Query optimization and SSIS Code optimization to improve the Load time.Testing and setting up peer reviews for each of the module to… Show more Work With Business Users and Managers to understands the business needs and design the data model to fulfill the needs.Provides the Optimal ETL Solution to extract and load the data from different source system to EDW.Designing the High Level ETL Dataflow.Designing ETL Reference ETL Pattern.Create the Technical Design Specification Document.Query optimization and SSIS Code optimization to improve the Load time.Testing and setting up peer reviews for each of the module to minimize the development errors.Create the SSIS jobs to run the ETL on daily basis.Creating change tickets to deploy the code in the Production.Responsible to handle the fix the issues in stabilization period.Prepared the support document and Transition the Project to the Support team Show less

Redesign current ETL / DW processes for best performance and proper dependencyUnderstand the project scope, identify activities/ tasks, task level estimates, schedule, dependencies, risks and provide inputs to Module Lead for reviewCreate regression tests architecture and processDesign and develop test plans for ETL unit testing and integration testingConduct testing to ensure successful deployment/ implementation of all developments or new applications key accountabilities

• Overseeing the entire operational & analytical aspect of the Microsoft• Management of the requests received in T2 queue ensuring Service Requests are actioned and closed within SLA• Troubleshooting and answering service tickets within Tier 2 scope• Identify root cause for data issue and respond to requestor• Understand platform/upstream process dependencies as potential cause• coordination with FTE for some unique scenarios• Manage proactive support communication to… Show more • Overseeing the entire operational & analytical aspect of the Microsoft• Management of the requests received in T2 queue ensuring Service Requests are actioned and closed within SLA• Troubleshooting and answering service tickets within Tier 2 scope• Identify root cause for data issue and respond to requestor• Understand platform/upstream process dependencies as potential cause• coordination with FTE for some unique scenarios• Manage proactive support communication to end users• Ad-hoc metric reports based on marketer’s needs Show less

Customer operates in education domain. It is a large-scale chain of lost-cost private schools, which works with governments and parents across Africa and Asia. They use a technology-enabled approach to provide standardized primary education through their "Academy in a box" model, allowing the chain to scale quickly and reduce cost.The project Academy Manager is an app used by the Academy Managers or principals of schools in Kenya, Nigeria, Liberia and Uganda. Principals can feed students… Show more Customer operates in education domain. It is a large-scale chain of lost-cost private schools, which works with governments and parents across Africa and Asia. They use a technology-enabled approach to provide standardized primary education through their "Academy in a box" model, allowing the chain to scale quickly and reduce cost.The project Academy Manager is an app used by the Academy Managers or principals of schools in Kenya, Nigeria, Liberia and Uganda. Principals can feed students details using the app and sync with the server Taking care of all analytical aspects related to the database ETL (SSIS) and SSRS based reports for all regions wherever bridge exist. Show less

Since Mar’11 with Wunderman International, Gurgaon, Haryana as Lead Analyst(Client: Microsoft)Key Result Areas:• Overseeing the entire operational & analytical aspect of the Microsoft’s Relationship Program worldwide• Ensuring:o Proper marketing execution of touch-triggered Marcoms intended for Microsoft Volume Licensing subscribers via Exact Target Tool o Effective execution management via an internal web-based tracking tool and delegate requests to team members as… Show more Since Mar’11 with Wunderman International, Gurgaon, Haryana as Lead Analyst(Client: Microsoft)Key Result Areas:• Overseeing the entire operational & analytical aspect of the Microsoft’s Relationship Program worldwide• Ensuring:o Proper marketing execution of touch-triggered Marcoms intended for Microsoft Volume Licensing subscribers via Exact Target Tool o Effective execution management via an internal web-based tracking tool and delegate requests to team members as required• Deftly generating:o Leads based on data analysis via WWLM, SQL & Excel tool for marketers to follow-upo Reports in SSRS reporting services for gauging execution performance of e-mail marketing communications with regards to quality, deliverability, volume and end-user click activityo Ad-hoc metric reports based on marketer’s needs• Working in coordination with onsite team based in Seattle (USA) via weekly conference calls for any process updates, resolving operational issues, future planning, etc. Show less

Mar’09-Mar’11 with HCL Technologies India, NOIDA, Uttar Pradesh as Data Analyst(Client: Kroll Factual Data)Key Result Areas:• Administered overall issuance of the Flood certificates for Flood Status of the Given Property Address using Online Resources (Parcel Maps, Section Township and Range Map, Land Lot and District Map, etc. • Liaised with US County Assessors / Recorders / Clerk of Courts / City Hall / USPS / 911 Addressing Offices / Departments to get the Plat Map / Tax… Show more Mar’09-Mar’11 with HCL Technologies India, NOIDA, Uttar Pradesh as Data Analyst(Client: Kroll Factual Data)Key Result Areas:• Administered overall issuance of the Flood certificates for Flood Status of the Given Property Address using Online Resources (Parcel Maps, Section Township and Range Map, Land Lot and District Map, etc. • Liaised with US County Assessors / Recorders / Clerk of Courts / City Hall / USPS / 911 Addressing Offices / Departments to get the Plat Map / Tax Map / Parcel Map / Legal Description or verbal directions to property location Show less