SUMMARY:

• A Data Analyst with six - plus years of field experience serving diverse client base in Confidential . Management qualification combined with demonstrated ability to develop and implement technical solutions to meet critical business needs. An excellent communicator between technical and business units who can translate complex data into easily understood terms. Strong Business analysis skills accompanied with Data warehousing and testing skills.
• Business Impact Analysis
• Strategic Planning
• Financial Analysis
• Technical Support, and Documentation
• Application Analysis and Development
• Agile Methodology.
• Problem Identification & Resolution
• Systems Applications Design and Implementation
• Data warehouse
• Quality Assurance and Management

TECHNICAL SKILLS:

Operating Systems: Windows, Mac, UNIX

Software: MS Office suite (inclusive Front Page, Project, Visio), MS SharePoint site administrator. Rational ClearQuest, HP/Mercury Quality Centre, Remedy, Altova XML Spy

Languages: UML, HTML, XML, JAVA J2EE, SQL, JavaScript, C++, C#, VB Script, .NET

SDLC Methodology: Rational Unified Process (RUP), Waterfall, Agile Methodology and Scrum.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

DATA ANALYST

Responsibilities:

• Leverage strong business knowledge of the investment banking sector to help design viable solutions.
• Involved in creating Data Flow Diagrams for Database of the Investment Portfolios
• Manages disbursements of home and mortgage insurance payments three weeks prior to due date.
• Worked with development team on Agile methodology (Rapid Application Development) of Software Development Lifecycle.
• Collaborate with financial analysts, investment analysts and accountants to collect and understand business requirements
• Involved in the design of system so that it would fully integrate the client’s portfolio management, trading, operations and reporting functions to facilitate Straight through Processing of client’s investment operations.
• Prepared an analysis report based on the COTS evaluation.
• Designed data models, logical models, data dictionary, data mart, data warehouse data mining, conceptual and logical relational database, star schema, extended star schema, tables, columns, attributes, relationship (primary, foreign, composite keys), sorting, sequencing, stored procedures, triggers, search criteria and Prototypes.
• Designed the Dimensional Model of the Data Warehouse Confirmation of source data layouts and needs
• Identified the Data Sources, ETL methods, OLAP designing and Reports required for the Business Intelligence Project.
• Data mapping, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Developed reports in Microsoft Access to show store performance and compliance.
• Extracted the data fromSQL Server,Oracle, Files,and Access intoData warehouse.
• Extensive experiences with configuring and enabling log shipping on SQL servers to resolving issues with log shipping and monitoring log shipping with automated notifications.
• Designed Data Stage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Organized various UAT sessions and made presentations to the users on the project and the changes implemented.
• Reviewed several test plans and test scenarios with the QC team for each project worked on.
• Successfully conducted Root Cause Analysis to identify the underlying issues and design solutions accordingly.
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements using UML.
• Designed and developed Use Cases and UML models using Microsoft Visio.
• Conducted JAD sessions to resolve critical issues
• Responsible for creating and reviewing business requirement documentation(BRD), functional specifications (FSD), project schedules and test plans
• Helped in migrating from the legacy system to the proposed new process systems
• Responsible for Application Documentations and served as a liaison between the business team and the technical team by assisting in identifying, understanding, and documenting their business requirements
• Assisted the Project Manager in setting realistic project expectations, in evaluating the impact of changes on the organization and conducted project related presentations.

Confidential, NYC, NY

DATA ANALYST

Responsibilities:

