SUMMARY:

• Extensive experience working with SQL Server data transformation services (DTS).
• Experience in database performance tuning and query optimization, data integrity and statistics.
• Hands on experience in creating ETL packages using SQL Server /2012 Integration Services (SSIS).
• Hands on experience in creating OLAP cubes using SQL Server 2005/2008/2012/2014 analysis services (SSAS).
• Good experience and understanding on Microsoft Data mining Algorithm.
• Hands on experience on Dundas application tools.
• Understanding of Power BI both Desktop version and old version Of Excel
• Created lot OF POC working with data at run time and creating analysis service project.
• Extensive experience in Data Migration, Data Conversions, Data Extraction/ Transformation/Loading (ETL) using DTS, PL\ SQL Scripts.
• Extensive experience in data migration between homogeneous & heterogeneous systems using various tools (DTS Import Export Data, DTS Packages, Bulk Insert and BCP, SSIS).
• Experience Bring data into Power BI Desktop, and create a report.
• Experience in creating DTS/SSIS packages with ActiveX scripting for transferred data modifications.
• Experience in developing complex SSRS Reports against both OLAP and Relational Database
• Experience in developing reports against SSRS reporting Builder
• Experience in designing logical and physical data models using ERWIN and ER/Studio tools.
• Good understanding on Asp.net Architecture.
• Good knowledge in the installation and configuration of SQL Server 2005.
• Extensive experience in T - SQL to write: stored procedures, triggers, functions, tables, views, indexes and relational database models.
• Hands on experience working with SQL Server 2005 analysis services, reporting services and integration services.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using MS Analysis Services
• View and interact with shared dashboards and reports in Power BI Mobile apps
• Extensive experience in working with the ETL tool.
• Comfortable working with Oracle 9i - PL/SQL programming and SQL * Plus.
• Experience in creating reports using Business Objects.
• Working on Product Usage Framework and Search Quality Framework, to provide company with insight to the company on how the products are doing mamong customers.
• Good understanding on Identity Management and single Sign on experience.
• Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS).
• Developed reports using SSRS 2005 to generate all daily, weekly, monthly reports
• Experience on Data Quality Services and Master Data Services
• Create SSRS Subscriptions that gets delivered to user on periodically basis
• Create both Manual and Data Driven subscriptions in SSRS 2008 R2
• Created drilldown, drill through and drill across reports in SSRS
• Have some exposure to develop reports against Spatial Data in SSRS
• Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS).
• Created Data Governance Program and awareness in the organization.
• Helped in creating Standards within organization.
• Helped Organization in forming Data Governance Council. Also helped in developing its role and responsibilities.
• Helped in creating Taxonomies and identified the importance of target and clean data to support the organization.

TECHNICAL SKILLS:

Operating Systems: MS-DOS, Windows 95/98/NT 4.0/XP/2000/2003 Server, UNIX

RDBMS/ Databases: MS SQL Server 7.0/2000/2005/2008, Oracle 8i/9i

Data warehouse Tools: SSIS, SSRS, SSAS, Data Mining, OLAP, SQL data

Data modeling & ETL Tools: ER/Studio, ERWIN, Visio

Reporting Tools: Microsoft reporting server, Business Objects XI

Packages: MS Office, Visual Basic

Languages: C, C++, Java, SQL, PL/SQL, T-SQL

Web Technologies: HTML, VB-Script, DHTML, XML

Microsoft Technologies: VB.Net, ASP.Net, C#.Net

PROFESSIONAL EXPERIENCE:

Confidential

Sr. BI Technical Architect

Responsibilities:

• Designed the entire data warehouse solution for insurance industry for UPS.
• Got familiarized with various premium, Claim data and architect the data model to accommodate ODS and Dimensional Data warehouse.
• Create a road map for the Enterprise and architecture road map for the success of the project.
• Introduced a foundation for Data Governance model.
• The entire solution incorporates end to end solution including report delivery.
• Worked and managed team of 8 resources to complete the entire project.
• Helped with project planning and ensure to deliver the product within budget.
• Learnt about various internal data sources such as IMS, IMX, CAPS, NTABL, IMX, Smart lite, UPSDWH, PCS, Portal, Bridge system .
• Build a Scale Out and Scale up Solution for future expansions and integrations.
• Involved and recommended enterprise’s server hardware, operating system for the enterprise data warehouse. Involved in creating Solution for Application Integration Including Defining, selecting tools, specifying shared and code resources. Defining dataflow.
• Performed Data analysis. Profiled Data from source, worked on ensuring the data quality is managed.
• Worked with system to come up with Master Data Service technology
• Reverse engineering the existing database to finding issues communicate with stakeholders at all levels to understand requirements manage to build multi-year strategic vision provide strong technical direction for leadership to visualize implementation
• Lead Data Warehouse Dimensional Modeling efforts including defining the Data Mode
• Design and Naming standards from the Database to the BI Layer to ensure consistency
• Leveraged data architecture and warehousing skills to build a leading-edge Data warehouse encompassing the entire life-cycle including data integration, transformation, logical and physical design implementing industry best practices.
• Collaborate with teams and other stakeholders to assess business and system requirements to develop and implement scalable Data warehouse solution that meets current and future needs.
• Performance tuning, tweaking and implementation of faster query performance baseline.
• Implementation of Power BI Gateway
• Introduced Power BI and trained user on User of Power BI technology.
• Implemented Kerberos authentication and double hop access for the users. Helped creating SPN’s guided team on delegation and accessing the row level security.
• Performed Row level security features using SSAS tabular
• Developed and designed the SSAS tabular model and row level security
• Designed ETL to help downstream systems using SSIS
• Created SSIS Package Framework to help with parallel processing.

