SUMMARY

• Over 8+ years of IT Experience in Database Design, Integration Services, Data Warehousing, Business Intelligence and Data Mining in various business domains like Financial, Insurance and Health Services.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/ 2008/2012/2014
• Hands on experience in SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Excellent knowledge in creating Databases, Tables, Views, Stored Procedures, DDL/DML/DCL, Triggers, Cursors, Views, User Defined Functions(UDF) and Indexes using T - SQL.
• Experience in using T-SQL in SQL Server 2000, 2005, 2008, 2012 and 2014 platforms.
• Experience in developing, monitoring, extracting, transforming, and testing data using SSIS, Import Export Wizard, and Bulk Insert.
• Excellent in Design of SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment
• Hands on experience in creating Star Schema and Snow Flake Schemas.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS
• Sound Experience and understanding of SSAS including creating data source, data source view, cube, dimension, creating calculating members and KPIs.
• Designed Dashboards, Scorecards and reports using multiple KPI’s, OLAP charts and SSRS Reports
• Knowledge in database back and recovery
• Experience in SAS and Rapid Miner Simulation and predictive analysis modeling such as decision tree, regression and neural network
• Routinely use advanced Excel functions to generate spreadsheets and tables such as Lookup, VLOOK UP, Pivot and Power Pivot.
• Knowledge of complete Software Development Life Cycle (SDLC) - Waterfall, Agile
• Experience in preparing Test plans, Test Data and execution of Test cases to ensure application functionality meet the user requirements
• Excellent analytical, communication interpersonal skills and a good team player.

TECHNICAL SKILLS

Development Tools: Microsoft SQL Server BI (MSBI) Stack, Data Tools SSDT, SSMS, Business Intelligence Developer Studio BIDS, Visual Studio, Query Analyzer, Visual Interdev, Visual SourceSafe, TFS-Team Foundation, GIT, BitBucket, Red-Gate SQL tools, Business Objects BOBJ

Programming Languages: T-SQL, PL/SQL, MDX, C#, VB6

Scripting Languages: Windows/DOS scripting, PowerShell 3.0, VBScript, JavaScript, XML

Web Servers: IIS, FTP, SMTP, SFTP

Database: SQL SERVER 2014, 2012, 2008 R2, 2005, 2000, OLTP, Data Tools SSDT, Integration Services SSIS, ANALYSIS SERVICES SSAS, DTS, Teradata, Oracle7,11

Reporting Tools: SQL Server Reporting Services SSRS, SSDT, RDL, PowerPivot, Power View, SharePoint Server, Analysis Manager, Metadata Integration Repository, Tableau 8.1, Business Objects BOBJ

DB Analytics: OLEDB, ODBC, OLAP, MOLAP, ROLAP, AMO, ADOmd, MDAC

OS: WINDOWS 2008,8,7,2003,XP,2000,NT, MSDOS, Linux, UNIX, Novel Netware

Other Tools: MS VISIO, Erwin 3.5,4,7.3, MSOFFICE, SSMA, Remedy & JIRA issue tracking tools

Methodologies: SDLC, OOP, OOAD, UML, Agile-Scrum

Hardware Used: IBM, DELL, COMPAQ, HP based Servers/Workstations/CISCO Appliance

PROFESSIONAL EXPERIENCE

Confidential, New York City, New York

Senior MSBI SSIS/SSRS/SSAS Developer

Responsibilities:

• Understanding Customer requirement via interaction and writing functional specifications.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Followed Agile methodologies (scrum)
• Involved in designing and implementing database applications using MS SQL Server 2005/2008 and Business Intelligence (BI) tools to support transactions and business decision-making.
• Written UNIX - Perl and Shell scripts to automate the process of retrieving the files from external vendors via HTTPS Connect Direct, FTP, SSH, SFTP.
• Created Stored Procedures, Triggers, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Created various database objects such as tables, indexes and views based on the requirement.
• Automation of creating Accounting code module for each account.
• 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 R2 and Flat files.
• Used different Transformation in SSIS as per design specifications.
• Applied various data transformations like Slowly Changing Dimension, 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.
• Created DTS/SSIS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
• Created a number of cubes, dimensions and business critical KPIs using SSAS
• Documentation of SQL objects using Red Gate’s SQL Source Control tool and Erwin.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Generated reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries
• Created Report Subscription and Data Driven Subscription using SSRS 2008R2.
• Extensively worked on data models like tabular data model and PowerPivot data model.
• Working knowledge on building SSAS cubes when opening a PowerPivot for SharePoint.
• Resolved connectivity issues and ODBC with front end application languages ASP.net, VB.net and C#.net
• Monitor and provide support to the application during the testing and production environments.
• Reviewed business requirement and work closely with client, business analysts, and system analysts to align functional responsibilities
• Contact client to gather requirement, call meeting and assist client for issues related with the project.

Environment: MS SQL Server 2008/2012/2014 , SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Visual Basic6.0, VB Script and Windows 2008 Server.

Confidential, Hopewell, NJ