• Facilitated meetings with user community to gather requirements and define project timelines.
• Interact with business stakeholders from multiple departments including: Card Finance, Accounting, Third Party Investor Reporting and Capital Market and led meetings and interviews.
• Served as Data Analyst on data warehousing projects,business process design, identifying and implementing system improvements and liaison to various business groups throughout the company.
• Responsible for business system analysis of customizing the BPS Risk Management product with involvement through the whole SDLC
• Performed Data mapping, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping
• Prepared an ROI analysis report after evaluating the COTS product of the multiple business lines
• Documented business, process, work, system, information flows using modeling techniques Unified Modeling Language (UML 2.0) diagrams; State Transition, Activity, Class, Sequence
• Uses UML to produce AS IS and TO BE models
• Created multiple database applications in Access to improve efficiencies in support of our clients businesses
• Created queries and pulled data into MS Access 2007 and MS Excel 2007 for analysis and reporting
• Create Data Flow/ Data Lineage Diagrams (DFD/DLD) to depict the source-to-Target Mapping and Data Lineage Analysis.
• Transferred data using the ETL process from the existing database to the new system.
• Transferred data (ETL) to Data ware house Environment using SSIS and SSAS.
• Utilized corporation developed Agile SDLC methodology.
• Worked with data warehousing team to design, develop, and implement data warehouse and in-house decision support system.
• Maintained the data integrity on thedata warehouse table
• Worked closely with CTO in writing Stored Procedures in MS Access and MS SQL for structure consistency.
• Queried database using SQL
• Wrote ad-hoc queries in SQL for report generation
• Develop SQL queries as part of Testing, perform end-to end testingin System and Staging environments.
• Participated in the as-is system/process understanding to gather the pain points and missing functionality in the existing system
• Documented all the requirements in use case format and created the BRD inclusive of the eco-system view, high level use case view etc.
• Played a key role in developing the HTML prototype, reviewing it with the business users and getting sign-off.
• Performed Gap analysis by comparing the current and future system functionalities.
• Participated in creating the functional, system and integration test cases
• Responsible for executing the test cases and documenting the test results
• Performed functional, regression testing and negative testing by applying boundary value analysis technique for the AUT.
• Developed SQL queries for data validation
• Tested various sprints using Agile methodology
• Discussed the defects raised in testing, with developers and project team and follow until defect closure.

Confidential, Chicago, IL

DATA ANALYST

Responsibilities:

• Interacted with Subject matter experts of different business groups to establish the details of transactions (options, swaps etc) managed by that group and also build the profile of users that will be accessing the system and document the same.
• Designing and customizing data models for Data warehouse supporting data from multiple sources on real time.
• Involved in the analysis of the existing data mapping phase according to functionality and data conversion procedure.
• Participated in various vendor selection processes and conducted Cost-Benefit Analysis of COTS products and comparison between COTS and In-house developed components.
• Analyzed the Data Mart structure of the data warehouse.
• Involved in creating Use Cases, Sequence Diagrams, Collaboration diagrams, Activity Diagrams, Class Diagrams, Business Intelligence Tools etc
• Developed data integrity procedures and quality control reports using SQL and UNIX Sync Sort.
• Mappedtest cases from Excel toSQLby using Data Transformation Services.
• Updated the impacted MS Access tables.
• Used UML during requirements gathering and created Use Case Models and Use Case Diagrams for the purpose of stakeholders in the project to help them understand the workflow of the system associated with the requirements.
• Involved in retrieve, insert and modify of Access database information.
• On execution of each cycle, validated the test results using the SQL queries and also looked at the generated actuate reports
• Implemented SQL queries and generate reports to ensure database data integrity and meets user requirements.
• Excellent knowledge of analyzing requirements for data migration, data reconciliation, mapping rules, staging rules and transformation rules for the ETL processes.
• Documented all the requirements in a structured BRD format that included multi-level functional views broken down by functionalities.
• Conducted workflow, process diagram and Gap analysisto derive requirements for existing systems enhancements.
• Played a key role in developing the EXCEL based wire frame design, reviewing it with the business users and getting sign-off
• Participated in creating the functional, system and integration test cases
• Responsible for executing the test cases and documenting the test results

Confidential, Philadelphia, PA

DATA ANALYST

Responsibilities:

• There was a requirement to translate a number of manual operational processes from the legacy systems into the enterprisedata warehouse. With the client acquiring another company, there was a need to consolidate the varied processes into a single repository in thedata warehouse.
• Designed the Dimensional Model of the Data Warehouse Confirmation of source data layouts and needs
• Gathered business and technical requirements for customizations impacted by service changes and set rules for proper data transfer from Data Source to Data Target in Data Mapping.
• Followed the UML based methods using Rational Rose/MS Visio to create: Use Cases, Activity Diagrams / State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Worked with Switch Boards in MS access
• Manipulated MS Access data within forms, tables, programming code, and by using action queries
• Performed backend testing to check the system data integrity for insert, update, delete and retrieve transactions by writing complex SQL queries including joins, group by, having clause etc.
• Used SQL to query the database and performed data analysis.
• Conducted weekly meetings and Conferences with the clients to review functional requirements and eliminate ambiguities.
• Worked as Test lead and developed Test Strategy, plan & test cases; worked with test team for test cases execution
• Worked with Data Warehousing team (ETL) in cleansing, mapping and migrating Data of existing loans for Loan Consolidation.