PROFESSIONAL SUMMARY:

• Over 8 years of strong experience in the IT industry as a SQL Server Developer/BI Developer in several domains.
• Experienced with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Expert in ETL - Extraction Transformation Loading, Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical processing technologies.
• Expert knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Extensive experience in MS SQL Server 2012/2008-R2/2008/2005, and expert in developing Business Intelligence in MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Analysis Services (SSAS) using Business Intelligence Development Studio (BIDS).
• Extensive experiences in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery
• Excellent experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server by using SSIS and DTS (Data Transformation Services) utility.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS, MS SQL Server Integration Services (SSIS) and scheduling the packages using SQL Jobs.
• Expert in the migration of reports from SQL Server reporting services, 2008R2 to 2012 Crystal Reports to SSRS, SSRS to Crystal format and deploying using Excel, MS Share Point. Services (MOSS) and Microsoft Reporting Server.
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS 2012/2008-R 2/2008/2005.
• Experienced in Logical and Physical Database design & development, Normalization and Data modeling methodologies of Ralph Kimball, Inmon.
• Experienced in writing the MDX queries to develop the Key Performance Indicator (KPI) Objects, Calculated Members, and Actions and to get the data from the OLAP cube for the reporting purpose.
• Proficient in Designing and Building the OLAP cubes with different types of Dimensions, Aggregations, Partitions, KPIs and Calculated members using SQL Server Analysis Services (SSAS) 2012/2008/2005
• Expert in developing complex Stored Procedures, Views, Functions, Triggers, Indexes and complex queries on SQL Server 2012/20 and Oracle 10g/9i/8i.
• Extensive Experience in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and Database Engine Tuning Advisor.
• Expertise in Crystal Repository with different templates, Crystal Migration Wizard, Crystal Publishing Wizard for publishing reports on the Info View, Internet using Crystal Reports XI/10/9/8.5 and developing the Dashboards using the Crystal Xcelsius.
• Experience in designing and developing web based and windows based applications using ASP.Net, C#. Net, ADO.Net, Web Services, ASP, IIS, HTML, DHTML, XML and XSL.
• Good in-depth understanding and experience in building server applications using C#, ASP.Net, ADO.Net, XML, Web Services, HTTP modules and handlers based on .Net Framework 3.5 / 3.0 / 2.0.
• Experience with different tools of Business Objects XI including the Import Wizard, Universe Designer/Builder, Business Views, and Web Intelligence Rich Client.
• Proficient in developing the KPIs, Scorecards, Dashboards using the Performance Point Server and deployed them using the MS SharePoint Services (MOSS).
• Experienced in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Excellent inter personal skills and communication skills and ready to take challenges with proven ability

TECHNICAL SKILLS:

Relational Databases: MS SQL Server 2000/2005/2008/2008 R2/2012, Oracle 8i/9i/10g, SQL Server Management Studio (SSMS), MS Access.

Tools: and Packages: SQL Server Management studio, Enterprise Manager, Profiler, SSIS, SSRS, Microsoft Visual Source Safe, Crystal Reports9.0, Visual Studio .Net.

Languages: T-SQL, PL/SQL, C, C#, ASP.Net

Operating Systems: Windows vista/XP/2003/2000/NT 4.0/9x, MS-DOS

Web Technologies: HTML, XML, XSL,, IIS(4.0/5.0/6/0)

Operating Systems: Windows 2008, Windows 2000/2003 Server, data center, Windows NT, Windows 95/98/2000 XP, UNIX, LINUX.

Data Modeling Tools: ERWIN, ETL, Visio, Microsoft Office Suite.

BI Tools: SQL Server Integration Services(SSIS), SQL Server Reporting Tools (SSRS), Crystal Reports

Configuration Management Tools: Visual Source Safe, Team Foundation Server

PROFESSIONAL EXPERIENCE:

Confidential, NYC

Senior BI Developer / DBA

Hardware/Software: MS SQL Server 2012/2008, SQL Server Reporting Service (SSRS) 2012/2008, SSAS, SQL Server Integration Service (SSIS) 2012/2008, T-SQL, PL/SQL, Excel.

Responsibilities:

• Worked on the analysis of the Design Specification documents for the Packages and coordinated with team members at the time of changes in Business requirements and changes in Data Mart Schema.
• Designed, reviewed, and created primary objects based on logical design models, user requirements and physical constraints.
• Upgraded the data from one server to another server (SQL Server 2008 to SQL Server 2012) for the SSIS Packages and SSRS reports.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems with different transformation and scheduled Jobs to run the packages on a daily basis.
• Implemented the changes in the existing ETL process to move data back and forth from ODS to all the integrated systems.
• Developed SSIS Packages to extract data from Excel spreadsheets, Microsoft Access database and flat files, load them onto SQL server 2012 for Data Analysis and Reporting by using multiple data flow transformations such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Created Clustered and Non-clustered Indexes for Query Optimization and also involved in Database Tuning.
• Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
• Created/modified complex stored procedures to fit to the changing requirements and to enhance performance and developed custom functions, indexes to ensure accuracy, quality and consistency of the database.
• Created triggers that capture the customer updates and made the required transformations to move the customer ps to ODS.
• Created Tables, Stored Procedures, Views, Constraints and User Defined Functions.
• Involved in the design, development and deployment of customer purge, mass consolidation process in ODS.
• Developed OLAP cubes using SSAS and calculate the metrics that were revealed in the functional analysis.
• Created MDX script for representing Cube Calculation using SSAS.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Performed daily tasks including backup and restore from disaster recovery in SQL Server 2008/2008R2 using SQL Server Management Studio.
• Configured Replication methods like snapshot replication, transactional replication and Merge replication for two environments.
• Used Replication to synchronizing between databases to maintain consistency on server level.
• Worked on the performance optimization of the ODS import jobs.
• Worked on the analysis of test cases with the team members and make the necessary changes.
• Designed, developed the customer comparison reports in MS SQL Server environment using SSRS 2008.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Providing the client with documentation, with component and task level details.
• Performed the Unit testing for packages developed to ensure that it meets the requirements.
• Used SQL Server profiler for auditing and analyzing the events that occurred during a particular time horizon and stored in script.
• Used the SQL Profiler, query execution plans to trace the performance of TSQL Statements, procedures and functions.

Confidential, Little Rock, AR

SQL Developer

Hardware/Software: MS SQL Server 2008, SSRS 2008, SSIS 2008, SSAS 2008, SSMS, MDX, VSS, VB.NET, C#.NET, ASP.NET, T-SQL, DB2, Documentum, Access and Excel.

Responsibilities:

• Gathered all the requirements from the end users for design and development of the WAS Application.
• Developed the star schema and the snowflake schemas depending on the requirements while designing the database.
• Involved in the enhancement of existing database schema by adding new tables, views, indexes and defining the relations.
• Develop and implement database design documentation, including database diagrams, data mapping documents, data dictionaries etc.
• Imported data from many heterogeneous elements like SQL Server, flat files, Excel, DB2 etc into SQL Server using SSIS 2008/2005.
• Used different tasks like scripts task, lookup, fuzzy grouping, conditional splits etc to load the accurate data into the central data warehouse and also Implemented Event Handlers and Error Handling in SSIS packages to notify the process results to various user communities.
• Developed many ASPX pages during the development of the FDDM application and implemented the logic for all the pages with code-behind technique using C#.NET.
• Involved in the development/testing of the web-based application OLP using the ASP and C#.NET by maintaining the different layers for different operations of the application.
• Developed different types of reports for the WAS application like drill-down, matrix, charts etc with different types of parameters using SSRS 2008.
• Integrated the reports with the documentum by providing the facility to pass the parameters through URL of the corresponding reports.
• Involved in the maintenance of the existing cubes of the data warehouse by adding additional dimensions, user-defined hierarchies, and calculated members using SSAS 2008 and also wrote many MDX scripts while developing the reports from the cubes using SSRS 2008.
• Scheduled many jobs job to run on a daily basis to import and export data at nightly basis.
• Created reports by retrieving the data from cube using MDX reports.
• Created new indexes for better performance of the database, and maintained data integrity by using foreign key relationship.
• Developed many stored procedures that act as data source for the all the web-based and reporting applications here in this project.

Confidential, Sunnyvale, CA

SQL Developer

Hardware/Software: MS SQL Server 2008, SSRS 2008, SSIS 2008, SSAS 2008, SSMS, MDX, TFS, VB.NET, C#.NET, T-SQL, PL/SQL, Oracle 10g, MS Share Point, Crystal Reports 2008/XI, Performance Point Server, Crystal Xcelsius, Access and Excel.

Responsibilities:

• Gathered requirements from the business users, created technical specification documents.
• Defined relationship between tables and enforced the referential integrity constraints.
• Gathered the data from different sources using SQL Server Integration Services (SSIS) 2008 using different transformation, constraints, checkpoints and configuration settings.
• Created OLAP cubes on top of the data warehouse with user-defined hierarchies based on different fact and dimension tables for analysis purposes using SQL Server Analysis Services (SSAS) 2008.
• Used C#. Net and VB.NET to develop different modules of the end-user interfaces and different SSIS packages.
• Used ADO.NET technology such as Data Adapter, Data Reader, Dataset and Data View, for consistent access to the data store to connect Business Layer to SQL Server 2000 database in Data Layer.
• Involved in setting up and implementation of the 2008 reporting server and Created/modified a variety of parameterized, drill down, click through, chart, matrix, sub reports using data from a variety of sources and from the OLAP cubes.
• Migrated the SSRS reports to Crystal format using the Crystal Reports 2008 and developed the dashboards for the end users using Crystal Xcelsius.
• Wrote many complex MDX queries with different functions to develop Calculated Members, KPIs and Actions and to gather the data from the OLAP cubes while generating the reports, which provides the information on the power, generated using the solar modules.
• Integrated the reporting services with MS Share Point while deploying the reports and implemented the report subscriptions to run on daily/weekly/monthly basis and email the results to the business users in the required format.
• Involved in the development of different KPIs, Scorecards, and Dashboards using the Performance Point Server and deployed them using the MS SharePoint Services (MOSS).
• Worked with SQL Profiler, Tuning Wizard, Execution Plan and Performance Monitor in order to analyze and optimize the queries, procedures.
• Added/modified Users, Groups, folders, rights and involved in the implementation of log shipping, mirroring to maintain the high availability of the servers.
• Created/modified SQL Joins, sub-queries, indexes, stored procedures, triggers and other T-SQL, PL/SQL code to implement business rules and automate the tasks.
• Involved in documenting the project steps and presenting to the team members.

Confidential

Customer-centric database SQL Developer

Hardware/Software: MS SQL Server 2005/2008, SSRS 2005/2008, SSIS 2005/2008, SSAS 2005/2008, SSMS, ASP.NET, VB.NET, C#.NET, MDX, T-SQL, PL/SQL, Oracle 10g, MS Share Point, Access and Excel.

Responsibilities:

• Involved in Planning, Defining and Designing database depending on business requirements and provided the documentation.
• Created complex Stored Procedures, User Defined functions, Triggers, Indexes, Tables, Views, SQL joins and also defined roles and privileges to implement business rules and control access to database.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse with different transformations in order to get the accurate data using SSIS 2008/2005 and deployed the SSIS packages to different environments by maintaining the configuration settings in the XML files and variables.
• Extensively involved in the design of SSAS storage, partitions and aggregations and developed different calculated members, KPIs, actions by using the MDX while designing the cube using SSAS 2008/2005.
• Wrote different MDX queries using different functions to gather the data from the cube and developed the reports using the SSRS 2008/2005.
• Modified the cube structure by adding the new facts, dimensions with user defined hierarchies, calculated members, attribute relations in order to optimize the cube and develop the user defined reports from the cube.
• Developed many scripts while designing the SSIS package using C#, VB.NET in order to perform various transformations while getting the data from different sources and also resolved the issues with ActiveX scripts and query driven tasks while migrating the DTS packages to SSIS.
• Provided statistical information through different reports in order to explain business conditions and scheduled the reports to run on daily/weekly/monthly basis and email the results to the business users in the required format.
• Created parameterized reports and ad hoc reports using Report builder and developed dashboards with different KPIs, scorecards for the users/management and deployed them using Excel, MS Share Point (MOSS).
• Used ASP.Net controls like Dropdown list, Button, Textbox controls while developing the user interface and developed complex web forms and business components.
• Extensively worked with the SQL Profiler, Database Tuning Wizard and query execution plans to identify the slow running queries and to test different application for performance.

Confidential

SQL Developer

Hardware/Software: MS SQL Server 2000, T-SQL, DTS, Teradata, Excel, Crystal reports 9.

Responsibilities:

• Involved in gathering requirements from business users.
• Involved in transformation of data from various sources and legacy systems like Teradata, SQL Server 2000 and Excel into SQL Server 2000 using DTS.
• Created triggers that capture the claims and wrote complex formulas that calculate the amounts related to those particular claims.
• Created number of complex formulas to calculate the amounts related to different claims in sub reports using different types of variables like shared variable and retrieved them from master report
• Created complex stored procedures to fetch and manipulate data in the databases.
• Created Tables, Stored Procedures, Views, Constraints and User Defined Functions.
• Wrote and Optimized Triggers, Stored Procedures and Queries in T-SQL.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Created various kinds of reports like drill down, drill through and on demand sub reports in Crystal reports 9.
• Customized reports by adding new features such as report alerts, cross-tabs, running total, sub-reports and drill-down fields.
• Modified report content and exported reports in multiple formats based on user input.
• Designed/modified database schema objects to support existing and new business related application development for a global-application. Write/test SQL scripts to perform application specific data manipulation