SUMMARY

• Over 11 years of IT Experience in Database Design, Development of business intelligence applications in Microsoft SQL Server 2005/2008/2012 environments and Microsoft .net technologies on various business domains like Health care, Financial, Retail and Fleet Logistics.
• Full Life Cycle Experience in Model, Design, Development of Data warehouse/ETL/BI Solutions.
• Proven ability to work with business users to take requirements and translate them into technical designs to facilitate BI reports and analytics
• Demonstrates a strong knowledge and competence of standard concepts, best practices, and procedures within a Business Intelligence environment
• Ability to define and implement migration strategies from legacy systems to new architecture and technologies
• Direct interaction with Project Management and System Managers throughout the SDLC including time estimates and status reports.
• Involved in migrations from DTS to SSIS 20 and .
• Designed and developed ETL using SSIS from heterogeneous data sources
• Experience in Extracting, Transforming and Loading (ETL) data from varied sources like Excel, Access, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Extensively involved in data cleansing and data enrichment in order to ensure data integrity using various transformations in SSIS.
• Skilled in programming to add custom functionality to the SSIS packages using Script Task and ActiveX Script Task.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Performed incremental loads of fact tables using Lookup transform and Cache connection manager in SSIS 2005, 2008 and using Change Data Capture in SSIS 2012.
• Experience in updating dimension tables using Slowly Changing Dimensions Transformation in SSIS.
• Expertise in enhancing and deploying the SSIS Packages from development server to production server using package configurations.
• Experience in performance tuning of SSIS packages by tuning the data flow and implementing parallelism.
• OLTP data modeling, process flow, stored procedure creation/tuning, ETL, strong application team interaction including understanding of the underlying data structures.
• Experience in creating Drill down, Drill through Reports, link Reports, Sub Reports using SSRS
• Implemented SSRS server level and item level security, subscription, performance tuning and access various reports in multi - user environment
• Expertise in creating different types of reports in SSRS - parameterized reports, linked reports, sub-reports, ad-hoc reports, snapshot reports, drill-through reports, and drilldown reports.
• Creation & tuning of Stored Procedures and MDX queries, Report development, SSIS package development, ad-hoc reporting in response to business reporting initiatives
• Expertise in Scripting T-SQL Queries, Complex Stored Procedures, User defined functions and Indexes
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Expertise in MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Worked on database administrator tasks like Log shipping, database mirroring, database replication, database backups, performance of the SQL server
• Strong query optimization and performance experience, Troubleshooting BI problems, Performance tuning SQL Server & Analysis Services
• Experience in creating jobs, Alerts and schedule SSIS Packages using SQL Agent and UC4.
• Expertise in dimensional modeling - conceptualizing and building star and snow flake schemas, junk dimensions, degenerate dimensions, role-playing dimensions, conformed dimensions, transaction and snapshot fact tables; implementing surrogate keys.
• Experience in multi-dimensional modeling, creation and maintenance of cubes, processing cubes, creating perspectives,partitions,attribute relationships,aggregations and KPIs in SSAS.
• Implemented performance tuning of cubes by building attribute relationships in user-defined hierarchies, designing aggregations based on usage and creating partitions.
• Well-versed with MDX to create calculated members, named sets and to generate custom reports based on user-requirements from SSRS
• Expertise in Dashboard design with a working knowledge of Performance Point Server including the ability to design and develop scorecards and dashboards
• Worked on power pivot data models, power View data exploration, visualization and presentation experience
• Involved in development of Internet applications using ASP.NET, C#, VB.NET and ADO.NET.
• Monitoring of Production Issues of Reloads and Reconciliation following Production Issue fixes
• Involved in essential Duties like Daily/Monthly Batch work Monitoring, Root Cause Analysis of Production Issues.
• Guide and mentor BI development team members through technical solution deliverables
• Prepare and dispense work assignments, provide guidance, and/or review the work of local and offshore development team members.
• Develop technical documentation to define the system components, development environment and implementation planning/strategies
• Worked as an Onsite coordinator - US and offshore team delivery model

TECHNICAL SKILLS:

Data Warehousing/BI Tools: SSIS/SSAS/SSRS,PowerBI

