SUMMARY

• Over 8 years of IT Experience in Analysis, Design, Development, Implementation, troubleshooting and Support of Microsoft SQL Server 2012/2008R 2/2008/2005/2000 suite of products like SSRS, SSAS and SSIS.
• Excellent skills in Designing, Development, Maintenance, Implementation and Troubleshooting o applications using SQL and TSQL.
• Experience in database administration, data privileges, roles, logins, permissions, restores and backups.
• Experience in SQL Server Agent, Monitoring jobs, SQL Server Logs and DB Email.
• Good experience in creating Databases, Tables, Stored Procedures, Triggers, Views, User defined functions, Types, Cursors and Indexes using T - SQL.
• Experience in writing complex T-SQL queries using Inner, Outer and Cross Joins.
• Experience working on CTEs and recursive CTEs.
• Worked on migrating DTS Packages from and R2.
• Experience with ETL framework standards, including error processing, validation and data reconciliation.
• Experience in creating SQL Server Analysis projects using MS SQL Server 2012/2008R 2/2008/2005.
• Experience in Designing and Building the Dimensions and Cubes with star schema using SQL Server Analysis Services (SSAS).
• Experienced in generating on-demand and scheduled reports for business analysis and management decisions using MS SQL Server Reporting Services (SSRS).
• Proven ability in generating Drill down and Drill through reports with Drop down option, sorting the data and defining subtotals.
• Experience in administrating the reports and assigning permissions to the valid users for executing the reports.
• Experience in data migration (using tools like DTS, BULK INSERT, and BCP) between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
• Extensive experience in monitoring and tuning SQL Server database performance using tools like SQL Profiler, Index Tuning Wizard, Database Engine Tuning Advisor, Windows Performance Wizard.
• Experience in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text file, Teradata) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all.
• Experience defining and building audits and controls to ensure the accuracy of the data.
• Experience in Analyzing Execution Plan, managing indexes and troubleshooting deadlocks.
• Experience in Data Modeling, Multi-Dimensional Modeling and involved in creation of Star Schema and Snowflake dimensional schema using Erwin Tool and Microsoft Visio.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Foreign Keys.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Good knowledge in various stages of SDLC (Software Development Life Cycle), Software Testing Life Cycle (STLC).
• Strong understanding of the Agile Software Development Life Cycle Methodologies
• Worked in an onshore-offshore project team set-up
• Ability to work well independently and effectively in teams
• Ability to prioritize tasks, organize, negotiate, and make important decisions.
• Self-motivated and ability to master new technologies
• Ability to work under pressure, meet deadlines and work extra hours when needed.

TECHNICAL SKILLS

Tools: &Packages SQL Server Management studio, SQL Server Business Intelligent studio (BIDS)

BI Tools: SSIS, SSAS, SSRS.

Databases: MS SQL Server 2005/2008, 2012, MS Access 2008.

Language: T-SQL,C,XML,MDX

Operating Systems: Windows Desktop / Windows Server.

Application Packages: MS Office Suite, MS Outlook.

PROFESSIONAL EXPERIENCE

Confidential, Oklahoma City, OK

MSBI Developer

Responsibilities:

• Involved in gathering, understanding and validating the project specifications.
• Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for generating reports using SSRS.
• Involved in migration of large amount of data from OLTP to OLAP by using ETL Packages.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Involved in partitioning and aggregation of cubes in order to increase the performance of cubes using SSAS.
• Experience in working on Cube structure optimization for MDX query performance in SSAS.
• Excellent hands on experience in creating groups, hierarchies and measures, KPIs.
• Created and maintained databases, tables, stored procedures, indexes, database check constraints, and business rules using T-SQL.
• Closely working with category for implementation master data management (MDM) of new products, customers and vendors.
• Designed, Developed and Deployed custom reports in MS SQL Server environment using SQL Server Reporting Services-2012.
• Developed SSIS packages bringing data from diverse sources such as Excel, SQL server, flat files for the daily load in order to create and maintain a centralized data warehouse.
• Developed complex T-SQL queries for the ETL packages.
• Designed packages in SSIS 2012 with various complex transformations such as derived column, conditional split, lookup, aggregation, execute SQL task.
• Good understanding and experience in SQL 2012 with new features.
• Create and maintain data model/architecture standards, including master data management (MDM) to define reference data.
• Implementing various SSIS packages having different tasks and transformations and scheduled SSIS packages.
• Worked on different kinds of Transformations in SQL Server Integration Services (SSIS) like Slowly changing dimension (SCD’s), Lookup, Merge, Derived column, Multicast, Conditional split, Aggregate, Fuzzy lookup, Pivot and Un Pivot as per the client requirement.
• Built Synchronous and Asynchronous scripting component for different modes of output.
• Created user variables, property expressions, script task in SSIS.
• Designed and created views for security purposes, implemented rules, defaults, user defined data types, documented the table relationships with diagrams.
• Designed different type of reports including: Tabular forms, Matrix such as cross tab form, Conditional, List items, Charts and Sub reports.
• Designed Cascading, Printable, interacted reports like drill-down and sorting functionality.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports using Sub-report.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created standard report Subscriptions and Data Driven report Subscriptions.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Responsible for deploying reports to report manager and troubleshooting for any error occurs in execution.

