We provide IT Staff Augmentation Services!

Senior Business Intelligence Analyst/ Report Analyst Resume

Dallas, TX

SUMMARY:

  • 7 years of experience as System/Business Analyst in Software Development Life Cycle (SDLC) and Business Process Reengineering in Finance Sector.
  • Documentation: BRD (Business Requirement Document), FRD (Functional Requirement Document) and Non - functional Requirement Document.
  • Ability to interact with developers and Business Analyst regarding Testing Status, Defects and change tracking using Quality center and Clear Quest.
  • Experience in developing detailed functional specs through JAD sessions, interviews, on site meetings with business users & development team.
  • Knowledge as Functional Consultant/ Business Analyst in Oracle identity Manager Implementations.
  • Developed Ad-hoc reports using Tableau Desktop, Excel
  • Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis.
  • Experience in interviewing Business users & SME providing recommendations to resolve issues for various business/technical groups & defining strategic solutions to business problems in a multiple project environment.
  • Extensive Experience on SQL 2000/2005/2008/ R2/2012 including DTS, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
  • Experienced in SQL Server 2005/2008/2008 R2 RDBMS database development including T- SQL programming.
  • Expert in SQL Server 2008 OLAP database development including KPIs, Data mining, working with changing dimensions.
  • Expert in defining Queries for generating drill down and drill through reports in SSRS 2008.
  • Analysis & Design (Use Case, Sequence and Activity diagrams).
  • Test Case writing (manual/automated test cases) and Conducting Tests (Integration testing, Regression testing), Black Box/White Box testing, UAT (User Acceptance Testing).
  • Created Drill-down and Sub-Report using SSRS. Monitored the performance of the reports.
  • Worked closely in team oriented environment utilizing quantitative and qualitative analytical skills. Ability to understand business problems and apply technology to formulate workable solutions
  • Excellent in developing detailed functional specs through JAD sessions, interviews, on site meetings with business users and development team.
  • 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).
  • Excellent writing skills in preparing BRD (Business Requirement Document), FRD (Functional Requirement Document) and Non-functional Requirement Document
  • In depth knowledge of PMO techniques such as Rational Unified Process (RUP), Agile and Waterfall life cycle
  • Excellent Experience in using scripting languages like JavaScript, JQuery and AngularJS.
  • Good experience in working using ASP.NET AJAX for partial page execution and asynchronous data transfer from web server to the client.
  • Experience in implementing Authentication and Authorization using Windows-based Authentication, Forms-based Authentication, Authorizing Users and Roles.
  • Strong knowledge of IIS 8/7.5/7/6.
  • Strong knowledge in writing complex Database queries, Stored Procedures, Views and Triggers using MS SQL Server 2012/2008/2005.
  • Experience in creating WPF/Silverlight applications using MVVM architecture.
  • Excellent experience in writing Data Access Layers using ADO.NET and Entity Framework (EF).
  • Worked using LINQ to retrieving data from different data source.
  • Consuming and Developing web service and Windows Communication Foundation services (WCF).
  • Writing Manuals (System guides, training material for business users and Deployment guides).
  • User training on the changes being released and conducting post production activities like getting feedback from users. In case of any issues - doing Root Cause Analysis, prioritizing tasks with business users.
  • Experience with data analysis, data mapping and dimensional modeling experience in decision support systems (data marts) using Star Schema.
  • Experience in helping development teams to break down large user stories for execution.
  • Working experience in a cross-functional team environment/different geographical locations teams.
  • Good knowledge and extensively used RDBMS, Oracle, SQL , and PL/ SQL along with MS SQL administration, SQL Enterprise Manager, Data analysis and reporting.
  • Well versed in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) diagrams using MS Visio and Rational Rose.

TECHNICAL SKILLS:

Process/Modeling Tool: MS Visio, MS Project, Win Runner, HP Quality Center

Reporting Tool: SAS, HP Quality Center

Methodology: SDLC, Agile, UM (User & Maker), UML

RDBMS and Databases: MS Access, SQL server, Oracle 9i,Informatica, Tableau

Languages: C#, C++, Java, .NET, XML, UML, SQL, HTML

Operating Systems: Windows Family, Familiar with UNIX and LINUX

Office Tools: MS Office, Word, Excel, PowerPoint, Visio, Outlook.

Project Management: MS Project, Microsoft Office

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Senior Business Intelligence Analyst/ Report Analyst

