SUMMARY

• 7+ years of Industry experience as a Functional Business Analyst/BI Analyst with solid understanding of Business Requirements Gathering, Data warehousing, Business Intelligence, Data Mapping and Data Modeling.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
• Strong hands on ability to use SQL in RDBMS (SQL Server, Oracle) for verifying source data preparation and assisting of data design input and trouble - shooting.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Strong technical background in systems architecture, database design and network administration.
• Extensive experience working in back end tester by writing SQL Queries and PL/SQL scripts on large data warehouse systems involving Terabytes worth of data.
• Extensive industry knowledge in the areas of advanced project management methodologies, systems integration methodologies, industry trends, and application software.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall.
• Experience in dealing with different data sources ranging from Flat files, Oracle, Sybase, SQL server, Teradata, Ms Access and Excel.
• Extensive Data Warehousing experience using Informatica as ETL tool on various data bases like Oracle, SQL Server, TeraData, MS Access.
• Followed Unified Modeling Language (UML) methodology using ReqisitePro and Rational Rose to create/maintain: Use Cases, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS

Programming Languages: C, C++, C#, VC++, VB, VB.NET, C#.NET, ASP.NET, Java, SQL, PLSQ

Development Methodologies: RUP, AGILE, Waterfall, ESDM, STV

Databases: MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase

Application Servers: IBM Websphere, ATG Dynamo, BEA WebLogic.

Internet: HTML, XML, VBScript, ASP, JavaScript, JSP, J2EE.

Automation Tools: MS Visio, Rational Rose, Rational ClearCase, Rational RequisiteProBug Tracking Tools Confidential TestDirector, Rational ClearQuest

Utility Tools: MS Office Suite, MS Project, TOAD, Adobe Photoshop

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS)

Data warehousing Tools: Informatica, Business Objects, Cognos, Erwin

Testing Tools: Quick TestPro (QTP), TestDirector, WinRunner, LoadRunner

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr. Business Analyst/ BI Analyst

Responsibilities:

• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
• Interviewed Business Users to gather Requirements and analysed the feasibility of their needs by coordinating with the project manager and technical lead.
• Prepared Source to Target Master Mapping Document which identifies the services consumed by Web from Amdocs Billing system
• Transform disjointed data from several different sources including Business Objects, Spreadsheets, Remedy and other management tools.
• Conducted UAT (User Acceptance Testing) to make sure that all the user requirements are catered by the application.
• Used Microstrategy dashboards for data analysis and custom reports.
• Analyzed systems requirements and systems architecture /design.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Prepared the SRS for the project with approved version
• Proposed solutions to reporting needs and develop prototypes using SQL and Business Objects that address these needs.
• Design, development, implementation and roll-out of Microstrategy Business Intelligence applications
• Responsible for cost estimation and timelines for various Business Intelligence reports
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Designed, developed, and maintained various Business unit reports by using Teradata, SQL, and Ms Excel.
• Created Teradata SQL Assistant scripts, Temp tables to be compatible for the monthly segmentation and migrated tables.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using Business object and SSRS
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Performed numerous Ad-hoc requests, financial reports involving SQL scripts, UNIX, SAS and Teradata.
• Developed QA Test Plan, test conditions and test cases, as well as assisted with QA team in System Testing using Confidential Test Director
• Developed Report Models, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Used Rational Rose to model the process using UML to create behavioral and structural diagrams.
• Provided technical and functional consulting to corporate and divisional users for Cognos.
• Responsible for updating and maintaining the Share Point Documents, Issues and Action Items

Confidential, Schenectady, NY

Sr. Functional Analyst/BI Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Used Cognos BI for operational reporting
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Development of reporting solutions which include MS Access MS Excel and OLAP reporting via Hyperion Essbase.
• Developed front end process flows, Generated module specific reports using cognos ReportNet posted in the share point portal for the review of development team.
• Design, develop and provide unit test data loading and data transformation programs related to Netezza Data Warehouses and Data Marts
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse
• Responsible for cost estimation and timelines for various Business Intelligence reports
• Design, development, implementation and roll-out of Microstrategy Business Intelligence applications
• Worked on collaborating with end users for requirements discovery, ability to formulate hypotheses, sufficient familiarity with SQL to conduct data research in order to prove/disprove hypotheses.
• Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, and data dictionary and data analysis.
• Worked with Cognos and micro strategy reporting systems to extract the data for analysis using filters based on the analysis.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Performed numerous Ad-hoc requests, financial reports involving SQL scripts, UNIX, SAS and Teradata.
• Designed workflows using Informatica Power Center to perform ETL on the data from the staging area to the transaction enrichment data store and to the compensation data marts.
• Worked with SQL queries using MS Access for data manipulations.
• Carried out UAT by developing test plans, test scenarios, test cases, and test data to be used in testing based on business and user requirements, technical specifications of the product.
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Supported User-Acceptance phases by performing data validations and metrics calculation across every layer including source systems, Staging, Mart and Microstrategy layer.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• Created Graphical representation of reports such as Bar charts, Pie charts etc as per the End user requirements using Business Objects and Crystal reports.
• Created UNIX shell script for processing data files from source system, for archiving and running the workflows.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Used Data warehousing for Data Profiling to examine the data available in an existing database.
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.

