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.
• Detailed understanding of Waterfall and Agile project Management approach.
• 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.
• 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.
• Worked closely with Data Governance team for data mapping approvals and data regulatory mappings.
• Created data dictionary with data definitions as per the data regulatory Compliance (GDPR)
• 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.
• Excellent in creating various artifacts for projects which include data integrity and data protection documents with the Governance team.
• 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, Axure, MS SQL Server Reporting Services, SAS, Oracle OLAP

ETL Tools: Informatica, Microsoft SQL Server Integrated Services

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

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst, Lotus Notes

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

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

Advanced Analytics tool: SAS for predictive analytics, forecasting, IBM predictive analytics, MATLAB, MINITAB

PROFESSIONAL EXPERIENCE

Confidential

Sr. Business Analyst/ Data Analyst

Responsibilities:

• Work closely with vision vendor for insurance product bundling and performing data analysis on inbound enrollment data into Facets before it’s 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 Confidential Data Warehouse.
• Work with the Data Governance team for data integrity and regulatory issues and risk aversion techniques. Use SQL for data analysis and fixing data codes.
• Carried out data mapping in CDMA tool. Performed data analysis and created mappings.
• Performed feasibility analysis, adaptability study and risk analysis to identify the critical business areas from the user perspective.

Environment: JIRA, SQL Management data studio, MySQL, Teradata, Tableau 9,Facets, CDMA, Power BI, MS office Suite.

Confidential

Sr. Business Analyst/ Data Analyst

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 and Tableau.
• Created process flows for source systems using MS Visio.
• Created a data dictionary for data governance teams that included definitions of each column in the database and its data requirement as per the governance regulatory compliance.(GDPR)
• 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 9 & 10.
• 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

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 and R)
• 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.
• Updated, modified retrofitted customizations enhanced and expanded existing programs as per changed requirements.
• 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.
• Developed Data mapping documents from heterogeneous data sources.
• Helped planning, scheduling of project and coordinated the creation and analyzing of Gap Analysis document and evaluated the Cost-Benefit Analysis using MS Project and MS Office.
• 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 with Salesforce CRM tools to keep a track and record of customer data.
• Worked on big data for capital and stock options 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 setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted project related presentations.
• Thoroughly analyzed the data on reports for accuracy using tableau 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.