SUMMARY

• Proficient in Data Analysis, Data Modeling, Technical Documentation with around 8+ years of experience in Finance Industry
• Performed Data Cleaning, Data Profiling, Data Analysis and Data Mapping operations to bring more insights onto the raw finance data and creating Data Flow Diagrams, Use Cases, Use Case Diagrams, Activity diagrams, Entity Relationship Diagrams and Data Integration.
• Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, Data Export and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages.
• Strong Knowledge in webAnalyticsprojects involving end-to-endAdobeAnalyticsdevelopment, support, and testing and data analysis.
• Performed in-depth data analysis and then involved in developingTableaudashboards after resolving data validation issues and doing multi-platform data source integrations
• General experience includes Business Process Analysis, Business Modeling, Business Intelligence, Data Warehousing, Data Modeling, User Acceptance Testing (UAT) and Implementation
• Extensive experience in involving Business Process Re-Engineering, Software Re-Engineering using RUP methodology and ERP Systems Implementation and Continuous Improvement techniques. Responsible for allcostdata in ERP system.
• Experience in data Extraction, Loading and Transforming of data at the Data Warehouse level as well as skilled in variousETLtools for design and development of work flows, transformations and mappings
• In depth technical knowledge and understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and ETL and Power BI, Tableau informatica.
• Excellent experience in maintaining sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting. Interface with internal customers. Provide ad-hoc reporting and analysis from data sources including PeopleSoft (SET) and Teradata.
• Experience in CreatingPricingreport creating using VLOOKUP, formula and Pivot Tables.
• Well versed with various types Software Development methodologies- Water fall, Agile, RUP, Iterative and extreme Programming.
• Experience in Software QA and Testing Methodologies, verification and validations in all phases of the SDLC.
• Expertise in creating Unified Modeling Language (UML) diagrams including Use Case diagrams, Class diagrams, Sequence diagrams and Activity diagrams.

PROFESSIONAL EXPERIENCE

Confidential - McLean, VA

Sr. Data Analyst

Responsibilities:

• Worked on Data Management and Business Solutions team, worked on Data Analysis, Requirement gathering, GAP analysis, Data Mapping and Testing of ETL and BI Reporting requirements
• Created source to Target data mapping document for reconciliation between different data systems.
• Worked on requirements gathering sessions with SME's (Subject Matter Experts), Business Analysts and Architects to understand requirements in terms of business.
• Performed intensivedataanalysis, technicaldatamapping in Teradata Mapping Manager for a new loan systemdatasource to be loaded to a newdatawarehouseusing Excel
• UsedAgile/Scrum method for gathering requirement, documenting user stories to discuss project specifications
• CreatePricingReport along with creating Pivot Table for review and compare against
• Worked on Gap analysis (AS-IS) & (TO-BE) by identifying existing processes, technologies, and documenting the enhancements needed to meet the end state requirements.
• Worked on SQL query (Oracle and TSQL) in analyzing and validating SSIS ETL databasedataware house processes.
• Worked on development of High-level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems
• Created Traceability Matrix to ensure that all requirements are covered in test cases.Skilled in various MS Office tools including MS Visio and MS Project
• Worked on Requirement Analysis,DataAnalysis and Gap Analysis of various source systems sitting and coming from multi systems. Responsible for BIDataQuality.
• Managed the implementation of new hierarchy design into enterprise data warehouse (Teradata)
• Scheduled data refresh onTableauServer for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Actively participated in reports in Access, Excel using advanced functions not limited to lookup, pivot tables, formulas
• Use SQL, PL/SQL to validate the Data going in to the Data Ware House Creating complex data analysis queries to troubleshoot issues reported by users.
• Involved in Building, publishing customized interactive reports and dashboards, report scheduling usingTableau server.
• Extensively usedSASprocedures like means, frequency and other statistical calculations for Data validation.
• Responsible for gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of BA testing
• Used JIRA for User Story requirements management throughout the Agile Sprints and development life cycle.
• Work with various data sources like excel, text, multi-layerXML(Accord format) to extract, transform and load the data into EDW for analyze and reporting.
• Conducted UAT (User Acceptance Testing) for multiple iterations by writing Test Cases and signed off the same after approval

Confidential, Madison, WI

Data Analyst

Responsibilities:

• Worked on analysis of end user requirements and business rules based on given documentation and worked closely with tech leads and Businessanalystsin understanding the current system.
• Involved in developing, maintain and enhance reports for various departments within the organization.
• Extensive daily/weekly reporting and analysis pertaining to company revenue, profit margin, and service
• Coordinated with third party vendors on implementingAdobeAnalyticsand GoogleAnalytics
• Worked on Exporting large data sets toexcelrelational worksheets,pivottables, create massive formulas andVLOOKUP’sto compare data and perform searches
• Used the Agile methodology to build the different phases of Software development life cycle. (SDLC)
• Involved in creating Dashboards as needed usingTableauDesktop andTableauServer
• Extracted data from the database usingSAS/Access,SASSQL procedures and createSAS data sets.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Performed requirement analysis, prepared user stories, functional requirements and issue logs using JIRA.
• Developed views, functions, procedures, and packages using PL/SQL & SQL to transformdata between source staging area to target staging area.
• Assisted in Integration testing, Regression testing and UAT. Analyzeddataand created reports using SQL queries
• Used various customer data to create dynamic BI presentations inTableau& PowerPoint
• Actively participated in developingdataflows & architecture models for the requirement and helped the business by creating business process flow & workflow models.
• Worked on Data Governance, Data management aspects and was responsible to maintain Business Glossary Referential Data & Data lineage in Metacenter and Collabra
• Managed the implementation of new hierarchy design into enterprise data warehouse (Teradata), Worked on exporting data using Teradata.
• Worked on data modeling and produced data mapping and data definition documentation.
• Worked ondatawarehousing projects dealing with ETL (extraction, transformation, loading) using various databases.
• Evaluate all SQL applications and prepare layouts for all logical models and maintain database objects for various application components
• Performed walkthroughs for Conceptual Data Model, Logical Data Model and Physical Data Model for validating designs for the enterprise data warehouse.
• Involved in Translating business concepts intoXMLvocabularies by designingXMLSchemas with UML
• Met with users and stakeholders to understand the problem domain, gathered customer requirements through interviews (group and one-on-one) along with JAD sessions Analyzed the business requirements and involved in writing Test Plans and Test Cases.
• Involved majorly in thedatamigration from legacy system to the new systems.

