SUMMARY

• 7+ years of experience as a Sr. Business/System/Data Analyst having in - depth experience in design, development, testing, security and support of Data Warehousing and Client/Server projects.
• Expert in at designing & developing BI solutions in Data Warehousing using Cognos suite (Framework Manager, Cognos connection, Report Studio, Analysis Studio, Metric Studio, Event Studio and Query Studio)
• Strong experience in Data Analysis, developed Ad-hoc reports and complex reports (e.g. reports from multiple data sources with drill down capabilities) by using Crystal Reports.
• Knowledge of understanding of b Data Warehouse experience building OLAP cubes using Cognos TM1
• Deft at developing logical models
• Worked in various technologies such as XSLT, XPATH, CSS, XML, and HTML.
• Experience on Teradata SQL assistant 14.1.0, MS SQL server, writing SQL queries, PL/SQL operations - functions, triggers and PL/SQL block statements providing Business Relations by developing & implementing Database Schemas like Star & Snowflake schema concepts used in relational, dimensional & multidimensional modelling.
• Thorough understanding of Software Development Life Cycle (SDLC) in designing, developing & implementing enterprise scale information management applications, reporting and handling multiple projects.
• Developed User Interface using Microsoft Visio, and developed web pages using SharePoint 2013
• Views and reporting tools like SSRS BIDS, Tableau, Qlik-View, Crystal Reports, and Power Pivot etc.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like OBIEE Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Have considerable expertise in Metadata Management, Data Analysis, Data Profiling & Quality, Data Governance and Master Data management (MDM).
• Perform complex MS excel operations using Pivot table, filter operations on the underlying data
• Deft at using Report Studio to customize functionality in prompt page, Master detail relationship, Drill through in Report page, Customized Prompts & Conditional Formatting and Ad-hoc reports using Cognos Query Studio
• Extensive experience in developing Use Cases, creating Screen Mock-ups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Write & maintain technical documents for reports development, logic, coding, testing, changes, & corrections
• Extensive experience with Business Intelligence, Data Warehousing, ETL processes and BI reporting projects.
• Designed documents in Confluence, maintained JIRA issue tracking in confluence and used MS Office, Share Point for sharing project documentation
• Provide clear understanding of Business Intelligence and Data Warehousing concepts with emphasis on ETL tool like Informatica and life cycle development; train end users and provide technical support and documentation
• Team-oriented, technically motivated and user oriented with a desire to learn client's business requirements; ability to adapt and learn new technologies and get quickly proficient with them

TECHNICAL SKILLS

Operating Systems: Windows, UNIX, Linux

Languages: UML, SQL, HTML, XML, C, C++, Java, Visual Basic 6.0/.Net

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

SDLC Methodologies: RUP, Waterfall, Agile (Scrum, XP), RAD

ETL/BI: Informatica, Crystal Reports, Business Objects, SQL Services Reporting Services, MicroStrategy (MicroStrategy Desktop Designer, MicroStrategy Architect, Object Manager, NarrowCast Server, Administrator), Cognos.

Testing Tools: QTP, Mercury Quality Center, Rational ClearQuest, LoadRunner, WinRunner

Other Tools: MS Visio, MS Office, Erwin Data Modeler, TOAD, Management Studio, PL/SQL.

Reporting tools: Business Objects, Tableau, Crystal Reports, and SSRS & PowerPivot.

Data Modeling Tools: Erwin, Transformer.

PROFESSIONAL EXPERIENCE

Confidential, Tennessee

