SUMMARY:

• Business Systems/Data Analyst with more than 13 years of progressive experience in Planning, Analysis, Design and Implementation of medium to large applications in multiple technology and domain areas.
• Strong data analysis, modelling and reporting skills using Microsoft Excel Power Pivot, Power View. Proficient in SQL and DAX in analyzing complex data problems, noledge in statistical data analysis, Machine Learning and natural language processing techniques.
• Possess strong stakeholder management skills with ability to produce high quality requirement specifications, functional design, and test plan to support complex project implementation.
• Creative problem solver with a proven track record of building solutions for complex business requirements for Auto Finance, Retail and Publishing majors.
• 8 years of customer facing experience working with large US and UK based customers
• Over 3 years of Data Analysis experience with specialization in Data Science, MS BI, SQL, DAX,SSAS Tabular
• Over 10 years of strong working experience in Mainframe DB2 Relational Database
• Over 5 years of working experience in requirement gathering, BRD, Functional Design, User Manuals, System Manuals preparation. Possess excellent stakeholder management skills
• Certified Data Science Specialist from Johns Hopkins Bloomberg School of Public Health
• Certified QA professional from International Software Testing and Qualification Board (ISTQB)
• Certified Auto Finance Domain associate from TCS Domain Academy

TECHNICAL SKILLS:

• Microsoft BI
• Windows
• DAX,M
• SQL Server,Teradata
• SSDT, SSMS, MS Excel Power Pivot, Power Query, DAX Studio
• Data Analytics
• Windows, Linux
• R Programming, SQL,SAS
• SQL Server, CSV Files
• R i386 3.1.1, Git, GitHub, RStudio, Shiny, SAS,R x64 3.1.1
• Mainframe
• OS/390
• Z/OS
• COBOL,SAS,JCL,IMS DC,PL/1,CA IDEAL, Easytrieve
• DB2,VSAM,IMS DB,
• CA Datacom
• File - Aid, QMF,SPUFI, Changeman, REXX,TSO,ISPF,
• Expeditor, CCF, CA Panvalet,
• CA LIBRARIAN,SYSVIEW,
• CA-7/OPC/ESP, AVRS,RDZ,
• IMS Enterprise Suite SOAP Gateway, SOAP UI

PROFESSIONAL EXPERIENCE

Power BI Designer

Responsibility:

• Understanding of the Existing Report, Data Model and Architecture
• Understanding of the future reporting and analytics needs
• Analysis of data requirements, pull required data into the Model
• Perform Exploratory Data Analysis
• Creation of reporting, data analytics and self-service BI solution to Business
• Created SSAS Tabular Model, Power Pivot Model for building complex reporting solution
• Used DAX and SQL heavily in analyzing complex data problems
• Provided solutions for custom Time intelligence reporting needs
• Preparation of BRD and Functional Design document
• Project: EDI Analysis and System Documentation Aug 2015 - Dec 2015

Business Systems Analyst

Responsibility:

• Exhibited understanding of the application and provided complete product analysis including scope for new features and enhancements
• Analyze and document the complete EDI application and its interfaces
• Analyzed data in the EDI PO, ASN and Invoice database and successfully extracted the meaningful business process flow from the underlying data
• Prepared a complete EDI call chain report (From Job to Program and Program to Database) that will halp performing impact analysis for future system changes
• Identified list of inbound and outbound transactions
• Collaborate with Meijer SME and Business for clarification on business processes
• Send regular status reports on the progress of the project
• Set up review meetings with support team and management

Confidential

Business Systems Analyst

Responsibility:

• Perform research and analysis of business and end-user needs and makes recommendations for new functionality and functionality improvement for the new Iberia Reporting system
• Create the Business Requirements Document (BRD), Functional Design (FD) and prepare detailed Test Cases
• Work with development team to translate system design and requirements into new functionality
• Work directly with business users and provide technical guidance to the test team at client site
• Perform Analysis and Profiling of the Source System data using DAX, SQL
• Design SSAS Tabular Model and Prepare mock-up reports in Tabular/Power Pivot/Power View for review/demo with Business for the reporting requirements

Confidential

BI Delivery Manager

Responsibility:

• Created the project scope document, conducted planning and developed milestones for integration of the application with the new architecture
• Served as the central point of contact for business reporting and analytics requirements and the development of information solutions
• Ensure smooth, defect free quality delivery to customer
• Created demand by driving proactive proposals and convert them into project
• Managed cost-budget, Billing, Revenue for the assigned portfolio
• Planning, Analysis, Design, Construction and Overall Project and delivery management
• Take part in Bidding, RFP Proposal and SOW preparation
• Prepare and Maintain Project Plan, Resource Loading, Environment Strategy
• Provide weekly and monthly status to Client Manager
• Actively participate in Project management review with TCS senior management
• Participate in Project Internal and External Audits, Project Management Reviews
• Project: Insurance Product Enhancement Projects June 2009 - Dec 2013

Lead Business Systems Analyst

Responsibility:

• Created the project scope document, conducted planning and developed milestones for integration of the application with the new architecture
• Gather requirements through questionnaire, Joint requirement sessions
• Created the Business Requirements Document (BRD), modified the Master Test Plan and prepared detailed Test Cases
• Worked directly with the internal and offshore development resources to drive ongoing communication, coordination and integration of work efforts and productivity
• Actively participated in reviews of system architecture, and design documents and provide inputs to Technical and Functional Design
• Involved in identifying options for potential solutions and assessing them for both technical and business suitability
• Create Use Cases, Business Processes and Work Flow Diagrams using MS Visio
• Run quality control process of an application by running a suite of regression tests whenever their is a change to the application
• Coordinated software life-cycle planning with other team leads, business users, development, operations and testing teams on the release timing to ensure systems is ready for code to be deployed
• Assessed impact analysis of changes made to a product to other products, and coordinated and resolved issues pertaining to the product change
• Managed and communicated changes to approved requirements through TEMPeffective application of change control processes and tools
• Work jointly with business to prioritize projects
• Conduct demo of the proposed solution to business and take their input

Confidential

Technical Lead

Responsibility:

• Took part in KT ;prepared Induction Manual
• Build up offshore team in parallel to the KT
• Worked in live projects after completion of the KT
• Suggest numerous process improvement ideas that are appreciated by clients
• Coordinate with various CTB departments

Confidential

Developer and Production Support team member

Responsibility:

• Understanding the business requirements from different business units and Chalk out the design
• Chalk out the detail implementation plan
• Provide Post-implementation support of the application
• Prepare daily status report
• Prepare Application Dashboard and Presentation to Client in a Monthly basis
• Provide Numerous System Improvement options to reduce the Mainframe batch window
• Build the Mainframe based web service that can be invoked real time for a project