Environment: MS SQL Server 2012, T-SQL, MS SQL Integration Services 2012, MS SQL reporting Services 2012, MS SQL Analysis Services 2012,Microsoft Visual Studio 2010, SharePoint Designer, SQL Server Management Studio

Confidential, Boston, MA

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Designed packages using Transformations Sort, Merge, Merge Join, Union, Union ALL, Lookup, Aggregate, OLE DB Command and Derived Column.
• 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.
• Developed new mappings using SSIS Look Up/Aggregation transformations to match the needs of the business case.
• Used Configuration Files in SSIS to ease the process of moving the packages across servers.
• Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed.
• Created reports on to Share-Point and Report Server and set the data-driven subscriptions for these reports.
• Deployed generated reports of each quarter onto the Report Server to access it through browser.
• Designed and developed Data Warehouses, Data marts using Multi-dimensional models such as Star Schema and Snow Flake Schema for developing cubes.
• Generated reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using SSRS.
• Formatted the SSRS reports using the Global variables, expressions and Functions.
• Created reports in SSRS using different types of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Maintained the consistency of data by performing Data Profiling and Data Cleansing.
• Involved in developing Life Cycle using Agile Methodology.

Environment: SQL Server 2008R2/2008/2012, SSIS, SSAS, SSRS, Visual Studio

Confidential, St Paul, MN

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Understanding Customer requirement via interaction and writing functional specification.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Involved in designing and implementing database applications using Business Intelligence (BI) tools to support transactions and business decision-making.
• Created Stored Procedures, Triggers, User defined Functions and Constraints on various database objects to obtain the required results.
• Created various database objects such as tables, indexes and views based on the requirement.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Responsible for stylish design layout like Pie charts, Graphs and Linked Reports and drilldown, cross tab and matrix style layouts.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Created Report Subscription and Data Driven Subscription
• Created Sub-Reports, Drilldown-Reports, and Summary Reports.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Involved in creating Cubes using SQL Server Analysis Services (SSAS).
• Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that servers.
• Involved in checking various Performance issues using RS objects of the reports in SSRS and in data integrity issues.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 and Flat files.
• Used different Transformation in SSIS as per design specifications.
• Applied various data transformations like, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Wrote complex T-SQL queries for data extraction.

Environment: MS Excel.SQL Server 2008 R2 / 2008/2012, SSRS (SQL Server Reporting Service), SSIS (SQL Server Integration Services), SQL Server Analysis Services (SSAS), Business Intelligent Studio, SQL Server Management Studio

Confidential

SQL Server /SSRS Developer

Responsibilities:

• Created standard report Subscriptions and Data Driven report Subscriptions.
• Created tabular, matrix, chart, drilldown reports, drill through, sub, linked reports, parametric, cascaded reports and dashboards and scorecards reports according to business requirement.
• Created reports using Report Builder from OLTP and OLAP data sources and deployed on report server.
• Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS.
• Generated multi parameterized reports in Report Builder allowing users the ability to make selections before executing reports; thus making them user friendly.
• Assembled and converted user requirements from multiple clients into our standard reporting solution and customized specific client requests when necessary.
• Worked on Agile Methodologies.

Environment: SQL Server 2008/2008R2, Report Builder 3.0, SQL Server Data Tools

Confidential

SQL Server Developer

Responsibilities:

• Created new tables, views, indexes, stored procedures using user defined functions and datatypes.
• Based on business requirement, developed Complex SQL queries using various Join techniques like inner join, outer join, left outer join and right outer join to implement the business rules and transformations.
• Created DTS Packages to export and import data from Flat files, CSV, MS-Access, Excel and OLE DB to SQL Database.
• Wrote Ad-Hoc T-SQL queries for analysis purposes.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Created the MS-DTS packages for executing the required ETL tasks.
• Created the Jobs and scheduled for daily running.
• Generated reports from database to Excel spread sheet using DTS.
• Performed daily database backup and restoration of Database Server.
• Developed complex stored procedures to create various reports by using SQL server reporting service 2005.

Environment: SQL Server 2005/2008, Windows 2000 Server, SQL Profiler, DTS, Query Analyzer, SQL server reporting service 2005