SUMMARY:

• 12 years of experience in Information Technology. Offers strong business analysis, leadership, effective communication and successful team building skills.
• In - depth understanding of data warehouse and business intelligence technologies, including experience with huge databases, ETL processing, Master Data Management, Dimensional data modeling, OLAP, and reporting tools.
• Excellent leadership and people management skills; ability to define team goals and objectives and motivate a high performing team to achieve them.

TECHNICAL SKILLS:

Database: Microsoft SQL Server 2012/2014, Oracle 10g R2, Microsoft Access 2013

Database Tools: SQL Server Management Studio, Profiler, Redgate SQL Prompt

Dashboard Tools: Dundas for ASP.NET Enterprise 6.1, Dundas for OLAP Enterprise 6.1

Database Language: SQL, T-SQL

Business Intelligence: Qlik View, Qlik Sense, Qlik Analytics, SQL Server Integration Services 2012/2014, SQL Server Analysis Services 2012/2014/2016, SQL Server Reporting Services 2012/2014/2016, SharePoint (MOSS) 2013, Microsoft Visio 2013, Power BI

Business Intelligence: Cognos 8 BI, Cognos Query Studio, Cognos Report Studio, Cognos Analysis Studio, Cognos ReportNet, Cognos Impromptu, Cognos PowerPlay Transformer, Cognos PowerPlay

Datawarehouse Modeling: ER-Diagrams, Dimensional Diagrams, Star and Snowflake Schemas

Datawarehouse Modeling Tools: IBM Cognos Framework Manager

Programming Language: C#.NET 2008, ADO.NET 3.5, C

Testing Tools: Mercury Quality Center 9.0, JIRA, Target Process

Web: Visual Studio 2005/2008, ASP.NET 3.5, HTML, XML

Operating Systems: Windows 7 Enterprise, Windows 2008 Server Enterprise, Windows XP Professional

Other: Microstrategy, Microsoft Team Foundation Server, Microsoft Office 2013, Microsoft Performance Point Server

CORE SKILL AREAS:

• Business Analysis, Project Management
• Data Warehouse & Business Intelligence
• Project Planning, Scheduling, Management
• Team Building, Mentoring & Leadership
• Business Process Reengineering Initiatives
• Disaster Recovery & Business Continuity
• Budget Development & Administration
• Hardware & Software Needs Assessment
• Business & Service Level Agreement
• IT & Corporate Policy Development

PROFESSIONAL EXPERIENCE:

Confidential, NY

BI ARCHITECT

Environment: Microsoft SQL Server 2008, SSIS 2008, SSAS 2008, SSRS 2008, Visual Studio 2008/2010, TFS, Agile/Scrum

Responsibilities:

• Understand existing Business Data Model and Customer Requirements for different phases of the project
• Created several SSAS 2016 cubes
• Created SSIS packages in 2012
• Used C# in several script tasks
• Used Lookup, Derived Column, Expression, Union ALL transformations
• Created and managed SSAS cubes to support enterprise level reports
• Involved in performance tuning of cubes using partitions.
• Used Power Pivot, Power View and Power BI dashboards
• Created and published Power BI dashboards to sharepoint
• Created maps, charts and parametrized reports in Power BI
• Used Stored procedures, views and functions to improve performance of queries.
• Lead strategy, architecture, and delivery roadmap planning
• Coordination of the day to day activities of team members for small, medium and large Data Warehouse and Reporting projects.
• Ensure project deadlines are met in a timely and efficient manner
• Creation and management of the project plan to ensure timely completion of the project - On time, within budget and maintaining scope
• Create Executive dashboards, presentations, and reports and present to key stakeholders.
• Performance tune existing SSIS packages and SSRS reports
• Implement best practices
• Schedule the SSIS jobs, SSRS reports and SSAS cubes
• Conduct regularly scheduled project review meetings with project team members and
• Used Lookup, Conditional Split, OLEDB command and other Data flow tasks in SSIS
• Used Execute SQL, Email and other Control Flow tasks
• Perform Unit Testing, System Testing and Integration testing of data and the packages
• Worked independently in creating and fine tuning the ETL Packages
• Communicate with business and modify the ETL Packages per business requirements
• Created and deployed SSAS cubes and perspectives

Confidential, NY

BI ARCHITECT

Environment: Microsoft SQL Server 2008, SSIS 2008, SSAS 2008, SSRS 2008, Visual Studio 2008/2010, TFS, Agile/Scrum

Responsibilities:

• Understand existing Business Data Model and Customer Requirements for different phases of the project
• Performance tuned SQL queries
• Integrated existing systems with PeopleSoft
• Created several SSIS packages in 2012
• Extensively used Sharepoint to publish and manage dashboards
• Extensively used Sharepoint to deploy cubes and user reports
• Used Lookup, Derived Column, Expression, Union ALL transformations
• Used C#.NET in script tasks
• Responsible for making changes to several metrics in the cube, adding partitions, adding aggregations, performance tuning and processing the cube.
• Interacted with business and technical teams, with clients, technical architects, project managers, requirements analysts to successfully deliver the reports on time.
• Created and scheduled cube runs
• Created and deployed Power BI dashboards and charts
• Created power pivot reports
• Used power query to extract and load data
• Created Wrote several Performance tuning SQL Queries
• Created Stored Procedures, Triggers and indexes.
• Modified ETL and SQL queries and brought down response time from a few hours to under an hour
• Researched several BI Tools in market and suggested best and most efficient tools to cater to business needs
• Managed and defined data warehouse and business intelligence strategy and performed an analysis of BI/DW business requirements, resource consumption across multiple platforms.
• Propose and follow best practices for SSIS Packages to make sure packages data load is fast and efficiently
• Used Lookup, Conditional Split, OLEDB command and other Data flow tasks in SSIS
• Used Execute SQL, Email and other Control Flow tasks
• Perform Unit Testing, System Testing and Integration testing of data and the packages
• Worked independently in creating and fine tuning the ETL Packages
• Communicate with business and modify the ETL Packages per business requirements
• Created and deployed SSAS cubes and perspectives

Confidential, PA

BI ARCHITECT/LEAD

Environment: Microsoft SQL Server 2008, SSIS 2008, SSAS 2008, SSRS 2008, Visual Studio 2008/2010, TFS, Agile/Scrum

Responsibilities:

• Understand existing Business Data Model and Customer Requirements for different phases of the project
• Gather Claims, Premium and Workers Comp. data
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS and in adding calculations
• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.
• Design Data Models to support reporting and analysis
• Prepared Business/Technical Report Specifications.
• Translated the Business Requirements into Technical specs
• Schedule reports in order for end users to be able to run reports as and when desired
• Involved in preparing the Test Scripts for the generated reports for UAT
• Created Stored Procedures, Triggers and indexes.
• Created and published Power BI dashboards
• Created Parameterized reports in SSRS
• Created several drill-through reports in SSRS
• Created Several ETL Packages in SSIS using various Control Flow and Data Flow Transformations
• Used Cognos Report Studio to create several reports and publish to IBM Cognos Connection
• Developed various crosstab, list and dashboard reports
• Develop various Corporate Dashboard Reports using Microsoft SQL Server Reporting Services as the Reporting Tool
• Created Data Design Models for the Data Warehouse
• Created Source-Target Mapping Documents
• Created High level and Low level design documents
• Proposed changes to existing Data warehouse model
• Created, maintained and supported SSIS Packages.
• Worked independently in creating and fine tuning the ETL Packages
• Communicate with business and modify the ETL Packages per business requirements
• Created and deployed SSAS cubes and perspectives
• Performance tuned the SSAS cubes
• Create SSAS Tabular models and publish models for client use

Confidential, NY

BI ARCHITECT/LEAD

Environment: Microsoft SQL Server 2008, SSIS 2008, SSAS 2008, SSRS 2008, Visual Studio 2008/2010, TFS, Agile/Scrum

Responsibilities:

• Worked with Business Solution team to understand and determine scope for different projects.
• Defined and designed project scope
• Create Dimensions and Fact tables
• Used Regression, Time Series, Clustering Algorithms
• Used Aggregator, Execute SQL and Merge Join transformations in SSIS
• Deployed reports on Report Server and SharePoint Server also scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports.
• Support production system for OLTP and post deployment SSIS packages/ SSRS Reports on the server.
• Responsible for the development of ETL/SSIS Packages, SSRS Reports and T-SQL objects like stored procedures, triggers, indexes and functions.
• Extensively Implemented SSIS auditing, error handling, and email error messaging.
• Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment using SQL Server Reporting Services(SSRS).
• Performed customization and configuration work on OLTP databases, tables, stored procedures, SSIS packages and other objects.
• Enhanced the reusability of the packages by making and deploying shared containers and
• Scheduled ETL packages for Development and production environment with SQL Server Job Agent.
• Designed, built and deployed MOLAP cubes in SSAS.
• Designed, Developed and maintained Relational databases.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Used that calculated measures in SSRS reports by using source connection as cube in SSRS.
• Created SQL server agent job to regularly process cube.
• Created and used SSAS Data mining models
• Predictive Modelling and Analysis
• Participated in reviews of issues related to SSIS Packages/SSRS reports and work in troubleshooting those issues, fixing, testing and re-deploying them.
• Involved in creating detail design documents for ETL jobs.

