SUMMARY

• Over 7 years of IT Experience in Analysis, Design, Development, Testing and Implementation of applications, reports and databases (Microsoft SQL Server 2012/ 2008 (R2)/2005/2000) on various business areas like Healthcare, Insurance and Manufacturing.
• Experience across all phases of SDLC from project initiation to post - implementation.
• Excellent knowledge in Dimensional Modeling, ER Modeling, Star Schema/Snowflake Schema, FACT and Dimensional tables.
• Expert in writing complex queries, stored procedures, cursors, triggers, views and user-defined functions for data consistency and manipulation.
• Expert in writing T-SQL for SSIS, SSAS, SSRS, Data Cleansing, Data Scrubbing and Data Migration.
• Experience in designing, developing and testing of the ETL processes to populate data from various source systems.
• Experience wif Integration services (SSIS), Reporting services (SSRS) Analysis services (SSAS) and MDX on SQL Server 2005 and MS SQL Server 2008 for data warehouse and data mart solutions.
• Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC, DMVand DMF.
• Experience in extracting data from various sources such as Oracle DB, DB2, MS SQL server, Flat file and XML by using SSIS in order to meet business requirements.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis.
• Built the data cubes by implementing SQL Server OLAP services in SSAS.
• Used MDX script to create dimensional cubes and query data.
• Experience in creating standard and ad-hoc report using SSRS and proficiency in creating different types of reports such as, Drill Down reports, Drill through, Sub reports, Parameterized reports, Cascaded reports and Dashboard such as Graph, Chart, Guage and Map.
• Managed report by using SSRS tools such as report management, report delivery and report security.
• Experience in all phases of Project Life Cycle Requirements, Analysis, Architecture, Design, Building, Unit & Integration Testing, Migration and Training, Deployment and Production Support.

TECHNICAL SKILLS

• SQL Server 2012
• SQL Server 2008 (R2)
• SQL Server 2005
• SQL Server 2000
• Access
• Oracle9i/11g data warehouse
• SQL Server Management Studio
• Query Analyzer
• System Performance Monitor
• SQL Profiler
• Index Tuning Wizard
• Upgrade Wizard
• Data Transformation Services (DTS)
• Business Intelligence Development Studio (SSIS
• SSAS
• SSRS)
• Informatica
• SQLCMD
• T-SQL
• PL/SQL
• MS windows
• C#
• VB.net
• ASP.net
• Core Java
• JavaScript
• Crystal Reports
• HTML
• XML
• CSS
• MS Visio
• Erwin
• Windows
• Data Modeling in relational database and data warehouse.

PROFESSIONAL EXPERIENCE

Confidential, Kennesaw, GA

SQL BI Developer

Responsibilities:

• Designed ClickStream Data Mart (Fact Tables, Dimension Tables) from CoreMetrics Database.
• Created Fact Tables and Dimension Tables on development server and production server.
• Implemented reverse engineering from ClickStream Data Mart by using Microsoft visio.
• Created T-SQL scripts and SSIS packages to perform initial load and incremental load for Fact Tables and Dimension Tables on development server and production server.
• Designed and Created OLAP cube from ClickStream Data Mart and added measures, dimensions, calculations to the cube.
• Deployed ClickStream OLAP cube to production server and configured security for cube.
• Developed and implemented SSIS package to automatically update ClickStream OLAP cube.
• Wrote MDX queries to create calculated members in ClickStream OLAP cube
• Designed and developed SSRS reports from ClickStream OLAP cube.
• Gatheird end user requirements regarding reports on RIB web application and checked wif them which report is currently in use and want to be replaced by Crystal Report.
• Created Crystal Reports to replace reports on RIB web application.

Environment: SQL Server, MS Visual Studio 2012, MS Visio, SSIS, SSRS, SSAS, MDX, OLTP, OLAP, ETL, T-SQL, Crystal report.

Confidential, Boston, MA

SQL BI Developer

Responsibilities:

• Involved in database performance tuning by using Execution Plan, Clustered and Non-clustered Indexes to optimize queries.
• Optimized database performance by using SQL Profiler for monitoring T-SQL code and stored procedures.
• Analyzed detailed end user specifications. Designed and configured BI metadata layer.
• Created SSIS Packages to import and export data between Flat files, Excel spreadsheet and SQL server 2008 (R2)/2012.
• Designed and created data model for relational data warehouse.
• Created SSIS packages to transform raw data into information stored in tables.
• Created SSIS packages to automatically update tables wif monthly data using scheduled jobs.
• Performed various SSIS Tasks such as Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task in order to load data into Data Warehouse.
• Created script task to perform specific ETL jobs by using C#.
• Designed and generated OLAP cubes. Built reports, dashboards and scorecards on OLAP cubes.
• Modified and maintained cube Dimensions, Hierarchies and adding Aggregations to Cube.
• Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using SSRS. Stylishly designed layout like Pie charts, Graphs and Linked Reports.
• Generated Parameterized Reports and cascaded Parameterized Reports.
• Provided support for production deployments and automation. Assisted in monitoring, job control and production support. Provided second level support for production issues related to the BI environment.
• Performed implementation and maintaining security in report development and report access at multiple levels including report groups, role-based and record level. Created report models for generating specific reports as per the client requirements and used row level security filters for report model.

Environment: SQL Server, MS Visual Studio 2005/2008, Windows 2000/2003, SSIS, SSRS, SSAS, MDX, OLTP, OLAP, ETL, T-SQL, Query Analyzer, SQL-Profiler.

Confidential, Santa Rosa CA

SQL BI Developer

Responsibilities:

• Worked wif Payment Analysis, New Orders, Renewals, and Accounting departments to ensure the accuracy of data migration from the old system to the new in-house application called FALCON by utilizing SSIS packages.
• Involved in developing Data models, Data dictionaries, mapping documents and cross functional documents across systems for all the ETL needs.
• Created various database objects such as tables, views, stored procedure, function, trigger and index based on the requirements and business rules.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008.
• Performed ETL Processes by using Informatica to prepare some data for Java application in accounting department.
• Wrote PL/SQL script to support Java application in accounting department.
• Extracted data from disparate sources and loaded into staging database and data warehouse by performing extensive ETL operation.
• Created Cubes and used basic MDX to retrieve the result. Used SQL Server Reporting Services to generate different types of Ad-hoc Reports.
• Generated various reports wif drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Used various report items like tables, sub report and charts to develop standard and customized reports reports in SSRS to halp tracking performance/productivity and other issues.
• Used Performance point service to integrate SSRS reports using Dashboard filters.

Environment: SQL Server 2005/2008, Informatica, Oracle11g, Visual Studio 2005/2008, Java Application, Windows 2000/2003, SSIS, SSRS, SSAS, MDX, OLTP, OLAP, T-SQL.

Confidential, New York, NY

SQL BI Developer

Responsibilities:

• Developed and modified database objects including tables, views, constraints, functions, triggers, user defined rules and stored procedures to provide systematic review, analysis, and evaluation of financial data to identify principal sources of risk as it relates to hedging, pricing, pooling and other focus-areas wifin the Enterprise Risk-Management Division.
• Designed and created data model of relational database for a loan modification application.
• Developed Ad hoc T- SQL queries to meet requirements from business analyst, Operations Analysts, and Financial analyst.
• Migrated data using SSIS, DTS, BCP, Bulk Insert and/or Replication.
• Created ETL processes through SSIS and responsible for loading Data from different input sources to main Database.
• Created ETL processes using Microsoft DTS and SSIS to maintain and update data about official document and research, and created customized reports from related document.
• Created script task to perform specific ETL jobs by using C#.
• Developed windows forms dat connect to database by using C#.
• Developed data extractions of company databases using SQL queries for financial analysis.
• Identified and managed Data Source and Data Source views for SSIS, SSAS, and SSRS Project.
• Created cubes and performed data mining using the fact table and the dimension.
• Created MDX script for Calculation processes in Cube using SSAS.
• Analyzed, designed and developed data marts, data views.
• Created ad hoc report in order to identify unusual trends and activity.
• Created complex financial trend and data analysis reports for decision-making management, using Performance point service to integrate SSRS reports and Power Pivot to create report in SSRS.
• Generated reports using Crystal Reports.
• Scheduled Jobs and Alerts using SQL Server Agent.

Environment: SQL Server, Visual Studio 2005/2008 (.Net, C#), Windows 2000/2003, SSIS, SSRS, SSAS, MDX, OLTP, OLAP, T-SQL, Query Analyzer, SQL-Profiler, SQL Server Enterprise Manager.

Confidential, Philadelphia, PA

SQL Developer

Responsibilities:

• Supported development staff about database related issues.
• Transferred data between Development, Testing and Production databases.
• Used Normalization techniques to create and modify data model.
• Designed DDL/DML queries and other database objects including triggers, stored procedures, indexes and view to manage database.
• Created views and stored procedures for front-end application.
• Created SSIS Packages to import different forms of health care claims data files from external contractors and export to SQL server tables.
• Analyzed the Data quality, Data validating, Data mapping on claims specific data.
• Involved in Data Integration by identifying the information needs wifin and across functional areas of an enterprise database wif SQL server Export Utility.
• Developed OLAP cubes using SSAS and defined measure groups for the functional analysis.
• Generated MDX queries to create calculated measures dat meet business requirement.
• Created and deployed reports and report models for internal and external customers and support their specific requirements using SSRS.
• Deployed the SSRS reports in Microsoft office share point server 2007 (Moss2007).
• Created Dashboards and reporting services web parts using Moss 2007.
• Involved in performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created datasets using stored procedures and reports using multi value parameters
• Created sub reports, bar charts and matrix reports

Environment: MS SQL Server 2005/2008, MS Visual Studio 2005/2008, Windows, SSIS, SSRS, SSAS, MDX, OLTP, OLAP, Sharepoint 2007, T-SQL.

Confidential 

SQL Developer

Responsibilities:

• Involved in gathering Business Requirements, designing, developing, implementing and building the database for data warehouse support.
• Used by Coupon Companion">Data warehousing design concepts/skills to develop multi-dimensional cubes.
• Worked wif DBA to design, create and analyze data model and defined metadata.
• Translated business processes to applicable requirement types such as functional and technical specification.
• Designed DDL and DML for MS SQL Server; developed stored procedures and views for front-end application.
• Created ETL processes using Microsoft DTS and SSIS.
• Wrote store procedures to serve different applications from SQL Server.
• Developed windows forms dat connect to database by using VB.net
• Developed OLAP cubes using SSAS and calculated the metrics dat were revealed in the functional analysis.
• Tuned SQL queries and stored procedures for better performance using Query analyzer, SQL Profiler and Index Tuning Wizard.
• Wrote Stored Procedures for Reporting purpose. Also developed various reports using SQL Server Reporting Services.
• Performed Key performance Indicators (KPIs), designed of star schema and snowflake schema in Analysis Services (SSAS).
• Created users and roles for security purpose on the development server.
• Tuned Queries for the performance of reports which were being developed in SSRS.
• Created custom and standard reports using Crystal Reports.

Environment: MS SQL Server 2005/2008, MS Visual Studio 2005, Windows 2000/2003, SSIS, SSRS, SSAS, MDX, OLTP, OLAP, T-SQL, Query Analyzer, SQL-Profiler, Crystal Reports.