ABHIMANYU SINGH

*** **** ****** 734-***-****

San Francisco, CA 94109 adyo10@r.postjobfree.com Visa Status: Permanent Resident

I’m looking to secure a job to use and further develop my analytical skills and knowledge in a practical and fast-paced environment. My career goal is to assume a role which allows me to take responsibility for the analysis and interpretation of commercial data for the organization which aspires to make a difference.

EDUCATION

Institute of Engineering & Management, Salt Lake. Kolkata, India Bachelor of technology with Computer Science.

PROFESSIONAL EXPERIENCE (Over 10 years in IT Industry)

Power BI SME/Lead at DTE(2019 September -Current) Hybrid

.

+Project Development Agile Cycle using Azure Dev-ops.

+Leading Agile and kanban Scrums.

+Retired tableau and deployed Power BI environment enterprise wide.

+Developed processes and standards for use of Power BI

+Deployed On premise reporting server Power BI for Compliance data such as NERC.

+Analyzing and interpreting large volumes of data and communicating insights in an understandable and actionable way.

+Created Visualizations and dashboards that display meaningful and actionable performance indicators.

+Served as internal subject matter expert for IT reporting.

+Optimized Power Bi Premium deployment, communicating with Microsoft Product SPOC to reduce overhead Costs.

+Deployment pipelines in Azure and Power BI.

+Visualizations include futuristic trends, historical trends, KPI’s, Operational metrics, Geo-positional trends etc.

+Statistical analysis, deviations curves.

+Dynamic reporting using, drill throughs, bookmarks, actions etc.

+Extensive use of DAX such as Selected value, In-scope functions to create dynamic measures on fly.

+Analyzing data and collaborating with BA staff to synthesize results.

+Leaded process improvement activities.

+Communicate technical subject matter to a non-technical audience.

+Provide direction and coaching to end users on how to use and interpret metrics.

+Translated data and trends into stories to support business and clinical decisions.

+ Investigated concerns and establish processes to streamline and improve data insights.

+Collaborate with specialist and leadership to ensure workflows adequately collect data required for reporting purposes and quality improvement strategies.

+Maintains work plan of reports and produces regular periodic (monthly, quarterly, and annual) reports as well as ad-hoc reports.

+Writing queries to integrate, extract and manipulate data from disparate internal and external data sources.

+Supports those doing grant reporting by developing quality financial and storm data reports.

Senior Developer at Infosys(2019 February – 2019 September ) on Client location Levi’s Strauss & Co.

+Analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Integration Services.

+Project Development Agile Cycle using Jeera.

+Source to target Mapping, ETL.

+Requirement gathering from the business.

+Managed offshore resources to convey business understanding, troubleshooting any problems.

+Writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors

+Error and event handling: precedence Constraints, Break Points, Check points and Logging.

+Aggregate data from multiple Power BI and SQL Sources.

+SQL Tracing Using SQL profiler.

+Generate views based upon business requirements.

+Creating configuration files to deploy the SSIS packages across all environments.

+Reading xml POS logs, using xml data types in SQL to fetch data and integrate systems.

+Worked with senior solution Architect for deploying integrations across all the environments.

+Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.

+Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

+Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.

+Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.

Senior Data Analyst at Capgemini(2016 January - 2019 January ) on Client location Unilever.

+Translating numbers into meaningful facts for businesses to help them make better business decisions. Dealing with sales figures, market research, logistics, and transportation costs, among other things.

+Used statistical analysis for futuristic forecast of data, Bell curve and Poisson distribution.

+Developed Key Performance Indicators to monitor sales.

+DAX queries and Measures, analyzing and publishing customized reports on Power BI cloud.

+Importing data in SSIS, transforming, cleaning and loading into server.

+Creating Power BI reports on top of Azure Data Lake.

+Having good knowledge in creating various dashboards, reports utilizing visual like bar graphs, scatter plots, pie-charts, geographic visualization and use of actions, other local and customized visual according to the end user requirement. Have knowledge to create highly interactive Data visualization Reports and Dashboards etc.

+Use of bookmarks, tool tips, heat map to create interactive dashboards.

+Gathered and documented business requirements for analytical reports. Participated in requirements meetings and data mapping sessions to understand business needs. Identified and documented detailed business rules.

+Developed at least two - three visual options for each report for discussions.

+Integrated Custom Visuals based on business requirements using Power BI desktop.

+Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI.

+Developed complex calculated measures using Data Analysis Expression language (DAX).

+Managed access of reports and data for individual users using Roles.

+Knowledge in SSIS, SSRS, Data Stage and SSAS.

+Data cleaning on Excel, VLOOKUP, HLOOKUP, Match, Pivot columns etc.

