SUMMARY:

• Around 4 years of IT experience in the field of Business/Data analysis, ETL Development, Data Modeling, and Project Management.
• Experience in conducting Joint Application Development (JAD) sessions for requirements gathering, analysis, design and Rapid Application Development (RAD) sessions to converge early toward a design acceptable to the customer and feasible for the developers and to limit a project’s exposure to the forces of change.
• Experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data.
• Worked with different methodologies such as RUP and Agile. Worked with Agile Scrum methodologies.
• Experience in Data Modeling with expertise in creating Star & Snow - Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.
• Fair knowledge in project management tools such as Cognos and Jira.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
• Expert in creating and developing Power BI Dashboards in to rich look.
• 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.
• Good understanding of Relational Database Design, Data Warehouse concepts and methodologies.
• Participated in Tableau release both in Tableau Desktop and Tableau Server.
• Involved in Creation of UML Diagrams including Use Cases Diagrams, Activity Diagrams/Flow Chart Diagrams, Sequence Diagrams etc.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS:

Business Modeling: Microsoft Visio

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

Front End Tools: Microsoft Project, Microsoft Office

Document management: Visual Source Safe, Share point

Defect management tool: HP Quality center

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

BI Tools: Cognos, Business Objects, Microsoft SQL Server Reporting Services, Tableau, Power BI

ETL Tool: Microsoft SQL Server Integrated Services

Data modeling: Microsoft SQL Server Analysis Services

WORK EXPERIENCE:

Business/Data Analyst

Confidential, NJ

• Worked according to the software development life cycle.
• Gathered requirements from remotely based business users and defined and elaborated the requirements by holding meetings with the users (who are also Fifth-third employees).
• Worked on the backend SSAS cube development which was the source data for the tableau.
• Analyzed the historical documentation, supporting documentation, screen prints, e-mail conversations, presented business and wrote the business requirements document and got it electronically signed off from the stake holder
• Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes, performed performance tuning of the dashboard and created tableau functional design document.
• Conducted GAP analysis so as to analyze the variance between the system capabilities and business requirements.
• Involved in defining the source to target data mappings, business rules, business and data definitions.
• Created Report-Models for ad-hoc reporting and analysis.
• Created Logical/physical Data Model in ERwin and have worked on loading the tables in the Data Warehouse.
• Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.

Business/Data Analyst

Confidential

• Experienced in gathering/analyzing the business/user requirements, designing ODS tables in consultation with the Data Architect, analyzing the source/target dependencies & Production Troubleshooting.
• Highly provide hands-on Database, Data Modeling, Data Warehousing, ETL expertise and mentoring.
• Created process ow diagrams to re ect underlying business processes for existing self-service options and as well as the proposed business process ow, using MS Visio.
• Acted as a Scrum master while delivering project releases in compliance with SDLC standards using Agile and Waterfall methodologies (daily scrum meetings, grooming, retrospective meetings, etc.).
• Used Informatica reusability at various levels of development.
• Developed Stored Procedures, Functions & Packages to implement the logic at the server end on Oracle. Performed Application/ SQL Tuning using Explain Plan, SQL Tracing & TKPROF. Also, used Materialized View for the Reporting Requirement.
• Responsibilities also include Gathering the Business requirements, Business Analysis, Design, QA testing and final promotion to the production as well.
• Performed Data Analysis and data profiling using complex SQL on various sources systems including Oracle and Tera data.
• Assisted in creation, verification and publishing of meta data including identification, prioritization, definition and data lineage capture for Key Data Elements (KDE) and Important Data Elements (IDE).
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.