SUMMARY:

• With more than 15 years of experience as BI Architect/ Sr BI Developer on Data warehouse, Data marts, Framework, OLAP Design, reporting solutions & architecture planning, design and development.
• Deep passion for driving technology vision/strategy and delivering tangible, high value business solutions.
• Strong experience in creating innovative architectures for vertical industry solutions and LOB applications.
• Large enterprise IT experience in various technical and project management roles using key methodologies, frameworks, data modeling & process reengineering.
• Strategic and technological thought - leadership in key emerging technologies such as Business Intelligence & Data Warehousing, Collaboration/Portals/Content Management, Integration/workflow/SOA, etc.
• Deep technical experience with architecture, design and hands-on programming on diverse technology platforms including RDBMS, OLAP engines including Cube design & development, ETL engines, BI Scorecards & Dashboards, Service Oriented Architectures (SOA), SharePoint, and a wide variety of programming languages.
• Strong experience in Cognos, Microsoft Stack, Tableau, SharePoint, Visual Studio, Source Control and MS SQL Server, etc
• Strong Experience in Agile and Waterfall methodology.
• Experience in management level meetings to determine feasibility and perform prioritization of development initiatives.
• Expertise to provide training to in-house and client training to new environment and BI product.
• Experience in LOE and Cost estimation for technical components.
• Strong Experience as the liaison between IT and sales focused business units coordinating projects, defining business requirements and balancing deliverables.
• Expertise in leading a technical team and provide technical solutions.
• Training on Microsoft Stack, SharePoint, and Agile.

TECHNICAL SKILLS:

BI Reporting Tools: Power BI, SSRS, SSAS, Performance point, Dashboard Designer, SAS, IBM Cognos BI Suite, SAP Business Object BI Platform, SAP Lumira, SAP Business Object Design Studio, Tableau, Microstrategy, Crystal reports, Power BI and Informatics

ETL Tools: Microsoft SSIS, Cognos Data Manager (Decision Stream), SAP Data Services, Informatica Power Center, Informatica PowerMart

Data Modeling Tools: Visual Studio 2012, Cognos Framework, ER/Studio, Erwin, Microsoft Tabular Model

Databases: MS SQL Server, Oracle, MS Access DB2

Testing Tools: Test Director for Test Scripts.

Project Management Tools: Microsoft Project, Microsoft Excel, Microsoft Visio, Microsoft Share Point, Telerik Team Plus, JIRA

Team Management Tools: Visual Studio Team foundation server, Microsoft Share Point, Daptive

Methodology: Agile, Traditional IT Life cycle Methodology (SDLC)

Pragmatic works: BI Documenter

Languages: C, VB, Java, SDK, SQL, PL/SQL, T-SQL, UNIX, Linux, Perl, HTML, XML, Shell script

Other Tools: Redgate Source Control, SQL Monitor, Task Factory, CozyRoc, Big data, Hadoop, Map reducer

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

BI Architect

Responsibilities:

• Developed data load application for corporate data warehouse using Data Integrator increasing load speed three times, which was critical achievement to support data delivery service level agreement.
• Studied, troubleshoot and configured corporate wide scheduling system. Linked all scheduled processes together increasing load speed by ~60%.
• Accomplished the strategic execution of projects to ensure the processes align to the customer's plans and technology road maps architecting OLAP data model schemas for cube development allowing analytical reports to render at maximum.
• Optimized corporate wide ETL operations cutting the overall load time in half.
• Organized a methodology that offered cleared metrics for measuring performance qualification for incentives like meaningful use, accountable care, regulatory compliance, clinical quality, financial performance, operational efficiency
• Lead and mentor application development team with Oracle and PL/SQL tuning and development.
• Lead cross-functional project teams and collaborated with business partners to determine and translate business requirements into technology and training solutions
• Developed, audited, coordinated, and promoted procedures during application development life cycle. Maintained and tuned procedures in three separate environments (development, Quality, and Production).
• Drive the creation and maintenance of a data dictionary around metrics, KPIs and other BI documentation.
• Develop proof of concepts to showcase BI tool functionality to the end users and management audience including report and dashboards.
• Develop strategy for implementing BI presentation layer tools within Organization for the next generation data warehouse including the entire Business Intelligence (BI) stack from standard reports, ad-hoc analysis, drill down reports, dashboards, scorecards and analytics.
• Evaluate feasibility of reporting requirements from the business against the technical stack.