Environment: SQL Server 2016, T-SQL, Analysis Services (SSAS), Reporting Services 2016, Integration Services (SSIS), Query Analyzer, SQL Profiler, SQL - Database Tuning Advisor, SQL Performance Monitor, Data Quality Services, Master Data Services, SharePoint Online 365, Power BI Desktop, DAX, Power BI Cloud

Confidential

BI Architect/Trainer

Responsibilities:

• Gather requirements for Service line Cube
• Created POC of Trueven Data Analytics
• Assisted in building Data Mart for Service line and Truven Data cube
• Created Training materials for
• Created lot OF POC using Power BI working with data at run time and creating analysis service project
• Experience Bring data into Power BI Desktop, and create a report.
• Creating Modeling and relationship in Power BI project.
• Experience creating Data Relationship, Calculated Columns, optimizing data model for performance, working with measures, Create calculated Tables. Explore time based data
• Working with power Bi Visualization, Using Simple visualization objects, Combination charts, Format slicer, Map visualization, Table and Matrix, Scatter Chart.
• Publishing and Sharing of reports.
• Understanding and using DAX
• Helped team with design and architecting the Solution. Also worked with other team architects and helped in to provide End to end solution
• Demonstrated Training plan for the organization’s IT team
• Creating content and demonstrating skills sets to create training plans
• Trained technical folks with the tools sets
• Power BI
• Power Pivot
• SSAS Tabular
• SSAS Multidimensional
• Reporting Service
• Power View
• Team Foundation Services

Environment: SQL Server 2016, T-SQL, Analysis Services (SSAS), Reporting Services 2016 Integration Services (SSIS), Query Analyzer, SQL Profiler, SQL - Database Tuning Advisor, SQL Performance Monitor, Data Quality Services, Master Data Services, SharePoint Online 365, Power BI Desktop, DAX

Confidential

SQL Developer

Responsibilities:

• Gather requirements for report development
• Develop adhoc reporting needs into reports and stored procedure.
• Write complex T-SQL, Stored procedures as underlying data needs for reports.
• Working with SSRS Visualization, Using Simple visualization objects, Combination charts, Parameters, Table and Matrix, Scatter Chart.
• Publishing and Sharing of reports.
• Worked on stored procedures, triggers and also on large number of business analytical functions.
• Add and modify all required tables/databases to support the requests from the system analysts and the systems Integrator and provide daily production support for the operations of databases.
• Hands-on training in the use, maintenance, and development of databases using MS SQL Server 2014/2016.
• Involved in supporting and maintaining the database servers, performing database installation, configuration, and upgrade.
• Involved in designing, implementing of database backup and restore procedures.
• Create report metadata for accessing and managing roles using middle layer.
• Create SSIS packages to help with state reporting, manage and deliver report using SSRS Solution and middle layer.
• Create deployments instructions.

Environment: SQL Server 2014/2016, T-SQL, Reporting Services 2014, Query Analyzer, SQL Profiler, SQL - Database Tuning Advisor, SQL Performance Monitor, T-SQL, Data Query

Confidential

Sr. BI Developer/Architect

Responsibilities:

