PROFESSIONAL SUMMARY:

• Around 6 years of IT experience with over 6+ years of experience in SQL Server and involved in all phases of Software Development life cycle from gathering requirement, development, implementation, testing and support.
• Over 6+ years of experience in SQL Server development and administration with DBA duties.
• Experience in SSIS, SSAS and SSRS of MS SQL Server tools.
• Proficient in Data Migration from sources like MS Access, SQL server, Text Files, Excel to SQL server 2005/2008/2012 using SQL Server Integration Services (SSIS).
• Well - versed with database Installation, configuration, maintenance, monitoring, backups and recoveries, develop and debug Stored Procedures and Triggers.
• Experience in creating SQL Logins, Roles and Authentication modes as a part of security policies for various categories of users.
• Experience in using BCP and Bulk Insert commands while working with Flat files
• Extensive knowledge of Relational Database Management Systems including MS SQL Server 7.0/ 2005/2008/2012 R2, Oracle 8i/ 9i/ 10g, DB2and Teradata.
• Extensive experience with monitoring, tuning, analyzing DB performance and allocating server resources to achieve optimum DB performance by performing various query-optimization techniques.
• Good experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008/2012.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
• Expertise in identification of Business & Data requirements and converting them into conceptual & logical data models.
• Experience in Dimensional Data Modeling Star and Snow Flake Schemas.
• Expertise in Database driven web based application developer: using SQL Server 2000, MS Access, Visual SourceSafe, MS SharePoint, and MS FrontPage.
• Experience in maintaining database, including updating statistics, re-indexing, structure modifications, and index analysis and also Log Shipping, Mirroring & Replication to restore Database backup.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication to develop creative solutions for challenging client needs.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the team involved with the System Development Life cycle and helped other developers in the team to their development tasks.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.1, Informatica Designer, Workflow Manager, AutoSys, Star Schema, Snowflake Schema, OLTP, OLAP

Data Modeling Tools: Erwin 7.2/4.5/4.0, MS Visio 2003/2007, Rational Rose

Languages: PL/SQL, SQL, Java, UNIX Shell Scripting, T-SQL, C++, HTML, JSP, Java Script, Asp.Net, VB.Net

Database: SQL Server 2008R 2/2008/2005/2000/7.0, Oracle, MS Access

Reporting Tools: Crystal Reports, SQL Reporting Services and Actuate E-Reporting

Operating Systems: Windows 2000/2003/XP/NT/Vista, UNIX, LINUX

SQL Server Tools: MS SQL Server 2014/2008R 2/20 /7.0, MSSQL Server Reporting Services 2014/2008R 2/2008/2005/2000 (SSRS), MSSQL Server Analysis Services 2014/2008R2/20082005(SSAS), MSSQL Server Integration Services 2014/2008R2/2008/2005 (SSIS), Data Transformation Services(DTS), Oracle 9i/10g, ODBC, OLTP, OLAP, SQL Server Management studio (SSMS), MS SQL Server 2000 Enterprise Manager, SQL Query Analyzer, Web Services, SQL Profiler, Bulk Copy Program (BCP).

PROFESSIONAL EXPERIENCE:

Confidential, MI

Sr. SQL Server Developer SSIS/SSRS/SSAS

Responsibilities:

• Created tabular and matrix reports in SSRS. Wrote stored procedures and functions to create SSRS reports.
• Involved in the creation and deployment of the reports using SSRS and configuring the SQL Server Reporting Server.
• Created views as required by front-end developer for easier implementation on ASP.net pages, and wrote instead-of triggers on those views to provide efficient data manipulation.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Designed dynamic SSIS to transfer data crossing different platforms, validate data during transferring, and archived data files for different RDBMS.
• Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Designed and implemented Data Integration and ETL processes with SSIS packages to make data available for reporting purpose within a data warehouse.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Designed and developed SQL Server Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.
• Involved in designing cubes in SSAS environment using Snowflake and Star Schemas.

Environment: MSSQL Server 2008/2012 Enterprise Edition, T-SQL, ODBC, ER/Studio, SSAS, SSIS Packages, SSRS, SQL profiler, ASP.net, VB Script, Java Script.

