We provide IT Staff Augmentation Services!

Bi Implementation Analyst Resume

GA

SUMMARY:

  • Technology Professional with over 5 years of Microstrategy experience in designing, developing and testing IT business applications.
  • Accomplished Programmer and Quality analyst with the experience of complete structured development lifecycle. Focused and energetic team player with strong client management, communication, and leadership skills. Avid learner and technology enthusiast with sharp analytical skills.
  • Skilled Business Intelligence and Data Warehousing applications developer with over 5 years of experience in the field of Information Technology implementing Data warehousing solutions using Microstrategy Developer 9.4.1/ Microstrategy Desktop 8.x and Microstrategy Web.
  • Extensive experience with creating and deploying Microstrategy application objects such as Dashboards and Documents, Metrics, Filters, Prompts, Transformations, Custom Groups and Consolidations.
  • Designed Data Marts using different multidimensional modeling techniques such as Star Schema and Snowflake Schema, Fact and Dimensional tables, Logical and Physical data model
  • Implemented and used best practices in Software Development Process, Standards and Process Improvement
  • Overall 14 years of experience in software analysis, design, development and testing, reviewing business requirements and developing Test Plans, Test Cases, and Test Scripts for both Manual Testing and Automated Testing; experience in Test Execution and Post Test Results Analysis
  • Decent Database development skills using SQL, PL/SQL, stored procedures, stored functions, packages and triggers
  • Experience in using database management tools for databases such as Teradata, Netezza, SQL Server 2005, Oracle 9i & DMSII.
  • Developed Quality Assurance and testing strategies for Mainframe, Client/Server, and Web - based applications.
  • Experienced in full software development lifecycle (SDLC) including requirements gathering, analysis, design, and implementation of large scale enterprise applications.

TECHNICAL SKILLS:

Data Warehousing Tools: MicroStrategy 9.4.1, 9.2.1, 8.1, MicroStrategy Narrowcast Server

Data Modeling: Normalized, De-normalized, Star and Snow Flake Schemas

Languages: SQL, Java, HTML, XML

RDBMS: Teradata, Netezza, SQL Server 2005, Oracle9i

Operating Systems: Windows XP, Windows NT, Windows 2000/98/95, and UNIX

Testing Tools: Selenium, Mercury WinRunner, Quick Test Professional, LoadRunner, Quality Center, Test Director, Rational TestManager.

PROFESSIONAL EXPERIENCE:

Confidential, GA

BI Implementation Analyst

Responsibilities:

  • Arrange and participate in design sessions with IT and bussiness to understand requirements for Saks Integration
  • Create new attributes, facts and metrics(Dimensional metrics, Compound metrics), Filters, Custom groups and Consolidations for complex reports
  • Design and develop Daily, Weekly and Internet Sales and Inventory reports for clients
  • Design Templates to generate reports in grid and graph mode. Auto prompt filter feature gave end-user a choice of different filtering criteria each time they run the report
  • Review the design of the the existing datasets to improve efficiency and report processing time
  • Redesign client Dashboards with user friendly prompts
  • Change the reports,Dashboards & PDF documents to replace or add new metrics
  • Create ETL, Stored Procedures in Netezza and Automate the scripts for daily data load

Environment: Microstrategy 9.4x and Teradata, Netezza

Confidential, GA

BI/DW Consultant

Responsibilities:

  • Assist Confidential team to customize their Microstrategy Product developed for their retail clients
  • Develop and Process ETL on the source data by creating DTS packages and Stored Procedures
  • Load Data Warehouse with the relevant data for reporting as per the requirements
  • Create and Configure new facts, metrics and test reports in Microstrategy
  • Create Selenium Test Cases for testing in-house Dashboards
  • Analyze data and identify the reports to be created based on the requirements of Microstrategy Tutorial Project, duplicated in Cognos
  • Create the Logical and Physical Data Model
  • Create a data model in Cognos Framework manager
  • Create reports in Cognos Report Studio
  • Include all the basic Cognos functionality in the reports
  • Create all the necessary documents required for the training project

Environment: Microstrategy 8.0x and MS SQL Server 2005

Confidential, Orlando, FL

Sr. Consultant / Programmer/Analyst

Responsibilities:

  • Resolve customer care issues related to loans and line of credit products for the existing software release.
  • Support and Develop lending enhancements for New York Community Bank. The bank recently acquired two institutions for which they want to develop a uniform product based on MISER banking application.

Environment: Unisys ClearPath COMS, MCP, DMSII with Cobol 85

Confidential, Chevy Chase, MD

BI Developer

Responsibilities:

  • Studied the Reports Requirements Specifications Document and Use Cases for the Product that automates data gathering, analysis and reporting for commercial aircraft maintenance and reliability processes.
  • Assisted in creation of the Test plan and Test Cases of the Microstrategy Reports.
  • Tested the reports for functionality, data and look and feel, along with measuring their execution time
  • Wrote custom SQL for all the reports to validate the report results
  • Created Report Documents containing the screen shots and SQL for all the reports to assist in the UAT process

Environment: Microstrategy 7.2x and MS SQL Server 2005

QA Analyst

Confidential

Responsibilities:

  • Analyzed the Report Specifications and prepared Design documents to create Dashboards to facilitate user analysis.
  • Defined and created MicroStrategy schema objects and application objects including attributes, filters, metrics, hierarchies, templates, prompts and reports based on source files.
  • Designed and created MicroStrategy reports according to design specifications
  • Extensively worked on Report Services Documents
  • Developed Graphical reports showing complex graphs.
  • Created reports requiring regression analysis and statistical modeling
  • Developed Microstrategy dashboards as per clients requirements

Environment: MicroStrategy on Windows

Confidential, Orlando, FL

Sr. Consultant / Programmer/Analyst and QA Tester

Responsibilities:

  • Led the development of a customized product for commercial loans that will help institutions improve commercial loan servicing.
  • Implemented the Extended-Overdraft feature to automate a bank’s manual exception handling process which helped the client generate $1 million NSF-fee income in the first year.
  • Developed and implemented enhancements for Bank of America to automate and expedite their CashPay employee enrollment process.
  • Designed/Enhanced the Bank-Day-Cutoff functionality of the MISER banking system to allow it to work independently of a bank’s Carryover feature.
  • Helped with the design and QA testing of a Web-based branch automation product for tellers.

Environment: Unisys ClearPath COMS, MCP, DMSII with Cobol 85

Confidential, Princeton, NJ

Consultant Programmer/ Analyst

Responsibilities:

  • Analyzed, remedied and tested existing system COBOL code of MISER banking system for Year 2000 compatibility.
  • Developed test cases based on the use case diagrams and functional requirements and executed the test cases. Managed the testing process using Rational Test Manager.
  • Performed unit and integration system testing for all the banking modules including ATMs.
  • Provided development support to customers for the deposits and loans related modules of MISER banking system.

Environment: Unisys A Series COMS, MCP, DMSII with Cobol 74

Confidential

Programmer/Analyst

Responsibilities:

  • Developed a tool to identify Year 2000 date impacted COBOL source code in core banking systems
  • Developed and executed test scripts to renovate, test and review core banking systems for Year 2000 compliance

Environment: Unisys A Series COMS, MCP, DMSII with Cobol 74

Hire Now