Business Analyst/ Business Intelligence Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analysed the feasibility of their needs by coordinating with the project manager and technical lead.
• Collects requirements from department managers and users for enhancements. Acts as liaison between clients and development. Facilitates sessions to bring business requirements and functionality into SAP system development and enhancement.
• 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.
• Designed Datastage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Collaborated with Basel II team on credit risk analysis and issue resolution.
• Communicated the implementation of the new calculation framework of Risk Weight Asset under Basel II.
• Led development and documentation of data governance policy and procedures as well as Stewardship inventory and control set up processes for MDM projects.
• Followed Agile/Scrum methodology for the life cycle of the project.
• Developed user stories and attended stand up meetings on a daily basis.
• Prepared for GAP Analysis; identified and documented improved areas to meet capital requirement regulations for Basel II Compliance.
• Enhancing supporting documentation (policies, frameworks, standards, methodologies, and modeling documents) to demonstrate compliance with the Basel II Accord.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Was responsible for indexing of the tables in that data warehouse.
• Reverse Engineered the existing ODS in to Erwin.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Created and maintain data model/architecture standards, including master data management (MDM)
• Worked on data modeling and produced data mapping and data definition documentation
• Configured the Data mapping between Oracle and SQL Server.
• Performed extensive data modeling to differentiate between the OLTP and Data Warehouse data models.
• Tested Performance & Accuracy related queries under SQL Server
• Designed and implemented basic SQL queries for testing and report/data validation
• Manage Scope and change throughout the SDLC process of the product.
• Created Use cases, activity report, logical components and deployment views to extract business process flows and workflows involved in the project. Carried out defect tracking using Clear Quest.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Managed backlogs within the agile projects.
• Used Data warehousing for Data Profiling to examine the data available in an existing database.
• Created custom reports in Payables in OBIEE according to user requirement
• 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.
• Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
• 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 noledge.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: Office Suite, Microsoft Visio, Documentum, MDM, Oracle, PL/SQL, SQL Server, Sybase, EVPN, IBM WebSphere Business Process Modeller, VBScript, Adobe Photoshop, ACORD, C#. NET, ASP.NET, XML, Agile, OBIEE, Test Director, LoadRunner.

Confidential, San Antonio, Texas

Business Analyst/Data Analyst

Responsibilities:

• Worked as data analyst from the PBM side of CVS.
• Conducted interviews with clients to analyse their data.
• Ensured all artifacts complied with corporate SDLC Policies and guidelines.
• Gathered requirements and translated the business details into the Functional Specification Documents that described the different types of processes.
• Captured requirements and worked with SMEs and Solution Architects in alignment process.
• Created application supporting documents including Non-Functional Requirements, user manuals, material etc.
• Retrieved data from Sql Server database, Create SSRS drill down reports and published them in SharePoint.
• Document all Data Mapping and transformation processes in the Functional Design documents based on the business requirements.
• Worked as a bridge with business and functional owner during risk engineering sessions and high-level review sessions to derive and execute action plans, meeting deadlines and standards.
• Implemented and incorporated all the HIPAA standards.
• Work as a member of a virtual development team where members of the team were physically located in different parts of the world.
• Created Requirement Traceability documents, tracing all functionalities down to the details of all business requirement documents, Use cases and CorpAdmin logics.
• Translated the reporting requirements such as defining the KPIs, volumetric to the Microstrategy reporting team.
• Extensively involved in Data Mapping, Data Modeling and Data Validations in all Reporting process.
• Implemented RTM (Requirements Traceability Matrix) and Business Requirement Specification Documents and also verified the functionality coverage.
• Worked with various vendors like sure script and Mirixa.

Environment: Waterfall, MS Word, MS Excel, MS PowerPoint, MS Visio, MS Project, Share Point, Teradata, PL/SQL, SQL Server Management Studio, .NET Framework, Visual Studio,, XML, C#

Confidential

Business Analyst/Data Analyst

Responsibilities:

• Actively engaged with off-site Third party integration (Cognos) partners in requirements gathering and discuss UI design and technological solutions. Conducted and lead requirements elicitation meetings with end users to document system requirements and management of these requirements
• Acted as a resource in understanding how the UODS (ETL Process) & Usage Data Warehouse systems carry out their business functions and assist in ensuring the timely and effective implementation by conducting Gap Analysis to derive requirements for existing systems enhancements.
• Experience in writing SQL queries for the data validation exercises using Oracle SQL Plus, SQL Server and TOAD.
• Designed, development and deployed InfoPath Forms to SharePoint Forms Library and lists.
• Improve existing business data processes with Lean Six Sigma and DMAIC methodologies; verify improvements with statistical tools
• Database management using SQL Server Management Studio for company CRM software Data reporting and analysis using SQL and MS Excel.
• Identified, investigated, analysed, defined and documented business processes and their Critical Success Factors (CSF) by conducting JRP sessions and heavily interacted with the IT Group by conducting JAD sessions to ensure project deliverables.
• Authored Business Requirement Document (BRD) and analysed the possible technical solutions, gathered business requirements from SME's and translated them into functional requirements and Business requirement documents using the Agile Methodology.
• Documented various current technical and business processes, understood the technical requirements from the various WOL groups to create, Data Mapping documents, WOL extract specifications to be sent UODS (ETL process) and UDW system.
• Worked on creating and updating UDW Cognos customer and product YTD reports and generated reports using Cognos. Worked with the developers for creating various DataMart’s from data warehouse and generated drill down reports using Cognos.
• Created an extract specification and related data mapping file for the product database team to send the related product information into the Usage Operational Data Store (UODS) & Usage Data warehouse (UDW) for generating reports in Cognos. Validated the data sent that was in UODS (ETL process) through manual and automated procedures.
• Wrote standard and complex SQL queries to perform data validation to make sure test results matched back to expected results bases on the user needs