Confidential, Boston, MA

Sr. BI Developer

Responsibilities:

• Strategic Planning for Existing model and BI Architecture.
• Gather and analyze the requirements of the users.
• Prepare Impact associated documentation and logic flow charts applied to business.
• Translates business needs into program specifications, which are Critical to Quality.
• Manage & handle the daily support, technical issues, tuning and disaster recovery issue.
• For standard reports, develop and oversee a schedule and plan for report generation, distribution, and distribution channels such as the Intranet, Extranet as well as the organizational levels
• Track & monitor the status of business requests ensuring that appropriate service levels are being met and that there is appropriate use of staff resources to meet needs.
• Work with reporting resources to create a peer review process for quality assurance.
• Manage the verification of expected report results, validating report data and reporting tools, and manage user acceptance validation and testing.
• Monitor creation of technical specifications, coding, testing and executing report scripts (both ad hoc and regularly scheduled) reflecting documentation for change management.

Confidential, Hartford, CT

Sr BI Consultant (With Multiple Clients)

Responsibilities:

• As a Vlink Consultant, involved in several projects for Installation, migration and upgrades for Report Net 1.1 and Cognos 8.x environment.
• As a Vlink consultant, worked on several small projects related to strategy planning for framework models.
• Designed Framework models using data sources in SQL Server, Oracle, Excel, MS Access
• Design and Develop Framework Packages.
• Written and Created Complex and critical queries.
• Created security setup for all three environments.
• Used conditional formatting, complex calculations, graphs, prompts and multiple drill downs and also used tabular reference, tabular sql, tabular sets and tabular models for complex reports
• Coordinate all communications with the Database Management team.
• Develop, document, manage, and coordinate all user acceptance testing.
• Deployed reports to all different environment (Dev, QA, Prod)
• Received an outstanding award from the Vlink based on the client’s performance review.

Confidential, Orlando, FL

Sr BI Consultant (As a Vlink Consultant)

Responsibilities:

• Coordinate with the Database Person for create the replica database for Reporting.
• Create the Reporting database from multiple data sources.
• Gather and analyze the requirements of the users.
• Design & Trouble shooting in Cognos 8.4/8.3 environment.
• Design System Architect for Cognos 8.4/8.3 Environment.
• Migration from Cognos 8.3 to Cognos 8.4.
• Strategic Planning for Framework Models.
• Designed Framework models using OLAP data sources in SQL Server.
• Import the data from the Costpoint data source and map Costpoint Objects into framework Manager.
• Develop Customize Costpoint Reports like (Time Sheet, purchasing, Labor, Journal etc.) Using Report Studio, Query Studio and Analysis Studio.
• Create critical finance, Accounting, project management, Journal reports into Cognos 8.3 & Cognos 8.4 environment.
• Build OLAP cubes using Cognos Transformer, views using Power Play.
• Develop, document, manage, and coordinate all user acceptance testing.

Confidential

Software Engineer

Responsibilities:

• Created database connections for different data sources.
• Created several different types of ad-hoc (Simple List, Grouped List, Section Heading, Crosstab, and Nested Crosstab) Reports and represented data graphically by Charts utilizing Query Studio.
• Created several different types of Professional Reports (Mailing Labels, Web Page Style, Cascading, Linked / Drill Through, Production, Business, Ranking, etc…) with complex formatting utilizing Report Studio.
• Produce Queries and Reports in Multiple Languages. Format, Present and Distribute Reports utilizing Different Layouts, Multiple Report Objects and Multiple Logical Pages.