SUMMARY

• 8+years of knowledge and experience in Microsoft SQL Server 2005/2008r2/2012/2014, including various RDBMS platforms such as Oracle, DB2 and SQL Server with knowledge in Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), Power BI and Data Warehousing concepts.
• Extensive experience in Developing and Supporting BI/EDW solutions in various domains like Financial, Insurance, Healthcare, Banking etc.
• Good understanding of IT development process and experience in IT project management.
• Involved in complete Software Development Life Cycle (SDLC) processes including Analysis, Design, Support, Programming, Testing and Documentation.
• Experienced in developing Logical and Physical data models using data modeling tools such as Erwin, MS Visio and ER/Studio.
• Extensive experience in SQL query tuning, analyzing of plans, supporting and troubleshooting of DB level problems like session locks, resource crunch and so on.
• Very proficient in T - SQL/PLSQL coding, creating complexstored procedures, functions,views, indexes, user profiles, relational database models, data dictionaries, data integrity and appropriate triggers to assist efficient data manipulation and data consistency.
• Well versed in Normalization/Demoralization techniques for optimum performance in RDBMS.
• Extensive ETL experience using DTS/SSIS forData Extractions, Transformations and Loading from OLTP systems to ODS and OLAP systems.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in creating dashboards, scorecards and building reports and integrate with web interface.
• Expert in designing reports using SQL Server Reporting Services (SSRS), PowerPivots and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamic reports and other features of reporting services.
• Experience in supporting other Reporting tools such as Cognos and Tableau
• Experience in integrating reports into web applications using Report viewer control, URL methods and creating data driven subscriptions to different users using Report Manager.
• Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), calculation scripts, data matrix, OLAP, Star Schema Modeling, Snow-Flake Modeling, facts, dimensions, partitions, Tables using MSAnalysis Services 2008.
• Experienced in DimensionalData modeling, SSAS Performance Tuning, Cube Partitioning, MDX Scripts and formulas,Refresh Strategy and Planning.
• Experienced in developing OLAP cubes using SQL Server Analysis Services (SSAS)and calculating the metrics that are revealed in the functional analysis.
• Expert in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions in SSAS.
• Extensive knowledge in database maintenance, SQLquery optimization & performance tuning using performance tools like SQL Profiler, Index Tuning Wizard, Database consistency check using DBCC utilities, Statistics and Database Engine Tuning Advisor.
• EDUCATION
• Bachelors of Computer Science in JNT University, INDIA, with 73% of aggregate.

TECHNICAL SKILLS:

Databases: MS SQL server 2005/2008/2008 r2/2012/2014, Oracle, Teradata, Mysql, MS Access

SQL Server Tools: SQL Server Management Studio, BIDS (SSIS, SSAS, SSRS), Power BI, Visual Studio, Query Analyzer, SQL Server mail service, DBCC, BCP, SQL Server profiler

Languages: T-SQL, PL/SQL C, C#, VB.net, HTML.

ETL Tools: Data Transformation Services (DTS), Server Integration Services (SSIS), Informatica Power center, Netezza.

OLAP/Reporting Tools: SQLServer Analysis Service(SSAS), Strategy Companion Analyzer, SQL Server Reporting Service(SSRS), Tableau, Crystal Reports 9/10/XI

Other tools: Blackbaud, Erwin, ER/Studio, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

SQL Server BI Developer/DBA

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC).
• Responsible for interacting with client for gathering business requirements.
• Installed MS SQL server 2008 and MS SQL server 2012 on windows 2003 servers, applied Service packs and Security fixes. Implementing database standards and naming convention for the database objects.
• Created various Jobs, scheduling & running jobs and troubleshooting the failed jobs.
• Tuning of Slow Running Queries or inefficient Queries for Optimal Performance using SQL Profiler and Managing Indexes and Statistics.
• Created complex Stored Procedures, Triggers and User Defined Functions.
• Created ETL process from the OLTP database to the Data Warehouse and loading Data Marts to support several reports.
• Created Indexes on tables for better performance and removed unused indexes based on the statistics.
• Created jobs to alert staff about data inconsistencies in the data warehouse.
• Created SQL Scripts for data loads and upgrades for data migrations and data validations.
• Developed Tabular and Chart Reports in SSRS.
• Created complex SSIS packages using proper control and data flow elements with error handling.
• Designed and Developed Integrations to Microsoft Dynamics (GP) from Loan Processing Audit systems.
• Experience in architecting and populating Data-Marts through ETL.
• Created roles for using the cubes.
• Maintained ProClarity Report’s, Dashboard’s access and data issues.
• Designed cubes in star schema using SQL Server Analysis Services (SSAS).
• Developed cubes with various Perspectives and deployed those cubes in development, integration, validation and production servers of SSAS.
• Good exposure on visualization tools Tableau and MS power BI.
• Design visualization reports by using MS power BI.
• Refactoring of data warehouse schema to remove unused or obsolete database objects and improve design.
• Responsible for keeping system and databases up-to-date by making necessary changes.
• Optimized Stored Procedures and long running queries using query-optimization techniques.