Environment: Windows, TOAD, SQL, MS Project Plan, MS Visio, Oracle, Cognos, XML, XHTML, Java, J2EE, MS Office Suite.

Confidential

Business System Analyst

Responsibilities:

• Followed the SCRUM methodology for the entire SDLC.
• Facilitated JAD Session to understand user requirements, design applications and define business processes for Supply chain manufacturing and logistics in IT operations.
• Worked one Business and eMarketing data collection, design, implementation and reporting.
• Worked with the project manager for planning and organizing the project activities.
• Organized JAD sessions to resolve issues and conflicts, and to arrive at quick agreements regarding the system architecture design.
• Interacted with premium distributors, dealers to understand the pro and corns of the product & its distribution system, its impact on the overall supply chain.
• Planned and worked with the online marketing team to develop Direct-to-customer initiatives.
• Played key role in developing and driving continuous improvement initiatives in Supply Chain & Logistics Function.
• Worked with development team for handling of shopping cart and accounts management.
• Coordinated bug fixing activities related to issues rose during end - User Acceptance Criteria.
• Wrote test cases based on the business requirements, which involved market risk analysis and risk management.
• Created programs to analyse legacy system data and generated error reports.
• Synthesized test data through various sources, Records/ensures/SME/BA/meetings and facilitated Testing Performed functional, integration, system, UAT and regression testing Identified problems and isolated software defects, data issues and user issues.
• Actively interacted with other corporate departments, including executive, shipping, legal and information services as well as vendor relationships.
• Communicated with clients and informed the organization about the customer business needs and specifications
• Extensively worked on User stories and Use cases in order to prepare the prototype and Technical Specification Documents for Mobile Banking Applications.
• Made certain the user stories comply with acceptance criteria, had sufficient business value and selling points
• Provided guidance to the development teams to break down large and complex user story into simplified versions for execution
• Tested the user stories for accuracy and compliance to ensure undisputed acceptance and validation of stories

Environment: MS Visio, Rational Requisite Pro, Rational Rose, Rational Clear Quest, MS Project, UML, XML, Test Director, Oracle, Java Script

Confidential

Business Analyst

Responsibilities:

• Analysed User Requirement Document, Business Requirement Document (BRD) and the relationship between business needs
• Elicited requirements for Dashboard implementation and acceptance criteria and documented business needs through product backlogs and user stories.
• Prepared AS IS and TO BE of existing architecture and created requirement traceability matrix in order to map the requirements effectively in to MUST HAVE and NICE TO HAVE buckets
• Created a file of ACORD Forms for both Personal and Commercial Lines of Business used as the standards in all Property and Casualty markets.
• Worked with the ETL team to use Informatica Power Center/Power Exchange to extract/transform and load data from different operational data sources like Oracle, Flat files, XML files into staging area and load into the data warehouse.
• Wrote and executed SQL queries to verify data in the reporting system and used Tableau to generate reports for upper Management.
• Built Use Case Scenarios, workflow scenarios, designed new process flows from the requirements gathered to create use case diagrams and Use case documents.
• Created and executed test plans and test scripts
• Performed quality assurance testing of systems and solutions, and user acceptance testing (UAT).
• Effectively deliver projects utilizing the Agile (Scrum) methodologies.
• Managed daily data exception reports plus created filters, sorting and prompts with the layout on different set of reports. Also tracked progress on updates in project plans and took signoff from the Personal and Commercial Lines of Business owners
• Liaison between the business teams and project teams and worked closely with technology teams and provided analytical support in the Design, Development, and Implementation of Project

Environment: Informatica Power Center, Toad Data Modeler, Tableau, Visual Basic, SQL, Requisite Pro, UML, MS Visio, Quick Test Pro, Load Runner, MS Office Suite, Project Management, HTML, CSS, ASP.Net, C#.