SUMMARY

• Qualified professional with 9 years of extensive IT Experience as a Project Manager, Business Analyst, Business data analyst especially in Data Warehousing, Business Intelligence and Project Management applications in Retail, B2B/ B2C, Warehouse Management and Financial industries including Capital Markets.
• Expertise in generating ad hoc reports using business objects, Tableau, predictive analytics and web analytics tools
• Performed data analysis and reporting using BI tools such as SAS, Tableau, Essbase, MS Excel, MS Access and Micro strategy.
• Performed product pricing using Salesforce CPQ (configure - Price-Quote)
• Hand on experience with managing Waterfall and Agile. Lead teams on Kanban and Agile methodologies.
• In depth understanding of Data warehouse, ETL- Extraction/Transformation/Loading, Data Analysis, Data mining, Data migration, Data integration, Graphical Presentation, Statistical Analysis, Reporting, Validation and Documentation.
• Experience with Product Lifecycle Management(PLM). Starting from gathering requirements to the product go to market.
• Strong implementation of compliance standards on data in different industries- CCAR, HIPPA, GDPR.
• Strong experience in interacting with stakeholders/customers, gathering requirements through interviews, workshops, and existing system documentation (SRD) or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
• Implemented AWS Cloud and gathered requirements for data migration from Teradata warehouse to AWS Cloud.
• Presented performance to the business users via MS PowerPoint presentations and factual data to support.
• Experienced working with Excel Pivot and VBA macros for various business scenarios.
• Performed Data Analysis and governance compliance on big data and data management(MDM) using MDM tools.
• Experience in various phases of Software Development life cycle (Analysis, Requirements gathering, Designing) with expertise in documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings, SQL Joins.
• Strong experience with conducting feasibility analysis, Gap Analysis, impact analysis, SWOT analysis, cost & benefit analysis, requirement gathering and documenting System Requirement Specifications (SRS), System Design Specifications (SDS) and Design Reviews.
• Performed data analysis, design and implemented data warehousing applications in Teradata, Informatica, Oracle environment.
• Knowledge of Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and modeling Transactional Databases and Data Warehouse.
• Good working knowledge of Meta-data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.
• Flexible, enthusiastic and project oriented team player with excellent communication skills and leadership abilities to develop creative solution as per client requirement.

TECHNICAL SKILLS

BI Tools: Tableau, Business Objects, MS SQL Server Reporting Services, SAS, Oracle OLAP, Microstrategy, Essbase,Power BI, Salesforce.

ETL Tools: Informatica, Oracle Warehouse Builder, SSIS, Cognos, Erwin DM.

Requirements Management: Requisite Pro, Microsoft Office (Word, Excel, PowerPoint)

Project Management: MS Project, Oracle EBS-R12, PMO, JIRA, TFS, SharePoint.

Databases: Teradata, Oracle, SQL Server, DB2, DB400 Access, Sybase.

Methodologies: Data Modeling - Logical/Physical/Dimensional, Star/Snow flake Schema, PLM, ETL, OLAP, Complete Software Development Lifecycle, Agile, Iterative

Advanced Analytics tools: SAS for predictive analytics, forecasting, IBM predictive analytics, Hive Google Analytics, Clickstream, Adobe Analytics, Salesforce, HDFS(Hadoop), MATLAB, MINITAB.

Compliance: CMMI, HIPPA, CCAR, AML&KYC, GDPR.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Business Analyst/Product Owner

Responsibilities:

• Worked on the product team for product pricing using the CPQ (Configure-Price Quote) tool.
• Performed reporting analysis on global sales data to check product sales using Tableau and worked on product category pricing in Apptus.
• Supported BI teams on report development and report analysis in Tableau.
• Translated the business requirements into conceptual and detailed technical design documents.
• Searched for data elements for data analysis on big data using Splunk. Data files comes in from different vendors and managed a team to carry out data mappings.
• Worked cross functionally with teams and worked on team assignments and collaboration using SLACK.