• Have written SharePoint Governance creating a Implementation and process for entire enterprise.
• Design and architect Information architecture
• Gather requirements for sharepoint and create development lead.
• Built wireframes for all the design session
• Built Metadata and term dictionary
• Configured Taxonomies and search Tags
• Created POC of Entire Sharepoint Solution.
• Assisted in building Data Mart and sharepoint Online Solution for SPH Analytics Assisted the team in requirements gathering.
• Understanding of Power BI both Desktop version and old version Of Excel
• Created lot OF POC using Power BI working with data at run time and creating analysis service project
• Experience Bring data into Power BI Desktop, and create a report.
• Creating Modeling and relationship in Power BI project.
• Experience creating Data Relationship, Calculated Columns, optimizing data model for performance, working with measures, Create calculated Tables. Explore time based data
• Working with power Bi Visualization, Using Simple visualization objects, Combination charts, Format slicer, Map visualization, Table and Matrix, Scatter Chart.
• Publishing and Sharing of reports.
• Understanding and using DAX
• Helped team with design and architecting the Solution. Also worked with other team architects and helped in to provide End to end solution
• Created SSIS packages to automate the creation of partitions and process the
• Created and design DataMart to load huge data set with high performance
• Planned and designed the incremental data load to improve the performance faster and higher
• Publish to the Power BI service, where you create new visualizations or build dashboards
• Administer performance issues, Fine tuning performance issues.
• Developed and built auditing and error handling process
• To lead all aspects of Business Intelligence with architecture, design and implementation projects while adhering and applying best practices for SSAS/SSIS/SSRS tools
• Managing and leading the SSAS, SSIS, SSRS module
• Detailed project planning, development and maintenance for SSAS, SSIS and SSRS
• Create and maintain project tasks and schedules
• Requirements analysis from business, Functional Specification preparation and explain the same to offshore team
• Managing project scope and change control
• Mentor team members in technical, functional and processes.
• Agile coaching, facilitating meetings:
• Planning sessions, retrospectives, daily standups, etc.
• Involving in design and development of a metadata-driven ETL framework
• Involved in the design of star and snow flake schemas for the data warehouse
• Handled inferred and slowly changing dimensions while loading fact and dimension tables respectively
• I was part of the Analysis and Design team
• Design and improved the Dimensional Data model for improved and efficiency reporting on research data.
• Created Stored Procedures and User Defined functions.
• Created Indexes to speed up the queries.
• Experience with ANSI SQL query writing in a relational database environment including complex query writing.
• Involved in loading the fact and dimension tables
• Identified and defined fact and dimension relationships
• Involved in the ETL process, used SSIS tasks and transformations to accomplish the ETL process
• Provide Expertise on solution designing for Data Quality Services and Master Data Services.
• Implement Data Quality Services and Master data Services.
• Deployed reports on to the report manager and presented them to the users creating custom vb.net applications and asp.net pages
• Created data source views from data sources SQL Server, Oracle
• Designed the architecture Support Data Quality Services and helping team to understand the Importance and stewardship of Data Quality Services.

Environment: SQL Server 2012 R2, T-SQL, Analysis Services (SSAS), Reporting Services 2012 R2, Integration Services (SSIS), Query Analyzer, SQL Profiler, SQL - Database Tuning Advisor, SQL Performance Monitor, Data Quality Services, Master Data Services, SharePoint Online 365, Power BI Desktop, DAX

Confidential

Sr. BI Developer/SSIS Lead

Responsibilities:

• Worked and managed the development team within agile environment.
• Responsible team member involved in requirements gathering with customers, end user and other development groups.
• Responsible team member involved in creating analytical reporting solution.
• Helped architecting and designing the relational data warehouse and data mart.
• Worked on PCORI and POPDNED MED Data and built a warehousre that allows and use reference data from PCORINET>
• Project to include information of patients and caregivers they need to make important healthcare decisions for the research .
• The PCORnet CDM will be implemented in phases. This will allow in corporation of new data domains and fields throughout the life of the project, building based on PCORnet needs, lessons learned from use, and data availability.
• Part of the team which designed Data warehouse
• Created Stored Procedures and User Defined functions.
• Created Indexes to speed up the queries.
• Experience with ANSI SQL query writing in a relational database environment including complex query writing.
• Implementation of De-Identification process. Creating a algorithm using Pseudo ID’s built within SSIS package
• Develop informatics standards, interoperability among systems, plans for achieving data standardization
• Create a research data warehouse with limited data sets of patients from Schedule D sites (PrimeSuite only to start) using a start data schema data mart
• Use new query tool (PopMedNet) to respond to query requests from PCORI using report /Power BI Tools
• In adherence of HIPPA practice to protect information
• Involved in loading the fact and dimension tables significant expansion from the original CDM(Common Data Model); some elements are still under discussion at the PCORI task force level.
• Identified and defined fact and dimension relationships
• Involved in the ETL process, used SSIS tasks and transformations to accomplish the ETL process
• Provide Expertise on solution designing for Data Quality Services and Master Data Services.
• Worked and managed the development team.
• Enhanced and promoted the idea of agile development methodology to software development group with in organization.
• Wrote SSIS packages
• Design, construct, deploy, test and support data storage in relational and multi-dimensional database technologies dealt with Diagnosis, ICD9, ICD10, Procedures, Interventions, Laboratory upload
• Helped architecting and designing the relational data warehouse and data mart
• Create SSIS Packages to load the data in to the data mart
• Created and design Cubes for faster Analysis Using SSAS OLAP Report
• Administering OLAP and reporting Services environment.
• Supervised contractors and other team members and their progress in the environment
• Created lot OF POC using Power BI working with data at run time and creating analysis service project
• Experience Bring data into Power BI Desktop, and create a report.

Environment: SQL Server 2012 R2, T-SQL, Analysis Services (SSAS), Reporting Services 2012 R2, Integration Services (SSIS), Query Analyzer, SQL Profiler, SQL - Database Tuning Advisor, SQL Performance Monitor, Power BI Desktop, DAX

Confidential

BI Architect/Data Modeler

Responsibilities:

• Analyzed and Reviewed the Enterprise and architecture requirements and
• Designed and developed proposed BI Solution End to End Solution for the Confidential to standardize and support HIPPA Compliance.
• Develop BI Solution that would integrate with Stanford and UHA Health system with recent acquisition of Affinity Medical by Stanford.
• Create a Robust solution that would help taking care of all the small bits and pieces of the entire solution of affinity Medical.
• Build a Scale Out and Scale up Solution for future expansions and integrations.
• Involved and recommended enterprise’s server hardware, operating system for the enterprise data warehouse.
• Involved in creating Solution for Application Integration Including Defining, Selecting tools, specifying shared and code resources. Defining dataflow.
• Working on Data Analysis
• Worked on Data Profiling
• Worked on process for data integration and data quality
• Reverse engineering the existing database to finding issues communicate with stakeholders at all levels to understand requirements manage to build multi-year strategic vision provide strong technical direction for leadership to visualize implementation
• Lead Data warehouse Dimensional Modeling efforts including defining the Data Mode
• Design and Naming standards from the Database to the BI Layer to ensure consistency
• Leveraged data architecture and warehousing skills to build a leading edge Data warehouse encompassing the entire life-cycle including data integration, transformation, logical and physical design implementing industry best practices.
• Collaborate with teams and other stakeholders to assess business and system requirements to develop and implement scalable Data warehouse solution that meets current and future needs.
• Document and diagram the proposed solutions to present to management, IT groups and project stakeholders. Prepare functional specifications and data dictionaries.
• Participated in the resolution of complex performance issues or enterprise failures involving critical business processes.
• Helped to provide root cause analysis and recommend Data warehouse solutions.
• As a data modeler participated in requirements gathering sessions and get input from the users to design data architecture model

Environment: SQL Server 2012 R2, T-SQL, Analysis Services (SSAS), Reporting Services 2012 R2, Integration Services (SSIS), Query Analyzer, SQL Profiler, SQL - Database Tuning Advisor, SQL Performance Monitor

Confidential

Sr. BI Developer/Architect

SSAS /SSIS

Responsibilities:

• Worked and managed the development team within agile environment.
• Responsible team member involved in requirements gathering with customers, end user and other development groups.
• Responsible team member involved in creating analytical reporting solution.
• Helped architecting and designing the relational data warehouse and data mart.
• Worked on Meaningful Use Stage 2 Deliverable. worked on Meaningful measure Stage 2 and CQM for Stage 2
• Created Complex MDX Calculations.
• All the Meaningful use results for Dashboard where built in MDX
• Part of the team which designed Data warehouse
• Worked and managed the development team.
• Enhanced and promoted the idea of agile development methodology to software development group with in organization.
• Wrote Complex MDX and T-SQL queries.
• Design, construct, deploy, test and support data storage in relational and multi-dimensional database technologies dealt with Diagnosis, ICD9, ICD10, Procedures, Interventions, Laboratory upload
• Helped architecting and designing the relational data warehouse and data mart
• Writing Complex MDX queries for each Measures.
• Dealt with Meaningful Use and CQM and QRDA Attributes.
• Wrote complex MDX to support complex business calculation.
• Worked on Performance tuning on both SQL and MDX Queries.
• Created and design Cubes for faster Analysis Using SSAS OLAP Report
• Created Complex MDX Calculations.
• Have some exposure to develop reports against Spatial Data in SSRS
• Fine Tune MDX Queries.
• Administer performance issues, Fine tuning performance issues.
• Fine Tune MDX Queries.
• Create SSIS Packages to load the data in to the data mart
• Created and design Cubes for faster Analysis Using SSAS OLAP Report
• Created Complex MDX Calculations.
• Administering OLAP and reporting Services environment.
• Supervised contractors and other team members and their progress in the environment

Environment: SQL Server 2012 R2, T-SQL, Analysis Services (SSAS), Reporting Services 2012 R2, Integration Services (SSIS), Query Analyzer, SQL Profiler, SQL - Database Tuning Advisor, SQL Performance Monitor

Confidential

Sr. BI Developer/Architect

Responsibilities:

• Worked and managed the development team within Waterfall environment. Enhanced and promoted the idea of agile development methodology to software development group with in organization.
• Responsible team member involved in requirements gathering with customers, end user and other development groups.
• Responsible team member involved in creating analytical reporting solution.
• Also enhanced data warehouse to create and Deliver SLA Metrics and Labor work force and its utilization.
• Helped architecting and designing the relational data warehouse and data mart.
• Created various SSAS cubes to support business needs. Work Management cube to support business needs to verify the SLA metrics and Labor Utilization needs. Also developed SSAS cube to support information related to Travel and Expense reporting. Also developed Cube to bring Active Directory information for daily reporting purpose.
• Created multiple perspectives within in the OLAP cube to control security for various groups.
• Worked on Performance point to create Dashboard KPI and Hierarchies using the data.
• Wrote complex MDX to support complex business calculation.
• Designed and developed various reports in form of canned reporting, dash board and adhoc reporting
• Worked with Performance tuning on both SQL and MDX Queries.
• Create SSIS Packages to load the data in to the data mart
• Created and design Cubes for faster Analysis Using SSAS OLAP Report
• Created Complex MDX Calculations.
• Developed reports using SSRS 2008R2 to generate all daily, weekly, monthly reports
• Create SSRS Subscriptions that gets delivered to user on periodically basis
• Create both Manual and Data Driven subscriptions in SSRS 2008 R2
• Created drilldown, drill through and drill across reports in SSRS
• Have some exposure to develop reports against Spatial Data in SSRS
• Enabled and demonstrated importance of Data Driven Subscription.
• Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS).
• Created SSRS using complex MDX and accessing Analysis Cube.
• Managing reports in Share point environment.
• Development of reports, parameters and KPI using Performance point in SharePoint 2010 Integrated mode.
• Reporting OLAP cubes built with Microsoft Analysis Services.
• Administer performance issues, Fine tuning performance issues.
• Fine Tune MDX Queries.
• Write complex MDX queries
• Administering OLAP and reporting Services environment.
• Supervised contractors and other team members and their progress in the environment.
• Developed Dimensional model to accommodate the needs of reporting using ER Studio Data Architect.
• Developing SSAS OLAP Cube for reporting.
• Develop real time OLTP Reports using SSRS with performance.
• Created awareness of Data Governance in organization to higher management.
• Develop and streamlined a Prototype process on how to Data Governance models to support business process.
• Streamlined importance and identified need of Data Governance in the Organization.
• Promoting the organization in line of creating a program to support Data Governance in the organization rather than a project to help establishment and importance of governance aspect.
• Created Enterprise definitions and Enterprise Glossary with Products of Work Management within the organization.
• Helped outline Sponsorship and worked with upper management to seek sponsorship to promote Data Governance.
• Identified Roles and Responsibilities for the Data Governance Council formation
• Identified list of sources and its importance to create Target data and taxonomies.

Environment: SQL Server 2008 R2, T-SQL, Analysis Services (SSAS), Reporting Services 2008 R2, Integration Services (SSIS), Query Analyzer, SQL Profiler, SQL - Database Tuning Advisor, SQL Performance Monitor, Windows OS. C#.Net, Performance Point, Data Governance, Program Management, Active Directory Identity Management consolidation. Data Management Process, Master Data Management, ER Studio DA

Confidential

Principal Software Engineer

Responsibilities:

• Worked and managed the development team within agile environment.
• Responsible team member involved in requirements gathering.
• Responsible team member involved in creating analytical application for reducing and planning Green House Gas Emissions.
• Helped architect in designing the relational data warehouse and data mart.
• Created complex SSAS Cube that helps analyze and budget and complex business rules that would help reduce emissions.
• Created multiple perspectives within in the OLAP cube to control security for various groups.
• Managing offshore team and helping coordinating with team in Chennai on regular schedules to manage development.
• Was responsible mentor for helping other team in the company, who had trouble developing and maintaining SSAS Cubes.
• Created complex MDX calculation with in SSAS Cube and SSRS report the calculations.
• Assisted various group in development and use of best practices involved in creating SSAS Cube.
• Created Complex SSIS Packages to help and support various data sources.
• Created Data Mining Application that would help forecast data based on Actual Emissions.
• Helped team with Security Implementation in .NET Web Application.
• Helped team in creating various Dundas charts that supports both OLAP Cubes and Relational database reports.
• Created Data Mining Application to use various algorithms supported by Microsoft Data Mining.
• Used Decision Tree data mining Algorithm, Naïve Bayes Algorithm, Neural Network algorithm and Forecast Data Mining Algorithm.
• Helped in modifying and creating Application and database installer.
• Helped customer in supporting installing the application and Database.
• Worked with Performance tuning on both SQL and MDX Queries.
• Created SSIS packages to automate the creation of partitions and process the partitions within the cube.
• Create SSIS Packages to load the data in to the data mart
• Created and design Cubes for faster Analysis Using SSAS OLAP Report
• Created Complex MDX Calculations
• Developed reports using SSRS 2005 to generate all daily, weekly, monthly reports
• Create SSRS Subscriptions that gets delivered to user on periodically basis
• Create both Manual and Data Driven subscriptions in SSRS 2008 R2
• Created drilldown, drill through and drill across reports in SSRS
• Have some exposure to develop reports against Spatial Data in SSRS
• Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS).
• Created SSRS using complex MDX and accessing Analysis Cube.
• Managing reports in Share point environment.
• Reporting OLAP cubes built with Microsoft Analysis Services.
• Administer performance issues, Fine tuning performance issues.
• Fine Tune MDX Queries.
• Write complex MDX queries
• Administering OLAP and reporting Services environment.
• Used Dundas Application for ad hoc analysis. Assisted in development Dundas clients.
• Supervised off shore team and on shore developer for performance of work.
• Developing a usage framework to provide analysis on Users Usage Experience and Search experience finding content.
• Developed a Dimensional model to accommodate the needs of reporting
• Developing SSAS OLAP Cube for reporting.
• Worked on development of Product Usage Framework
• Developing OLAP cubes for Audit and Usage framework to combine and provide information on how products are performing
• Developed SSAS Cube for Search Quality Framework
• Presented well designed report that helps business users to make a decision.
• Develop real time OLTP Reports using SSRS with performance.

