SUMMARY

• SQL Server Developer with over 10 years of experience in the Analysis, Design, Development, Implementing and Testing, Administrating Client/Server applications using Microsoft Technologies.
• Extensive experience with all phases of Software Development Life Cycle in Different Environments like Banking, Insurance, Engineering and Information Technology.
• Expert in working with the Business Intelligence Development Studio (BIDS), which includes SSIS, SSAS and SSRS.
• Expert in writing T - SQL, working on DTS, Data Cleansing and Data Migration.
• Involved in migrating and upgrading SQL server 2005 to SQL Server 2012.
• Migrated data from different sources including flat files, MySQL, MS Access, Oracle 11g, and OLE DB sources to various Destinations by using SSIS 2008/2012.
• Managed slowly Changing dimensions (SCD) and optimized fact table inserts.
• Used DTS/SSIS packages and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Experience in implementing Dynamic ETL.
• Deployed several SSIS packages using package configurations.
• Loading data into Dimensions and fact tables using SSIS
• Experience in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Services (SSIS).
• Expertise in developing reports using SQL Server 2008/2012 Reporting Services (SSRS).
• Experienced in sorting the data, defining subtotals for reports and designing report layout.
• Proven ability in generating Drill down and Drill through reports with Drop down menu option.
• Developed interactive reports using Crystal Reports and SQL Server Reporting Services.
• Excellent knowledge on Object Oriented Analysis and Design concepts.
• Experience in creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access. .
• Expertise in developing OLAP cubes using SSAS for data mining and created reports from the OLAP cubes using SSRS and Report Builder 3.0
• Experience with .NET in interacting with Business users and the development team.
• Experience in tuning the reports that includes modifying, Testing the required TSQL and MDX queries using DMV's and creating the necessary environment for Deployment.
• Great Knowledge in Dimensional Modeling, applying Kimball’s methodology, Star Schema/Snowflake Schemas, ODS. Experience in Performance Optimization of SSAS cubes.
• Wrote MDX Queries and expressions in Cubes for use in front end Business Intelligence applications.
• An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hardworking and high level of motivation. A quick learner with an attitude for taking responsibilities.

TECHNICAL SKILLS

Database: MS SQL Server 2005/2008/2012 and Oracle 10g/9i/8i, MS Access

Modelling tools: Erwin 4.5/4.2/3.5, E-R-studio 7x/6x/5x, MS Visio

ETL Tools: MS SQL Integration Services (SSIS), MS SQL Analysis Services (SSAS), DTS, MS SQL Reporting Services(SSRS)

Languages: T-SQL, PL/SQL, .Net, VB Script

Operating Systems: UNIX, Windows 2000/NT/98, MS DOS

PROFESSIONAL EXPERIENCE

Confidential, Virginia Beach, VA

MS SQL Server SSRS/SSIS/SSAS Developer

Responsibilities:

• Removed VB code and modified SQL SERVER Store Procedure to capture VB logic in production reports.
• Migrated Tables, Views and Stored Procedures from Oracle and DB2 database to SQL SERVER database.
• Created stored procedure based on Business Requirement Document and data mapping.
• Created Member, Provider, Claim reports using SSRS for various state markets.
• Identified and worked with cascading parameters for parameterized reports in SSRS.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Developed Query for generating drill down/drill through reports in SSRS 2008/2012 in SharePoint Integrated Mode.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Enhanced reports by using a series of features like Highlighting report values using conditional styles, applying a report template, format report objects, focus the scope of a report using filters for accuracy of the equity rewards and Incentive grants.
• Deployed reports for QA and UAT testing in JIRA.
• Checked in and out code using MS TFS.
• Designed and applied entity and attributes description and definition for the models.
• Implemented different types of constraints on the tables.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Extract data from different sources and transferred to OLAP using SQL Server Integration Services (SSIS) 2008/2012.
• Created SQL server Analysis Projects and created multi-dimensional databases and OLAP cubes and dimensions for the analysis of KPI in specific areas using SSAS.
• Migrated data from Oracle data server to the SQL data server by using SQL Server Migration Service.
• Worked with ASP.NET and SQL Server for developing applications.
• Improved query performance by using SQL profiler.
• Reviewed and changed the cubes in the data marts for product valuation based on the revenue opportunities using SSAS 2008/2012.
• Identified the Data Sources and defined them to build the Data Source Views.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Identified and defined Key Performance Indicators (KPIs) in SSAS 2008/2012.
• Used MS Excel (Pivot Table), Reporting Services as Front Viewer and OLAP cubes as backend and provided integration between MS Excel/SSRS and SSAS.
• Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters for the analysis of Performance

