SUMMARY:

• Over 6 years of diverse experience in Information Technology with emphasis on Business Analysis and Data Analysis with substantial know - how of Business Processes, Business Requirements gathering, Business Process flow, Business Process Modeling, Data Mining, Data Mapping, Data Modeling, Data Migration and Data Integration.
• Data Analyst with in-depth knowledge and practical experience of using Waterfall, Agile and Rational Unified Process methodologies.
• Background of using SQL queries on SQL server 2008 R2.
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Expert in Data Extraction, Mapping, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS).
• Excellent understanding of Business Intelligence, Databases, Data Warehousing, Data Mapping, Data Modeling, Data Migration and Data Integration
• Worked on supply chain transaction issues with 3PLs in integrations and reports.
• Extensive knowledge of ERP (Dynamics AX 2009) in Supply Chain (AR, AP & Inventory Management) and General Ledger modules.
• Experience in Data Transformation and Data Migration.
• Experience in Data Cleaning & determining the quality of the data.
• Created SSIS packages for data Import/export and Data Transformation.
• Generated reports using SSRS from OLTP & OLAP data sources to schedule reports on daily, weekly, monthly, quarterly basis.
• Thoroughly used MS Excel (VLOOKUP, CountIf, Nested If, Pivot Charts, etc.) for effective visual representation and analyzing of data.
• Experience in conducting SWOT analysis, Cost benefit analysis and ROI analysis, and QA testing, User Acceptance Testing (UAT)
• Developed Test Plans, Test Cases and defect tracking documents, as required by the project.
• Experienced in manual testing, recreating errors and provide support to programmers to correct defects in the system.
• Strong team building skills while focusing on project deliverables in the shadow of Triple Constraints.
• Highly effective management and organizational skills with ability to prioritize.

TECHNICAL SKILLS:

Programming Languages: SQL

Operating Systems: Windows XP & Windows 7

MS Access, MS: SQLServer2008 R2/2016

Front End Suite: MS Office suite, MS Visio, MS SharePoint, MS Project

ERP: Microsoft Dynamics AX 2009

Software Development Methodologies: Agile & Waterfall

Data Migration tools: SSIS

BI Tools: BI360 & SSRS

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst / Business Analyst

Responsibilities:

• Perform requirements gathering, and business analysis. Responsible for analysis, design & development of new enhancements in AP/AR modules (Microsoft Dynamics AX 2009 ERP).
• Worked on Supply chain management (AP, AR & Inventory management modules) and General Ledger.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to import cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created SSIS packages for data Importing, Cleansing, Transforming, and Parsing etc. Extracted, cleaned and validated.
• Generated reports using SQL Server Reporting Services 2008 (SSRS) from OLTP and OLAP data sources.
• Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Create pivot tables and modify spreadsheets to achieve analytical goals.
• Daily used complex Excel formulas and pivot tables to manipulate large datasets.
• Reviewed and adjusted deliverables involved during SDLC involving database changes and development.
• Optimized the query performance with modification in T-SQL queries, removing unnecessary columns, normalizing database, establishing necessary joins, creating useful clustered and non-clustered indexes.
• Worked on profiling the data for understanding the data and ETL mapping document.
• Created a lot of ad-hoc reports using SSMS (SQL Server management studio).
• Worked with the users to do UAT on the customizations that were done on ERP.
• Created test plans and performed unit testing.

Confidential

Data Analyst

Responsibilities:

• Translated Business Requirements into Functional Specifications and collaborating with technical team to propose or and implement solutions based on the user needs
• Formulated and documented the physical ETL (SSIS) process design based on business requirements and system specifications with strong ETL (SSIS) design skills.
• Worked on Data Integration and Data Migration from the various sources of data using SSIS.
• Worked on Microsoft Dynamics AX 2009 ERP (Supply chain modules AR, AP and inventory management).
• Optimized the query performance with modification in T-SQL queries, removing unnecessary columns, normalizing database, establishing necessary joins, creating useful clustered and non-clustered indexes.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Worked on Integration of all the data processes in UAT/PROD.
• Did Unit Testing for all SSRS reports and SSIS packages.
• Documented business rules, created activity flow diagrams, and validated entity relationship diagrams.
• Designed and created various Test Plans, Test Cases based on the Business requirements.
• Performed execution of test cases manually to verify the expected results.
• Involved in Unit, Functional, Regression and User acceptance testing.
• Documented and reported various bugs during Manual Testing.
• Identified, tracked and documented remediation of issues during User Acceptance Testing (UAT).
• Retesting the resolved defects/issues after the developers fix the defects.

Confidential

Data Analyst

Responsibilities:

• Involved in gathering and synthesizing business requirements and translated them into functional and non-functional requirements to be used as input to the functional design specifications thus defining key challenger, project scope, requirements and project deliverables.
• Segregated requirements into high level and low-level Use Cases, activity diagrams using Microsoft Visio according to UML methodology thus defining the Data Process Models.
• Assisted Developers in Data Modeling using Entity Relationship Diagrams (ERD).
• Automated manual processing with SSIS to save resources.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Tested the entire data reconciliation process for multiple source and target systems.
• Documented Entity Relationship Models for establishing Table Columns and relationships between data.
• Used MS Access database and also defined tables, queries, forms, reports, and macros.
• Facilitated UAT testing with the users.
• Used SSIS Data Migration solution to migrate data.