Environment: SQL Server 2005, T-SQL, Analysis Services (SSAS), Reporting Services 2008 R2and 2005 (SSRS), Integration Services (SSIS), Query Analyzer, SQL Profiler, SQL - Database Tuning Advisor, SQL Performance Monitor, Windows OS. C#.Net, Microsoft Data Mining, WIF, Identity Management, Access Control, Identity Warehouse, Search Quality Data Mart, Product Usage API.

Confidential

SSAS Sr. Developer

Responsibilities:

• Creating Complex Cube on Microsoft SQL Environment.
• Assisted in building Data Mart for support both insurance and re insurance business.
• Assisted the team in requirements gathering.
• Created SSIS packages to automate the creation of partitions and process the partitions within the cube.
• Create SSIS Packages to load the data in to the data mart
• Created and design Cubes for faster Analysis Using SSAS OLAP Report
• Created Complex MDX Calculations
• Created SSRS using complex MDX and accessing Analysis Cube.
• Managing reports in Share point environment.
• Reporting OLAP cubes built with Microsoft Analysis Services.
• Help people create dashboards using SSRS.
• Administer performance issues, Fine tuning performance issues.
• Fine Tune MDX Queries.
• Write complex MDX queries
• Developed reports using SSRS 2005 to generate all daily, weekly, monthly reports
• Create SSRS Subscriptions that gets delivered to user on periodically basis
• Create both Manual and Data Driven subscriptions in SSRS 2008 R2
• Created drilldown, drill through and drill across reports in SSRS
• Have some exposure to develop reports against Spatial Data in SSRS
• Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS).
• Developed reports using SSRS 2005 to generate all daily, weekly, monthly reports
• Create SSRS Subscriptions that gets delivered to user on periodically basis
• Create both Manual and Data Driven subscriptions in SSRS 2008 R2
• Created drilldown, drill through and drill across reports in SSRS
• Setup Local Cache and reporting cache to improve performance in SSRS
• Administering OLAP and reporting Services environment.
• Integrated SSRS reports in SharePoint for internal access
• Used Dundas Application for ad hoc analysis. Assisted in development Dundas clients.
• Installed and configured SQL Server 2008 R2,Visual Studio 2008 and TFS in Dev environment
• Supervised off shore team and on shore developer for performance of work.

Environment: SQL Server 2005, T-SQL, Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS), Query Analyzer, SQL Profiler, SQL - Database Tuning Advisor, SQL Performance Monitor, Windows OS. VB.Net

Confidential

SSAS OLAP Architect/BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Created Complex Cubes of Teradata Platform for Merchandising Group.
• Most of the cubes were built on Teradata as Source Platform, dealing with Terabytes of data.
• Created SSIS packages to automate the creation of partitions and process the partitions within the cube.
• Create SSIS Packages to load the data in to the data mart on daily basis.
• The Size of each cube is more than 70GB in Size.
• Dealt with Terabytes of Data
• Use excel and SharePoint to connect to the cube data source
• Reporting OLAP cubes built with Microsoft Analysis Services using SharePoint as a front end tool.
• Help people create dashboards using SSRS.
• Created drilldown, drill through and drill across reports in SSRS
• Worked with team to integrated SSRS reports in ASP.Net Application
• Administer performance issues
• Write complex MDX queries
• Administering OLAP and reporting Services environment.
• Worked on creating calculated measures that fits business logic, using MDX queries.
• Created more than 50 SSRS reports for various teams in the company
• Installing report server and SSAS configurations.
• Implemented Cache warming techniques using SSIS for OLAP Cubes

Environment: SQL Server 2005, T-SQL, Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS), Teradata, Query Analyzer, SQL Profiler, SQL - Database Tuning Advisor, SQL Performance Monitor, Windows OS. VB.Net

Confidential, Charlotte, NC

SSAS OLAP Architect/BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Creation of SSAS OLAP Cubes for Ecommerce group, where the cubes are used to automate the current manual process of Reports.
• Moving all the ecommerce reporting to centralized SSAS OLAP Cube and then the future plan would be joining the entire cube to convert it to a huge data mart.
• Created Complex Cubes of Teradata Platform.
• Most of the cubes were built on Teradata as Source Platform, dealing with Terabytes of data.
• Created SSIS packages to automate the creation of partitions and process the partitions within the cube.
• The level of automation was to eliminate if not reduce all the manual process.(converting more then 200 reports into SQL SSAS 2005 and Reporting Services Platform)
• Create SSIS Packages to load the data in to the data mart on daily basis.
• The Size of each cube was more then 20GB in Size.
• Dealt with Terabytes of Data
• Use excel and SharePoint to connect to the cube data source
• Help offshore team in development process and guide the helped them in creation of reports.
• Simplified the complex report into a simple analysis.
• Migrate all the Micro strategy report into reporting services.
• Reporting OLAP cubes built with Microsoft Analysis Services using SharePoint as a front end tool.
• Administering OLAP and reporting Services environment.
• Worked on creating calculated measures that fits business logic, using MDX queries.
• Installing report server and SSAS configurations.
• Implemented Cache warming techniques using SSIS for OLAP Cubes
• Create SSRS Subscriptions that gets delivered to user on periodically basis
• Create both Manual and Data Driven subscriptions in SSRS 2008 R2
• Created drilldown, drill through and drill across reports in SSRS
• Setup Local Cache and reporting cache to improve performance in SSRS
• Administering OLAP and reporting Services environment.
• Integrated SSRS reports in SharePoint for internal access
• Used Dundas Application for ad hoc analysis . Assisted in development Dundas clients.