Responsibilities:

  • Interacting with various stakeholders to understand the business and technical requirements.
  • Analyzing the requirements and estimating the effort required to design, build and test.
  • Suggesting optimized solutions and new technical designs for the data models and report layouts.
  • Installing and configuring environments, setting up securities based on user groups and roles and Troubleshooting configuration issues.
  • Preparing analysis and design documents for the new and enhancement requests.
  • Preparing prototypes, proof of concepts for the new and enhancement requests.
  • Building both relational and multi-dimensional OLAP models using star schema with Cognos Framework Manager.
  • Validating and testing Framework Manager Models and all the developed reports.
  • Creating packages in Cognos Framework Manager and publishing them to Cognos Connection.
  • Developing different types of decision making reports: List, Cross-tab, Chart, Repeater, and Combination etc.
  • Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS and SSIS in Business Intelligence Development Studio
  • Prepared the complete data mapping for all the migrated jobs using SSIS.
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Using SSIS, built high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing
  • Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
  • Using SSIS, built high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
  • Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report)
  • Involving in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
  • Assisted ted in the design and support of ETL jobs and SSIS packages.
  • Effective use of advanced reporting and formatting functions in Business Objects reporting.
  • Implementing different types of functionalities: Master-Detail, Drill-Through, Cascading Prompts, Report Bursting, and Conditional Rendering etc.
  • Developing different types of Dashboards and Scorecards.
  • Conducting status meetings with offshore and onsite development teams.
  • Troubleshooting and fixing the defects logged by the testing team in the Quality Center.
  • Creating various types of Microstrategy objects including Attributes, Facts, Metrics, Filters, Prompts, Drill Maps and Hierarchies etc.
  • Validating and testing the created objects and reports in Microstrategy.
  • Creating different types of detail and summary reports using grids, documents and dashboards.
  • Implementing various functionalities including Sorting, Grouping, Banding, Drill-through, Drill-Up, Drill-Down, Custom SQL etc. Creating intelligent cubes and scheduling.
  • Content administration and Deployment of packages and reports from DEV to QA and QA to PROD.
  • Involved in creating ETL mappings using different transformations in Informatica to load data from source to staging and staging to target tables.
  • Supporting post production activities including accepting tickets raised by the end users and providing fixes.

Environment: Cognos Suite, Microstrategy, Oracle, Teradata, Informatica, Sharepoint, Toad, ESP Scheduler, HP Quality Center.

Confidential, Newark, NJ

Senior Business Intelligence Analyst/ Report Analyst

Responsibilities:

  • Analyzed “TO BE” scenarios based on the data that are currently required to generate reports.
  • Gather requirements by conducting meetings and brainstorming sessions with end users and SME and document them using Requisite Pro - the documentation tool offered by Rational.
  • Extensively involved in data modeling.
  • Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
  • Perform Gap Analysis of the processes to identify and validate requirements.
  • Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
  • Facilitated Joint Application Development sessions and facilitated stakeholder meetings to identify business process and requirements; exhaustive management of project requirements using CaliberRM
  • Conducted meetings and understood the requirements of the sales and marketing team
  • Organize requirements into high level Use Cases and low level Use Case Specifications and modeled them into UC, Activity and Sequence Diagrams using Rational Rose and MS Visio.
  • Recorded retention stored in Knowledge Link. Ad Hoc reporting, Admin for MS Project 2003, Excel dbase and pivot tables, Clarity and MS Project Server Admin duties.
  • Apply UML notations and methodology in developing models that accurately represent the business process and workflows and clearly communicate them to the stakeholders.
  • Used ETL process to Extract, Transform and Load the data into stage area and data warehouse
  • Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate
  • Installing and Configuring Cognos environment i.e., Framework Manager and BI Server on local machines.
  • Understanding requirements from the business team and estimating the effort required.
  • Analyzing the requirements and preparing low-level and high-level design documents and prototypes.
  • Understanding the database structure of the source system and designing star schema layouts.
  • Working with Data Warehouse team as needed to define new data warehouse tables required for reporting.
  • Building Framework Manager Models and publishing packages to Cognos Connection.
  • Creating different types of objects including model query subjects, user-defined calculations, filters, prompts, and parameter maps.
  • Worked with developers to design and develop SSIS/SSRS to generate BI (Business Intelligence) reports.
  • Extracted Transform Load(ETL) development Using SQL server, SQL Integration Services(SSIS )
  • Generated several drill down and drill through reports using SSRS
  • Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes
  • Created Packages in SSIS with error handling
  • Actively involved in creating SSIS packages to transform data from OLTP database to a data warehouse.
  • Experience in creating SSIS packages using dashboard.
  • ETL capabilities of SSIS were used to define imports of the data, build scheduling packages.
  • Created SSIS Packages to migrate slowly changing dimensions.
  • Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS transformations.
  • Authored stored procedures used in ad-hoc and subscription based SQL SSRS reports.
  • Worked on building queries to retrieve data into Tableau from SQL Server and Oracle SQL Developer, and developed T-SQL statements for loading data into Target Database.
  • Involved in data dictionary management, extraction, transformation and loading (ETL) of data from various sources. Participated in ETL requirements process during data transition from source systems to target systems
  • Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
  • Validating and testing Framework Manager Models and all the developed reports.
  • Developed different types of decision making reports: List, Cross-tab, Chart, Repeater, and Combination etc.
  • Implemented different types of functionalities: Master-Detail, Drill-Through, Cascading Prompts, Report Bursting, and Conditional Rendering etc.
  • Wrote complex SQL queries when the Cognos built-in options failed to meet the user requirements.
  • Deployed reports from Cognos DEV to QA and Cognos QA to PROD servers.
  • Resolved production issues for the existing reports and providing external support/extracts when necessary.
  • Enhanced existing reports per new change requests.

