SUMMARY

• Over 7+ years of experience as a MS SQL Server Developer /Administrator specializing in database design, data warehousing development & administration work with SQL Server 2008R2,2008, 2005 and 2000 for OLTP, OLAP and large - scale data warehouse applications using SSMS.
• Experience in data warehouse development with Integration Services, Analysis services and OLAP report development.
• Experienced in creating real time applications using QlikView for various data sources such as SQl, Excel, AS-400.Created some real time sales and demand applications which can give the growth of the business hourly.
• Sound knowledge of software development life cycle (SDLC) with substantial experience with object oriented analysis and design methodologies.
• Strong knowledge in database design features including ER Diagrams, normalization, tables, views, indexes, constraints, keys, data dictionaries, and data integrity.
• Experience in Data Modeling & Database Design with Erwin, Performance Tuning and Optimization of SQL Server 2005 and 2000.
• Experience inwritingComplexSQLQueriesinvolving multiple tablesinnerandouter joins.
• Experienceinoptimizing the queries by creating variousclustered, non-clustered indexesand indexed views.
• Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functionsand other T- SQLstatements for various applications.
• Worked Extensively on ETL process using SSIS package.
• Excellent inData Extraction, Transforming and Loading (ETL) usingSQL Server Integration Services (SSIS),DTS,Bulk Insert, Bulk Copy Program(BCP).
• Expert indesign and development ofSQL Server Integration Services (SSIS)packagesand using variouscontrol flow task anddata flow transformation.
• Excellent increating SSISPackages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSISsuch asData Conversion, Conditional Split, Bulk Insert, merge and union all.
• Expert increatingvarious type of reports such asComplex drill down & drill through reports,Matrix reports, Sub reportsandChartsusing SQL Server Reporting Services (SSRS) based on Relational andOLTP databases.
• Expert indesigningcomplex reportslike reports usingCascading parameters,Drill-Through Reports, Parameterized Reportsusing SQL ServerReporting Services (SSRS) based on client requirement.
• Created dashboards consisting of grids, charts and reports in Performance Point to detail the costs.
• Developed MDX Queries against SSAS cubes to generate reports.
• Involved in SSAS Cubes design by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services (SSAS).
• Absolute knowledge of software development life cycle(SDLC),database design, RDBMS, datawarehousing and data modelingconcepts.
• Experience in Service Broker, Replication data distribution tools
• Experience with a high volume/high transaction internet-based in a real-time transaction processing systems
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.
• Have AcquiredExpertise in business, technical design and database administration knowledge
• Experience in Normalization and building Referential Integrity Constraints, Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Experience in Performance Tuning, Query Optimization, Execution Plan, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Design and Development Experience in Large Complex Multi-terabyte data environments.
• Using Performance Monitor/Profiler to solve Dead Locks/Long running queries.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Good understanding ofRetail,Health careandFinancial Industry

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2008/2005/2000 , Oracle 11g/10g/9i/8i, Teradata V2R5, MySQL and MS Access 2003/2000/97

Database Technologies/Tools: SQL Server Entreprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, OLAP. Microsoft Visio, ER Studio

Reporting Tools: Microsoft SQL Server Reporting Services, Crystal Reports.

Operating Systems: Windows XP, 2000, NT, 98, 95, Windows 2003, Windows Vista, Windows 7

Programming Languages: HTML, C#.Net, VB.Net, T-SQL,, PERL,COBOL,SAP

Design Technologies/Tools: Erwin, MS Visio

Data Warehouse / Business Intelligence Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio, Business Intelligence Development Studio (BIDS)

PROFESSIONAL EXPERIENCE

Confidential, Quincy, MA

Sr. Data Warehouse Developer (SSRS/SSAS/SSIS)

Responsibilities:

• Involved in building dimensional cubes with SQL Server Analysis Services(SSAS)and querying the data withMDXscript.
• Designing and developing SQL Server 2008 Databases, Tables, Indexes, Stored procedures, Views, Triggers.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Worked on SSAS, developed Cubes, deployed Cubes on the server, pulled data from various Data sources and thus developed Cubes.
• Create prototype SQL Server 2008 Analysis Services (SSAS) cubes using the Unified Dimensional Model (UDM)
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Created and developed some real-time sales and demand applications using QlikView from various types of data sources.
• Generated Reports from the cube by using MDX Queries and created calculated members.
• Generated various reporting services RDL’S using reporting services for Account Aggregation reports
• Developed Custom Selection of reports ordering using SQL Server Reporting Services.
• GeneratedSub-Reports,Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Delivered the reports using ‘pulled’ and ‘pushed’ methodologies and formatted them using Global variables and expressions
• Developed Multi-dimensional Objects (Cubes, Dimensions) as well as dimensional cubes using MS Analysis Services
• Created Reports with all Aggregate functions and Expressions using SSRS and VB.NET.
• Worked on ETL SSIS Development, Created packages using various transformation techniques and also created jobs that are scheduled to run on daily basis and thus load into the Data Warehouse.
• Created Batch Files for the Autosys Jobs for the procedures to run on a daily and weekly basis.
• UsedSQL Server profilerfor auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part ofPerformance Tuningoperations.
• Involved in migrating the existing DTS packages into SSIS packages using SSIS services provided by SQL Server 2008 Management studio
• Created Fact tables and Dimensions and deployed them to the existing cube.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Involved in designing the physical databases model on SQL Server 2008 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database
• Extensive testing on the Performance of the Stored Procedures by using the execution plan.
• Monitored performance and fine-tuned the database objects and server to ensure efficient data retrieval.
• Managed existing indexes in ROLAP to optimize the performance of reports accessing it as well as all other BI applications.

Environment: MS SQL Server 2008 Visual Studio, MS SQL Server 2008 Management Studio, T-SQL, SQL Server Integration Services (SSIS), SSRS, SQL Server CE client, ASP.Net, vb.Net, VB Script, MS Access, Lite Speed Backup software, DTS, MDX, Sybase, OLAP, Windows 2008/XP, MS Visio

Confidential

Business Intelligence Reporting Analyst

Responsibilities:

• Designing and developing SQL Server 2008 Databases, Tables, Indexes, Stored procedures, Views, Triggers.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Identify, analyze and review technical requirements for MEDD/RDS.
• Analyze current work flow and initiate process improvements to enhance the efficiency of existing work flow.
• Comprehend technical feasibility and define database specifications of reporting requirements.
• Translate the requirements to technical specification for development.
• Provide quality assurance/testing and analysis for deployed reports under UAT and post production deployment as per Software Development Life Cycle (SDLC) Process.
• CreateStored Procedures, User Defined Functions, Views, T-SQLScriptingfor complex business logic.
• Generate RDS(Retiree Drug Subsidy) reports by uploading the CRL(Client Retiree List), creating Store Procedures and complex queries and filtering out the data pull(Raw All claims Data) using GPI and NDC Inclusions/exclusions. Outcome of the query is later exported to Microsoft Excel and formatted and submitted to the client.
• Automated the tedious RDS reporting process to a 2 step process and improved the accuracy and efficiency of the Process.
• Created SSIS Packages to validate the accuracy of the report with the previous generated report.
• Worked extensively withSlowly Changing Dimensionandlookup Transformationfor implementingInserts andUpdates.
• Identify SQL Server performance issues through the use of dynamic management views and server statistics monitoring and offer solutions (execution plan optimization, index tuning, and query modification). In cases of hardware bottlenecks, identify the culprit and work with System Administrators to resolve the problem.
• Worked extensively on adhoc reports on various internal tools like Lynx.
• Did performance tuning for Lynx generated queries for team members to help them save time and improve the performance of the team.
• Involved inReport Design and Coding for StandardTabular type reports,includingDrill downandDrill throughfunctionality and Graphical presentations such asChartsusingCognos Based tools RxFocus and RXTrack.
• Generated Impact reports and tier mismatch reports on RX Focus for IBC(Independence Blue cross).
• Hands on work with different business analysis i.e., COPAY Analysis, DAW Analysis and Deductible analysis.
• Manage change control based on customer requirements to according to project work flow.
• Assist in performance assessment of the project.
• Involved in analysis, design and development of project to consume data,consolidate into data warehouse and creating reports.
• Extensively worked with Microsoft BI Stack tools (SSIS, SSRS, SSAS)
• Created ETL packages using SSIS to move data from various heterogeneousdata sources.
• Used SSIS to create packages to validate, extract, transform and load data todata warehouse databases, data mart databases, and process SSAS cubes tostore data to OLAP databases.
• Implemented error handling and roll back process in ETL load.
• Created logs for ETL load at package level and task level to log number ofrecords processed by each package and each task in a package using SSIS.
• Configured SSIS packages using Package configuration wizard to allowpackages run on different environments
• Used XML and environmental variables in the package configuration fordeploying SSIS packages
• Maintained and enhanced the existing data warehouse and SSRS reports.
• Worked on different database technologies including creating SQL Serverstored procedures, Triggers, Functions, Views, Indexes and SQL Server datastructures in order to build the new SSRS reports.
• Responsible for maintaining SSAS Cubes and processing the cubes andretrieve the data by writing MDX Queries
• Responsible for monitoring, DB tuning and maintenance activities
• Managing SQL Server full database backup, T log backups and data restore.
• Scheduling Jobs and Alerts using SQL Server Agent.
• Performed unit and system testing, troubleshooting and bug fixing indevelopment and QA environments.
• Worked on Performance Tuning, Query Optimization, using SQL ServerProfiler, Data Base Engine Tuning Advisor and other troubleshooting tools.