Environment: JIRA,SQL Server, CPQ,APTUS, MS office Suite.

Confidential

Sr. Business Analyst

Responsibilities:

• Work closely with vision vendor for insurance product bundling and performing data analysis on inbound enrollment data into Facets before its moved to the data warehouse.
• Performed feasibility analysis for claims submitted under the ACA and map them into the Data warehouse before the CMS check for duplicates, replacements and qualifiers is performed. These claims are then sent to CMS.
• Supported BI teams with reporting requirements. Performed data Analysis and data visualization for Business reporting using Power BI and Tableau.
• Interacted with Subject Matter Experts & End Users and gathered business requirements.
• Carried out day to day stand up meetings for status checks.
• Data mapping for customer claims from source system (Facets) into the Confidential Data Warehouse.(Part of Master Data Management)
• Prepared weekly status reports to be suited to the client stating the project color code and resource allocations using MS Project and MS Visual code.
• Worked with data governance team for risk adjustment score and data quality checks on data sent to the state government.
• Worked with Source system Subject Matter Expert (SME) to ensure that the extracts are properly mapped. Used SQL for data analysis and querying.
• Translated the business requirements into conceptual and detailed technical design documents.
• Worked with product team and vendors on product bundling and go to market strategy using Marketo.

Environment: Facets, SQL Server, Teradata, Power BI, Tableau, Marketo and MS Project.

Confidential

Project Manager

Responsibilities:

• Gathered Business Requirements, interacted with the Users, Designers, Developers, Project Manager, and SMEs to get a better understanding of the Business Processes, and analyzed and optimized the process.
• Gathered business requirements for migration of operational data from data warehouse to AWS cloud for reporting and analytics.
• Created process flows for source systems using MS Visio and worked on CMMI Process Improvements for supply chain using R-12.
• Created theuser requirement specificationsand helped convert them tofunctional requirements, and assisted the developers withsystem requirement specifications.
• Responsible for ensuring data integrity using SQL and coordinating efforts with testing and implementation Responsible for the development and execution of test plans.
• Supported BI teams with reporting requirements. Performed data Analysis and data visualization for Business reporting using Tableau on big data from DW and AWS Cloud.
• Facilitated meetings to understand business processes and translated to business requirements and present them as a MS Powerpoint presentation.
• Worked with business to understand the product requirements and worked closely with cross functional teams for product lifecycle management(PLM) until product go to market using Essbase Product line analysis.
• Prepared data governance documents for data protection, accounts and data integration compliance.
• Expertise in the concepts of Data Warehousing, Data Marts, Dimensional Modeling, Fact and Dimensional Tables.
• Worked with Data Architects, DBA and Development team and assisted in building data marts.
• Performed Gap Analysis and facilitated data migration from legacy systems.

Environment: JIRA,SQL Server, Teradata, Micro Strategy, Unified Change Management, MS office Suite.

Confidential

Sr. Business Analyst

Responsibilities:

• Responsible for gathering information to create clear, concise and complete business and functional requirements for assigned tasks.
• Actively participate in project phases and report status to Project Manager, including Feasibility, Requirements, Development, Quality Assurance, Root Cause Analysis, Implementation and Maintenance.
• Worked as a part of merchandising team to carry out business analysis of returns and exchanges to promote sales with minimized returns and exchanges.
• Performed data migration from Teradata to MS PDW and AWS Cloud. Wrote SQL queries in both environments for data mart testing.
• Validated reports in Teradata and MS PDW by writing complex SQL queries and reporting discrepancies, if any.
• Documented Functional Requirement Documents (FRD) and Business Requirement Documents.(BRD)
• Performed data extraction from AWS Cloud to orecast returns and exchanges using advanced analytics( predictive using SAS, Statistics and IBM)
• Order Management- Data Profiling for returned orders and optimization of products based on data analysis.
• Designed a strategy for product pricing (project management) with respect to competitors to optimize returns, create bundling and increase sales as a part of PLM.
• Performed Gap Analysis, cost-benefit analysis and facilitate data migration from a different data system. (Teradata to Microsoft PDW).
• Facilitated meetings to understand business processes and translated to business requirements and present them as a MS Powerpoint presentation.
• Performed Feasibility Analysis of data after data integration. ( mdm data)
• Responsible for resolution of any roadblocks in the system during month end, quarter end and year end processes using Oracle Hyperion-Essbase.
• Performed analytic operations to forecast returns and calculate outliers using data discovery implementation.
• Worked with Data Architects and Data modelers and participated in identifying the dimensions and facts for individual Data Marts.
• Collaborated with developers in order to develop technical specifications out ofbusiness specifications and apply it to the suite ofBusinessObjects products (in order to achieve certain specifications, we had to use a suite of products, not just one product).