Environment: SQL Server 2005, T-SQL, Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS), Teradata, Query Analyzer, SQL Profiler, SQL - Database Tuning Advisor, SQL Performance Monitor, Windows OS. VB.Net

Confidential

BI Developer /ETL Developer /BI System Analyst

Responsibilities:

• Creation of SSAS cubes for Automotive marketing Research Company, which does analysis on performance of their dealers.
• Creating various OLAP cubes using MS SQL Analysis Services 2005.
• Creating reports of SQL Server Analysis Server cubes in SSRS.
• Built MDX queries and queries for Analysis Services
• Helping ASP.Net and VB.net Developers to connect the SSRS generated.
• Creating various SSIS Packages to bring the data in from call center. Convert the data and load them into the database.
• Extracted large volumes of data from different data sources and loaded the data into target data by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Installing report server configurations.
• Worked on creating calculated measures that fits business logic, using MDX queries.
• Finding and Tuning Problem Queries.
• Migrating DTS packages to SSIS Packages in 2005.
• Reporting OLAP cubes built with Microsoft Analysis Services using Business Objects as a front end.
• Updated the multi-dimensional cube data using SSIS packages.
• Designed transformation strategy from OLTP to OLAP Interfaces.

Environment: SQL Server 2005, T-SQL, Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS), Query Analyzer, Cognos, SQL Profiler, SQL - Database Tuning Advisor, SQL Performance Monitor, Windows OS. VB.Net, ASP.NET

Confidential, Marion City, IN

Database Analyst

Responsibilities:

• Supervised the activity of the Database for identifying the bottlenecks that are slowing down the performance of the data warehouse.
• Identified and implemented the methods to fine tune the queries, procedures and functions.
• Reviewed the executions of views and stored procedure and identified the bottle necks within the query.
• Monitored Database and Server Resources with various tools such as Performance Monitor, SQL Profiler, Stored Procedures and Database Tuning Advisor.
• Finding and Tuning Problem Queries.
• Implemented Peer to Peer Transactional Replication with in the system.
• Creation of file groups for the existing Tempdb Database.
• Changing collation in the existing configurations.
• Designed Ideal disk configurations for the future Database server.
• Designed and Created Cube and report from scratch including research.
• Set up guidelines for the team for the future.
• Created reports using ProClarity and analyzed accordingly
• Worked with database performance tuning and query optimization, data integrity and statistics
• Provided documentation on current database environment and as well on the structure that needs to be modified in the future for better performance of the system.
• Advised on the question and concern they had for maintaining the database.

Environment: SQL Server 2005, T-SQL, Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS), DataTel 18ERP system, Query Analyzer, Cognos, SQL Profiler, SQL - Database Tuning Advisor, SQL Performance Monitor, Windows OS.

Confidential, Jersey City, NJ

SQL Server Developer/ETL Programmer/OLAP Developer

Responsibilities:

• Installation, configuration and maintenance of SQL Server database on different platforms.
• Set up the DTS packages for the exchange of data between different data sources.
• Upgraded from SQL Server 2000 to SQL Server 2005.
• Migrated SQL Server 2000 DTS objects to SQL Server 2005 integration services (SSIS) environment.
• Migrated SQL Server 2000 DTS Packages to SSIS.
• Very knowledgeable on SSRS, Business Intelligence reporting applications.
• Defined and processed the Fact table & Dimensions using SSIS.
• Built MDX queries for Analysis Services & Reporting Services.
• Built SSIS Packages to transfer data in and out of the Extract, Stage and Production Servers.
• Updated the multi-dimensional cube data using SSIS- Import/Export wizard.
• Designed ETL packages for different data sources (SQL Server, Flat Files, XMLs etc).
• Extracted large volumes of data from different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Built and designed Star, Snowflake schemas and dimensional data models.
• Reporting OLAP cubes built with Microsoft Analysis Services using Business Objects as a front end.
• Designed/implemented the information access and delivery effort for the data warehouse.
• Installed and administered Microsoft SQL Server Reporting Services, created schedule reports and send the reports via email.
• Created logical and physical data models according to the business requirements.
• Designed SQL Server database tables, views, stored procedures, triggers and functions.
• Designed/Implemented/Maintained OLAP servers and processes to replicate production data to the server.
• Monitored the performance of SQL Server using SQL Server Profiler.
• Designed different kinds of transactions for the application.
• Performed data transformation services and bulk inserts for large amounts of data.
• Developed, modified, and optimized complex queries for data retrieval and modification.
• Managed the backup and recovery of the database.
• Interacted with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.
• Experienced in setting up SQL Server and database configuration parameters.

Environment: SQL Server 2000/2005, T-SQL, Data Transformation Services (DTS), Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS), ER/Studio, Query Analyzer, Business Objects, SQL Profiler, Enterprise Manager, Windows OS.

