SUMMARY

• 8 years of experience in analysis, design, development, testing and implementation of Microsoft SQL Server and Business Intelligence tools (SSIS, SSRS, SSAS) in business domains like Energy, Mobile device management, Tracking Systems and Education.
• Expertise in designing and implementing Business Intelligence(BI) solutions with Microsoft SQL Server Integration Service (SSIS), Microsoft SQL Server Reporting Service (SSRS) and Microsoft SQL Server analysis Service (SSAS).
• Extensively worked on Extract Transform Load (ETL) packages for loading data into Data warehouse using SQL Server Integration Services (SSIS). Experience in SSIS package design, configuration and deployment.
• Excellent in developing SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Tables, Flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge, Multicast and Union all.
• Proficient in creating Dynamic Packages for incremental loads and Data Cleansing in Data Warehouse using SSIS.
• Experience in error handling techniques by using Event Handlers, Precedence Constraints, Break Points, Check Points.
• Expertise in developing Parameterized reports, Tabular reports, Charts, Graphs, Dashboard, Summary Reports, Sub Reports, Scorecards, Report on SSAS Cube using MDX, Drill - down, Drill-through, Ad hoc and Cascading reports using Microsoft SQL Server Reporting Service (SSRS).
• Expertise in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS).
• Involved in creating PivotTables, PowerPivot tools, Data Driven Subscription reports.
• Experienced in working with OLAP and Cubes developed in SQL Server Analysis Services (SSAS). Experienced in Dimensional Modeling.
• Excellent knowledge in creating Data Marts, Measures and Dimensions.
• Proficient in building and writing MDX Queries, Calculated Members, and Key Performance Indicators(KPIs) using Microsoft Business Intelligence components (SSAS, SSRS).
• Good knowledge in building, deploying, processing and maintaining Cubes and Dimensions using SQL Server Analysis Services (SSAS).
• Experienced in database installation, configuration, maintenance and monitoring of SQL Server.
• Experienced in developing and managing Transact-SQL/T-SQL (DDL, DML) queries, Stored Procedures, User Defined Functions, Joins, Indexes, Data Integrity (constraints), Performance Tuning, Validation issues, CTE, Cursors, Views and Triggers in MS SQL Server.
• Hands on experience in Developing, Testing, Monitoring and Troubleshooting SQL Server complexed queries. Experienced in designing Star, Snowflakes schemas.
• Knowledge in Software Development Life Cycle (SDLC) and experienced with Agile development methodology.
• Self-Motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.
• Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS

Operating Systems: Windows 2000/XP/Vista/7/8.1/10, Windows Server 2008/2003

RDBMS/Databases: MS SQL Server 2014,2012,2008,2005, MySql, Oracle 9i

Tools: SQL Server Management Studio (SSMS), SQL Server Data Tools (SSDT), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)

IDEs: Microsoft Visual Studio 2012/2008 (Business Intelligence Development Studio BIDS)

Programming Languages: Transact SQL (T-SQL), PL/SQL, HTML, XML, MDX

Application Packages: MS Office 2013/2010/2007

PROFESSIONAL EXPERIENCE

SQL Server BI Developer

Confidential

Responsibilities:

• Extensively utilized SSIS packages to create complete ETL process and load data into data warehouse which was to be used by Reporting Services.
• Designed and supported applications to pull real-time market data, weather data and gas flow data which is used by traders.
• Performed operations like sorting, merging on the source data in order to clean the data and remove duplicates.
• Created SQL Server Agent Jobs to execute SSIS packages.
• Involved in gathering the report specifications by interacting with the business users.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Based on the requirement offered production support for SSIS packages created.
• Created various reports like Drill Down, Drill Through in Reporting Services 2012.
• Created parameterized reports to view the reports dynamically at run time.
• Matrix reports were created for the reports whose columns were not predetermined.
• Reports were scheduled to be executed and sent to the business users via email.
• Designed Databases, Tables, Joins, Triggers in SQL Server 2012.
• Based on the requirement created Stored procedures while loading gas and weather data.
• Performed Performance Tuning of databases to optimize existing applications and processes.
• Designed and supported Gas, Power Trading BI solutions.
• Gathered requirements of Power Trading BI solutions from users and analysed them to meet end result.
• Created dynamic archive process using SSIS 2012
• Configured packages and environments using SQL server 2012 SSIS catalog.
• Developed Tabular SSAS cube for Gas BI application.
• Involved in Cube development, Partition and Aggregations and Optimizing using SSAS.
• Developed reports using Variables, Expressions and Functions in handling Parameterized reports in SSRS.
• Developed various reports like Tabular, Charts, Graphs, Cascading, Drilldown, Drill through, Sub reports, Dashboards in SSRS.
• Created tabular cube for small dataset and represented to users using Power Pivot.
• Worked on Scheduling Jobs, Alerts, SQL Mail Agent and Scheduled packages.
• Worked on detailed technical specifications and ETL documentation.