Environment: Microsoft SQL Server 2008/2001,MS Access, MSBI Stack (SSRS, SSIS, SSAS), ProClarity, Power BI, XML, VB.Net, HTML, IIS, Visual Studio, C#, SharePoint 2007/2010, MS Data tools, SVN, T-SQL.

Confidential, Hartford, CT

Senior MS BI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC).
• Supervised team members work,managed the development and deployment programs whenever needed.
• Performance tuning of the existing PLSQL/T-SQL code.
• In-depth analysis of business criticalissues encountered in the day to day functioning.
• Besides debugging and resolving business critical application and database performance issues and supervising a team, my responsibilities also requires owning several development assignments aimed towards application enhancements and delivering the same with the best of my capability.
• Experienced in writing complex TSQL/PLSQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in upgrading to SQL Server 2012, installation, configuration SSRS, SSIS and SSAS.
• Complete knowledge of Data Modeling, developed Database model using ERWin and Visio tools.
• Involved in complete ETL life cycle in creating ETL packages using SSIS, deploying and executing the packages in both the environments (Development and QA) before deploying it to production servers.
• Ensure all changes to production have been thoroughly tested, resolved and go through proper management controls.
• Created SSRS reports that are in production at my.scouting.org user based website.
• Advanced extensible reporting skills using SQL Server Reporting Services (SSRS).
• Developed various types of complex reports like Drill Down, Drill through, Parameterized Reports, Sub reports, Dashboards and Scorecards as per the client requirements.
• Scheduled and maintained Data Driven Subscriptions for reports.
• Developer and maintained reports using PowerPivots in Excel.
• Experience in MS Power BI.
• Good Experience in Power Query, Power Pivot and Power view.
• Create dash boards and reports by using power BI.
• Experience with other reporting tools such as Tableau and QlikView.
• Managing and troubleshooting existing DTS/SSIS ETL packages.
• Designed and developed DTS/SSISETL Packagesfor data migration fromOracle database to Microsoft SQL server.
• Developed and maintained ETL sync packages to run real time between Oracle and SQL Server while the transformation is done.
• Used change data capture CDC and third party tool Attunity for capturing change data.
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc... And extraction data from various heterogeneous data sources like Oracle, Excel, MS Access and flat files.
• Developed complex mappings in Informatica to load the data from various sources.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Other duties included extracting personal information data using SSIS for Mass Emailing system used in Marketing sector.
• Created reports out of OLTP and Analysis Services cubes (SSAS) based on the requirements.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Microsoft Office Share point Server.
• Developed user friendly printable, unique training certificates and membership cards with bar codes and watermarks.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
• Created and configured OLAP Cubes (Star Schema and Snow flake Schema) using SSAS 2008/2012 and created calculated members using MDX and dimensions design and scaling to large numbers of users.
• Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options in SSAS.
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Programming in C# for automating some mass emailing processes.
• Proficiency in Windows, Linux and cloud based server operating systems.
• Worked on Blackbaud CRM tool for fundraising. Identified and Defined Key Performance Indicators and created aggregations in SSAS 2005/2008.
• Worked with slowly changing dimensions.
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.

Environment: Microsoft SQL Server 2005/2008 Enterprise Edition,MS Access, MSBI Stack( SSRS,SSIS,SSAS),ProClarity, XIMS, .Net, VB.Net, HTML, IIS, Visual Studio, C#, SharePoint 2007/2010, Performance Point Server, Source Safe, T-SQL.

Confidential, Oklahoma City, OK

MS SQL Server /SSRS /SSIS/SSAS Developer

Responsibilities:

• Experience with SQL Server 2008 and SQL Server 2005.
• Experienced in creating logical and physical ETL packages.
• Used SQL Server Integration Services (SSIS) to implement the ETL operations that are required to build a data warehouse.
• Added data to the Data Warehouse through development of source to targets maps and transformation rules using SSIS.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLTP databases.
• Migrated DTSX packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.
• Used BCP command for copying large amount of data.
• Experienced in implementing an ETL solution that meets the corporate and production operations best practices
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Designed and developed Data Warehouses, Data marts using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• Create, manage, and query your enterprise data warehouse with SQL Server2005.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Used different storage method for SSAS. Used ROLAP storage method for performance of SSAS.
• Identified and Defined Key Performance Indicators and created aggregations in SSAS 2005/2008.
• Worked with slowly changing dimensions.
• Created different reports (parameterized, linked, adhoc, sub reports, map reports, drill through and drilldown reports) depending on the business requirement.
• Proven ability in defining Query for generating drill down reports in SSRS 2005/2008.
• Writing queries and stored procedures to generate reports for analysis of data using SQL Server Reporting Services.
• Responsible for scheduling the packages using Batch files every night and generating Sales Ranking reports using SSRS
• Developed reports using SSRS 2005 and Crystal reports and used table control, matrix control for cross tab reports
• Drill down Sales Report using Pie Chart or Bar Chart Representation.
• Created snapshot of large reports to save the run time of the stored procedures and processing impact on report server,
• Installed SharePoint and integrated SSRS with SharePoint.
• Installed and monitored configuration of Performance point Server 2007 and integrated Performance Point Server with SharePoint.
• Created different reports and scorecard in Performance Point Server.
• Created different filters and KPI’s in Performance Point Server.
• Created Weekly, Monthly and yearly Dashboards and deployed it to SharePoint.
• Experience in Testing for data-warehousing (Data Completeness and Data Quality).
• Assisted DBA team in configuring database mirroring and log shipping.
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.