Confidential, Cleveland, OH

SQL Developer

Responsibilities:

• Determined the MS SQL Server 2000 installation options. Installed SQL Server Management tools using SQL Server Setup Program. Test the Installation of SQL Server and implemented different security modes.
• Worked on Client/Server tools like MS SQL Server 2000 Enterprise Manager and Query Analyzer to Administer SQL Server.
• Used Aggregation Design Wizard to decide best possible aggregation for a given amount of disk space in MS Analysis services 2000.
• Experience in DTS for data flow from one source files like Excel, Tables, Views to other databases or files with proper mapping.
• Implemented a successful security plan by creating statement permissions, linked servers and encryption of connections by creating certificates.
• Experience in star schema over 1 year by building relationships between Fact Table and Dimension tables.
• Participated in maintaining and modifying tables and constraints for Premium Database using MS SQL Server.
• Created Distributed Partitioned Views, Debugging/Troubleshooting Stored Procedures, and upgrading existing ones.
• Developed DTS Packages to transform data to MS SQL Server from Excel for further analysis.
• Configured Database Mail, created operators, jobs and alerts for automating databases.
• Created DTS packages using Active X Task to migrate data from heterogeneous data sources such as MS Access, Excel etc.
• Designed DTS package, with DTS Import/Export wizard for transferring data.
• Data migration (Import & Export - BCP) from text to SQL Server.

Environment: MS SQL Server 2000 Enterprise Edition, Enterprise manager, MS Analysis Services 2000, MS Access 2000 & Windows 2000 platform, Reporting Services, Crystal Report 8.0, DTS ,Windows Active Directory

Confidential, Hollywood, CA

Data Warehouse/OLAP Developer

Responsibilities:

• Designing and implementation of OLAP environment that would serve different users in different locations.
• Analyzed the current OLTP system to interface with legacy OLTP System.
• Created mapping spread sheet to map columns from current OLTP System (Source SQL Server) to legacy OLAP System (Target SQL Server).
• Designed transformation strategy from OLTP to OLAP Interfaces.
• Extracted and loaded the data from legacy systems using SQL Server Integration Services (SSIS).
• Transformed the data using different transformations of SQL Server Integration Services.
• Loaded the data into another data sources (Oracle, SQL Server or DB2) using SSIS.
• Generated the reports for a variety of topics: theatres, locations, and credits using SQL Server 2005 reporting services.
• Backup and recovery database procedures.
• Created linked servers for multiple legacy systems using ODBC drivers and OLEDB Providers.
• Generated DDL script in both Legacy (Informix) and SQL Servers.
• Converted triggers from Informix to SQL Server as per the new database design.
• Created database with multiple file systems.
• Creation and configuration of the film databases.
• Wrote the SQL queries, stored procedures using T-SQL to optimize the performance of the film databases.
• Wrote store procedures to convert data logically as per the business requirement.
• Used scalar user defined functions to be used in SQL queries to retrieve calculated values.
• Managed logins, roles, assigning rights and permissions.
• Backed up master & system databases and restoring them when necessary. Supported production environment.

Environment: SQL Server 2000/2005, Windows 2000, IBM Informix, MS Office Access 2003, MS Visual Studio .Net, T-SQL.

Capital One, Richmond, VA

Database Developer/DBA Consultant

Responsibilities:

• Created and maintained the database for all the products.
• Created programs to load and calculate bank’s financial data.
• Used JDBC to load data to/from SQL Server for large amount of bank's financial information.
• Teamed with developers to create the most optimal code and database connectivity to meet client-timing requirements.
• Involved in migrating the data onto different database servers.
• Designed different kinds of transactions for each module of the application.
• Worked on stored procedures, triggers and also on large number of business analytical functions.
• Add and modify all required tables/databases to support the requests from the system analysts and the systems Integrator and provide daily production support for the operations of databases.
• Hands-on training in the use, maintenance, and development of databases using MS SQL Server 2000.
• Involved in supporting and maintaining the database servers, performing database installation, configuration, and upgrade.
• Involved in designing, implementing of database backup and restore procedures.
• Monitored server performance, creating user logins and granting security privileges.
• Create alerts, notifications and emails for system errors, insufficient resources, fatal database errors, and hardware errors.
• Migrated stored procedures and databases from one server to another.

Environment: Windows 2003 Server, MS-SQL Server 2000, HTML, XML, and MS Office 2003

Confidential

Database Developer/Programmer

Responsibilities:

• Understanding of data modeling fundamentals and techniques.
• Installation and configuration of SQL Server database.
• Creation of databases & objects like tables, views, stores procedures and triggers.
• Migration of different versions of databases.
• Performance analysis of SQL Server databases using SQL profiler.
• Worked extensively on data transformation services (DTS) for transferring data between discrete data sources.
• Worked extensively on SQL & Stored Procedures programming.
• Worked extensively on BCP utilities for bulk data & image file uploading.
• Developed quality assurance strategy and test plans.

Environment: SQL Server 2000, SQL Profiler, Data Transformation Services, and T-SQL.