Syed Hashim
Manager Data Analytics
New Delhi
Summary
Performance-driven professional with 12+ years of experience in Strategic Project Delivery Management, Automation using ETL, Data Mining & Analytics, Requirement Gathering and People Management. Experience in different domains in the area of End to End Software Development, Data Analytics & Visualization and Automation & Reporting.
Develop and execute competitive strategies based on thorough market analysis.
Effectively manages projects to deliver high-quality work product in a timely fashion (meets deadlines). Ensures that regulatory guidelines are followed
Provides input for business development projects
Overview
17
17
years of professional experience
Work History
Data Analytics Manager
United Health Group
03.2021 - Current
- Excellent working experience in Waterfall, Agile methodologies. Proficient in performance analysis, monitoring and SQL query tuning using EXPLAINPLAN, Collect Statistics, Hints and SQL Trace both in Teradata as well as Oracle.
- Alteryx Hands-on skills and experience in Alteryx Designer, Alteryx Server, and the tools with Alteryx such as Predictive, Parsing, and Transforms. Involved in one of the Rx-Specialty Project to prepare some Alteryx Work flow for generating revenue for Specialty Drug.
- Package optimizations and code reusing functionality ensuring best practice and methods applied and for that we used SVN and GIT Repository.
- Worked so many project on MS-BI , VBA and Data visualization tool like Tableau and Power-BI
- Worked in Hadoop based environment , writing shell scripting and scheduling jobs through Chron expression.
- working in Microsoft Azure cloud like writing script in python/scala in Azure Data-bricks and integration done using ADF.
- working experience on Master data management.
- worked on ORACLE PL/SQL.
- Manage a team of 20 people on the diverse tools. Motivation, leadership for a team and developing future leaders.
- Daily status call with team related to project progress and challenges and their workaround.
- Creating PowerPoint presentations to showcase in front of leadership related to business update / process update / Achievements etc.
- To manage the day to-day planning, operation and problem-solving of a team of developers / analysts to meet with the required service level components.
- People Management including conflicts management amongst team members.
- setting Goal for our repartees and worked on their compensation plan
- working as an Data Architect role as well on different project.
- Attending daily meeting with US stake holders suggesting the best analytical solution and tools and technologies to accomplish certain project or task also overall planning for any project like Cost estimation , people engagement etc
- following Agile methodologies.( 2 week per sprint)
Lead Data Analyst
United Health Group
03.2018 - 03.2021
- Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses.
- Leveraged text, charts and graphs to communicate findings in understandable format.
- Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
- Lead Scrum Meetings, Team Leader and Mentor for various Project Teams
- Created entity relationship diagrams and multidimensional data models for merging Confidential and PHI data sets into one single data warehouse.
- Started leading the team and played an data architect role to understand the business requirement
- worked on various MS-BI tools, writing compex SQL queries , worked on automation part
- worked on TALEND ELT tools Rundeck ,Jenins for automation purpose
- I was onsite for 2 year ( San Diego, California office) for few project implementation)
- worked on various ETL process to integrated various source of calim data
- worked/Handling a core team on IRIS/Scriptmed/RX-Claimapplication to support all PBM based client and how to set up our own PBM.
- Creating and sustaining a dynamic environment that fosters the development opportunities and motivates the high performance amongst the team of Project Managers
- Understanding the project requirements details from high level to low level and defining project scope.
- Calculating the project cost and budget accurately ensuring that actual cost is not more that budged cost to avoid project failure. Adjusting cost accordingly, if needed.
- Taking project sign off from stake holder. Checking project skills sets needed and its associated application software require in project team.
- Resource allocation on module as per skill sets and backfilling / hiring new employee to complete the project on time.
- Arranging training sessions to new / existing employees, if needed.
- Created project schedule and allocate task in team, ensuring that team is clear about project objectives, scope and timelines.
- Help project team with design and development tasks.
- Daily follow-up with project team to take current project status and monitoring the progress.
Data Analyst
United Health Group
03.2015 - 03.2018
- Produced monthly reports using advanced Excel spreadsheet functions.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Utilized data visualization tools to effectively communicate business insights by using Power-BI and Tableau visualization tools.
- Identified, analyzed and interpreted trends or patterns in complex data sets.
- worked on Provider Group Audit project
- Worked on automation using MS-SQL,SSIS and VBA
- worked on creating Datawarehouse system and Data modelling
Reporting Analyst
United Health Group
01.2012 - 03.2015
- worked on Provider Data Quality (PDQ) project
- ETL developed with strong ability to write procedures to ETL data into a Data Warehouse from a variety of data sources including flat files and database links (Postgres, MySQL, Oracle, DATALAKE, NETEZZA.
- Knowledge of extracting data from different kind sources such as Google Analytics using Java API into Datawarehouse.
- Build Data migration processes using SQL Server as database and SSIS/TALEND as ETL and Design, Develop, Test and Maintain Data Warehouse which is built in Oracle 12c.
- Worked on AD-HOC report by writing complex MS-SQL queries.
- Worked on MS-BI (SSRS/SSIS/SSAS) for automating the daily report.
Senior IT Executive
Artech Infosystem Pvt Ltd
05.2010 - 11.2011
- Developed and led large-scale technology initiatives for long-term strategic plans and solutions.
- Report Publishing, Data uploading through SQL* XL, Data Mining, Data Handling, Data Migration.
- Netcampaign :- Worked on Performance Tuning on existing SQL queries
- Worked on creating database Model
- Worked on creating Datawarehouse System.
Senior Data Analyst
Sapneosoft Technology Pvt Ltd
02.2009 - 02.2010
- Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
- Leveraged text, charts and graphs to communicate findings in understandable format.
- Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses.
- Developed and implemented data collection systems and other strategies to optimize statistical efficiency and data quality.
- Created Access queries and defined the process by running all queries in order using Access macros built-in functions.
- Automated all Excel reports and eliminating manual entry process by incorporating advance functions (formulas, lookup, pivot tables, VBA-macros). This has reduced the process time to create the report from 1hr to 15mins. Any changes to the data will automatically update the charts and tables all across the workbook.
- Prepared monthly and quarterly HR metrics reports and decks.
- Collating data for Con Calls with the client twice daily.
- Preparation of Call Report done writing SQL/PL-SQL queries.
Database Executive
ATS Services PVT LTD
06.2008 - 01.2009
- Identified and resolved data-handling errors and created dump report for calling and dump report generated by using writing ORACLE PL/SQL code in SQL* XL plus SQL Plus environments.
- worked on MIS report where used so many excel function and VBA functionality as well.
- domain was banking credit card where it need to churn the data plus purging the data.
- Lent qualitative analytical support to lead data analysis.
- Analyzed content access, retention and evaluation projects to maintain nonstop information repository.
Education
High School Diploma -
Victoria Memorial High School
Gopalganj 04.2001 -
High School Diploma -
Science College
Gopalganj 04.2001 -
Bachelor of Computer Applications - Bachelor of Computer Application
Jai Prakash University
Chhapra 04.2001 -
MTECH(CS) - Computer Science
Shri Venkateshwara University
Gajraula,UP 04.2001 -
Master of Computer Applications - Master Of Computer Application
Vishweshwarya Technological University
Bangalore,Belgaum 04.2001 -
Skills
Statistical Analysis
Data Science Research Methods
Enterprise Resource Planning Software
Advanced Data Mining
SQL,PL/SQL,TALEND,MS-BI,VBA,EXCEL,TABLEAUE,POWER BI,PYTHON,SCALA,HADOOP,ORACLE PL/SQL,DATA WAREHOUSE,DATA MODELLING
Timeline
Data Analytics Manager
United Health Group
03.2021 - Current
Lead Data Analyst
United Health Group
03.2018 - 03.2021
Data Analyst
United Health Group
03.2015 - 03.2018
Reporting Analyst
United Health Group
01.2012 - 03.2015
Senior IT Executive
Artech Infosystem Pvt Ltd
05.2010 - 11.2011
Senior Data Analyst
Sapneosoft Technology Pvt Ltd
02.2009 - 02.2010
Database Executive
ATS Services PVT LTD
06.2008 - 01.2009
High School Diploma -
Victoria Memorial High School
04.2001 -
High School Diploma -
Science College
04.2001 -
Bachelor of Computer Applications - Bachelor of Computer Application
Jai Prakash University
04.2001 -
MTECH(CS) - Computer Science
Shri Venkateshwara University
04.2001 -
Master of Computer Applications - Master Of Computer Application
Vishweshwarya Technological University
04.2001 -