Confidential, San Jose, CA

Business Analyst/BI Analyst

Responsibilities:

• Analysed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Led the development of a training program to train users on a custom web application and a Cognos ad-hoc reporting environment.
• Wrote Teradata scripts for data manipulation, data inserting millions of records into tables.
• Developed script to perform Data validation on Account level by using Teradata SQL Assistant, SQL scripts.
• Assisted the IT team to develop service oriented architecture (SOA), and data warehouse system to utilize data mining for data analysis.
• Transferred data (ETL) to Data ware house Environment using SSIS and SSAS.
• Building the cubes by using SSAS.
• Automated Shell scripts to pull and load data from operational resources into the Data Staging Area and Data Warehouse for business intelligence reporting.
• Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of RUP effort in different iterations and phases of the Software Development Life Cycle.
• Experience in data governance/ data stewardship business/systems analyst needed to work as part of a team on data governance and writing SQL queries.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Manage Scope and change throughout the SDLC process of the product.
• Created source table definitions in the Data Stage Repository by studying the data sources.
• Wrote Test Cases in Confidential Quality center that would test various Test scenarios.
• Wrote Test plan and Test cases for the Integration testing and system testing.
• Did Integration Testing, GUI testing, Smoke and Sanity Testing, and Acceptance testing in the new builds for Basic Functionality Checking.
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Wrote detailed specifications for various reports generated using Cognos
• Served as a resource for analytical services utilizing SQL Server, and TOAD/Oracle.
• Run the SQL queries using TOAD and SQL Navigator.
• Used XML for building and parsing of Application Configuration file.
• Owned the entire reporting process. Interacted with the ETL team, developer(s), management, and account holders to get the requirements, document them, design templates, and write specifications.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Facilitate JAD sessions involving the management, development and user teams for clarifying requirements and facilitating better communication.

Confidential, Jacksonville FL

Business Analyst

Responsibilities:

• Acted as primary liaison between the client departments and the Information systems IT department to perform analysis, review, and estimation of client requests, prepared and reviewed requirements and client documentation for Personal Lines Property and Casualty business.
• Interacted closely with End users from Underwriting & Claims teams and SMEs to understand and gather the business needs and requirements.
• Collaborated with External Auditors and documented SOX compliance requirements
• Develop direct mail and email marketing initiatives using Unica Affinium Campaign and SQL
• Managed the database using SQL and Unica Affinium Campaign to execute queries
• Performed Data Mapping by moving the data from the Subscriber member database to Bus layout on the mainframe.
• Data transfers from text files and Access databases using BCP and DTS; Data mapping and transformations while loading data using VBScript
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
• Created a cross walk to gather the data items such as authorization status, error messages from back end processing system, co-pay, co-insurance, non-covered amount and deductible from XML responses.
• Work closely with production underwriters to review commercial property insurance renewal and new business opportunities to ensure proper risk identification, analysis and assessment and the development and growth of a profitable portfolio of business.
• Worked on Property and Casualty insurance company as an Underwriter. Strong understanding of rating in Property and Causality.
• Involved in generating Test cases for property and casualty Insurances for Different Levels of Business.
• Worked directly with business users to gather, document and implement requirements to improve Marketing campaign delivery capabilities; including enhancement project management.
• Accumulated system requirements from various departments through surveys and interviews.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
• Worked for a project to customize and integrate a Business Process Management (BPM) solution.
• Worked extensively with MS Excel and MS access
• Responsible for special projects requested by company management or reinsurance broker involving analyzing underwriting revenue and financial performance for companys reinsurance broker.

Confidential, NY

BI Analyst

Responsibilities:

• Conducted one to one interviews with Manager to gather Business Requirements and was involved in the documentation of Business Requirement Documents.
• Created Project management plans for managing on time delivery using MS Project along with writing test cases, and systems integration test plans in Test Director.
• Provide business intelligence analysis to decision-makers using an interactive OLAP tool
• Architected Extract, Transformation and Load processes (ETL) to populate an operational data store from various sources including other databases like Teradata, SQL, Oracle, spreadsheets, and flat files.
• Extensively worked in the performance tuning of programs, ETL procedures and processes.
• Analyze requirements utilizing various methods. (E.g. sample data from SQL queries, Screen Shots, reports, prototype screens, sourcing information, and other data models.)
• Worked on data modeling and produced data mapping and data definition documentatio
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Performed data analysis and ran various SQL queries to critically evaluated test results
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Designed and developed Project document templates based on SDLC methodology.
• Conducted user interviews, gathered requirements, analysed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro.
• Developed Business Requirement Document as well as High-Level Project Plan.
• Met with users and stakeholders to understand the problem domain, gathered customer requirements through surveys, interviews (group and one-on-one) along with JAD sessions.
• Developed Functional Specification Document and Supplementary Specification (non-functional) Document.
• 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 Acceptance Testing.