+Working experience in development project with a transnational consumer goods client as a Sr. data analyst. I have experience in strategic planning, analyzing, cleaning up data, Error handling and transformations. Good knowledge in MSBI.

Experience details with client:

Having Professional Experience in IT Industry, involved in MSBI Projects with extensive usage of ETL & Reporting Tools like SSIS (SQL Server Integration Services), Power BI with MICROSOFT SQL SERVER 2008R2/ 2012. Experience in High Level Design of ETL Packages for integrating data using OLE DB connections from heterogeneous sources (Excel, CSV, SQL, flat file, Text Format Data) by using different transformations.

Name of Client: Unilever AD

Project Objective: To provide detailed analysis on the Player Data through ETL and Reporting tool.

My Role: Power BI and ETL Developer and Contributed in Reporting.

Reviews and analyzes data information to properly process sales accounts for Sales Operations team through SalesForce Program. Capturing and documenting account information and communicating data to senior level. Extensive experience in creating several reports such as Drill down, Drill through reports, linked reports, sub reports, Matrix Reports, Chart reports and Dashboards using Power BI. Experience in report writing according to the business requirement in Power BI. Using Bookmarks and actions to make the report more interactive.

+Expertise in Creating, Deploying and managing reports using Power BI.

+Generating the reports weekly and monthly wise and rendering the reports on Power BI Cloud.

+Generated reports using variables parameters from web sources.

+Participated in requirements meetings and data mapping sessions to understand business needs. Documented requirements in Business Requirement Documents (BRD)

Expertise in using different transformations provided by SSIS such as Lookup, Data Conversion, Conditional Split, Bulk Insert, Merge, Union all, derived column and many more to transform the data before loading into the destination.

+Experience in Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

+Developing SSIS Packages to Load Data from Different Sources.

+Deploying, Monitoring and scheduling the packages.

+Debugging and Trouble Shooting SSIS Packages.

Involved in performance tuning of TSQL queries and Stored Procedures.

+Created and deployed other database objects like tables.

+Debugging stored procedures for Change requirements and improvisations.

+Gained Knowledge in Creating Databases, Tables, Stored Procedure, DDL/DML, Views, Functions using T-SQL.

+Experienced in using T-SQL in SQL Server 2012, 2008R2 platform.

+Good Experience on Performance Tuning.

+Experienced in writing complex T-SQL queries using Inner, Outer and Cross Joins.

+Guide a team as well as take individual responsibility.

+Verbal & Written Communication skills with presentation skills.

+Having Knowledge in creating the data model with star schema to meet business requirements.

Data Analyst at Meri track(2014 March- 2016 January )

Paid intern at MeriTtrack services:

Involved in Report generation using Excel, TSQL queries and Stored Procedures.

+Created daily reports in designed Excel spreadsheet with pivot tables and deployed other database objects like tables.

+Provided every day support status to Business.

+Supported Daily loads and job runs.

+Job monitoring through Tivoli.

+Basic SQL and Dax in MS Excel.

+Knowledge based training on Examination operation handling and Inventory reports.

+Excel PIVOT, Vlookup, Hlookup, Data filtering.

+Job scheduling through Tivoli.

A team player who is flexible enough to work in any role that serves to wellbeing of humanity and life around us.

TECHNICAL PROFICIENCY

Operating System

Windows XP, 2000,2003 and Windows 7,8, 10

Technologies

MSBI (Microsoft Business Intelligence), SSIS, SQL, POWERBI, SSRS

Azure Suite.

Programming Languages

DAX, M, T-SQL, HTML, Java, C++

Databases

SQL Server 2012, Oracle, Sqllite3, Access, BW, Azure Databricks, Datalake, IBM DB2

TRAININGS:

Capgemini provisional hands on training, Aug 2016– Dec 2016

+POWER BI

+Microsoft Business Intelligence tools

+ETL Tools: SSIS, DATASTAGE, INFORMATICA, Data services.

+Reporting tools: SSRS,

+Understanding of Data Analysis: SQL server, algorithm.

IEM’s Big Data Training Jan 2016-April 2016

+Understanding Big Data, Map Reduce, Clusters etc.

SKILLS:

Technical Skills: POWER BI, SSIS, SSRS, DATASTAGE, INFORMATICA, Data service.

Excel, SQL server, DBMS.

Please find a sample POWER BI report that I created on top of open-source data. https://drive.google.com/file/d/1YDYPGUPYhYOInixVBq9_gSUrwRrtNkP8/view?usp=drivesdk.

Languages known: Java, C, HTML, English, Hindi, Bengali.

Co-curricular skills:

Self-trained in Adobe Photoshop, Adobe premiere pro, Audio visual editing.

Worked on short Film as an Editor and Director of photography.

(Watch it here: https://www.youtube.com/watch?v=pmD4TRENRQ4)

Contact this candidate