Confidential, NJ

BI ARCHITECT/LEAD

Environment: Microsoft SQL Server 2008, SSIS 2008, SSAS 2008, SSRS 2008, Visual Studio 2008/2010, TFS, Agile/Scrum

Responsibilities:

• Create Dimensions and Fact tables
• Data Governance and Data Quality
• Gather requirements and design reports
• Performance tune SQL queries
• Suggest enhancements to existing and propose changes to new reports, based on discussion with client
• Experience with Master Data Management
• Compared and cleaned data using SQL Server Master Data Services
• Created Data Management Gateways for Cloud refreshes
• Created Report Builder 2012 reports and trained users on using the reports
• Created parameterized SSRS reports, deployed them to server and scheduled them
• Created and supported SSIS ETL packages and jobs on 2012 servers
• Create SSAS 2012 Tabular models and publish models for client use
• Used TeamFoundationServer to park source code
• Used Power BI extensively for reporting and dashboarding
• Extracted data using PowerQuery
• Created reports, bar charts, maps and tables using PowerView
• Created Line, Scatter and used Play axis in Powerview
• Create PowerPivot data models and reports
• Used PowerBI for BI needs
• Used XML as datasource for ETL
• Gather requirements from Business Users
• Created business reports in Power Pivot and Powerview
• Created and trained users on Power pivot and Power view reports

Confidential, NY

BI ARCHITECT/LEAD

Environment: Microsoft SQL Server 2008, SSIS 2008, SSAS 2008, SSRS 2008, Visual Studio 2008/2010, TFS, Agile/Scrum

Responsibilities:

• Create Data warehouse Star Schema Structures
• Created Powerpivot reports
• Extracted data using PowerQuery
• Used XML as data source in SSIS Packages
• Installed and used Master Data Services (MDM) for business data
• Designed Dimensions and Fact Tables
• Created parameterized SSRS reports, deployed them to server and scheduled them
• Use Lookup, Sort and other complex transformations in SSIS 2012 to implement business transformations
• Created Drillup, drilldown, drill through and several operation reports in SSRS 2012
• Created data for users in Report Builder
• Create SSAS Tabular models and publish models for client use
• Gather requirements from Business Users
• Created business reports in Power Pivot and Powerview
• Work closely with End users in defining, modifying and freezing requirements
• Assist users with technical expertise needed
• Created PowerPivot and Powerview reports
• Created Tablix, Chart and tabular reports in SSRS 2012
• Work closely with clients to understand and propose requirements
• Experience working with VLDB
• Create Unit test cases
• Perform Unit Testing, System Testing and Integration testing of data and the packages

Confidential, Philadelphia, PA

BI ARCHITECT/LEAD

Environment: Microsoft SQL Server 2008, SSIS 2008, SSAS 2008, SSRS 2008, Visual Studio 2008/2010, TFS, Agile/Scrum

Responsibilities:

• Created and Managed Full Life Cycle BI/DW Data Integration, Data Warehousing and Business Intelligence Project for Consumer Lending.
• Created visually appealing analytical models in Pivottable, Pivotcharts
• Created several adhoc and scheduled reports in SSRS
• Created calculated columns, hierarchies, slicers in Powerpivot
• Created and deployed SSAS cubes and perspectives
• Performance tuned the SSAS cubes
• Created several KPIs in SSAS
• Created several list, tablix and chart reports in SSRS
• Scheduled SSRS reports in Report Manager
• Trained users on using Microsoft Excel, PowerView and PowerPivot as reporting tool
• Wrote several Performance tuning SQL Queries
• Modified ETL and SQL queries and brought down response time from a few hours to under an hour
• Created Mining models and used in Excel
• Created Data Design Models for the Data Warehouse
• Created Source-Target Mapping Documents, High level and Low level design documents
• Proposed changes to existing Data warehouse model
• Created Documentation for Modeling and ETL phases
• Provided several solutions to convert many manual processes to automated process
• Create, manage and monitor SQL Server scheduled jobs
• Extensively used Lookup, Merge Join, and other SSIS transformations
• Trained users on SSIS and SSRS
• Gather requirements, prepare documentation and interact with client on regular basis
• Created reconciliation SSRS reports
• Prepare technical and functional documentation
• Create and modify existing data models and data marts
• Performance tune existing SSIS packages and SSRS reports
• Implement best practices
• Schedule the SSIS jobs, SSRS reports and SSAS cubes