Confidential, VA

SQL Server Developer

Responsibilities:

• Create new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2008.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Responsible for creating the reports basing on the requirements using SSRS 2008.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Involved in extracting the data using SSIS from OLTP to OLAP
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
• Involved in Deployment and Administration on SSIS packages with Business Intelligence development studio.
• Developed, monitored and deployed SSIS packages.
• Performance tuning of Stored Procedures and T-SQL Queries.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Involved in Designing, Analyzing, building and testing of OLAP cubes in SSAS and adding calculations using MDX.
• Performed data conversion from flat file into a normalized database structure.
• Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables.
• Responsible for creating the Change requests and prepare all the documentation required to move the code changes to production.

Environment: SQL Server 2014, SSAS, SSIS, T-SQL and SSRS

Confidential, OH

SQL/SSIS/SSRS Developer

Responsibilities:

• Gathered user requirements. Responsible for Analysis and implementation for DB changes requested by users. Developing reports using efficient data retrieval techniques.
• Updated functional specification and technical design documents. Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Developed Analysis Services Project. Responsible for identifying and defining Data Source and Data Source views. Created cubes and defined the dimensions.
• Create and maintain project artifacts including; data requirements, technical specifications, test plans, etc using Business intelligence tools.
• Defined attribute properties in a Parent Child Dimensions. Responsible for hiding and disabling attributes hierarchies. Sorting attributes members based on a secondary attribute.
• Defining relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes and MDX queries
• Specifying the named sets for calculations using named queries. Responsible for creating reports based on the requirements using SSRS 2008.
• Identified the database tables for defining the queries for the reports. Defined report layouts for formatting the report design as per the need. Identified and defined the Datasets for report generation.
• Wrote queries for drill down reports to get the dataset required to build the report. Identified and included report parameters for parameterized report. Formatted the reports using Global variables and expressions. Deployed generated reports onto the Report Server to access it through browser.
• Involved in doing Unit Testing for the Packages created.
• Involved in Production Support when the project is in release.

Environment: MS SQL Server 2008, SQL Server Analysis Services, SQL Server Reporting Services 2008, Windows XP.

Confidential

SQL/SSRS/SSIS Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Used SSIS to create .dtsx packages to validate, extract, transform and load data from different source’s and mapped them onto destination.
• Extracted data from different sources like Oracle, SQL Server, Flat Files, Teradata, Composite View and transformed, loaded onto required database through SSIS 2005.
• Involved in writing MDX Scripts for the OLAP CUBES.
• Creating Static Reports using MDX queries and creating MDX Base Report Definition.
• Expertise knowledge on variables to make package dynamic and scheduled the package using SQL Server Agent as per the business requirement.
• Well versed with creating stand-alone packages for data extraction using SQL Server Integration Services and also have experience on creating dynamic packages through Script task components.(VB.NET)
• Experienced in creating XML file for package configurations.
• Good knowledge on optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Expertise knowledge in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, views and other SQL joins and statements for applications using SQL Server 2005.
• Managed large number of Meta Data Tables which are used in the process of ETL in SQL Server 2005.
• Good experience in working with higher environments like SIT, UAT and Production environments. Also experienced in creating DDL scripts like CREATE TABLE, ALTER TABLE, and DROP TABLE for Databases, SQL Jobs, and Linked Server when moved from lower environments to higher environments.
• Worked for ICD 10 Project to differentiate between ICD 9 and ICD 10, as per the requirements provided by Business.
• Worked on Data Integration and Data Migration Projects.
• Involved in doing Unit Testing for the development which I have done.
• Had War Rooms with business users before deploying the data to UAT.
• Experience in the usage of AutoSys scheduler in order to run Packages and Informatica sessions.
• Used Function-based Indexes in PL/SQL Packages in order to increase the performance of Package.
• Supported QA people while testing the Data provided by our team.

Environment: PL/SQL Developer, Windows XP/7, UNIX, Erwin,Informatica, SQL Server 2005/2008, SSIS, SSRS, Crystal Reports, ETL, Win 2000 Professional, Win Server 2003.