Summary:

• Over 7 years' experience as Business Intelligence Developer using Microsoft BI framework SQL server, SSIS, SSAS, SSRS in various business domains including Finance, Insurance, and Information Technology.
• Experience in Relational Database Management Systems, Including Normalization, Data Import/Export, Joins, Stored Procedures, Keys, Constraints, Indexes, Triggers, Cursors.
• Expert in building Data Integration, Workflow solutions, and ETL solutions for data warehousing using SQL Server Integration Services SSIS .
• Extensive experience in migrating data from various sources such as Excel, Oracle, MS Access, MySQL, OLE DB, and flat files to different destinations using SSIS.
• Experience in Performance Tuning in SSIS package by using Row Transformations, Block and Unblock Transformations.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Expert in creating different types of reports such as drill down reports, drill through reports, parameterized reports, linked reports, sub reports using SQL Server Reporting Services.
• Experience in Deploying reports in various sources like Web browser in XML and PDF formats.
• Expert knowledge in developing multidimensional databases using SSAS.
• Developed OLAP cubes using SSAS for data mining. Experience in Dimensional Modeling, Star/Snowflake Schemas, and performance optimization of SSAS cubes.
• Excellent T-SQL programing skills. Expert in writing complex Queries, stored procedures, Triggers, Functions using T-SQL
• Experience in creating Cell Level Security in cubes using SSAS. Experience in Performance Optimization of SSAS cubes.
• Strong communication and team-oriented skills with a strong attitude toward learning new technology quickly supporting the project requirement.

Skillset:

MS SQL Server 2005/2008R2/2012, MS SQL Server Reporting Services SSRS 2005/2008R2/2012, MS SQL Server Integration Services SSIS 2005/2008R2/2012, MS SQL Server Analysis Services SSAS 2005/2008R2/2012, MS Excel, MS Visio 2013, Visual Studio 2008, Report builder 3.0,

Project Summary:

Confidential

MS SQL Developer SSIS/SSRS

Responsibilities:

• Involved in Planning, Defining and Designing database based on business needs for insights analytics. Assisted DBA in architecting, developing, validating BI solutions such as reports, dashboards, KPIs and alerts.
• Studied in-house requirements and conducted Joint Requirement Development JRD session to analyze the database requirement in detail.
• Gathered Requirements, Analysis and Documentation for creating reports. Analyzed complex technical requirements and made determinations for modifications of existing programs/modules.
• Developed conceptual, logical and physical data models for creating schemas using MS Visio. Created Star/Snowflake Schema for Data Marts.
• Designed, Created and managed primary objects such as tables, triggers, db links, indexes, and privileges, based on logic design model. Developed all the required stored procedures and user defined functions, and worked with stored procedures for data set results in reporting services to reduce report complexity and to optimize runtime.
• Designed extract, transform and load ETL packages to load business retail data received from different stores and other locations into data marts using Data Flow Task, Execute SQL Task, Lookups, Fuzzy Lookups, Conditional Split, Derived Column and Execute Package Task.
• Designed and implemented data structures for new functionality and restructured existing data structures to increase performance by writing queries and stored procedures.
• Created SSIS packages to automate maintenance, database backup and restoration, update statistics, re-build indexes as well as create error log for event during data load.
• Used MDX queries for pre calculated measures and created reports model on SSAS cubes as well as changing default configuration on existing cubes. Created perspectives, partitions, and Designed aggregations in cubes using SSAS.
• Manipulated database security by creating authentication on databases. Created Window users, Work Group and SQL Server logins based on various security requirements. Created Cell Level Security in cubes using SSAS.
• Researched and resolved complex issues and implemented longer-term solutions to frequent occurring issues.
• Conveyed problems, solutions, updates and project status to peers and management. Developed and maintained clear and succinct documentation.

Environment: MS SQL Server 2008/2012, MS SQL Server Reporting Services SSRS 2008R2/2012, MS SQL Server Integration Services SSIS 2008R2/2012, MS SQL Server Analysis Services SSAS 2008R2/2012, C , Microsoft Visual Studio, MS Excel., MS Visio 2013.

Confidential

