SUMMARY

• 6 years of experience in Database Design, Development & Support of MS SQL Server 2012/20 in Production and Development.
• Involved in business to develop Entity Relationship/data models, requirement documents, and ETL specifications.
• Experience in all aspects of Data Warehousing(usedKimball’s approach) including projectplanning,requirementgathering,datamodeling,development,deployment, maintenance and enhancement.
• Experienced in migrating database system from SQL server 2005 to SQL server 2008.
• Experienced in ETL design, developmentandimplementation.
• Hands - on working experience with analyzing query plans, using extended Stored Procedures
• Proficient in working with SQL statements to extract data from data tables and verify the output data of the reports. Good at T-SQL, Sub queries, Correlated Sub queries, Joins, Views, Indexes, SQL Functions, Set Operators and other Functionalities.
• Proficient in RDBMS concepts and Objects creation such as Database, Table, Normalization, UDF, User Defined Data Type, Indexes, SPROC, Views, Cursors, CTE and Triggers.
• Expert in designing and creating Indexes, planning and implementing Server Security and authentication.
• Expert in T-SQL Programming, query optimization and performance tuning.
• Experienced in using ETL tools to design SQL Server Integration Services (SSIS) packages in Business Intelligence Development Studio (BIDS) for Data Management applications.
• Excellent experience in migrating DTS packages from SQL Server 2000 to SQL Server 2005 and SQL Server 2012 SSIS packages.
• Experienced in creating Jobs, Alerts, SQL Mail Agent, Scheduling DTS packages.
• Experience in error and event handling, precedence constraints, break point and logging.
• Expert in using transformations like Aggregate, Multicast, Data conversion, Merge Join etc.
• Involved in Data Modeling using Erwin 7.0/6.5 and Unified Modeling Language (UML) 2.5/2.0 tools.
• Experienced in creating the MDX queries to access cubes and dimensions (SSAS).
• Experienced with aggregation using OLAP analysis services cube.
• AdvanceknowledgeinRDBMSconcepts,conceptual/logical/physicaldatamodels&Dimensional/Star/Snow Flakeschemas.
• Knowledge about MOLAP, ROLAP and HOLAP Proactive caching mode for cubes.
• Experienced in SQL Server 2005 OLAP database development including KPIs, Data mining, slowly changing dimensions etc.
• Developed reports on SSAS & SSRS on SQL Server (2005/2008/2012 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Developed Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Multi-valued parameters, Cascaded parameters, Linked reports, Ad hoc reports, Drill through, Drill down reports, etc. using SQL Server Reporting Services (SSRS).
• Expert inPerformance Tuning and Optimization ofSQL Server.
• Experienced in Deploying Reports in SharePoint solution builder and creating dashboards in SharePoint.
• Excellent analytical and communication skills to present points precisely and solve problems efficiently.
• Detail-oriented multi tasking with strong technical concepts and organizational abilities.

TECHNICAL SKILLS

Operating Systems: MS DOS, Windows 9x/2000/NT/Server 2003/XP/Vista/7, UNIX 4.0

Databases: MS SQL Server 2000/2005/2008/2008 R2/2012, Oracle 8i/9i, 10g, 11g, MySQL Server 2012/2008/2005, MS Access 2000/2003/2007

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS)

Analysis Tools: SQL Server Analysis Services(SSAS)

Database Tools: SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Import/Export, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs, Bulk Insert and BCP

Languages: Transact SQL (T-SQL), PL/SQL, C, C++, Java, C#, ASP.Net, VB Script

DB Modeling Tools: MS Visio 2010, Rational Rose, Erwin 4.0,Visual Paradigm for UML

Reporting Tools: SQL Server Reporting Services (SSRS), Report Writing in SSRS, MS Excel

.Net Frameworks: .Net Framework 1.0/2.0/3.0/3.5, Microsoft Office SharePoint Server (MOSS 2007)

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

MS SQL Server, SSIS, SSRS and SSAS Developer

Responsibilities:

• Created stored procedures, views, tables, triggers, table-valued, scalar functions etc. on various databases for critical data involving profit and loss, net revenue, forecasting etc.
• Used Date functions, String functions and Database functions to manipulate and format source data.
• Developed logical database and converted into physical database using Erwin.
• Installed, upgraded and migrated databases from MS SQL Server 2008 to MS SQL Server 2012.
• Proposed and implemented optimized side-by-side SQL server migrating plan with minimum server downtime.
• Experienced in documenting the ETL process flow for better maintenance and analyzing the process flow.
• Created an automated ETL summary report which consists of the summary information for all the loading activities done for day and month
• Designed a complex SSIS package for data transfer from three different firm sources to a single destination like SQL Server 2008.
• Designed dashboard reports using SSRS in integration with SharePoint.
• Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads
• Generated a report which identifies the performance efficiency of every component within the modules of payroll.
• Proposed KPI’s for trending infrastructure online performance, reliability and component failure events.
• Implemented data views and control tools for guarantee data transformation using SSIS.
• Extensively worked on data profiling task in SSIS.
• Experience in Error Handling using TRY and CATCH blocks and performance-tuning using counters in SSIS.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Extensively worked on SCD transformation in SSIS package.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Successfully deployed SSIS packages with defined security.
• Extensively worked with OLAP cubes to generate drill through reports in SSRS.
• Wrote complex T-SQL queries and Stored Procedures for generating reports.
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, fund Reports, sub-reports, charts, conditional and dynamic reports using SSRS 2008.
• Developed various Charts and Graphs like bar charts, line charts, pie charts etc. by using chart experts as per requirements.
• Performed database maintenance using SSIS maintenance plan tasks.
• Responsible to monitor performance and optimize SQL queries for maximum efficiency.
• Used stored procedures, wrote new stored procedures and triggers, modified existing ones, and tuned them such that they perform well.
• Developed complex reports using multiple data providers, user defined objects, charts, synchronized queries.
• Implemented star schema in SSAS to develop OLAP cubes and generated ad-hoc reports for the clients as per their requirements using SSRS in MS SQL 2012.
• Identified and defined Facts and Dimensions relationships for OLAP cubes in SSAS.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Helped even as an administrator at times and good at troubleshooting like setting up drivers, installations of operating systems, assigning IP’s to machines, software issues, error-detections.

Environment: MS SQL Server 2012, MS SQL Server 2008 R2, MS SQL Server Reporting Service 2008 R2, SharePoint, MS SQL Server Integration Services 2008 R2, BIDS, T-SQL, Windows 2003 Server,VB.Net,Asp.Net.

Confidential, Boston, MA

MS SQL Server / SSRS /SSIS Developer

Responsibilities:

• Worked on health care data, used to get data from various states, creating extracts, ETL process.
• Created and designed Staging, ODS (Operational data store), Normalized databases for various business needs.
• Used to deal with Claims, providers, Recipients healthcare data and good at understanding health care business.
• Implemented SQL server clustering to gain control over SQL Server uptime.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of UNION, *, Top, Distinct and <> statements.
• Configured SQL Server’s Optimal Settings (Locking & Memory) according to the usage of its tables, # of users and hardware.
• Created detailed reports for the employers to help them decide which retirement plan showing demographic information based on various parameters using SSRS 2005.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Scheduling jobs for nightly/weekly loads with efficient database backup and recovery plans.
• Created several stored procedures to do bulk insertion, ftp of data/files from mainframe/host systems to SQL server
• Monitored performance using SQL profiler and optimized SQL queries for maximum efficiency.
• Identified and defined multiple Datasets to generate sub reports based on main parameterized report.
• Developed data marts, cubes and ETL to process the cubes nightly, weekly and full refresh of data during the weekends
• Developed and designed DTS package/application for importing the data from word and update
• Created different user level groups, and assigned appropriate permission levels to the reports, to ensure access to the information for the right persons with authorizations based on their levels in the Organizational hierarchy.
• Generated drill down reports by passing parameters from top level to sub levels.
• Uploaded reports on to the report manager and organized them in folders.
• Delivered the reports using ‘pulled’ and ‘pushed’ methodologies.
• Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning, and Optimizing Indexes using Performance Monitor, Profiler, and Database Engine Tuning Advisor.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Designed the reports layout for creating tabular and matrix reports.
• Used prompts to generate Parameterized and Cascading Parameterized Reports allowing the user to limit the reports to particular cases.
• Established data exchange and integration for XML documentation using XML schema.
• Deployed the generated reports on to the server by configuring Report Service Configuration Manager and established credentials to access or deploy a report.
• Analyzed OLAP cubes in order to generate performance reports, drill down reports.