Environment: MS SQL Server 2008 Visual Studio, MS SQL Server 2008 Management Studio, T-SQL, SQL Server Integration Services (SSIS), SSRS, SQL Server CE client, ASP.Net, vb.Net, VB Script, MS Access, Lite Speed Backup software, DTS, MDX, Sybase, OLAP, Windows 2008/XP, MS Visio, Cognos, RX Claim, RX track

Confidential, Atlanta, Georgia

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Designing and developing SQL Server 2008 Databases, Tables, Indexes, Stored procedures, Views, Triggers.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Managing security roles in SQL Suite.
• Diagnosing and tuning the server optimal performance using SQL Server 2005 SQL Profiler and Database Engine Tuning Wizards.
• Coordinate with business and end users and gather all data design specifications as per customer requirements.
• Analyze business requirements and assist in appropriate configuration for all solution architecture.
• Design communication process and prepare plans for all work assignments and ensure completion within deadline.
• Monitor all data projects according to development life cycle and ensure compliance to quality standards.
• Administer design of Business Intelligence projects and develop dashboards and operations for reports.
• Develop reports and dashboards on SQL servers.
• Prepare test cases and plans and perform tests on systems.
• Install and assist to configure various Business Intelligence tools.
• Perform troubleshoot on all Business Intelligence tools and assist in resolution.
• Assist all clients to choose appropriate Enterprise Business Intelligence tools.
• Coordinate with enterprise systems and applications and assist in merging various platforms.
• Design and fabricate various SQL Server Integration packages and prepare appropriate reports for data collection.
• Good hands on experience with SQL Server Integration Services, SQL Server Reporting Services and SQL Server Analysis Services.

Confidential, Fort Washington, PA

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Worked with Client/Business Analysts to define data requirements for reporting warehouse.
• Designing and developing SQL Server 2008 Databases, Tables, Indexes, Stored procedures, Views, Triggers.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and Unpivot Control Flow Transformations.
• Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from data warehouse and client systems.
• Designed and developed ETL process with SCD (slowly changing dimensions) with T-SQL, SSIS and VBScript
• Loaded data from heterogeneous sources to databases using various tasks and transformations using SSIS
• Migrate the data from an Access database to SQL Server 2008.
• Used VB.Net Code to create embedded functions in SSRS.
• Fetch the data from Oracle 11g by creating a linked server and use SQL Server to query Oracle database.
• Designed the packages in order to extract data from SQL DB, flat files and loaded into Oracle database.
• Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Designed best practices document for ETL and Reporting Systems using Data Warehouse concepts.
• Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
• Design, deploy and maintain various SSRS Reports in SQL Server 2008.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Involved in the preparation of detail Unit Cost, Price and Volume Trends, Expense Variances and Profitability Reports using SSRS.
• Used ProClarity for accessing and analyzing cubes and dimensions and also worked on integration of SharePoint with SSRS.
• Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
• Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis Services (SSAS).
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS 2008.
• Used SQL Server Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2012/2008, Visual Studio 2008, VB.Net, C#, Oracle, MS SQL Server Management Studio, SSIS, SSRS, SSAS, MS Excel, Teradata.

Confidential

SQL Server Developer/QA Testing

Responsibilities:

• Actively participated in gathering User Requirement and Online System Specification.
• Actively involved in different stages of Project Life Cycle.
• Worked on writing the test scripts for the database objects.
• Involved in the creation of the databases and designing Normalized database objects.
• Developed Indexes, Stored procedures, Views, Triggers and user-defined functions as per business requirement.
• Modified current database by adding tables and relationships to support online system.
• Defined constraints, rules and defaults.
• Created views as required by front-end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation.
• Created complex stored procedures and functions to support efficient data storage and manipulation.
• Create the SSIS reports.
• Fixed the reports exporting issues and paging issues.
• Created interactive reports as per the business requirements using the stored procedures, expressions, filters.
• Scheduled jobs for backup, and created alerts for error reporting.
• Tested the DTS packages.
• Optimized the performance of queries with modification in index system for online system.
• Tested the performance and load effect on the web application which has SQL database backend using Load runner tool.

Environment: MS SQL Server 2012/2008, Visual Studio 2008, VB.Net, C#, Oracle, MS SQL Server Management Studio, SSIS, MS Excel, Java, JSP, Oracle Test Director, Windows NT.