SQL Server Database/ETL/Report Analyst

Responsibilities:

• Extract, Transform and Load source data into respective target tables to build the required data marts.
• Understand user requirements and Data Model defined and developed by the business analysts and data architects.
• Constructed OLTP and OLAP Databases.
• Performed DBA tasks like Backup, Restore of tables and Stored Procedures and Refreshing Database on weekly basis.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Implemented different types of constraints on tables.
• Designed and applied entity and attributes description and definition for the models.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Migrated data from SAS environment to SQL Server 2005 with SQL Server Integrated Services (SSIS).
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Responsible for gathering business requirements to create business user reports.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
• Developed optimal stored procedures and queries to create data sets for reports.
• Designed and implemented stylish report layouts.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Played a Content Manager role on report server.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Designed SSAS cube to hold summary data for Target dashboards.
• Developed Cube with Star Schema.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Target.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: MS SQL Server 2008/2005, SQL Server Management Studio, MS Excel, MS Access T-SQL, SQL Server Business Intelligence Development Studio, Tableau, Window 8.

Confidential, Delaware, OH

MSBI (SSIS/SSRS/SSAS) Consultant

Responsibilities:

• Modification of database object such as addition of triggers, modification of table, stored procedure to meet new customer’s requirements.
• Database performance tuning, monitoring, scalability and Testing. This includes optimization of slow running stored procedures, deployment of locking mechanism to increase concurrency.
• Created DTS (SSIS) packages to get data from various sources (mainframe, Informix, Oracle).
• Administer, maintain, develop and implement policies and procedures for ensuring the security and integrity of the department database.
• Performed Weekly Application Builds, including some troubleshooting and debugging of Multi-tier financial applications.
• Automation of monitoring all the failed jobs in the database using DTS (SSIS) and SQL mail.
• Prepared patch and upgrade scripts for service packs and new releases
• Index optimization, Performance, Disk management, Disk partitions and optimizing.
• Worked on locking strategy which is used for various batch Programming structures & Transactions.
• Memory management, data storage, user connections and load balance.
• Prepare and set up environment for disaster recovery.
• Transformation of data from one server to other servers using tools like bulk copy program (BCP), data transformation services, data conversions from legacy systems to SQL server.

Environment: MS SQL Server 2005, MS SQL Server Integration Services, MS SQL Server Reporting Services, SQL Server Analysis Services (SSAS) T-SQL, MS Visio, MS Access, MS Excel, Window 7.

Confidential, Fort Worth, Texas

MSBI (SSIS/SSRS/SSAS) Consultant

Responsibilities:

• Created database objects such as tables, views, triggers and indexes.
• Took part in Normalization of the database and bringing it to 3NF.
• Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential integrity and created ER diagrams.
• Used joins and sub-queries to simplify complex queries involving multiple tables.
• Created User Defined Functions (UDF) and Common Table Expressions (CTEs) for efficient data manipulation.
• Migrated data from heterogeneous data sources to a centralized SQL Server using SQL Server Integration Services (SSIS).
• Created packages to validate, extract, transform and load data to centralize SQL Server using OLEDB providers from the existing diversified data sources.
• Extensively used SSIS transformation such as look up, merge, merge join, conditional split, derived table, data conversion and aggregates and etc
• Created Sub reports, parameterized and drilldown reports based on requirement provided
• Generated daily and weekly monthly reports including regular and ad hock reports using SSRS
• Created various SSRS reports such as Multi value reports, Linked, Tabular and chart diagrams
• Created cubes and dimension and generated calculating objects and KPIs by using SSAS.
• Generated Dynamic Report from cubes (SSAS) and SSRS.

Environment: MS SQL Server 2005, MS SQL Server Integration Services, MS SQL Server Reporting Services, SQL Server Analysis Services (SSAS) T-SQL, MS Visio, MS Access, MS Excel, Window 7.

Confidential

SQL Server Data Analyst/ETL Analyst

Responsibilities:

• Collected requirements from Business Users and take part in preparation of technical specifications.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views
• Designed Constraints, rules and set Primary, Foreign, Unique and Default key, and hierarchical database
• Developed stored procedures in SQLServer to standardize DML transactions such as insert, update and delete from the database.
• Created SSIS package to load data from Flat Files, Excel, and Access to SQL Server 2008 using connection manager
• Transform the data using various SSIS tools such as Derived Columns, Condition Split, Data Conversion, Aggregate, and Pivot Transformation.
• Created data transformation task such as BULK INSERT to import data from client
• Identified the dimension, fact tables and designed the data warehouse using star schema and designed new schema for the Data Mart
• Implemented SCD1, SCD2 type maps to capture new changes and to maintain the historic data.
• Created SSRS report in BI studio, prepared prompt generated/ parameterized report using SSRS 2005.
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Take in charge for unit testing of each reports and sub reports

Environment: MS SQL Server 2008R2/2008/2005, MS SQL Server Integration Services, MS SQL Server Reporting Services, T-SQL, MS Access, MS Excel, Window 7.