Environment: MS SQL Server 2008 (Query Analyzer, SSIS, SQL Profiler), MS SQL Reporting Services 2008, ASP.Net, MS Excel, Window XP.

Confidential, Houston, TX

MS SQL Server, SSIS, SSRS and SSAS Developer

Responsibilities:

• Involved in requirement gathering, analysis, design, development and deployment.
• Responsible for writing T-SQL (DDL/DML) Queries, Stored Procedures, Views, Functions and T riggers, complex PL/SQL packages.
• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Used Date functions, String functions and Database functions to manipulate and format source data.
• Developed packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Used Batch Files to Import Data from other Data Base.
• Carry out creation of SDLC documentation for existing applications.
• Created packages in SSIS with error handling and worked with different methods of logging.
• Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Responsible for Import and export of data between the environments and Data Cleansing.
• Responsible for migration of databases from old SQL server versions to SQL Server 2008.
• Developed Slowly Changing Dimensions (SCD) Packages using SSIS (ETL) to perform the Incremental / Historical load logic data from Source to Staging Environment and into the Enterprise Data Ware House.
• Performed Data profiling tasks in SSIS Packages using the Data Profiler and standardizing the data appropriately for the database.
• Experience in managing Alerts, Creating Jobs, and Operators through SQL Server Agent.
• Involved in generating Matrix reports, Sub reports and Complex reports with multi value parameters for the analysis of Performance using SSRS.
• Developed complex Stored Procedures to generate various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into the front end.
• Developed various drill down, parameterized reports using Crystal Reports and SSRS 2008.
• Created calculated measures for business calculations using complex MDX scripts.
• Implemented hierarchies on Cubes, wrote MDX for creating calculated measures.
• Responsible for creating OLAP cubes for deep through analysis using SSAS 2008.

Environment: SQL Server 2005/2008, T-SQL Windows Enterprise Server 2003/2008, SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio(BIDS), SQL Server Profiler, XML, SSIS, SSAS, SSRS, ProClarity, Crystal Reports 10, Windows 2000/NT.

Confidential

MS SQL Developer

Responsibilities:

• Involved in writing T-SQL programming for implement Stored Procedures and Functions for different tasks.
• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules.
• Optimized the performance of queries by modifying the existing index system and rebuilding indexes.
• Created SSIS packages to transfer data from Oracle to SQL server using different SSIS components and used configuration files and variables for production deployment.
• Developed SSIS Packages to Consolidate date from various data Sources and also Data loads from various types of sources files (EXCEL, Access, Flat files, CSVs) and converted XL to SQL reporting.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups. Created several Staging Databases. Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Wrote complex queries, triggers and stored procedures, views and user defined functions.
• Design and implement database logical and Physical Schemas.
• Responsible for database tuning using normalization and application tuning.
• Maintenance of Development, System test, Assemble test and Integration Servers and databases.
• Query tuning, Index Tuning and performance tuning.
• Creation and maintenance of databases, objects.
• Users and user group creation and maintenance.
• Extensively used Enterprise Manager, Query Analyzer, and SQL Server Profiler.
• Created custom and standard reports using Crystal Reports.
• Developed parameterized crystal reports existing reports for presentations using cross-tab reports, running totals, and alerting.
• Created and modified stored procedures to Create Reports.

Environment: SQL Server 2000/2005 Enterprise Edition, MS PowerPoint, MS Access 2000 & Windows 2K platform