Environment: SQL Server 2014/2012, Windows 7, Visual Studio 2012, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Microsoft Office 2013

SQL Server BI Developer

Confidential

Responsibilities:

• Worked extensively on SSIS Packages, importing data from various data sources in different formats for Multimode diagnostics project, Confidential .
• Implemented data validations and error handling techniques on source data received from production sites.
• Automated email alerts were sent to the respective teams using predefined tasks available in SSIS.
• Partitioned many tables, which have frequent inserts, updates and deletes to improve the performance.
• Involved in building regular reports of mobile device transactions performed at various production sites of DataMigrate project of clients DoCoMo Japan, Confidential etc.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Designed dynamic SSIS to transfer data crossing different platforms, validate data during transferring, and archived data files for different RDBMS.
• Responsible for generating automated scheduled reports, dashboard to monitor the performance of the products.
• Utilized subscriptions for generating reports in SSRS.
• Worked on designing schemas, developed cubes and implemented various hierarchies in SSAS.
• Querying and manipulating multidimensional cube data through MDX Scripting
• Involved in development and debugging of complex stored procedures, functions, joins and Indexes using T-SQL.
• Worked on database performance Optimization, Debugging and Tuning.
• Used exception handling techniques to handle run time issues.

Environment: SQL Server 2008, Windows XP Professional, SQL Server Integration Service 2008, Microsoft Analysis Service 2008, Microsoft Reporting Service 2008, Microsoft Office 2007, T-SQL.

SQL Server BI Developer

Confidential

Responsibilities:

• Involved heavily in database development
• Installed and Configured SQL Server 2008 successfully.
• Worked on requirements for the products related to safety of school children
• Expertise in Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Responsible for complete Student Information System (SIS) database. Attendance, Marks, Bus Tracking information of each branch was regularly maintained by SSIS.
• Created complex SSIS packages using proper control, data flow elements and error handling.
• Used various features such as Slowly Changing Dimension, Checkpoints, Import Column, Export Column and Data Conversion Transformations.
• Daily, monthly and Quarterly reports were generated and maintained in SIS using SSRS
• Involved in development, enhancement, testing and performance tuning of the application

Environment: SQL Server 2008, Windows Server 2003, Microsoft Visual Studio 2008, SSAS, SSIS, SSRS, T-SQL, MDX, HTML, XML, MS Office 2007, Oracle 9i.

SQL Server Developer

Confidential

Responsibilities:

• Worked on Database installation, configuration, maintenance and monitoring of SQL Server 2005.
• Worked on Developing, Testing, Monitoring and Troubleshooting SQL Server complexed queries.
• Designed Star, Snowflake schemas.
• Migrated SSIS packages between servers and loaded data into SQL Server 2005 database.
• Gathered all the data from site locations and loaded them into a flat file using ETL.
• Created various SSIS packages to load data from the flat files into MS SQL Server 2005.
• Developed complex SQL queries using various Joins, Views, Functions and Triggers.
• Performed Database Performance Optimization, Debugging and Tuning.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval
• Optimized various SQL Server statements with the help of MS SQL Server Profiler.
• Created reports using Microsoft Reporting Services and published them for the users.
• Worked on Stored Procedures, Triggers and Cursors for applications. Developed complex T-SQL code for the application.
• Created reports using stored procedures. Involved in scheduling, creating snapshots and subscriptions for the reports (SSRS)
• Involved in System Integration Testing, bug fixing and documentation for the project.

Environment: SQL Server 2005/2008, Windows XP, SQL Server Analysis Service 2008, SQL Server Reporting Service 2008, Microsoft Office 2007, T-SQL.

SQL Server BI Developer

Confidential

Responsibilities:

• Involved in Database design, development and implementation.
• Used SSAS, SSIS and SSRS at various stages in implementation of CIT and TTP projects.
• Created SSIS packages for transferring data from various data sources like Oracle, MS Access, Excel, Flat files, CSV files from various engineering colleges.
• Used various transformations such as Slowly Changing Dimension, Multicast, Lookup, Conditional Split, Aggregate and Data Conversion Transformations.
• Involved in building regular performance reports at different levels like student, mentor and college using SSRS.
• Created tables, stored procedures, views, functions, and triggers using T- SQL.
• Written code for different modules related to educational products.
• Conducted seminars regarding educational techniques.

Environment: SQL Server 2005, Transact-SQL(T-SQL), Microsoft Access, Microsoft Excel, SQL Server Reporting Services, SQL Server Integration Services, Windows 2000