SUMMARY

• Over 9+ years of experience using Microsoft Business Intelligence (MSBI) Stack, SSIS, SSRS, SSAS/OLAP and Microsoft SQL Server 2005/2008/2008 r2/2012/2014 in various Banking, Finance and Healthcare domains.
• Extensive noledge and experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors using SQL.
• Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system.
• Expertise in working on all activities related to teh development, implementation, administration and support of ETL processes for large - scale Data Warehouses using, Data Transformation Services (DTS) and SSIS with MS SQL 2005/2008/2012.
• Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
• Experienced in migration from SQL Server 2008 to SQL Server 2012.
• Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations and involved in package configurations and deployment process.
• Proficiency in creating different types of reports such as Parameterized, Linked, Snapshot, Cached, Ad-hoc, Clickthrough, Drill-down, Drill-through, Sub reports, and formatting them.
• Experience in creating different data regions such as Table, matrix, List, Chart, Gauge, Map.
• Experience in integrating teh SSRS reports into web applications using Report viewer control, URL methods and creating data driven subscriptions to different users using Report Manager.
• Experience in Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS).
• Experience in building Star schema and Snow Flake schema depending on business requirements.
• Experience in creating Perspectives, Partitions, KPI’s and Design Aggregations in cubes using SSAS.
• Able to work with minimal supervision in any collaborative environment.
• Knowledge of Data Warehousing (DW) concepts and Data warehouse applications.
• Have experience in PowerShell scripting.
• Working noledge in Agile/Scrum Environment and used TFS team foundation server.
• Highly motivated with an ability to learn new systems and business processes.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills

TECHNICAL SKILLS

Databases: MS SQL SERVER 2014/2012/2008 R2/2005/2000

Business Intelligence Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)

Database Tools: SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), SQL Server Data Tools Enterprise Manager, SQL Profiler, Query Analyzer

Programming Languages: C#,T-SQL, asp.net, HTML, XML

Data Modeling: ERwin, MS Visio, Star, Snow flake schemas

Operating Systems: Windows (XP, 2008 server), Windows 7

MS Office: Word, Excel, PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Technology Lead\MSBI Developer

Responsibilities:

• Extensive experience in developing Stored Procedures, Views, Cursors, Triggers, Scripts and Complex Queries in MS SQL Server.
• Developed SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, CTE accommodating complex filters and database links.
• Optimized teh performance of queries in TSQL queries, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Extensively used BI tools like Integration service, Reporting Services and Analysis services in MS SQL server 2008R2 and 2012.
• Developed SSIS packages and SSRS reports in SQL Server 2005/2008/ 2008 R2/2012.
• Filtered and cleansed bad data from legacy system using complex Transact- SQL statements in staging area, and implemented various constraints for data consistency.
• Developed Packages using most of teh Tasks, Containers, Transformations and Implemented Error Logging using SSIS.
• Strong background in Data Warehousing principles and methodologies.
• Designed different kinds of reports like Linked, parameterized reports and Worked on Drill Down and Drill-through Reports with different data regions like Tabular, Matrix etc.
• Experienced in developing stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.
• Created Report Models for building Ad hoc reports using SSRS and deployed reports into SharePoint.
• Created and managed roles for security in Reports.
• Created Cubes with Star schema in SSAS and developed SSRS reports based on teh cubes.
• Worked in AGILE methodology in development of Database Objects in SQL Server 2008R2/2012.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: MS SQL Server 2012, 2008R2, VS2010, Business Intelligence Development Studio (BIDS), T-SQL, XML, SSIS, SSRS, SSAS, OLAP, OLTP, Windows 7, Microsoft Excel.

Confidential - Somerset, NJ

Technology Lead\MSBI Developer

Responsibilities:

• Designed logical and physical model of OLTP database using ER-Win and later forward engineered teh physical model to Microsoft SQL server 2008
• Assisted in designing both teh relational data warehouse and teh staging databases, ensuring teh quality and consistency of teh data in both repositories.
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data loads and transformations.
• Created various database objects such as tables, indexes and views based on teh requirements.
• Optimized several stored procedures using SQL profiler for report latency and fast delivery access.
• Responsible for teh architecture, design, development and implementation of SSIS templates and packages.
• Designed and created user based reports, admin level reports against teh SSIS logs and report server to monitor teh SSIS packages and teh reports for teh execution time using SSRS 2005 and 2008.
• Optimized SSIS packages for teh performance as teh high volume data flows were taking more TEMPthan teh desired time to execute.
• Created drill down Reports, which gives all teh details as per business requirements. Designed and implemented stylish report layouts.
• Generated various Report models on Views (due to security issues) and deployed them on to teh production reporting server and generated various Report models and ad-hoc reports.
• Experience in administrating teh created reports and assigning permission to teh valid users for executing teh reports.
• Created OLAP applications with OLAP services in SQL Server and build cubes with many dimensions using both star and snow flake schemas.
• Created hierarchies and aggregates dat will optimize teh analysis against teh cubes dat uses MDX queries.
• Scheduled and monitored various jobs using teh SQL Server Agent like package execution and cube processing as well as notification associated with each process.
• Created weekly database backup jobs and schedules using SQL Agent.
• Created Logins and server roles.
• Responsibilities include meeting with users to define business rules and requirements and ensuring proper documentation for all phases of teh project.

Environment: SQL Server 2005 Enterprise Edition, SSIS, SSRS, SSAS, XML, T-SQL, Windows 2000/2003 Advance Server, MS Excel, MS Access, Visual Studio 2008/2005.

Confidential, Merrimack, NH

SQL server Developer\MSBI Developer

Responsibilities:

• Worked on T-SQL skills in creating stored procedure, functions, views, triggers.
• Creating tables with cluster and non-clustered indexes on columns and created various database objects such as tables, indexes and views based on teh requirement.
• Performed security updates for all user types and responsible for Clustering.
• Expertise in Performance Tuning, Index Tuning wizard, maintenance, troubleshooting and Query optimization skills.
• Modified teh existing stored procedures to get teh new functionality depending on teh client requirement.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and tan loaded teh data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Developed teh packages with monitoring features and logging so dat audit information of teh packages and their execution results are loaded into teh audit table.
• Hands on experience in using different transformations like Script task, Fuzzy Lookup, Derived column, Conditional split, Multicast transformation, Pivot etc., using SSIS.
• Expert in Creating Complex SSIS packages using proper Control and Data Flow elements with teh error handling.
• Involved in teh creation and deployment of teh reports using SSRS and configuring teh SQL Server Reporting Server.
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Generated various reports with drilldowns, drill through, parameterized reports from teh cubes by connecting to Analysis server from SSRS.
• Deployed teh SSRS reports in Microsoft office share point portal server.
• Used various report items like tables, sub report and charts, Graphs to develop teh reports in SSRS.
• Created daily, weekly, monthly reports for various categories and Hierarchies based on business needs.
• Understanding teh OLAP processing for changing and maintaining teh Warehousing Optimizing Dimensions, Hierarchies and adding teh Aggregations to teh Cube.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Perform Back-ups, Restores, Scheduling, Maintenance and Disaster Recovery planning for SQL 2008 databases.
• Experience in working on Agile/scrum.
• Experience with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
• Worked with product development teams and senior designers on complex program designs to develop architectural requirements dat meet design and performance requirements

Environment: MS SQL Server 2012, 2008R2, VS2010, Business Intelligence Development Studio (BIDS), T-SQL, XML, SSIS, SSRS, SSAS, OLAP, OLTP, Windows 7, Microsoft Excel.

Confidential

SQL Developer\MSBI Developer

Responsibilities:

• Developing T-SQL queries, triggers, functions, cursors and stored procedures.
• Responsible for logical and physical design of SQL Server databases.
• Developed SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.
• Alter teh schema for teh required objects. Designed and optimized all teh SSIS packages.
• Performing teh ETL operations to support teh incremental, historical data loads and transformations using SSIS.
• Designed SSIS packages for synchronizing teh data between two different servers.
• Involved in building and maintainingSSIS Packagesto import and export teh data from various data sources usingBIDSbased on teh design data models.
• Created Ad-hoc reports and cascading reports, Pivot Tables for historical data using SSRS 2008.
• Involved actively as a part of team for collecting and analyzing teh needs of end user requirement.
• Generated various reports with drilldowns, calculated members, and dropdowns from teh cubes by connecting to Analysis server from SSRS.
• Generated Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports etc.
• Used Publishing Report Parts feature of newly released SQL Server 2008 R2 and deploy teh various report items like charts, maps, images, graphs, tables etc. to teh R2 report server along with teh reports.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules.
• Created subscriptions to provide a daily basis reports.
• Managed and troubleshoot report server related issues.
• Created Dimensions with teh cube wizard and also individually Generated Named calculations and Named queries.
• Involved in defining referenced relationships with measure group and fact tables.
• Experience in writing PowerShell scripts.
• Performed day to day Database Maintenance tasks - Database Backups, Space Management, and Resource Utilization, responsible for performing object Migration.
• Worked under Team Foundation Server (TFS).
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs
• Provided on-call support to production system to resolve any issues.

Environment: MS SQL Server 2012, 2008R2, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, Business Intelligence Development Studio-SQL, DTS, SQL Profiler, OLAP, OLTP, MS-Excel.

Confidential

SQL server Developer\MSBI Developer

Responsibilities:

• Involved in installation and configuration of SQL Server 2005 and SQL Server 2008 with latest Service Packs.
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data loads and transformations.
• Created various database objects such as tables, indexes and views based on teh requirements.
• Responsible for teh architecture, design, development and implementation of SSIS templates and packages.
• Designed and created user based reports, admin level reports against teh SSIS logs and report server to monitor teh SSIS packages and teh reports for teh execution time using SSRS 2005 and 2008.
• Optimized SSIS packages for teh performance as teh high volume data flows were taking more TEMPthan teh desired time to execute.
• Created drill down Reports, which gives all teh details as per business requirements. Designed and implemented stylish report layouts.
• Generated various Report models on Views (due to security issues) and deployed them on to teh production reporting server and generated various Report models and ad-hoc reports.
• Experience in administrating teh created reports and assigning permission to teh valid users for executing teh reports.
• Designed teh data models to meet teh requirements of each report.
• Responsible for teh architecture, design, development and implementation of teh SSAS 2005/2008.
• Created OLAP applications with OLAP services in SQL Server and build cubes with many dimensions using both star and snow flake schemas.
• Created weekly database backup jobs and schedules using SQL Agent.
• Created Logins and server roles.
• Responsibilities include meeting with users to define business rules and requirements and ensuring proper documentation for all phases of teh project.

Environment: MS SQL Server 2008R2, 2008, 2005, SSIS, SSRS, SSAS, XML, T-SQL, Windows 2000/2003 Advance Server, MS Excel, MS Access, Visual Studio 2008/2005.

Confidential

Business Intelligence MSBI Developer

Responsibilities:

• Responsible for getting, understanding teh business specifications, preparing technical specifications.
• Responsible for creating appropriate loaders and relational writes to load teh Data using SSIS.
• Involved in migration of DTS packages to SSIS.
• Created jobs for scheduling teh SSIS packages.
• Used different transformations like excel source, data conversions, lookup, Merge, Merge Join, OLEDB command, derived columns, OLEDB destination, etc.,
• Designed dynamic SSIS with C#.Net to transfer data crossing different platforms, validate data and data clearing during transferring, and archived data files for different DBMS.
• Designed multiple reports such as linked reports, sub, drill through and drill down reports depending up on teh client’s need.
• Participated in report deployment, report authoring, used conditional formatting to make teh reports more user friendly.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Wrote and integrated stored procedures to generate teh reports.
• Used various report items like tables, sub report and charts, Graphs to develop teh reports in SSRS.
• Multilingual SSRS reports are built based on client specifications
• Fine-tuned teh complex database stored procedures and increase performance up to 5%.

Environment: MS SQL Server 2005 Enterprise Edition, SSIS 2005, SSRS 2005, XML, C#,T-SQL, Windows 2000/2003 Advance Server, MS Excel, Visual Studio 2005