Environment: Cognos Suite, Cognos ReportNet, IBM Open Pages, Oracle, Sharepoint.

Confidential, New Jersey

Business Systems Analyst/Report Analyst/ BI Analyst

Responsibilities:

  • Interacted with various stakeholders to understand the business and technical requirements.
  • Analyzed the requirements and estimating the effort required to design, build and test.
  • Suggested optimized solutions and new technical designs for the data models and report layouts.
  • Installed and configured environments, setting up securities based on user groups and roles and Troubleshooting configuration issues.
  • Prepared analysis and design documents for the new and enhancement requests.
  • Prepared prototypes, proof of concepts for the new and enhancement requests.
  • Building both relational and multi-dimensional OLAP models using star schema with Cognos Framework Manager.
  • Validated and testing Framework Manager Models and all the developed reports.
  • Created packages in Cognos Framework Manager and publishing them to Cognos Connection.
  • Developing different types of decision making reports: List, Cross-tab, Chart, Repeater, and Combination etc.
  • Implementing different types of functionalities: Master-Detail, Drill-Through, Cascading Prompts, Report Bursting, and Conditional Rendering etc.
  • Developed different types of Dashboards and Scorecards.
  • Conducted status meetings with offshore and onsite development teams.
  • Troubleshooting and fixing the defects logged by the testing team in the Quality Center.
  • Created various types of Microstrategy objects including Attributes, Facts, Metrics, Filters, Prompts, Drill Maps and Hierarchies etc.
  • Validated and tested the created objects and reports in Microstrategy.
  • Created different types of detail and summary reports using grids, documents and dashboards.
  • Implementing various functionalities including Sorting, Grouping, Banding, Drill-through, Drill-Up, Drill-Down, Custom SQL etc. Creating intelligent cubes and scheduling.
  • Content administration and Deployment of packages and reports from DEV to QA and QA to PROD.
  • Involved in creating ETL mappings using different transformations in Informatica to load data from source to staging and staging to target tables.
  • Supported post production activities including accepting tickets raised by the end users and providing fixes.

Environment: Windows, RUP, MS Project, MS Office (Word, Excel, PowerPoint, Outlook), MS Visio, Cognos Suite, Oracle, Sharepoint.

Confidential, Irvine, CA

Business Systems Analyst/ BI Analyst

Responsibilities:

  • Performed Requirement Gathering by interacting with Business users and documented the requirements in story cards.
  • Captured Use Cases in Story Cards.
  • Researched, defined and deploy BI improvement opportunities and streamline the business intelligence processes
  • Requirements were gathered through interactions and meetings and periodic walkthroughs with SME’s
  • Responsible for providing BI support and ensuring high levels of availability in the Business Intelligence environment.
  • Ground-Up replacement of Wholesale/Retail legacy mortgage production Origination systems
  • Conducted meetings with all levels of organization from executive management to technical development teams and system users to define requirements and research and document operational processes. Worked with the Agile method of analysis.
  • Developed operational PMO leveraging Agile methodology, reducing development effort.
  • Key liaison between business unit and development groups in a Service Oriented Architecture (SOA) environment.
  • Collaborated with other Business Analysts and developers to define and implement an improved Software Development Life Cycle based on the Agile thereby increasing the quality and efficiency of software development efforts.
  • Assisted with SOX compliance evaluations and the adoption of IT controls which reduced corporate liabilities and potential risks to technology and data assets.
  • Performed Gap Analysis to review the existing XML XSD and make necessary changes.
  • Worked with XML files and suggested changes to the XSD.
  • Conduct JAD Sessions, Peer Review sessions with the SMEs, Solution Engineers, developers, Business users.
  • Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems
  • Created Stored Procedures for data transformation purpose.
  • Analyze the scope of the project to review it with the customers for different review sessions of the application.
  • Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
  • Good understanding of Agile Methodologies.
  • Intensively involved in project testing efforts by doing System Integration Testing, Regression Testing and by helping UAT team in User Acceptance Testing
  • Implemented Aggregate, Filter, Joiner, Expression, Sorter, Lookup and Update Strategy, Normalize, Sequence generator transformations
  • Designed and created logical & physical data models to support strategic business Decisions
  • Extensively used Informatica debugger to validate Mappings and to gain troubleshooting Information about data and error conditions.
  • Create SQL queries to read data from databases.
  • Worked with the Testing team to test the system extensively and log defects.
  • Used BizTalk 2006 R 2 to developed orchestration to consume WCF service to extract the lookup values from the database.
  • Defined the maps from the existing BizTalk solution and validated it with the client for any changes.
  • Performed data mapping and tracing data from system to system in order to solve a given business or system problem

Environment: Ms Office Tools, Windows XP, Facets, MS Project, SharePoint, BizTalk Server utilities, MS-PowerPoint, JIRA, SQL Server, XML Spy, TOAD, Content Management Services, Quality Center, Agile framework.

Hire Now