SUMMARY

• Experience gathering, analyzing, and translating business and functional requirements
• Participate, document and contribute in IT governance, process improvement, procedures sessions
• Experience with business process improvement, operational intelligence and information security
• Lead and facilitate JAD sessions and also act as a technical analyst for different product reviews
• Experience with enterprise program management tools, delivery of metrics and reporting
• Experience with performing and coordinating RCA and trend analysis
• Experience in creating project timelines, roadmaps and estimating project cost
• Ability to work on multiple projects from inception to completion e.g. SharePoint 2007 to 2010
• Experience working on complex data analysis and data mapping using Informatica
• Understanding of project development life cycle, ITIL concept and Agile Methodologies
• Solid understanding of Data Warehouse, Data Virtualization, MDM and working with BI tools
• Hands on experience with scripting in T-SQL/PL-SQL DDL, DML statements, used to retrieve and modify data from database
• Hands on experience with report development using SSRS, Webi, BO Explorer
• Excellent hands on experience in creating KPI's, Scorecards, Dashboards and analytic reports
• Experience understanding and redesign business processes to fully utilize available technologies
• Lead and coordinate quality assurance and testing process, also sign off releases to production
• Strong experience in analyzing, defining processes and understanding established procedures.
• Ability to bring groups together to address issues and come to agreement on resolution
• Conduct quantitative, qualitative analysis to determine the benefit of project
• Identify opportunities for improvement and make constructive suggestion for change
• Experience working with different stakeholders and subject matter experts from multiple BU's
• Strong interpersonal, communication, problem solving, analytical presentation skills
• Comfortable working independently, and in multi-team environments under tight deadlines

SKILLS

Applications: Flex cube, Microsoft Office Suite, Hyperion Essbase, PeopleSoft Financial HCM, Business Objects XI ,4.0, Explorer , SharePoint 2010, SSAS, SSRS, Double Click, PerformancePoint, Report Builder, Power Pivot, VISTA PLUS, JIRA 4.4, Tableau, SAP BW BEx Query, Report, Analyzer, WAD ,TOAD for Oracle, Cognos TM1 10.2

Operating Systems: MS Windows 2000, XP, Vista, 7, 2003 Server , UNIX

Programming: SQL, HTML, MDX, DAX

Databases/Data Warehouse: Microsoft SQL Server 2008, SAP BI 7.0, Oracle

ERP Packages: ECC 6.0, SAP Net weaver 2004s

Networking: RDP, VPN, Dame Ware, PC Anywhere, VNC, LAN, TCP/IP

PROFESSIONAL ASSOCIATION: Member NSBE, IEEE, NBMBAA, SWE, AITP UT Chapter .

WORK EXPERIENCE

Business Intelligence Analyst

Confidential

• Facilitate requirement gathering, UAT, review for improvement to meet deliverable get sign off
• Conduct gap analysis, and map large data sets from multiple data source systems
• Direct the identification and use of appropriate data sources, technologies and analytic techniques
• Support the data governance team in data cleansing, audit, collection and reconciliation phase
• Review/participate in the development of implementation plans for new applications and work practices, including plans to manage transition to new work practices and applications
• Act as data analytics subject matter expert and advisor to compliance and internal audit team
• Provide periodic demonstrations of the system under development to the subject matter experts to get feedback on design
• Responsible for successful specification of enhancements for a data warehouse and associated reporting environment used to track time-sensitive issues
• Participate and lead the data validation process ensuring adherence to requirements, business rules, and performing timely, diligent follow-ups on data feed remediation
• Act as SME in projects that support the operations of PCI and SOX functional areas
• Create a repository for all policies, procedures, standards, control documents, narratives and governance documents that are used to manage and support technology and applications that impact PCI and SOX
• Involved in all phases of Software Development Life Cycle SDLC including Analysis, Design, Development, Testing, Implementation and Maintenance.
• Provide support for internal and external vendors, PCI and SOX IT audit teams
• Attend weekly sprint, daily scrum meetings and contributes to tracking all phases of the project and resolving conflict
• Identify gaps with existing systems/processes and identify risks and vulnerabilities
• Develop user manual documentation defining technical processes and procedures
• Work with business stakeholders in presenting and executing a successful business change plan

Cognos TM1, SharePoint, Performance Point and PowerPivot

• Data extraction, reporting and analysis using Cognos TM1 10.2
• Develop plan to help end users keep existing SharePoint sites in compliance with information policies and standards
• Develop PerformancePoint contents such as Scorecard, KPI's, Time Intelligence Filters
• Create Dashboard in SharePoint 2010 using PerformancePoint contents and Power Pivot
• Experience with developing, deploying reports and managing documents in MS SharePoint
• Create parameterized drill down reports from SQL Server 2008 OLTP and OLAP data sources with T-SQL and MDX queries
• Proficient with Excel PowerPivot to create self-service reports and using DAX to create calculated measures in the report

SAP Business Objects Web Intelligence and Explorer MS SQL Server Suite

• Act as a product owner for Business Objects enterprise application
• Develop reports using Webi and information spaces using Explorer
• Manage information spaces and design Exploration view sets
• Create and enhance visualization, views to and existing Exploration view
• Review requirements for SSRS reports that needs to be created or enhanced
• Designed and developed reports, dashboards and ad hoc queries

Business/ Lead UAT Analyst

Confidential

• Own the requirements process from needs assessment through application go-live
• Participated in process designs, identify priorities and conduct gap analysis on business processes
• Managed 3 QA analysts and made sure worked together to meet and exceed business objectives
• Conducted presentations, demos, facilitated discussions with users to gather business needs
• Performed validation of test results, and provided regression progress status in ITRAX
• Participated in product design reviews to provide input on functional requirements, product designs, schedules, or potential problems, and to strategize big-picture test plan for the product
• project scope and ensured project management methodologies are followed
• Coordinated, facilitated UAT analyzed, reviewed for improvement before sign off to production
• Provided test case progress updates in standard test case and defect repository
• Developed overall test process documentation for the department, which included test plan, test cases, test scripts and Traceability Matrix
• Performed manual and automated testing of Business Intelligence applications
• Managed and tracked tickets using JIRA and also followed Agile methodology framework
• Created process flow diagrams, user guides and advanced application diagrams
• Conferred with business to define, gather, analyze information via JAD sessions to document business requirements using UML and business logic flows
• Collaborated with IT team and SMEs to test BI solutions to ensure quality of requests
• Developed, delivered documentation, provided peer training and mentoring to other BAs

Business Analyst

Confidential

• Provided user, credit card application support for business information applications
• Created, updated and managed banking data files writing ad-hoc, SQL queries and T-SQL
• Managed user access to business information application using SQL DCL
• Acted as a liaison between the businesses, technology, support teams and third party vendors
• Gathered business requirements by conducting detailed interviews with business users and SME's
• Generated and reviewed status reports prepared by project personnel and modified schedules
• Identified gaps to understand current business process and opportunities for improvements
• Communicated releases, updates and enhancement to existing business information application to relevant departments and also recommended improvement to applications
• Assisted in the enforcement of project schedules and deadlines
• Supported the project delivery team during design, construction and testing phases of the project and facilitated User Acceptance Testing using test cases and process diagram
• Maintained issue list, proactively escalating issues to project and departmental leadership to mitigate risk
• Covered the scope, objectives of projects and ensured that there is a balance between satisfying clients and assisting developers
• Assisted with project training/documentation activities as requested