SUMMARY:

• Over 8 years of Experience in various facets of working on IT Technical and Functional, with four years of experience in Design, Development and Implementation of Data warehouses as an ETL Developer. All other experience has been taken the biggest challenging roles on business operations such as a Business Analyst, ERP Sales Marketing, Business Development, Key Account Management and Team Management.
• 5 years of strong Data Analyst, Data Warehousing experience using ETL Informatica Power Center 9.1/8.6 Workflow Manager, Workflow Monitor, Repository Manager, Source Analyzer, Mapping Designer, Mapplet Designer, Transformation developer , Data mart, OLAP, OLTP.
• Worked closely with the Architects, Data Modelers and Data warehouse Architects in determining the exact business rules and functionalities required for the delivery of the work articles.
• Involved in all phases of the SDLC process starting with Requirements Analysis, Technical Analysis, Design, Build, Test, Deploy and Production support.
• Expertise in Logical Modeling, Physical Modeling, Dimensional Modeling, Star and Snow-Flake schema.
• Developed Data Migration and Cleansing rules for Integration Architecture OLTP, ODS, DW
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language UML .
• Strong business analysis skills and an understanding of the software development life cycle SDLC .
• Experienced in designing/developing SQL statements and queries for Oracle and SQL Server 2005/2008 databases for Data profiling and development.
• Proficient in developing applications using RUP or Agile/Scrum methodologies
• Expert in developing and updating existing processes and conducting gap analysis.
• Strong understanding of Extraction Transformation and Loading ETL Process.
• Extensive Experience in creating Tasks, Sessions, Worklets and Workflows in Workflow manager/designer.
• Worked on integrating data from flat files, CSV files into a common reporting and analytical Data Model.
• Experienced in performance tuning of Informatica Sources, Targets, Mappings and Sessions.
• Designed and developed complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Sorter, Normalizer, Sequence Generator, Router, Filter, Expression, Aggregator, Joiner and Update Strategy.
• Involved in Test Planning and execution for various Test Phases: Unit Test, System and User Acceptance Testing.
• Extensive experience with Oracle 11g/10g, SQL, Constraints, Views.
• Excellent communication, interpersonal, analytical and presentation skills. Flexible to adopt any working environment. Excellent problem solving, troubleshooting, issue resolution capabilities.
• Ability to excel and succeed in diverse environment and projects with strong determination, dedication and inclination towards customer satisfaction.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Analyst/Informatica Developer Confidential

Project: The EyeMed Data Warehouse project aims to build an integrated data warehouse for EyeMed which would address the organization's business reporting and analytics requirements. EyeMed aims to develop Informatica mappings to perform ETL process from different legacy heterogeneous systems AS400, Sales Force, Client Crosswalk, etc. and Facets to hpX data model at specified interval in the target system as Oracle. These ETL codes will help those who have Informatica as their technology stack. On top of this, hpX Data Warehouse BI Reporting team creates different reports for end users. The project is split into two releases and each release is divided into multiple phases.

Responsibilities:

• Interacts with Business Users, Business Analyst and source system owners to gather the Requirements and Business logics.
• Designs, develops Informatica mappings, enabling the extract, transport and loading of the data into EDW.
• Based on the requirements, creates Functional design documents and Technical design specification documents for each ETL Process.
• Designs, implements, documents ETL processes completely based on best data warehousing practices and standards.
• Involved in the complete SDLC system providing SOW, work to be done in detail, specifying both hardware and software involved Scope of Work to the client.
• Analyze requirement and design specifications to create test cases for manual automated testing
• Prepared Business Requirement Documents BRD's based on functional requirements collected from system users that led to appropriate scope of work for technical team during prototype development. Implemented agile methodology for the project life cycle and scrum framework for team management.
• Responsible for creating mappings as per technical design documents.
• Develops mappings in Informatica to load the data from various sources into the Data Warehouse using different transformations like Joiner, Aggregator, Update Strategy, Router, Lookup, Sequence Generator, Filter, Sorter, and Source Qualifier.
• Creates various Mapplets in designer using Informatica Power Center Mapplet Designer.
• Implements performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Tests data integrity among various sources, targets and performance related issues.
• Involved in Unit and System testing of developed mapping.

Business Analyst/Data Analyst

Confidential

• Historically Sports Authority provides a third party vendor with customer and sales transaction data to be merged and stored for marketing analytical purposes. This project allowed Sports Authority to store customer and sales data in-house for marketing analytics. This required integrating the customer information, customer demographic information, sales transaction information, and loyalty account information into the Customer Data Model for marketing to apply to campaigns and promotions.
• Responsibilities:
• Facilitated meetings among the Change Management, Problem Management and other relevant teams to discuss the impact of the changes, problem tickets and prepare project milestone plans.
• Met with various groups, including business owners, SMEs subject matter experts and marketing team, for requirements gathering in definition Stage.
• Actively involved in business modeling.
• Gathered requirements, developed Process Model and detailed Business Policies.
• Responsible to determine the GAP Analysis between the As-Is / To-Be Business Process Flows.
• Involved in business analysis and project management, coordinating between the team members according to the business requirements.
• Designed and implemented simple workflows using SharePoint modules and email notification.
• Transfer Customer documentation into SharePoint document management infrastructure.
• Designed requirements traceability matrix to trace and manage business requirements.
• Organized and conducted meetings, briefings, demonstrations, conducted JAD sessions, and wrote minutes of project meetings.
• Worked with an e - marketing team for online advertising and marketing of various products of the company.
• Worked with the project manager for planning and organizing the project activities, and in communicating with other business center managers and stakeholders of the project.
• Utilized Excel in performing special projects, creating spreadsheets, macros and filtering
• Involved in all major cycles and phases of the project from scope definition, cost/benefit and risk analysis to user acceptance testing and monitoring the release of the product.
• Actively resolved day-to-day technology needs of the business unit with a focus on the analysis of processes.
• Involved in project planning and coordination.
• Prepared the Business Workflow using MS-Visio with input, output, Pre and Post conditions
• Worked with the clients on the final signing process in the User Acceptance stages.
• Developed recommendations and designed solutions for process improvements.
• Responsible for submitting status reports to management summarizing completed projects/tasks.

