SUMMARY:

• Expertise in Enterprise Data Warehouse, Business Data Analysis, Data Integration and Business System Analysis.
• Strong in translating business requirements and user expectations into detailed functional specifications.
• Strong experience in configuring data mapping between different Schemas and Databases.
• Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.
• Designing and developing SQL statements and queries for DB2 and SQL Server 2000 database.
• Experience in writing SQL queries and optimizing the queries in SQL Server 2000.
• Ability to gather business and technical requirements from both formal and informal sessions.
• Proficient in discussing and defining project, Gap Analysis with the clients from both a business and technical perspective.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Pro - model, MS Excel, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and development.
• Good understanding of Use Case Model, Analysis Model, Design Model, Implementation Model, Use Case Diagrams, Behavior Diagrams (Sequence diagrams, Collaboration diagrams, State chart diagrams, Activity diagrams), Class Diagrams.
• Worked extensively on user requirements gathering, gap analysis, and development of functional speculations for critical mission accomplishing projects.
• Experience inputting data using SAP
• Generates various reports (Create sales, orders received/ invoiced, change sales orders, generating outbound delivery report) on an as needed basison SAP. able to write formulas, create graphs and work with pivot tables on excel, Access resolve user problems by communicating with end users and by translating technical problems from end-users to technical support staff. install hardware, software, and peripherals; run diagnostic software; utilize mainframe and/or client server software to provide system security access; and accommodate user requests for computer hardware and software
• Proficient experience in designing, developing, and testing of applications on MS Access Platform. Provided support for multiple Production MS Access applications for various departments
• Knowledge of web design principles
• Developed and maintained accurate network documentation and Visio diagrams to provide management with proper understanding of organizational needs
• Highly motivated, result oriented professional with a short learning curve and strong communication skills

TECHNICAL SKILLS:

Programming Languages: Java (Core), C, C++, and VBA, HTML, CSS, JavaScript

Databases: MS Access 2007 & 2010, MYSQL, and ODBC

Operation System: Windows 2000, XP and windows 7, Mac OS X, Windows server 2008

Software Application: MS Office 2007 & 2010, Exchange 2010, Visio 2010, Adobe Dreamweaver CS5, Eclipse SDK, AutoCAD, Photoshop, Corel draw, Page Maker and Light room.

Methodologies: Unified Modeling Language (UML), Software Development Life Cycle(SDLC)

PROFESSIONAL EXPERIENCE:

Confidential, Brooklyn, NY

Business Data Analyst

Responsibilities:

• Created Business Requirement Documents, Technical Requirement Documents and high level Requirements Traceability Matrix.
• Essential member of the Data Analytics team; responsible for providing proactive report solutions and advanced data analytics in support of the strategic goals of the corporation.
• Analyze data and prepare ad hoc and standard reports for users related to health care services, utilization, costs, trends, etc.
• Utilize reporting tools such Toad for Oracle, BOE, and Crystal Reports daily, to extract data from Oracle databases.
• Conducted TRD walkthroughs with development team to explain all the functional requirements and made sure that all open questions/issues are resolved for a smooth development process.
• Worked on end to end projects from requirements to deployment phase.
• Thoroughly validate own work and the work of peer Data Analytic team members.
• Contribute in the and assimilation of team members regarding particular reporting duties.
• Gathering business requirements and transform them into functional requirements.
• Conducted JAD Sessions periodically with various stakeholders at various phases of the System Development Life Cycle (SDLC) to discuss open issues and resolve them.
• Facilitate daily team meetings and manage the customer Inbox in weekly rotations.
• Assist in report migrations by performing system testing of new reports to locate defects if any are present.
• Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.
• Responsible for requirement and design documentation review, test plans, identifying and reporting software anomalies and test results.
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Supported data warehousing, data profiling, and Enterprise Service model standards in designs, and developed standardization of processes like configuration management.

Environment: DB2, MS Access, MS Visio, MS Word, MS Excel, Clear Quest, Informatica Data Explorer, MS SQL Server, RAA

Confidential, Schaumburg, IL

Business Data Analyst

Responsibilities:

