SUMMARY:

• Qualified professional with 9 years of extensive IT Experience as a 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, MS Excel, MS Access and Micro strategy.
• Hand on experience with managing Waterfall and Agile projects using R - 12 EBS.
• 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.
• Adept in streamlining Business processes by recognizing and avoiding bottlenecks, thereby reducing Cycle time and improving system efficiency and productivity . Used Oracle R-12 for system integration efficiency checks.
• 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.
• Performed data analysis for financial data using SQL Joins and subqueries.
• 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 large data sets 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, 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, ETL, OLAP, Complete Software Development Lifecycle, Agile, Iterative

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

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

PROFESSIONAL EXPERIENCE

Confidential, Livermore, CA

Business Systems Analyst/Project Coordinator

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.
• Interacted with Subject Matter Experts & End Users and gathered business requirements.
• Data mapping for customer claims from source system (Facets) into the Blue Data Warehouse.
• 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.

Confidential, Des Moines, IA

Senior Business Analyst/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.
• Created reports containing all the information regarding the sales, traits and analytics data using Micro strategy reports.
• 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.
• Facilitated meetings to understand business processes and translated to business requirements and present them as a MS Powerpoint presentation.
• 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, Minneapolis, MN

Sr. Business Analyst/ Data 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. 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)
• Forecast 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.
• 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.
• Responsible for resolution of any roadblocks in the system during month end, quarter end and year end processes.
• 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, Lancaster, PA

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.
• Analyzed data and performed quality checks to be complaint 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 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.