Confidential - Detroit, MI

Data Analyst

Responsibilities:

• Performed the requirement analysis and documented the requirements using Rational Requisite Pro. Interacted with business heads to finalize the Business Requirements for the application
• Involved in Developing ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems feeds.
• Assisted project team in preparing Functional Specification Document (FSD), developed non-functional requirements, and documented Business Requirements Document (BRD).
• Analyze and report on web performance using google andadobeanalytics
• Used Tableau to create and distribute daily, weekly, and monthly dashboards (KPI's) to relevant business units
• Involved in Designing and Administered Teradata Scripts, Tables, Indices and Database Objects
• Involved in Creating impactful dashboard in excel for data reporting by using Get pivot and VLOOKUP, helped in transforming raw data into meaningful, actionable information.
• Worked on Development Life Cycle process, implementing the Rational Unified Process (RUP) in all different phases.
• Involved in developingdataconversion strategy fordatamigration from legacy systems to Technology product modules.
• Assigned tasks among development team, monitored and tracked progress of project following Agile Methodology
• Extensively worked on development of Reporting Data Warehousing System.
• Worked on Generating data element matrix encompassing all the data element report wise including the data mapping for the data warehouse.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Wrote SQL queries to performDataValidation andDataIntegrity testing.
• Created Jira User Guide and performed training sessions to introduce Jira to the team.
• Performed felid-by-field mapping of interface between parent EMR system and downstream system. Performed Load and Stress Testing using Load Runner.
• Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Exclusively involved in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center.
• Worked on following applications Business Objects, Enterprise Architect, Toad, Plainview (project management), Microsoft Suite (Word, Excel, PowerPoint, Visio, Access, Project)
• Worked along with SMEs to Implement SDLC which included requirements specifications, design, analysis and testing.
• Participated in Coordinating and developing QA activities with team members to support the Scrum methodology.

Confidential, River Woods, IL

Data Analyst

Responsibilities:

• Analyzed the Business requirements and developed Test cases based on functional requirements, general requirements and system specifications.
• Involved in preparing test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Involved and reviewed Search engine optimization (SEO & SEM) techniques to track and improve website traffic to the client’s website and track the effectiveness of the digital content
• Worked with the fundraising teams to gather data migration andETL requirements, and preparing requirement documents.
• Reviewed the data model and reporting requirements for Reports with the Data warehouse/ETL and Reporting team.
• Performed Data Cleaning, Data Profiling, and Data Analysis and Data Mapping operations to bring more insights onto the raw finance data.
• Worked on exporting data using Teradata and involved in the development of Reporting Data Warehousing System.
• Involved in understanding the customer needs with regards to data, documenting requirements, developing complex SQL statements to extract the data and packaging/encrypting data for delivery to customers.
• Initiated detailed discussions/functional walkthroughs with stakeholders
• Work with developers in anagilework environment to develop data-driven software solutions, identify software bugs and write automated tests
• Actively participated in producing system documents, functional requirements, ETL mapping and modeling deliverables Worked with root cause of data inaccuracies and improved the quality of data by using Data Flux
• Worked with Data Modeling team to create Logical/Physical models for Enterprise Data Warehouse.
• Worked with developers and testing teams to ensure that the requirements are communicated accurately and that the system being developed is verifiable against the requirements
• Involved in Documenting/Executing business test cases
• Participated in Writing SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Involved in Tested whether the reports developed in Business Objects and Crystal Report are as per company standards.
• Involved in Testing Ad-hoc reports, drill down and drill through reports using SSRS and different detail, summary reports and on demand reports.
• Involved in pre and post session migration planning for optimizing data load performance.

Confidential, El Paso, TX

Data Analyst

Responsibilities:

• Interacted with Business Users to conduct thorough Requirements Analysis.
• Reviewed and analyzed the business environment and identified process improvements.
• Involved in extensive analysis on security trading cycles; provide consulting on financial disclosure, regulatory and compliance issue.
• Involved in interactions with the Subject Matter Expert, Project Manager, Developers, and the End-Users.
• Coordinated activities with project manager and various other teams using MS Project.
• Interacted with other Business Analysts for designing and implementation of Use Cases and Test Plans.
• Involved in developing Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Involved in reviewing test plans and test cases and ensuring test cases reflect user needs. Also responsible for conducting user training and user acceptance testing to ensure and verify system is designed according to user needs.
• Worked on SDLC, Business analysis, GAP analysis and Quality Assurance of application software in Agile framework.
• Involved in generation and execution of SQL queries.
• Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
• Assisted the Senior Business Analyst in writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).