Environment: MS Project, PL/ SQL,SQL Server, MS Office, Visual Studio,SQL Server, Oracle 10g, Teradata, MS PDW.

Confidential

Data Analyst/ Sr. Business Systems Analyst

Responsibilities:

• Analyzed business requirements for capital market trading data reports and segregated them into high level and low level.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Used Security Master Data (Bloomberg) to compare the data outputs using SQL and find variances, which would help in business decisions for KYC compliance.
• Developed Data mapping documents from heterogeneous data sources.
• Worked with data governance to perform quality check on data to be compliant with CCAR
• Performed Risk analysis and Needs assessment to identify the keybusinessrisk areas in the project and prioritized development and testing of application modules using the reference data.
• Worked with Data Architects and Data modelers and participated in identifying the dimensions and facts for individual Data Marts.
• Worked on SAS to manage data migration and predictive analytics.
• Worked on CRM tools to keep a track and record of customer data.
• Worked on big data for credit cards and created reports using tableau.
• Provided inputs in the strategic development of detailed project plans, work assignments, and target dates.
• Wrote functional and technical specifications and communicated requirements to development teams.
• Developed Use Case diagrams, business flow diagrams, Activity, State and Sequence diagrams so that developers and other stakeholders can understand the business process.
• Served as a liaison between development and database administrators in order to identify and resolve database issues.
• Presented statistical analysis using SAS for the probability of mergers and acquisition.
• Worked closely with the business users to identify various KPI's and designed solutions to enhance business decision-making.
• Assisted the PM in evaluating the impact of changes on the organization and plans accordingly and conducted project related presentations for CCAR checks.
• Thoroughly analyzed the data on reports for accuracy using cognos and also made sure the dependencies are met as well as emphasizing on the timely delivery.
• Actively participated in clarification meeting with the Clients.

Environment: Tableau desktop 7/8, Tableau server 7/8, MS Project, Oracle 10g, SQL, PL/SQL, SQL Developer, Informatica 7/8, DB2, Oracle, SQL Server.

Confidential

Business Analyst

Responsibilities:

• Extracting data from different sources like MS SQL, Oracle, Flat files, External files and transformed the data based on Business requirements.
• Used MS PowerPoint for complex project management presentations.
• Data analysis and reporting using Oracle, MS Power Point, MS Access and SQL server.
• Provided Data modeling and Data Mining support for numerous strategic application development projects.
• Performed extensive requirement analysis including data analysis and ‘as is’ and ‘to be’ GAP Analysis.
• Designed and implemented basic SQL queries for testing and reporting.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency.
• Performed Data analysis and reporting using MS Excel and MS Access.
• Defined additional views (chart, ticker, narrative, column selector, view selector, legend, and funnel) of the data returned by the request to visualize data in many different ways.
• Projected and forecastedfuture growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on whichstates were connected the most.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Participated in meetings, reviews, and user groupdiscussionsas well as communicating with stakeholders and business groups

Environment: Windows NT, Oracle 9i, My Sql, MS Excel, PowerPoint.