Mitesh Kumar

Sr. Data Engineering Analyst with 5yrs. of experience in SQL server reporting and BI development (SSRS, SSIS, PowerBI, and Tableau). Overall experience of 10 years. Professional Experience United Health Group (OPTUM)Greater Noida, UP Senior Data Engineering AnalystAugust 2014 – till date Polaris Reporting Report development using SSRS, backend query developed in hive using dbeaver application scheduling the subscription of the report as per client requirement. Uploading the report at GitHub location and documentation using confluence used the JIRA tool for raising tickets. Developed ETL packages using SSIS to automate certain tasks. Understanding client requirements, creating BRD, direct interaction with clients to gather report requirements. Suggesting the best possible way for their ease of doing business. Converted 5 SSRS reports into PowerBI for better visualization and provide some insights out of data to formulate policies by upper management. Contributed in the development of knowledge transfer documentation. Designed PowerBI data visualization utilizing cross tabs, maps, scatter plots, pie, bar density charts. Requirement analysis. Customer interaction for requirement clarifications. Experience in providing logging, error handling by using Event Handlers and Custom Logging for SSIS Package. Polaris Report Migration Migrated Polaris (SSRS) report to Tableau using Tableau Desktop. Developed Tableau workbooks from multiple data sources. Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau. Participated in daily stand-ups with clients on daily design and development effort Design Dashboards using Filters, Parameters and Action Filters ASO (Administrative Service Only) Reporting ASO reporting and package development for claims, provider and membership domain, debugging of the existing packages, migration to the new server. Work with business partners to understand business objectives and develop value-added reporting and provide ad-hoc data extracts and analysis Work effectively as a member of a team, as well independently. Contribute to the development of automated reporting solutions Create and deliver HR reports, dashboard and analyses for senior and executive level audiences. Create and maintain detailed documentation on all projects/requests. Preparing dashboard, workspaces and sharing with other teams, obtaining insights and suggesting work related solutions to client. Claim processing, in order to prove that every claim we receive and scan is handled. A pulse process has been built as an internal reconciliation. It’s a SOX (Sarbanes Oxley) compliance requirement that we reconcile the number of claims scanned versus the number of claims loaded to the adjudication engine. Aon HewittNoida, UP VBA DeveloperJune 2012 –August 2014 Initially I was responsible to make various reports and automation after a year I got promoted as Team developer, where I got some extra responsibility to handle projects and to support my team members. Here I did some projects like COS scorecard performance enhancement, Task Closed automation, BAC (Bank of America) scorecard and HW shared service scorecard. In all above-mentioned scorecard I have used VBA coding and SQL 2008 database and got appreciation from onshore team as well as offshore team and also got rewarded. Wipro BPOGR. Noida, UP MIS ExecutiveMay 2011 – June 2012 Working in Ms-excel (Vlookup, Hlookup, Pivot table, Formulae, Macros), VBA.:- I was responsible to send various kind of reports for Airtel platinum, Airtel Blackberry, Airtel Telemedia, Airtel CFM and Airtel AES processes. And reports were CWN report, APR report, Schedule Adherence report, Satisfaction report etc. I have done various automations here in VBA to minimize work hours and create time zone to take extra work. I also rewarded as a best MIS for the last quarter of 2011. Education Degree Board/University Institute % Year BCA IGNOU NSIC, New Delhi 56 2010 Class XII BIEC SN College, Jehanabad 52 2006 Class X BSEB FS High School, Arwal 76 2004 Technical Skills Expertise in SQL Server. Experience in ETL development (SSIS and SSRS). Visualization using PowerBI and Tableau. Excel, VBA, Ms Access (with VBA), Major Strengths Good problem-solving abilities and hardworking. Eager to learn and acquire new skills Goal oriented and dedicated to the assigned task. I hereby affirm that the above furnished information is true to the best of my knowledge and belief. Mitesh Kumar