SUMMARY:

• Collaborative problem solver with impressive track record of leading, architecting and delivering new, high - value and unique solutions to complex business problems.
• Proficient in Project Management both Waterfall and Agile Methodologies, design, implementation, maintenance and administration of secure metadata, enterprise business intelligence environments and data warehouse.
• Enthusiastic, results-driven mentor who successfully guides teams by demonstrating personal mastery of tasks to be performed.
• Project Management | Requirements Gathering | Technical Leadership | Data Modelling & Data Visualization |Process Improvement | Architectural Best Practices

TECHNICAL SKILLS:

BI Tools: Tableau Reports, Tableau Server, IBM Cognos Analytics, Cognos BI tools (Report Studio, Analysis Studio, Query Studio and Event Studio), Framework Manager, DMR Models, Dynamic Cubes, TM1, MS Excel

ETL Tools: WhereScape, SSIS, Data Junction

Databases: Teradata, DB2, Oracle, MS SQL Server, DB2

Data Modelling Tools: Rational Rose, Erwin, MS Visio

DB Tools: SQL-A, SQL*Plus, SQL Navigator, Toad

Scripting Languages: HTML, XML

Database Admin: Oracle Database Administration, SQL Server Administration

Programming Languages: SQL, PL/SQL, SAS, COBOL, Basic Java, Visual Basic, Macros, OOAD

Project Management: SDLC, Agile methodologies (Scrum, KANBAN, XP), MS-Project, Innotas, PlanView, Sharepoint

PROFESSIONAL EXPERIENCE:

Confidential, Bridgeport, CT

Application Architect, Business Intelligence and Data Analysis/Scrum Master

Responsibilities:

• Partnered with business users, senior management, Confidential, technical teams, stakeholders to analyze business requirements, ensured communications across teams, facilitated in the development and implementation of working solutions using Agile methodologies.
• Provided direct project management from initiation to completion; ensuring project requirements are met within scope, budget and time. Regularly updated project plans, identified risks, communicated plans effectively which helped resolve complex business issues.
• As a Scrum Master facilitated Product owner in creating Product backlogs, backlog grooming, User stories, test cases, test plans, release, sprint planning, daily standups, impediment removal, velocity charts, burn-down charts for the projects assigned.
• Focused on team collaboration, prioritization, accountability and visibility with cross-functional teams that helped deliver projects on time without compromising quality that increased customer satisfaction.
• Spearheaded and successfully implemented over 1K user metrics used by different departments of organization and delivery of key performance indicator metrics (KPIs) for Power Users. This facilitated self-organized customers.
• As a special project researched technical solution, enforced Scrumban, trained team members that enhanced run-time performance of standard BI scorecards and e-mail burst reports by 75%, ad-hoc reports by 95%. Reduced Microsoft Exchange storage space by 50% during e-mail bursts.
• Enabled automated security process to configure access control to users/user groups on BI environments, handled complex exceptions and realignments which resulted in reducing support calls by 60% and increasing team productivity in areas of innovation and development.
• Conducted retrospectives, documented lessons learned, created standard operating procedures for educating support team members and user training to efficiently manage over 997+ branches and 14.7K+ users in various departments of organization.

Confidential, Purchase, NY

Senior Cognos Administrator / Developer

Responsibilities:

• Created complete project management solutions, including requirements, data architecture and dimensional modelling for sales, finance, operations excellence and Confidential departments.
• Delivered insights on current performance, trends and future projections.
• Updated and streamlined Cognos report designs and complex dashboards, enhancing report performance by 90%.
• Created data extracts and SQL queries for delivering daily, weekly and monthly reports. These ETL processes led to 95% reduction in manual intervention.
• Resolved issues quickly and efficiently by serving as point of contact for root cause analysis, Cognos server administration, migration and production-related issues.

Confidential, New Canaan, CT

Senior BI Programmer / Administrator

Responsibilities:

• Translated business requirements to technical specifications.
• Designed and developed custom reports and ad-hoc reports per specification from finance department, senior executives and plant managers.
• Provided Cognos BI and Cognos Controller day-to-day administration.
• Maintained SQL server, database tuning and administration.
• Performed data mapping and designed SSIS package to extract, transform and load data into desired tables from Confidential system to data warehouse system, providing foundation for BI reports used by Senior Vice Presidents, Vice Presidents, sales teams and plant managers to arrive at key business conclusions.
• Maintained data accuracy and consistency through access control, input validation and database backup.

Confidential, Norwalk, CT

Programmer Analyst

Responsibilities:

• Scheduled meetings with Business Implementation Manager and end client to create requirements documents, detailed client data analysis, detailed flow diagrams and documentation. Designed test plans (unit, integration, regression and acceptance) for client projects.
• Mentored off-shore team and reviewed tasks completed by junior members of team.
• Created data mapping and generated complex queries for data extracts, building custom and ad-hoc reports as requested by clients and business users using SAS, SQL, DB2, SQL, Crystal Reports, Cognos Reports and Oracle Reports.

Confidential, Norwalk, CT

Senior Database Analyst

Responsibilities:

• Performed data analysis for development projects such as generic load procedures for provider load, knowledge-based search engine and several client data load analysis and data feed analysis procedures in order to improve quality of service to clients.
• Developed complex queries using SQL, PL/SQL, stored procedures and designed reports generation using Crystal Reports for claims and benefits department of organization.
• Minimized errors 100% by automating ETL load procedures.
• Created documentation that was used by other members of team.