Analytics Associate Project Manager
Accenture - India
مجموع سنوات الخبرة :16 years, 0 أشهر
SQL Server, SSAS DAX, SSAS Cubes, SSIS, Azure DevOps, Visual Studio 2019, SSAS Tabular Model and Microsoft Excel
Roles:
➢ To develop the assigned modules for a Business Intelligence application that generates visualization and
tabular reports to help the finance and commercial operations users.
➢ Later, functioned as lead and architectural roles, in enhancing the OLAP with newer modules. Have served as
a core ETL developer using SSAS, SSIS and MS SQL Server. Besides these, have created tabular and
visualizations using SSAS Cubes, SSAS DAX.
➢ Have been a part of all SDLC phases during the time period with independent management thereby gaining
deep knowledge over short duration.
➢ Have always explored outside the prime area to ensure latest technological changes and best practices are
being incorporated in all deliverables. Besides executing deployments, have taken up responsibility of
maintaining Production servers and databases.
➢ Proposed and introduced various modules, innovative ideas and process improvements within the project to
improve Customer Satisfaction and overall value of the service.
Responsibilities:
o Design and development of DWH solution for Analytics
o Ingestion of Data from multiple sources using ETL
o Data & Business analysis and customer interactions
Our Client provides insurance broking, risk management and claims consulting services, globally. With over $10 billion of
premium placed worldwide each year, we have the scale and experience to deliver.
They have scorecard, carrier, Insights, MMI as visual data platform to showcase know and how the business is getting
operated.
Scorecard has lot of visualization built from UI (Angular) connected via API(.NET) from SSAS Cubes. Data will be injected
through API to UI Angular.
Scorecard application provides information about Income, Staff cost, EBITDA, GWP, Team Performance . This application
has KPI, DATABOOK, Health check and Scorecard Page as Main pages, inside we can be able to see information about
Clients, insured, Product Summary, Product Details, Location details, Placement Types, Wholesale and retail differentiation
, New and Renewal, Third Party Payaway. Databook page contains Risk Comparison, Risk Details and data book which
includes Calculations.
Project Name: Application Fraud Detection System (AFD)
Team Size : 22
Customer British Multinational Banking and Financial Services company
Functional Skills Fraud Risk Operations, Screening, Investigations Technology - Legal & Compliance
Technologies
used
Power Bi, Tableau, SSRS, SSIS, SQL SERVER, Oracle Pl/SQL, SQL SERVER DATA
TOOLS, SVN, JIRA, and GIT, Cron Jobs, Confluence.
Technical Responsibilities
❖ Developed high level test matrix on business requirements, functional and technical specifications and development standard for
assigned projects/applications.
❖ Assisted in producing OLAP Cubes, wrote queries to produce reports using SQL 2012 Integration Services and Reporting Services.
❖ Performed data quality analysis using advanced using advanced SQL Skills, performed Count Validation, dimensional analysis,
statistical Analysis, and data quality validation in data migration. Extensive SQL querying on staging, Data Warehouse and data
mart.
❖ Designing current database by adding tables, relationships, creating stored procedures, views and performance tuning on SQL
queries and stored procedures.
❖ Developed Power BI Reports and dashboards from multiple data sources using data blending.
❖ Developed SQL Queries/Scripts to validate the data such as checking duplicates, null values, truncating values and ensuring
correct data aggregations.
❖ Designed POWER Bi data visualization utilizing cross tabs, maps scatter plots, pie, bar and density charts.
❖ Involved in troubleshooting, resolving and escalating data related issues and validating to improve data quality.
❖ Gathering user requirements and identify new features
❖ Developing technical and training manuals
❖ Provide data management support to users
❖ Ensuring all database programs meet company and performance requirements.
❖ Implemented nearly 18 markets across global.
Analytical/Decision Making Responsibilities:
• Monitors and manages project baseline to ensure activities are occurring as planned - scope, budget and schedule -
manages variance.
• Proactively identify risks and issues on projects - leading team to develop risk management and issues management plans
• Identifies potential points of contention for missed deliverables; creates and implements strategy to mitigate shortfalls in
timeline and budget.
• Anticipates problems before they occur; defines the problem or risk; identifies possible causes; works with team to identify
solutions; selects and implements most appropriate solution.
• Develop and manage plans to address project strengths, weaknesses, opportunities and threats.
• Ability to balance both the "science" of how to perform project management and the "art" of program/project management,
which is learned through experience and skill training/application
• Analytical skills and problem-solving skills needed to manage multiple factors on a project simultaneously.
• Demonstrating business analytics to manage and meet sponsor and customer needs.
• Experience working in a multi-skilled engineering environment coordinating Change Requests and Service Requests.
• Mastery of project management methodology, tools and templates (includes program/project planning, schedule
development, scope management and cost management)
• Track record of customer focus, based on openness, trust, and delivering on promises
• Extensive experience of delivery that includes the use of supplier and off-shore resources
• Ability to work highly matrixes, multi-functional IT organization
• Management skills to manage one or more large, complex projects simultaneously
• Working knowledge of market-leading data analytics tools such as PowerBI
• Experience of delivering enterprise-scale Data Analytics projects
• Proficient in the use of IT methodologies, processes and standards for project management
Project Name: Prime Compliance Suite
Customer US Multinational Financial Services company
Functional Skills BSA Reporter or Anti-Money Laundering (AML), Enhanced Due Diligence (EDD)
Technologies
used
Power Bi, SSRS, SSIS, SQL SERVER, Oracle Pl/SQL, SQL SERVER DATA TOOLS, SQL SERVER
MANAGEMENT STUDIO, SQL SERVER BID STUIDO, SVN, JIRA, and GIT.
Roles and Responsibilities :-
❖ Developed high level test matrix on business requirements, functional and technical specifications and development
standard for assigned projects/applications.
❖ Assisted in producing OLAP Cubes, wrote queries to produce reports using SQL 2012 Integration Services and
Reporting Services.
❖ Performed data quality analysis using advanced using advanced SQL Skills, performed Count validation, dimensional
analysis, statistical Analysis, and data quality validation in data migration . Extensive SQL querying on staging, Data
Warehouse and data mart.
❖ Created and deployed cubes in star and snowflake schema. Performed and worked with dimensions, facts, measures
and MDX Queries.
❖ Designing current database by adding tables, relationships, creating stored procedures, views and performance tuning
on SQL queries and stored procedures.
❖ Developed Power BI Reports and dashboards from multiple data sources using data blending.
❖ Developed SQL Queries/Scripts to validate the data such as checking duplicates, null values, truncating values and
ensuring correct data aggregations.
❖ Designed POWER Bi data visualization utilizing cross tabs, maps scatter plots, pie, bar and density charts.
❖ Involved in troubleshooting, resolving and escalating data related issues and validating to improve data quality.
❖ Gathering user requirements and identify new features
❖ Developing technical and training manuals
❖ Provide data management support to users
❖ Ensuring all database programs meet company and performance requirements
AWARDS:
BEST PROJECT of the YEAR - FIS - Prime Compliance Suite
BEST Team of the Year - Prime 2.0
Project Name Enhanced Controlled, orchestration, Management & policy (ECOMP)
Customer US Telecom Services company
Functional Skills Telecom Architecture
Technologies
used
SSRS, SSIS, SSAS, SQL Server 2012-2016, .Net 3.5, Erwin D-M tool,
Toad, Oracle 11G
Roles and responsibilities
✓ End to End Production Support including Development of enhancements like major and minor,
✓ Deployment, Server Configurations and disaster and recovery processes.
✓ Preparing Production Support issue tracking documents, Impact Analysis documents.
✓ Preparation of Technical design documents, Project Specifications, Estimations for the new requirements, integration
with the external System and Test data preparation.
✓ Identifying all the list of entities, tables and data
✓ Database design and Volume estimations
✓ Basic data cleansing activities like format change, static data and look up transformations
✓ History Data Migration
✓ Organization and customer data migration (Corporate and Retail Users)
✓ All transactional data migration
✓ Check of Data integrity
✓ High level Data migration approach document
✓ Technical Design document preparation during the design phase in detail with table to table and column mappings in
detail
✓ Batch job details like purpose, process, targets, frequency, trigger event and attributes will be provided
✓ Preparing the Migration Approach document
✓ Data base environments and instance set up
✓ Data cleansing activities like duplicating and erroneous data correction of existing data
✓ Data extract from the source database
✓ Backups and archiving activities
AWARDS AND RECOGNITIONS
CUSTOMER APPRECIATION AWARD - PRODUCT DIRECTOR FROM AT&T APPRECIATED MY EFFORTS AND INVOLVEMENT.
BRAVO AWARD FOR QUICK RESOLUTION PROVIDED FOR THE SEV 1 ISSUE.
Project Name SCM - P7 Applications (
Customer US Multinational Automotive Company
Functional Skills Supply Chain Management
Technologies used SQL SERVER 2008, T-SQL, SSIS and SSRS, ASP.net and C#, Oracle PL/SQL
SCM P7 Applications are mainly used for Supply chain management in the Cars Production environment. It has nearly 25 Applications
, the main applications which I have handled are Cross Dock, Hitachi Sequencer, SIMS, PTA, ABP . These applications are core
applications which have the key involvement in supply chain management. Cross dock is a client server web-based Shipping
Schedule allows the users to print and reprint barcode label pick tickets, depart shipments, and print discrepancy
reports. It is used to tracks load/delivery status of shipments between facilities. Hitachi Sequencer application
takes daily order information from the mainframe and generates a sequenced vehicle sequence capable of being
built in respect to given plant constraints. This application interacts with the Vehicle Management System (VMS).
NEC Nissan export CENTER Application interacts with various internal customers of Nissan as well as with suppliers.
ROLES AND RESPONSIBILITIES IN THE PROJECT:
• Lead project development, production support and maintenance activities. Ensure timesheets and
Invoicing processes are completed on or before the deadline.
• Lead the customer interface for the project on an everyday basis, proactively addressing any
Issues before they are escalated.
• Create functional and technical specification documents. Track open tickets/ incidents in queue and
allocate tickets to resources and ensure that the tickets are closed within the deadlines.
• Ensure that all in the delivery team, including self, are constantly thinking of ways to do things
faster, better or in an economic manner.
• Assist Project Manager in Risk Management and participate in quality reviews and implement
quality norms. Lead and ensure project complies with Software Quality Processes and is adhering to the
defined timelines.
• Review and consolidate project (over all the modules) status reports and lead and perform all
activities related to maintaining successful knowledge management including re-usage, accuracy and
efficiency.
• Serve as the single point of contact for the team to the project stakeholders. Promote team
work, motivate, mentor and develop subordinates.
• Providing application production support as per process/RACI (Responsible, Accountable,
Consulted and Informed) Matrix.
Awards and Recognitions :
Pat on Back Award for reducing the time consuming batch programs performance drastically
Bravo Award for delivering the WMS Application prior to schedule.
Best Team Award - To achieve the target of On Time Every Time
❖ Title: Profit and Forecasting Europe (PFxE) (
.