Confidential, Philadelphia, PA

MS SQL Server SSRS/SSIS/SSAS Developer

Responsibilities:

• Wrote ad-hoc T-SQL queries for data analyzing, research, unit testing and identifying and resolving bugs.
• Designed, modified database objects such as tables, views, indexes, Stored Procedures, user defined data types and functions
• Extracted and transformed data from various sources such as SQL server, Excel, Access and flat files using SSIS into destination tables as per the business requirements.
• Used various SSIS/ETL tasks such as Conditional Split, Derived Column, lookup used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Designed, developed, debugged and tested SSIS packages, SSRS reports and T-SQL Stored Procedures.
• Performed unit integration and functional testing of the SSIS packages, T-SQL and Stored procedures.
• Administered, monitored and supported SSIS Packages and ETL process. Wrote support documentation for SSIS packages/SSRS reports and Stored procedures.
• Using SQL Server Analysis services 2008 created & enhanced Cubes, Dimensions, Measures based on the business requirement.
• Using Dimension Creation wizard created Standard Dimensions with attributes, relationships, Levels and hierarchies and tested using Dimensions browsers.
• Responsible for creating reports based on the requirements using SSRS 2008.
• Identified the database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Wrote production implementation documents and provided Production support when required

Confidential, San Leandro, CA

MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Involved in Database Design, Table & Relationship creation. Involved in Data Analysis using Power Pivot for EXCEL, Updated Stored Procedure, Functions and Views.
• Involved in the performance tuning of queries with modifications in T-SQL queries, eliminated inconsistent data using Data-Clean script, normalized tables, established Inner/Outer Joins and created indexes whenever necessary.
• Implemented Business Intelligence using SSIS Package to Import/Export data from Flat Files to SQL Server using Data Flow Task, File System Task and Execute SQL Task, with For Each Loop Container.
• Used Constraints, Variables & Expressions to dynamically change path of SSIS Package. Debugged package using Breakpoints and Data Viewers.
• Used SSIS Transformations like Derived Column Transformation to create new column, Conditional Split Transformation to split data flow.
• Participated in Build and Deployment of SSAS Cubes as well as processed them.
• Created/ Modified SSRS based reports based on T-SQL and Stored Procedure with Input parameters.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).

Confidential, Simi Valley, CA

MS SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in performance tuning of report by analyzing underlying Stored Procedure and error solving by analyzing Execution-Log of Reports.
• Created SSIS Packages using Execute SQL Task, File System Task, Send Mail Task, Foreach Loop container and Sequence container.
• Created SSIS Package with various Variables, Expressions and Transformations like Conditional Split, Derived Column, Data Conversion, Lookup, Merge Join, Sort and Aggregate.
• Debugged SSIS Packages using Breakpoints, Data Viewers & watch windows.
• In SSIS package, created Event handlers for handling runtime events and Implemented Transactions using Checkpoints.
• Involved in data migration from Excel, CSV files into SQL Server using SSIS Packages.
• With Analysis Services 2005 created various Cubes, Dimensions, Measures and Aggregates based on the business requirement.
• Also involved in creation, build, deployment & processing of SSAS Cubes.
• Created/ Modified SSRS based reports based on T-SQL and Stored Procedure with Input parameters.
• Enhanced report by adding Report Header/Footer with Execution Date/Time, No. of Pages, and No. of Records retrieved using Business Intelligence Development Studio.

Confidential

MS SQL Server Developer

Responsibilities:

• Installed SQL Serve.
• Developed backup restore scripts for SQL Server 2000 as needed.
• Wrote various stored procedures for the purpose of application development.
• Tuned SQL statements (e.g. using Indexes) and Stored Procedures.
• Performed disaster recovery and database maintenance plan.
• Involved in replication of Data (Transactional method used).
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Involved in job scheduling and alerts.
• Assisted in the Analysis and Design of database.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Defined relationship between tables and enforced the referential integrity constraints. Created Clustered and Non-Clustered Indexes.
• Worked with DTS packages to load the massaged data into Data warehousing system.
• Tuned the SQL queries using SQL profiler. Involved in tuning the database.
• Involved in data migration from legacy sources.
• Trouble shooting Problems by using SQL server profiler. Pre-actively identifying the problems before user complaints.