RDBMS/DBMS: MS SQL Server 2000/2005/2008 R2/2012/2014, MS Access, Oracle, MySQL,DB2,Clarify

Tools: SSMS,PowerPivot,PowerView,VSS, Team Foundation Server(TFS),SQL Server Profiler, Erwin,SM7,Visio

Web Technologies: HTML, DHTML, XML, IIS

Programming Languages: T-SQL, C#.net, C, Java Script,VB Script, XML, HTML

Operating Systems: Windows 8/7/Vista/XP, Windows Server 2000/2003/2008/2012.

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, OH

Tech Lead MSBI Consultant

Responsibilities:

• Worked with business users to take requirements and translate them into technical designs to facilitate BI reports and analytics
• Responsible for data modeling, logical and physical database design using Erwin.
• Lead and responsible for analysis, architecture, design, and development of data warehouse and business intelligence solutions
• Analyze business requirements and provide end-to-end solution design for respective data foundation builds including Data Marts, Data Feeds, Data Warehouse Subject Areas.
• Analyze business analytics and reporting needs to provide solution design supporting custom reporting, advanced analytics, data discovery, data science, self-service capabilities.
• Designed and created complex SSIS packages for performing ETL operations from different source systems.
• Extensively used transformations, control flow tasks, containers and event handlers.
• Great Expertise in creating and managing Check Points, Package Configurations, Logging, System and User-defined Variables for SSIS Packages
• Deployed the SSIS Packages to different environments and created jobs for efficient running of the packages.
• Designed, developed Sub-reports, Drill-Down, Drill - Through and Parameterized reports using SSRS 2008.
• Extensively created dashboards/scorecards against SSAS cubes using SSRS
• Worked on with Report Manager, Report Builder, and Reporting Security and Reporting Services Configuration manager.
• Experience in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes.
• Responsible for designing the SSAS cubes, dimensions, fact tables and measures.
• Created OLAP Cubes and was responsible for OLAP processing, Optimizing Dimensions, creating hierarchies and adding the Aggregations to the Cube.
• Performed partitioning of cubes as well as cube optimization in order to increase the performance of cubes
• Designed and built complex Multidimensional Expressions (MDX) for retrieving the multidimensional data stored in OLAP cubes.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Involved in SQL Query Optimization techniques to improve the performance of the query

Environment: SQL Server 2005/2008/2012 , ASP.NET, HP Mainframe server, Artiva, Perfect practice, SSAS/SSRS/SSIS, XML, MS Excel.

Confidential, Atlanta, GA

Tech Lead MSBI Consultant

Responsibilities:

• Worked on full software development life cycle (SDLC) starting from collecting business specifications, user requirements, confirming the design decisions regarding data, process, interfaces, reviewing/audit the code and documenting effectively the entire life cycle
• Worked with business users to take requirements and translate them into technical designs to facilitate BI reports and analytics
• Involved in understanding the BRD (Business Requirement Document) which includes mapping document with databases.
• Designed and Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Created checkpoints and configuration files in SSIS packages
• Implemented slowly changing dimensions in SSIS packages.
• Upgrade packages from SSIS R2.
• Performed incremental data load in BIDS using Lookup Transform, Cache Transform, and Merge Join Transform
• Developed and Deployed different types of Reports like List, Drill Down, Matrix, Chart and Sub Reports etc. with SSRS
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements.
• Experience in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Design and Develop database objects and structures for reporting according to project specifications including the creation, modification, testing, performance tuning, and review of tables, stored procedures, database functions, and triggers.
• Involved in Deploying the SSAS cubes from development to QA server and then to Production server.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Involved in deploying the .Net applications to Application server for Go-Live.
• Provided 24x7 support and trouble shoot production issues on high availability systems

Environment: SQL Server 2005/2008, ASP.NET, SAP, Informatica, Clarify, Siebel, SQL Server SSAS/SSRS/SSIS, XML, MS Excel.

Confidential, Los Angeles, CA

Senior MSBI Consultant

Responsibilities:

• Involved in SQL Query Optimization techniques to improve the performance of the query
• Generated Logical and Physical Data Models using Erwin.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, user defined data types and functions by writing complex queries and joins.
• Migrated Stored Procedures from 2005 to SQL Server 2008 to refer to Dynamic Management Views.
• Created and Deployed of Ad-hoc and Customized Reports to satisfy business needs using SSRS.
• Designed ETL using SSIS to extracted data from flat files, excel files and SQL server.
• Designed SSRS reports for use of expense analysis, asset related and balance sheet reports.
• Designed stored procedures, views, triggers, functions for data warehousing.
• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
• Created OLAPCubes and was responsible for OLAP processing, Optimizing Dimensions, creating hierarchies and adding the Aggregations to the Cube.
• Performed partitioning of cubes as well as cube optimization in order to increase the performance of cubes.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc
• Developed complex Stored Procedures, Functions,DTS (Data Transformation Service) packages, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created Parameterized reports and linked reports using Bookmark links and Hyperlinks.
• Created SSIS Packages to (ETL) Extract, Transform and Load the data into Reporting instance to generate the reports easily and quickly.
• Deployed the SSIS Packages to the MSDB as well as File System depending on the requirements
• Worked extensively on Scalability in PDWusing Kimball approach. It handled tens of terabytes of data and then moved to hundreds of terabytes worth (up to 600 TB) of data.
• Monitored Indexes, file growths and analyzed blocking & locking issues to remove the performance bottlenecks.

Environment: MS SQL Server 2000/2005, SSRS, T-SQL, Windows Server 2003, Windows XP.

Confidential, San Diego, CA

Senior MSBI Consultant

Responsibilities:

• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated measures, dimension members using MDX, mathematical formulas and user defined functions, named calculations using SSAS for generation of cubes
• Designed and built SSAS complex cubes which include millions of records which are complex and large.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Experience in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes.
• Created SSIS packages to extract, transfer and load data into the data warehouse on a daily basis.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing
• Performed data conversions from SQL server to flat file using SSIS. Created packages that implements tasks like Execute SQL Task, Data Flow Task etc.
• Created SSIS packages with which data resources are loaded daily in order to create and maintain a centralized data mart. Made the package dynamic so it fit the environment.
• Created and scheduled a SSIS package to run our stored procedures to create the output report tables and regenerate reports automatically on weekly or monthly bases using SSRS 2008.
• Responsible for creating summary Reports, Sub Reports, Drill Down Report, dynamic grouping.
• Used Bulk Insert and BCP to load data from flat files.
• Created and managed schema objects such as Tables, Views, Indexes, Stored Procedures and User-Defined Functions by writing complex Queries and Joins.
• Done performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks.
• Performed daily tasks including backup and restore by using SQL server 2005/2008 tools.
• Responsible for implementing different disaster recovery technologies like Replication, Log Shipping
• Responsible for job monitoring activities, analyze and evaluate the causes for the job failures.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server SSAS/SSRS/SSIS, DTS, MS Performance Point Server 2007, Sharepoint, C#, ADO.net, XML, MS Excel

Confidential

SQL BI Developer

Responsibilities:

• Developed web based ASP.NET internet applications
• A good understanding of N-tier and N-layered architecture
• Design, code, test, debug and document software according to the functional requirements
• Use Microsoft technologies: C#, ASP.NET, SQL and Microsoft Workflow to develop technical solutions
• Experience with user interface design and prototyping
• Created both automated and manual reports
• Designed the usage summary and detailed reports in SSRS 2005 from the requirement document and the old reports Mock-Up in MS Excel.
• Responsible for the reports deployment through SSRS on the Reports Server. Returned the stored procedure and the UDF for the reports.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS with .NET applications.
• Designed and implemented stored procedures and triggers for automating tasks.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.

Environment: ASP.Net, MS SQL Server 2000/2005, T-SQL, SSRS

Confidential

Developer

Responsibilities:

• Developed web based ASP.NET internet applications
• Involved in developing code libraries for the project.
• Design and develop web user interfaces with back-end databases and other tools.
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity
• Developed Stored Procedures, Triggers, and SQL scripts for performing automation tasks
• Customized the stored procedures and database triggers to meet the changing business rules

Environment: ASP.Net, MS SQL Server 2000, T-SQL