• Conducted one to one interviews with Portfolio Manager to gather Business Requirements and wasinvolved in the documentation of Business Requirement Documents.
• Assisted the Project Manager in setting realistic Project expectations and in evaluating the impact ofchanges on the organization and plans accordingly and conducted Project related presentations.
• Identified internal and external system Requirements, design and configuration set-up.Assisted with development of strategy for managing SharePoint permissions in conjunction with Active
• Directory and future implementation of Identity Lifecycle Management functionality
• Constructed and maintained UML models using Visio and created use case diagrams, class diagramsand sequence diagrams for all the use cases
• Design, development, implementation and roll-out of Microstrategy Business Intelligence applications
• Translated the Business needs into system Requirements, communicating with the Business on abroader scale and with an in-depth view.
• Designed and developed Project document templates based on AGILE methodology.
• Developed Business Requirement Document as well as High-Level Project Plan.
• Functioned as the primary liaison between the Business line, operations, and the technical areasThroughout the Project Cycle.
• Developed Functional Specification Document and Supplementary Specification (non-functional)Document.
• Coordinate with Program/ Project Managers and their teams, keeping the business and IT team up-to-date/ informed about scope changes, as and when approved, analyzing the business impact on the initiative
• Collaborate with UI development team the development of User Interfaces, and secure sign offs from the business team in light of the validated Business/ System Use Cases achieving the most intuitive User experience
• Conduct analysis for change-requests, walk-thrus, advise the concerned Project Managers, BSAs and technical teams on the impacts of the changes
• Facilitate virtual meetings utilizing GotoMeeting, and Intercall to validate requirements with the Developers, SMEs, and QA Team during the entire project

Environment: Quality Center, MS Project, Visio, SQL.

Confidential, Bedminster, NJ

Business Data Analyst

Responsibilities:

• Designed & Created Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document)
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment
• Developed separate test cases for ETL process (Inbound & Outbound) and reporting
• Involved with Design and Development team to implement the requirements.
• Developed and Performed execution of Test Scripts manually to verify the expected results
• Design and development of ETL processes using Informatica ETL tool for dimension and fact file creation
• Involved in Manual and Automated testing using QTP and Quality Center.
• Conducted Black Box - Functional, Regression and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios)
• Defects tracking, review, analyzes and compares results using Quality Center.
• Participating in the MR/CR review meetings to resolve the issues.
• Defined the Scope for System and Integration Testing
• Prepares and submit the summarized audit reports and taking corrective actions
• Involved in Uploading Master and Transactional data from flat files and preparation of Test cases, Sub System Testing.
• Document and publish test results, troubleshoot and escalate issues
• Preparation of various test documents for ETL process in Quality Center.
• Involved in Test Scheduling and milestones with the dependencies
• Functionality testing of email notification in ETL job failures, abort or data issue problems.
• Identify, assess and intimate potential risks associated to testing scope, quality of the product and schedule
• Created and executed test cases for ETL jobs to upload master data to repository.
• Responsible to understand and train others on the enhancements or new features developed
• Conduct load testing and provide input into capacity planning efforts.
• Provide support to client with assessing how many virtual user licenses would be needed for performance testing, specifically load testing using Load Runner
• Create and execute test scripts, cases, and scenarios that will determine optimal system performance according to specifications.
• Modified the automated scripts from time to time to accommodate the changes/upgrades in the application interface.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: Windows XP, Informatica Power Center 6.1/7.1, QTP 9.2, Test Director 7.x, Load Runner 7.0, Oracle 10g, UNIX AIX 5.2, PERL, Shell Scripting

Confidential, Knoxville, TN

Business Analyst

Responsibilities:

• Interview various stake holders and get their ideas as to how they envision their future web-presence.
• Ensure that this opportunity is used to maximize the benefit and all new functional requirements for both the portals are incorporated into the new system.
• Analyzing their internal and external processes, practices, and SOPs, mapping those to the specific business needs and functional requirements.
• Documenting the new enhancements to ensure the proper integration with various internal and external processes to ensure the of a higher level of efficiency and automation for a smooth experience for both, external, as well as internal users.
• Compare, analyze and map the As-is business processes, to highlight and define the Gaps, and then create the new Process flow diagrams, which would result into the desired data-flows and Use Cases.
• Document the As-is systems architecture to better understand the impact of the new portals’ merger.
• Participated in the Logical and Physical Design sessions and developed Design Documents.
• Worked with developers to make sure that they understood the Use Cases.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Partnered with the Technical Areas in the research and resolution of System and User AcceptanceTesting.
• Worked with Quality Control Teams to develop Test Plan and Test Cases.
• Develop User Manuals, and Manuals as per Project Specifications and timelines.

Environment: Windows XP/NT/2000, JSP, Java, Oracle, SQL, PL/SQL,, MS Visio, MS-Project, MS-Office Suite, Quality Center 9.0