Business Analyst/Data Analyst Confidential

Project: Confidential. is the largest health benefits company in terms of commercial membership in the United States. Through its network is nationwide, the company delivers a number of leading health benefit solutions through a broad portfolio of integrated health care plans and related services, along with a wide range of specialty products such as life and disability insurance benefits, dental, vision, behavioral health benefit services, as well as long term care insurance and flexible spending accounts.

Responsibilities:

• Analyzed and documented business requirements and detail design of the software for full understanding of the business.
• Interviewed Subject Matter Experts SMEs and Stakeholders to develop detailed use cases for functionality and process flow.
• Prepared Business Requirement Documents BRD's based on functional requirements collected from system users that led to appropriate scope of work for technical team during prototype development. Implemented agile methodology for the project life cycle and scrum framework for team management.
• Analyze requirement and design specifications to create test cases for manual automated testing
• Involved in the complete SDLC system providing SOW, work to be done in detail, specifying both hardware and software involved Scope of Work to the client.
• Planned and defined system requirements to Use Case, Use Case Scenario, and Use Case Narrative using the UML Unified Modeling Language methodologies.
• Participate in meetings with developers, project managers, and business analysts to discuss business requirements, test planning, resource utilization and defect tracking
• Preparation of Test Data for validating application's functionality.
• Establishing baselines, rerunning test scripts, comparing them with the baseline and reporting them
• Database testing by writing SQL Statements and executing with Rapid SQL on Sybase servers.
• Analyzed and validated SSIS ETL database data ware house processes.
• Preparing detailed quality status matrix and weekly status report on a weekly basis for the project members and management.
• Interacted regularly with Developers/BSAs to resolve technical/functional issues
• Used MS Project for scheduling project tasks, tracking completion of tasks and sending out biweekly progress reports to stakeholders.
• Analyze requirement and design specifications to create test cases for manual automated testing and maintain data warehouse content.
• Performed task decomposition, delegated tasks and monitored project milestones using MS Project.
• Implement and support the SDLC process flow per audit requirements

Business Analyst Confidential

Project: Confidential Corporation is the world-class email communication solutions provider of enterprise market information solutions for the clients like Sony Pictures, Cars Direct, Confidential Airlines, Confidential airways, Time Inc and Venetian. The initiatives are focused on improving the marketplace information to provide faster, more accurate, and more actionable market information to its customers globally.

Responsibilities:

• Responsible for analyzing/modifying business requirements with senior management Directors and VP's .
• Worked with the Project Manager and vendor in communicating milestones.
• Involved understanding the current business process, defining scope of the project along with position statement.
• Created test cases and tested approved business requirements for functionality test environment .
• Attended weekly scorecard and executive revenue management meetings with vendor using PowerPoint .
• Served as a liaison between business unit revenue management and IT in executing milestones.
• Worked with Revenue Cycle for the Revenue Project Management.
• Worked closely with revenue management analyst to establish facts and draw valid conclusions.
• Performed Gap analysis to ensure the projects is effective for the organization.
• Monitored client expectations through client involvement and communication throughout the lifecycle of the project, educated clients, stakeholders and end users on the benefits and risks associated with the project
• Validated business rules and all artifacts with users, approval and sign off.
• Review of Profit and Loss statements and worked with accounting staff to insure their accuracy.
• Provided technical and business knowledge to clients and worked with CRM
• Created traceability matrix to ensure comprehensive test coverage of requirements.

Jr. Business Analyst

Confidential

Project: This Sun Dial Application is a retail Desktop application for their Sun Glass Hut retail stores. They are implementing this application in Australia and New Zealand, in Sun Glass Hut, ILORI. This project is to enhance the Additions and Change Requests in Existing Application which we used for customers.

Responsibilities:

• Identified and validated high potential business opportunities for stakeholders and developed customized business strategies that are aligned with corporate strategic objectives.
• Gathered Business Requirements, analyze data/workflows. Defined the scope, financial projections and Cost/benefit analysis. Progressed from Problem Statement to well-documented Designs.
• Actively involved in validating the requirements and applying Agile Scrum throughout the SDLC. Collaborated in the creation and updating the Requirements.
• Interviewed clients and defined functional and non-functional requirements.
• Created URS-User Requirement Specifications and FRS- Functional Requirement Specifications documents.
• Designed Use-case and Activity diagrams using UML in Enterprise Architect.
• Reviewed and analyzed the Use cases and came up with System design and Test plan Templates.
• Worked as an Interface between the users and the different teams involved in the application development for the better understanding of the business and IT processes.
• Participated and co-coordinated the System testing, regression testing of various builds during integration, performance and User acceptance testing.