SUMMARY

• Comprehensive 7+ years of experience as developer on Tibco Spotfire 4.1/5.5, Spotfire Integration, ADS CIS, DAC, EIM, Micro strategy BI.
• Configuring and Managing Scheduled updates for the analysis, managing user roles, supporting deployment process in Spotfire.
• Proficient in designing multiple enterprise level Spotfire Analytical solutions.
• Work with users of Spotfire as an analysis tool including training, collaborating on report generation.
• Customization of Spotfire reports using Spotfire APIs and scripts.
• Diverse experience in Retail, Healthcare and Insurance, extensive experience with the HRIS system, Payroll, Time and Attendance, Benefits.
• Knowledge of Oracle 10g/9i, Teradata, Tomcat 4.0, SQL server and reporting tools.
• Expertise in business process tools MS Project, MS Excel, MS Visio, and technical assessment tools, Micro Strategy, Data Warehouse, Data Modeling and Design.
• Responsible for creating reports in Micro Strategy BI, Share point BI.
• Knowledge of Cloud computing concepts and integration with BI tools.

TECHNICAL SKILLS

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

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

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

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

Internet: Iron python script, VB Script, ASP, JavaScript, JSP, J2EE.

Bug Tracking Tools: Mercury TestDirector, Rational ClearQuest

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

Reporting Tools: Tibco Spotfire, Microstrategy, Sharepoint BI

Data warehousing Tools: Teradata, Informatica, Business Objects, Cognos, Erwin, Microstrategy.

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

PROFESSIONAL EXPERIENCE

Confidential, Wichita, KS

Spotfire Developer

Responsibilities:

• Gathering the requirements from business team and transforming them in technical architecture and design documents.
• Involved in estimation, analysis and solution documents.
• Responsible for creating cost effective efficient Data visualizations using third party connector for sales force to Spotfire integration and ensure the quality of data loaded to the system.
• Responsible in creating the Analysis Design and Building dashboards by creating the information links from oracle, sales force to display data in reports.
• Creating Information links, parameterization, defining join rules in Information designer.
• Pivoting and transforming data in spot fire professional before building visualizations.
• Integrating sales force data and feed with Spotfire reports.
• Implementing security for write back data from Spotfire.
• Testing and debugging the dashboard for quality assurance.
• Conveying problems, solutions, updates and project status to project manager in a timely and regular basis.
• Serve as a primary point of contact for Production Support issue resolution.
• Analyze and document process along with quick resolutions for typical issues in production and which were critical to the process.

Environment: Spotfire 4.1, Oracle 10g, UNIX, Iron Python, Java.

Confidential, Hillsboro, OR

Data Analyst /Ad-hoc BI Reporting

Responsibilities:

• Responsible for defining the scope and implementing business rules of the project, gathering business requirements and documentation.
• Designed High level design, for new process, integrating with legacy and Facet.
• Analysis Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
• Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Creating user stories in Rally consolidating FRS and URS.
• Developed estimates, project plans (Microsoft project), training material, BI reports using Micro strategy.
• Compiled, tabulated and coded statistical reports using pivot tables to produce spreadsheets, graphs and databases.
• Developed estimates, project plans (Microsoft project), training material, BI reports using Share point.
• Performed analysis on enterprise data/report integration & provided functional specification to development team to build Enterprise Reporting Systems.

Environment: Spotfire 4.0, Teradata, Sql server, Iron Python, Micro strategy BI.

Confidential, Franklin Lakes, NJ

Spotfire Developer

Responsibilities:

• Gathering requirements from functional team.
• Coordinate with offshore development team in designing, development and deployment of new business enhancement requirements.
• Coordination with various internal/external system interface team for design/integration testing/ deployment and production issues.
• Create information links and source the information in spotfire reports.
• Design and development of spotfire dashboards.
• Creating Iron python scripts with spotfire APIs for customizations.
• Configuring and managing scheduled updates for spotfire analysis.
• Project Delivery aspects like UAT, Production Migration and Production Implementation.
• Preparation of Test Plan and Plan System Integration testing and perform UAT test along with Business Users.
• Creating one stop shop reporting dashboard using spotfire to analyze and make decisions on product, Sales, Territory etc.

Environment: Informatica 9.1, Spotfire 4.0, Oracle, UNIX, Iron Python, Java

Confidential, Houston, TX

Sr. Business Analyst

Responsibilities:

• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• Created User groups and roles to manage security in Cognos Connection and Access rights of the reports for the end users.
• Developed and Published Packages in Framework Manager, Connecting and testing Data Source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects and fact tables.
• Developed FM Model against Star, Snowflake and Fact Constellation Data Models.
• Created metadata models, Joins, filters and calculations in packages, organized Folders according to the Business view and published the packages using Framework Manager onto Cognos Connection and created the store procedure.
• CreatedLists, Grouped Crosstab, andReportswith calculated fields and Conditional formatting, Conditional Page layout, Sections, page Breaks, sorting, summaries, grouping, drill down/up.
• Applied grouping and associated the data with group functionality, Performed aggregate functions on calculations inreportstudio.
• Creating the Cubes based on the requirements and creating the drill through reports for the cubes and provided training to the end users.
• Scheduled to triggerreports based on an event using Event Studio.
• Updated stored procedures, database views as per user requirements.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.
• Created documentation for the complete project life cycle and mentored the End Users with technical support.

Environment: Windows NT, Oracle 9i, SQL, MS-Project, Toad, PL/SQL, MS Access, Micro strategy

Confidential, Bentonville, AR

Sr. Business Analyst

Responsibilities:

• Interviewed the Business team to gather relevant business requirements, wants/ needs concerning the project and documented the requirements using BRD’s and FSD’s.
• Conducted JAD Sessions with SMEs, end users to resolve what data should be shown in the initial phase.
• Involved in the SDLC including requirements gathering, designing, developing, testing, and release to the working environment. Developed and maintained Requirement Traceability Matrix (RTM).
• Performed thorough GAP Analysis to check the compatibility of the existing software functionalities with the new business requirements.
• Drive and facilitate key discussions with respectivebusinessareas and leads to navigate discovery of scope and assess/architect resolution options.
• Performed business process mapping for change requests and new requirements.
• Attended meetings with the SMEs and technical lead to discuss the enhancement issues and bridge the gap for future design modifications.
• Responsible for gathering requirements (BRD), writing functional specifications (FSD) and use cases for the application.
• Analyzed, documented and managed requirements as well as changes to requirements using Rational Requisite Pro.
• Developed use case diagrams, use case models and class diagrams based on UML methodology.
• Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures.
• Conducted UAT in the final phase of software development process to check the functionality of the Designed and implemented basic SQL queries for QA testing and report / data validation software.
• Developed estimates, project plans (Microsoft project), training material, BI reports using Micro strategy.
• Compiled, tabulated and coded statistical reports using pivot tables to produce spreadsheets, graphs and databases.

Environment: Windows XP/2000, Oracle, SQL, MS-Project, MS-Office Suite, MS Visio, MS Visual Source Safe, Quality Centre, Quick Test Pro (QTP), Caliber RM, Micro strategy BI.

Confidential

Sr. Business Analyst

Responsibilities:

• Developed Data Flow Diagrams, Work Flows, Process Flows, and Entity Relationship Diagrams in MS Visio, and analyzed them to create “AS IS” and “TO BE” scenarios.
• Interacted with department heads to finalize business requirements, functional requirements and technical requirements and also created Business process model.
• Facilitated JRP sessions between technical and regulatory teams for meeting requirements as well as solving problems on a daily basis.
• Performed Requirement Analysis by gathering both functional and non-functional requirements based on interactions with the process owners & stake holders and document analysis, represented them in Requirements Traceability Matrix (RTM).
• Involved in creation and reviewing of Functional Specifications and created a Functional Requirement Document.
• Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
• Conducted JAD sessions, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
• Provide implementation assessment, strategy, and mentoring services for Rational Rose, UML and RUP.
• Created and maintained Narrative Use Cases (Business Use Cases, System Use Cases).
• Followed the adaptive RUP framework for the whole Project life cycle (PLC).
• Fine-tuned search engines and pulled data from different databases and migrated data back and forth using.
• Designed and developed, Use Cases, Activity Diagrams, Sequence Diagrams, OOAD, Visio and Business Process Modeling.
• Teamed up with both internal and external software development groups to provide functional requirements specifications in form of use cases, business process flows, and prototypes and management reporting requirements.
• Assisted in data mart design and prototyping.
• Involved in creation and execution of manual test cases in Mercury Test Director and automated Test Cases in QTP and analyzed the Test Results.

Environment: MS-Project, MS-Office Suite, MS Visio, HPQC, Windows XP, Oracle, Mainframes, .NET Java, J2EE, Mercury Test Director.