MS SQL developer/Data Modeler

Responsibilities:

• Gathering various reporting requirement from business analysts. Translated the business requirements into workable functional and non-functional requirements.
• Designed Star Schema for data marts based on business requirements.
• Developed Drilldown reports, Drill-Through reports, Parameterized reports, and Cascading Parameterized reports using SSRS. Tested all the generated reports with some test cases in the actual application.
• Designed and created Report templates, bar graphs, pie charts, and map reports based on the source data. Involved in creating snapshots, subscriptions and scheduling for the reports
• Created, maintained, and optimized data objects like indices and schemata. Various enhancements have been made to the old system so that reports can be easily managed by other departments.
• Developed numerous ad-hoc reports using SSRS for day to day pricing reporting. Generated periodic reports based on the statistical analysis of the data from various time frame and division using SSRS.
• Designed and wrote SSIS ETL systems for data from many disparate sources, structured and semi-structured, using transformations such as lookup, merge, derived column, data conversion and aggregates extensively.
• Developed logical and physical model for schemas. Created standard data documentation, such as ERD and Flow Diagram. Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Employed Transparent Data Encryption to store the data securely by encrypting sensitive data such as credit card numbers, specific names for each pricing record.
• Employed Server Group Management, new features to SQL Server 2008, which enables T-SQL queries to be issued against multiple servers from a single central management server.
• Wrote T-SQL queries, stored procedures to build packages. Developed user defined functions, triggers, views based on business requirements.
• Worked in a collaborative team environment, with other data developers, product and research groups to define the future of automotive data science.

Environment: Windows Server 2008, MS SQL Server 2008R2/2012, MS SQL Server Reporting Services SSRS 2008R2/2012, MS SQL Server Integration Services SSIS 2008R2/2012, Microsoft Visio 11.0, Visual Studio 2008R2, Report Builder 3.0

Confidential

MS SQL developer SSIS/SSAS/SSRS

Responsibilities:

• Extensively involved in the full lifecycle of ETL software development analysis, design, build, documentation and testing for the project using SQL Server Integration Services.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and scheduled several SSIS packages.
• Automated the migration of data transfer packages to the appropriate destinations using SSIS
• Scheduled the reports to run daily/weekly/monthly basis and email the results to the business users in the required format.
• Implemented Event Handler and Error Handling in SSIS packages and notified process results to various user communities.
• Created complex stored procedures, efficient triggers, required functions, indexes, and indexed views for improving performance.
• Designed database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.

Environment: MS SQL Server 2008, MS SQL Server Reporting Services SSRS 2008R2, MS SQL Server Integration Services SSIS 2008R2, Microsoft Visio 11.0, Visual Studio 2008R2, Report Builder 3.0

Confidential

MS SQL Developer

Responsibilities:

• Involved in design, development, and testing, databases. Optimized existing databases and deployed database on development and production servers.
• Migrating data from existing excel tables to MS SQL databases using SSIS 2005.
• Gathered and analyzed user requirements.
• Created various T-SQL queries including creating tables, views, triggers, stored procedures and user defined functions.
• Generated reports using SSRS 2005.
• Assisted DBA in taking database backup and restore.
• Participated in performance tuning and query optimization.
• Created indexes to improve the performance of database.
• Designed cubes using SSAS 2005.

Environment: MS SQL Server 2005, MS SQL Server Integration Services SSIS 2005, MS SQL Server Reporting Services SSRS 2005, Windows NT/2003, MS SQL Server Analysis Services SSAS 2005, MS Excel.

Confidential

MS SQL Developer SSIS/SSRS

Responsibilities:

• Involved in design, development, and testing, databases.
• Used SSIS Import/Export Wizard for performing the ETL operations.
• Migrated data from different sources to SQL Server.
• Creating tables, views, triggers, stored procedures, and user defined functions.
• Creating Indexes to improve the performance of the database.
• Generating reports using SSRS 2005.
• Participated in performance tuning and query optimization.
• Creating backup and restore.

Environment: MS SQL Server 2005, MS SQL Server Integration Services SSIS 2005, MS SQL Server Reporting Services SSRS 2005, MS Excel.