Environment: Microsoft SQL Server 2005/2008 Enterprise Edition,MS Access, MSBI Stack( SSRS,SSIS,SSAS),ProClarity, XIMS, .Net, VB.Net, HTML, IIS, Visual Studio, C#, SharePoint 2007/2010, Performance Point Server, Source Safe, T-SQL.

Confidential, Minnepolis,MN

MS SQL Server / SSRS /SSIS/SSAS Developer

Responsibilities:

• Experience with SQL Server 2008 and SQL Server 2005.
• Experience with web based architecture for front end OLTP.
• Used SQL Server Integration Services (SSIS) to implement the ETL operations that are required to build a data warehouse.
• Worked with different stored procedures, views and Functions.
• Added data to the Data Warehouse through development of source to targets maps and transformation rules using SSIS.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Migrated DTSX packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages. Used BCP command for copying large amount of data.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models and in data analysis.
• Create, manage, and query your enterprise data warehouse with SQL Server2008.
• Proven ability in defining Query for generating drill down reports in SSRS 2005/2008.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Responsible for scheduling the packages using Batch files every night and generating Sales Ranking reports using SSRS
• Drill down Sales Report using Pie Chart or Bar Chart Representation.
• Architected, developed, tested, and deployed project Reports using ASP.NET 3.0.
• Developed reports using SSRS 2005 and Crystal reports and used table control, matrix control for cross tab reports
• Experience in Testing for data-warehousing (Data Transformation and Integration testing).
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Identified and Defined Key Performance Indicators and created aggregations in SSAS 2005/2008.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Created different SSRS reports & dashboards from SSAS cube by making use of MDX queries.
• Integrates SSRS with SharePoint and deployed all the reports to SharePoint.
• Worked as BI SQL Tester who is responsible for back end SQL testing work.
• Conducted Performance Tuning using SQL Profiler and making using of execution plan for reports performance.

Environment: Microsoft SQL Server 2005/2008 Enterprise Edition,MS Access,SSRS,SSIS,SSAS, ProClarity, XIMS, .Net, VB.Net, HTML, IIS6.0, Visual Studio, C# ASP.Net 3.0,T-SQL,TFS Server. e

SQL Server DBA/Developer

Confidential

Responsibilities:

• Involved in various stages like development, system Analysis &design, and creating stored Procedures.
• Imported and Exported database using DTS utility.
• Wrote SQL stored procedures to implement business logic.
• Wrote different stored procedures for Reporting purpose.
• Created different SSRS report depending on the business requirement.
• Created different Tabular, Matrix and Chart Reports.
• Strong experience in developing Sub Reports, Matrix Reports, Charts, Drill down reports, using SQL Server Reporting Services.
• Involved in performance tuning of the SSRS reports.
• Created SSIS Packages to load the data from different files to SQL Server Database.
• Developed and coded applications in T-SQL.
• Designed a report on the monitoring of Server Performance using Task Manager and Performance monitor. This report gives a detail report to the management on the Performance of the server.
• Maintained SQL Script for creation of Database Objects.
• Provided back-end support for performance testing and functional testing using use case testing methodologies.

Environment: SQL Server 2000, SQL Enterprise Manager, Windows 2000/ NT, MS Access, MS Excel, VBScript.

Confidential

Database Developer/Trainee

Responsibilities:

• Wrote User Defined Functions and Stored Procedures, and also defined Roles and Privileges to control access to database
• Created tables, Constraints, Defaults, Triggers, Views, and Indexes
• Performing data transfer/migration using Export/Import and Data Transformation Services.
• Load data using Bulk Insert.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Create packages, procedures, functions, and triggers; handle database performance and tuning.
• Apply Service Packs for SQL Server database. Creation of new database, starting from scratch i.e. deciding the location of data files and log files on the disks. Reorganization of existing databases to standardize the placement of various databases related files.
• Creation of additional databases, logins and roles.
• Data transfers between various servers using DTS.
• Creating and running DTS Packages for Import and Export of Heterogeneous Data.
• Ensuring that the backups are running fine for various databases on different servers.
• Providing support to the Application developers on the application databases.

Environment: SQL Server 7.0/6.5, Visual Basic 6.0, and Windows NT 4.0