SUMMARY

• Highly accomplished professional with a distinguished 15 - year career leading the design and implementation of advanced data capture, integration, analysis, and reporting solutions to enhance decision-making.
• Skilled in partnering with business, leadership, teams and partners to identify needs, define strategy, and guide the delivery of tools, systems, interfaces and analytics to measure performance against goals, identify trends, and respond immediately to new opportunities or issues.
• Natural communicator and team leader with strong motivational skills and ability to produce and succeed.
• Proven ability to quickly grasp and apply new technologies and best practices.

TECHNICAL SKILLS

Database: Microsoft SQL Server 2008R2/2012, Oracle, Teradata, Netezza, DB2, MYSQL, POSTGRE, Cassandra, Mango DB.

Analytics: Cognos suite, MicroStrategy, Tableau, Qlik View, Business Objects

Languages: HTML, UML, Java Script, Core Java.

Software Tools: Remedy, JIRA, Bugzilla, Clear Quest, Rose, Clear case, Caliber RM, Doors, Microsoft Visio, SharePoint, Microsoft Office, Microsoft Project.

Technologies: Agile (Scrum), Rational Unified Process, SDLC, Data Modeling

PROFESSIONAL EXPERIENCE

Principal Lead

Confidential, Irving, TX

Responsibilities:

• Developing strategies and roadmaps for BI and Analytics solutions.
• Using tools like tableau, cognos to translate data into actionable information.
• Compiling & delivering Business intelligence reports to end users on regular basis.
• Provide data driven strategies to analyze huge volumes of data to derive BI solutions for external users.
• Significantly improved system usability and availability if execute-level decision sensitive information by managing the transition of daily business intelligence updates to an on-demand web based format.
• Delivered over 300 reports in cognos for analysis to support Key process in Finances and Operations.
• Managed on site and offshore teams to develop and support the BI platforms for external and internal users in cognos.
• Focused with attention to detail, and a go-getter attitude with the ability to get things done, received appreciation from multiple application teams for providing highest level of support.
• Building, publishing customized interactive Dashboards, report scheduling in Cognos.
• Upgraded the BI environment from Cognos 10.2 to Cognos analytics 11.
• Created models and Packages using Cognos framework manager and deployed them to the portals for the users and developers to generate adhoc and standalone reports.

Sr Cognos Consultant

Confidential, Irving, TX

Responsibilities:

• Promoting knowledge sharing and integration of analyzed information to get competitive advantage
• Using tools like Cognos translate data into actionable information to various Clients.
• Ensuring sustainable business growth and development with advanced knowledge management practices.
• Improving business process with systematic analysis of data about the organization’s historical performances and identification of key areas of improvement.
• Responsible as BI Architect to design the Frame work Models, Cognos cubes and TM1 cubes.
• Installed and Configured Tableau server on windows server for Dev, QA and PROD environments and provide support to the Dev teams.
• Developed workbooks, Dashboards and processed extracts on the servers to provide data sources for the users for Self-servicing.
• Carried out data analysis and management exercises to offer the clients and management with highly critical information.
• Established strategic business development practices with clarified analysis and interpretation of market performances.
• Demonstrated data processing and analysis techniques with market research abilities and practices.
• Ensuring proper and effective information sharing with utilization of advanced technological developments.

BI Consultant

Confidential, Plano, TX

Responsibilities:

• Responsible to Deliver the Bi Projects for Health care Client on time.
• Helped redesign Cognos dashboards as a single applications so that users could get the Dashboard as a landing page when the login in Cognos.
• Successfully delivered multiple projects by meeting deadlines and achieved high-level satisfaction from the client.
• Collaborating with senior management on client account management and growth.
• Helped client to bring Netezaa database by doing proof of concepts with Netezza and Teradata Vendors to make sure Cognos environment is compatible and improved Performance.
• Worked on the prototypes and presented the solutions to the higher management for project approvals.
• Partnered with leadership to automate and integrate budgeting processes to annual planning and reducing timeframe from months to a couple of weeks.
• Implemented Netezza database for Tenet Health care by working with the vendors with in short time frame without any issues.
• Improved the development of support staff with cross-training, which increased productivity by 17% and reduced staffing budget by 9%

Principle Lead

Confidential, Dallas, TX

Responsibilities:

• Responsible to Architect the BI Model in Microsoft suite and Intengrate sharepoint with BI reporting.
• Designed Dashboards for the stake holders with cognos tool and integrated with SharePoint which is an internal portal for the corporation.
• Designed workflow of the jobs to schedule and burst the reports to their respective files system and co-ordinate with control process team to schedule the jobs.
• Worked closely with the internal Business teams to produce BI Solutions to utilize the quantitative
• Information for real time decision-making and enabled precise focused analysis in enhancing customer satisfaction. .
• Helped client to bring Netezaa database by doing proof of concepts with Netezza and Teradata Vendors to make sure Cognos environment is compatible and improved Performance.
• Worked on the prototypes and presented the solutions to the higher management for project approvals.
• Created Requirement specifications and defined future platform, architecture, and functional Capabilities of the system.

BI Architect

Confidential, Dallas, TX

Responsibilities:

• Designed and Architect the Model using Cognos Frame work manager to build the packages for generating the Cognos reports and cubes.
• Created Dashboards providing user friendly prompt pages with filter criteria.
• Designed Dashboards for the stake holders with Cognos tool and integrated with SharePoint which is an internal portal for the corporation.
• Developed Cubes using Transformer and developed report studio reports based of off the cube.
• Involved with the team in providing the technical guidance as and when required resolving the technical issues.
• Responsible for administration on Cognos environments, Installations, configurations, deployment, Maintaining Data Source Connections, controlling the security for user groups, creating User groups.
• Involved in giving training to the users on Cognos Business insight reports and Active reports.
• Build the Cubes using SQL server Analysis services for better performance and for Pivot tables.

BI Systems Analyst

Confidential, Bloomington, IL

Responsibilities:

• Responsible for installing and configuring various components of Cognos8, such as the Framework Manager and Content Manager.
• Responsible for creating User groups and roles to manage security in Cognos Connection and Access Rights of the Reports for the end users.
• Deployed packages, folders and Reports from a development environment to Testing and Production environment.
• Created HTML Scripts to default the values in the Prompts and also to default the search options for the prompts in Prompt page.
• Created new Catalogs using the Impromptu Administrator and used them for reporting purposes in Cognos Impromptu.

BI Consultant

Confidential, Hartford, CT

Responsibilities:

• Involved in the meetings with various Project Managers to understand the workflow of different projects to analyze the data stored in the database.
• Prepared Documentation and analysis for each project workflow based on the information gathered from each project manager.
• Designed the Data model for the Metrics Portal Project using an Erwin tool.
• Involved in creating Technical Specification Document (TSD) for the project.
• Created Portlets in Quintana against the database, which is used to generate reports from Kintana database schema.
• Interacted with the users to assist them to access the database to get the efficient data what they required.
• Participated in the Interactive session from the Mercury Company while demonstrating the Quintana tool for the purpose of reporting.

Cognos Consultant

Confidential, Boston, MA

Responsibilities:

• Involved in production support working with various mitigation tickets created while the users working to retrieve the database.
• Involved in the part of production team and worked on the issues in ETL to make some changes while loading the database.
• Involved in creating Technical Specification Document (TSD) for the project.
• Written Data loading stored procedures, functions using PL/SQL from Source systems into operational data storage. Created views and altered.
• Carried out UAT by developing test scenarios, test cases, test data to be used in testing based on business and user requirements, technical specifications and/or product knowledge Responsible to fix the issues for the end users when they opened a Service