SUMMARY:

• A results - oriented professional with 14+ years in technical consulting of Business Intelligence technologies in transformation projects & Client relationship in the IT industry.
• Experience in creating and maintaining enterprise level reporting systems.
• Proficient in Business Intelligence & Data Integration of medium to large sized projects.
• Proficient in developing and implementing BI Analytical tools for MS Power BI, IBM Cognos, SAP Business Objects, MicroStrategy, Tableau Visualization solutions.
• Excellent contributor to MS Power BI, IBM Cognos & SAP Business Objects development & enhancements.
• Proficient at managing large, medium, simple transition BI (MS Power BI, IBM & SAP) projects from transition state to stabilizing the project to Steady state in migrations.
• Strong team leadership skills along with capability to think out of the box, generating new solutions, thereby generating an improved learning curve for the team being a lead.
• Possess excellent interpersonal, communication and organizational skills with proven abilities in Team management and Customer relationship management.
• Microsoft BI Analytics - Microsoft Power BI 2.x - Desktop and Mobile tools
• MS SQL Server 2012/2008R2/2008/2005 SSIS/SSRS/SSAS, Access and Excel.
• BI front-end solutions (traditional reports, dashboards, Power Pivot etc.) to support the business’ use of data.
• Business Objects Application Development - WebIntelligence, Desktop Intelligence,
• SAP Business Objects Meta Data layer Development - Universe Design & implementation.
• SAP Business Objects Report Conversions & Migrations
• SAP Business Objects Xcelsius Dashboard Implementation
• IBM Cognos 10.2.1/Cognos ReportNet (Report studio, Query studio, Event Studio, Analysis Studio & Cognos connection & Cognos administration).
• IBM Cognos 10.2.1 - Excellent knowledge of developing and publishing packages in Framework Manager, reports in Report Studio, Ad-Hoc reports in Query Studio.
• SAP Business Objects XI R2, 3.1, 4.0 Migrations, Sizing & Clustering
• Advisory Consulting for Strategic IT, project, program roadmaps
• Fit for business solution consulting - BI, Information Mgmt, Big Data, Analytics
• Project Management Life Cycle - Agile, Waterfall and LEAN methodologies.

TECHNICAL SKILLS:

Tableau: Business Analytics, Big Data Analytics, Cloud Analytics, Data Visualization

MicroStrategy: MicroStrategy Analytics, MicroStrategy Visual Insight, MicroStrategy Mobile MicroStrategy 9/8.x Product Suites including MicroStrategy Desktop, Web, Architect, Administrator, Intelligence Server.

IBM Cognos BI: 10.i, 8.i, Installation, Migrations, Clustering in complex environment, integration of IBM Cognos with SharePoint Webparts, User & Content Deployments, Configuring Performance Metrics, BI Server Performance tuning.

IBM Cognos BI Client Tools: Administering through Cognos Connection, Metric Studio, PowerPlay Studio, Report Studio, Event studio, Analsys Studio, Workspace, and Workspace Advanced.

IBM Cognos BI Data Manager: 10.i, 8.i, Administering Deployments, Installations

IBM SPSS Predictive Analytics: Administering Modeler Server, Collaboration and Deployment Server Administration with Setup and configuration.

Middleware Technologies: Websphere, IIS & TOMCAT Administration

PROFESSIONAL EXPERIENCE:

Technical Architect

Confidential, Montvale NJ

Environment: Microsoft Power BI 2.x, SSIS, SSRS, IBM Cognos BI 10.iDB2, MS SQL Server 2005/2008, Oracle 10g/11i, Windows Platform

Responsibilities:

• Create advanced Visualization reports and management dashboards using MS Power BI - Desktop and mobile.
• Responsible for developing and implementing solutions using organizational data warehouse, data marts, and operational data stores
• Responsible in creating / maintaining enterprise-level reporting systems.
• This includes designing and hands on development of the application using Microsoft BI/DW technologies.
• Responsible in supporting the design and specification of data presentation and knowledge of reporting, analytics, KPIs and trending Technical Skills.
• Responsible for understanding the data warehousing technologies, including: Relational Database and SQL language, OLAP development using SQL Server Analysis Services (SSAS) - Tabular and Multidimensional, Report development using SQL Server Reporting Services (SSRS)
• Preparing conformed dimensional design across all source systems, matrix of various aspects of ETL design and architecture, requirements for reports - MS BI, SAP BO and IBM Cognos.
• Participated all Business Partner meetings during the requirement elicitation and the management reviews
• Coordinated and lead from the front Business Partner meetings for requirement elicitation, preparing 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.
• Coordination activities in the delegating the Change Tasks with the team members.
• Developed Dashboard reports for ITM Performance Management systems (SMC category reports).
• Developed complex business reports for various business units.
• BI Frontend Administration - Administering end to end IBM Cognos Instances in the Shared and Dedicated environment, User Access Management, Content Management, DataManager Deployments.
• Shared Services during Project evaluation and POC’s in MicroStrategy & Tableau for data integration, visualization and migration projects
• IBM Cognos BI Reports Development - Created Simple, Medium to Complex reports, management dashboards in Report Studio, Created Ad-Hoc reports in Query Studio.
• Designed and Developed simple, medium Meta data Models and publish packages using Cognos FrameWork Manager.
• SAP Business Objects - BI Support team does Application management and report tools using Web Intelligence, Designer, and Performance manager which support Business stake holders to use the reports developed and maintained.
• Designing the Metadata Models
• IBM SPSS Predictive Analytics - End to End infrastructure setup, Know how Documentation, Administering SPSS Modeler(Windows), C&DS (Linux), Client components - Deployment Manager, Modeler Client, Deployment Manager Webclients.
• Manage Installations, configuration and tuning of the BI application in a Distributed & Standalone environments, Server Monitoring (CPU, HW, Memory, Log files), Batch job creation for regular activities (images copy from FTP servers), Log Maintenance (Archival).

Technical Architect & Lead

Confidential - Toronto CA

Environment: SAP Business Objects XI R2 SP5/3.1/3.1 SP3/4.0, IBM Cognos BI 8.i, 10.i, PL/SQL procedures, SQL Scripts, Oracle SQL Developer, MS SQL Server 2005/2008, Oracle 10g/11i, Platforms: Windows Server 2005, Server 2008

Responsibilities:

• BI Support team does Application management and report tools using SAP Business Objects - Web Intelligence, Designer, and Performance manager which support Confidential stake holders to use the reports developed and maintained.
• BI Support team is the central point of contact for all Business Objects Application Development.
• The support includes Report Development, Universe creation; work requests and Application developments patch / upgrade releases.
• BI Support team manages critical productivity applications, tools, and resources to ensure operational and infrastructure efficiencies.
• BI Support team provides Administration and Maintenance support to the different Business Unit stakeholders in Confidential, NA, GORO, UK, PTI and Rest of the World.
• Support includes different Administration activities like User and Groups maintenance, IIS and Tomcat administration activities.
• Created mission critical complex Voyager reports using cubes.
• Created and deployed Web Intelligence Reports through Info View
• Created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections
• Involved in migration and deployment of the Universes and reports across multiple domain
• Developed Dashboards using Crystal Xcelsius 2008
• Developed queries and reports using different data providers in the same report
• Use of designer module to implement universes, linkages between tables, prompts and queries, parsing the universes, applying contexts and alias tables to remove cyclic dependencies.
• Server Administration: Managing the Clustered Servers in Cognos BI Servers, SAP BO Production, Test & QA.
• Managing the Users, User creation, Groups, Folder Creation.
• Content Management: Deployments, Publishing, Scheduling, Import Wizard, promotion to production.
• Worked on all complex SAP BO XI reports - Created reports using Crystal Reports and also using Business Objects functionalities like Queries, Drill down, Functions, Cross Tab, Master/Detail and Formulas etc.
• SAP BO Design Data Models & Architecture Reviews & Signoffs.
• Lead the scoping, planning, cost estimating, and pricing of consulting projects.
• Responsible for statement of work development and Risk assessment, including defining goals and objectives.
• New Project Discussions, Client Meetings and Project Coordination Work.
• Identifying and documenting client requirements, resource requirements, project budget, project risks, and the translation of the client’s business requirements into specific deliverables
• Responsible for daily Support activities like Incident, Service Request and Change Request Management. Coordinate between Offshore/Onsite works.
• Stake holder management - Requirement Gathering, Estimating the changes in Production.
• Triggering Monthly AMS reports, Quarterly Engagement Level Feedback Performance reports.
• Responsible for managing the Custom scripts (.Net C# & JSP’s) integration with BO.
• Communicate with the management team members on all aspects of the migration (i.e., problems encountered solutions, tips and tricks, etc.)
• Responsible for Process Optimization, defining the technology solution and ensures that it is designed and constructed to meet current and anticipated future technical roadmap and technology requirements.
• Responsible for development and review of infrastructure design, integrity of application integration landscape, validation of system configuration, security schema analysis, and Installation/Configuration of software components.
• Change Management - Version managing the production changes and tracking and reporting to SME’s (BO Reports & BO Universes). Resolving Deployment (Cognos BI Content & User Administration) and Post Deployment Issues, Synchronize the Deployment window with the maintenance window in coordination with CM team.
• Change Management - Responsible in joining the Technical Advisory Board, Change Advisory Board meetings for all the Changes to be implemented in the production.
• Work Request Management - maintaining the SLA’s and reporting the deliverables in Weekly L1, L2 Meetings and PM Calls.
• Problem Management - Driving the entire Problem Management cycle from identifying Problems till converting them to Known Errors, reporting and taking them to closure.
• Knowledge Management - Initiating KM articles and reviewing articles for the L1 support teams on the identified frequent issues and make them available for support.
• Availability Management - Working with Event Management team to understand the production unavailability and work with Infra teams to understand the down time and resolve the issues.

BI Technical Lead – BO Team

Confidential

Environment: Business Objects XI R2 SP5/3.1SQL Scripts. Oracle SQL Developer, MS SQL Server 2005

Responsibilities:

• Created and deployed Web Intelligence Reports through Info View
• Created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections
• Involved in migration and deployment of the Universes and reports across multiple domain
• Involved in Installation and configuration of the Business Objects XI R2.
• Involved in Designing and maintenance of security model for users in accessing the reports.
• Involved in Setting up SSO & NT Authentication for all the users.
• Troubleshooting client side and server-side (Web Server, Application Server) installation and configuration issues.
• Troubleshoot database connectivity, cluster configuration
• To respond to user requests (for permissions, security group creation etc.) that are beyond the scope of the L1 team.
• To respond timely to the alerts generated by the monitoring system, verifying the same & resolving them.
• To send out notifications for application downtime, maintenance, or updates.
• Monitoring critical productions systems and performing health check from time to time, checking the disk space usage.
• Central Management Console: Start, stop, restart, enable, disable, add, delete servers
• Configure, refresh server properties, Specify CMS data source, auditing data source, Update objects after a system upgrade.
• IIS server Administration.
• Performance monitoring of Servers, generating reports on health of the servers.
• Monitoring the Database Servers, consistency checks.
• User requests: Publishing reports, Verify reports against native Database queries, User management:
• Content Management: Publishing/managing and maintaining reports, oPublishing and Managing 3rd party documents and hyperlinks, Managing universe connections and restriction sets, Running universe integrity checks to ensure universe integrity

BO Admin & Report Developer

Confidential

Environment: Business Objects 6.5, BOXIR2, MS SQL Server 2000, MS SQL 2005

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the Call Center Directory Operations system for Business Objects Universes and Reports
• Installation of software BO 6.5 & BOXI on windows platforms
• Involved in Building and Sizing the BO 6.5 Business Objects Enterprise XI servers (N-tier) and per the Systems Architecture best practices in terms of Design, Content management, User management, Server Management.
• Implemented the Software development life cycle methodology for creating reports.
• Prepared and maintained documentation for understanding universes and reports.
• Designed the Report Specifications and test cases based on Universe as the main Data provider and also using the Personal data files provided by the users
• Designed Reports using Prompts and Filters, Created Objects and prepared Reports like Call Centre Dashboard reports, HR reports, standard and Adhoc reports and universes.
• Created and modified the universes according to the client requirements.
• Created objects in the universe for report linking purpose, this resulted in excellent report performance.
• Developed and created classes with Dimension, Detail & Measure Objects and specified the hierarchies.
• Created the reports using WebIntelligence, using prompts, filters and drill filters. Developed Hierarchies to support drill down reports.