Confidential, Berwyn, PA

BI ARCHITECT

Environment: Microsoft SQL Server 2008, SSIS 2008, SSAS 2008, SSRS 2008, Visual Studio 2008/2010, TFS, Agile/Scrum

Responsibilities:

• Created and Managed Full Life Cycle BI/DW Data Integration, Data Warehousing and Business Intelligence Project for Consumer Lending.
• Provided several solutions to performance tune several processes
• Created and managed SSAS cubes to support enterprise level reports
• Involved in performance tuning of cubes using partitions.
• Lead strategy, architecture, and delivery roadmap planning
• Coordination of the day to day activities of team members for small, medium and large Data Warehouse and Reporting projects.
• Ensure project deadlines are met in a timely and efficient manner
• Creation and management of the project plan to ensure timely completion of the project - On time, within budget and maintaining scope
• Create Executive dashboards, presentations, and reports and present to key stakeholders.
• Conduct regularly scheduled project review meetings with project team members and stakeholders.
• Improved the usability and accessibility of analytic business data; delivered timely and trustworthy data feeds to downstream systems, delivered standardized reporting and analytics, provide self-service analytics.
• Managed a team of Data Warehouse and Business Intelligence professionals, (onsite and offshore) and provided day-to-day management support to the team.

Confidential, Redwood City, CA

BI Architect/ Team Lead

Environment: Microsoft SQL Server 2008, SSIS 2008, SSAS 2008, SSRS 2008, Visual Studio 2008/2010, TFS, Agile/Scrum

Responsibilities:

• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.
• Prepare Project Plan for the Project and update the plan at various phases to ensure deadlines are met
• Effort estimation for various phases of the Project
• Created lookup, execute sql tasks and other complex transformations in SSIS
• Created and scheduled jobs in SSIS 2005
• Prepare Business/Technical Report Specifications and Functional and Non-Functional Requirements’ Documentation
• Interact with Business End-Users on a regular basis
• Work closely with the business and understand their requirements/views
• Translate business users' requirements into technical requirements
• Prepare Monthly, Quarterly and Annual assessments of the business environment
• Design/Develop the Entire Business Data Warehouse
• Design Data Models to support reporting and analysis
• Use various Dimensional Modeling techniques including Star and Snowflake Schemas
• Identify Data Marts, Choose Dimensions and identify Aggregation Strategy
• Research several Data warehousing tools available in the market and select the best one to meet the business requirements
• Implemented logic in a way that reduced the number of queries by over a half
• Experience using Visual Studio 2008 in creating various Microsoft Applications
• Migrated reports and packages from SSIS 2005 and SSRS 2005 to SSIS 2005 and SSRS 2008
• Created various SSIS transformations viz..Derived Column Transformations, Execute SQL Tasks, foreach loop container, etc.
• Installed and configured several tools including but not limited to SQL Server 2005/2008, SSIS 2005/2008, SSRS 2005/2008

Confidential, Mount Prospect, IL

BI Developer/ Team Lead

Environment: Microsoft SQL Server 2008, SSIS 2008, SSAS 2008, SSRS 2008, Visual Studio 2008/2010, TFS, Agile/Scrum

Responsibilities:

• Understand existing Business Data Model and Customer Requirements for different phases of the project
• Designed and developed high level data cubes and supported Reports.
• Worked with SSAS storage and partitions, and Aggregations, calculation of queries, Data Mining Models.
• Built Framework models from scratch by analyzing business processes
• Prioritized tasks/deadlines and accordingly, worked towards deliverables
• Prepared Functional/ Data Validation/ UI validation test scripts
• Understand existing Business Data Model and Customer Requirements for different phases of the project
• Prepared Business/Technical Report Specifications.
• Translated the Business Requirements into Technical specs
• Schedule reports in order for end users to be able to run reports as and when desired
• Designed, Developed and Implemented an Enterprise Wide Reporting system using Cognos
• Regular interaction with Project Manager, Software Developers and Testing and other concerned teams to ensure Business Requirements are met
• Effort Estimation for various phases of ETL and Reporting
• Involved in preparing the Test Scripts for the generated reports for UAT
• Used Cognos Report Studio to create several reports and publish to Cognos Connection
• Developed various crosstab, list and dashboard reports