SUMMARY

• Over 7 years of IT experience in the Analysis, Design, Development, Administering Client/server application using Microsoft SQL Server and BI suite (Development, UAT and Production Environment.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
• In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
• Experience in creating dashboards, scorecards and building reports using performance point server 2007.
• Experience with working on ProClarity Analytics server to analyze results produced in the Dashboard.
• SQL Server 2000/2005/2008 RDBMS database development including T-SQL programming.
• SQL Server 2005 OLAP database development including KPIs, Data mining, working with changing dimensions.
• Experience of designing strategies to maintain audit tables, load balance, exception handling and high data volumes.
• ETL implementation using SQL Server Integration Services (SSIS).
• Developing reports on SSAS & SSRS on SQL Server (2000/2005). Sound Experience and understanding of SSAS, OLAP cube and Architecture
• Expert in creating the MDX cubes and dimensions.(SSAS)
• Experience in logical, physical, and dimensional data modeling, data mapping, and data normalization, well verse in ERWIN
• Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Involved in DBA activities such as backups, restores, replication etc.
• Exposure to CMMI, ISO and QA processes, change control management, source safe, version controlling etc.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2000/ 2005/2008/2012 , MySQL, Oracle 9i/10g

Operating System: Windows 2000/2003, Linux, HP UNIX

.NET Technologies: ASP.net, C#, VB.net

Database Tools: SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Import/Export, SSRS, SSIS, SSAS, Backup Server, Replication server, OLAP Services, SQL, Agents, SQL Alerts, SQL Jobs, Replication tools

Programming Languages: C, C++, Java

Web Technologies: HTML, DHTML, CSS, Java Script, AJAX, VB Script, XML, SOAP, IIS

Database Access Technology: ADO.NET, DTS

Design and Development: Visual Studio 2008/2005/2003 , Visual Studio 6.0

Reports: SSRS, Crystal Reports, Cognos Reporting tool

PROFESSIONAL EXPERIENCE

Confidential, Deerfield, IL

SQL Server Developer/MSBI

Responsibilities:

• Actively participated in gathering of User Requirement and System Specification.
• Created database logical and physical design to fit new business requirement and implemented new design into SQL Server 2005.
• Made changes to the existing data flows and redesigned the system.
• Creating Database objects - tables, views, and functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Creating LINQ enabled database layer using API such as LINQ to SQL and Entity Framework.
• Involved in taking backups and restoring of crucial databases involved in the business.
• Create, Edit, Maintain ETL processes utilizing Microsoft SQL Server Integration Services (SSIS) from a diversity of data sources including other servers, flat files, MS Access and Excel
• Source control tools such as Microsoft TFS, Tortoise SVN.
• Implementing Road Map, Defining and building best Practices for .NET Application Development.
• Writing queries which involve various joins in order to perform a thorough analysis on the missing sales on a daily and cumulative basis.
• Worked with SQL Server Analysis Services (SSAS).
• Implemented DTS Migration and Metadata Management( Migrating DTS packages to SSIS, Package Migration Wizard) and Storage Management using MSDB And FlatFile
• Multidimensional Expressions (MDX) is to make accessing data from multiple dimensions.
• Pulling data on a daily basis from OLTP database to OLAP or staging database using the SSIS packages.
• Used link servers in cases where data is to be pulled form a different database like oracle.
• Worked in OLAP environment where star schema is implemented, creating and identifying fact and dimension tables and establishing proper relations between them.
• Created special dimension tables like time dimensional tables.
• Created cubes and dimensions and measures and calculated measures according to the business requirements.
• Worked in creating hierarchies for dimensional tables like date dimensions and region dimension tables.
• Browsing the cube for analysis and validation of the data.
• Processing the cubes and dimensions on a daily basis using the SSIS tasks.
• Publishing scorecards which gets its data populated from the cubes, purpose being the verification of sales by the client business executives and also for further analysis.
• Fixing bugs in scorecards which pertain to the pivot tables and formulas.
• Used visual source safe to store all the versions of scorecards and design flows.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Performing the tasks of data conversions, adding derived columns, sending results in mails is done by making use of various tasks in SSIS.
• Filtered bad data by using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Used Report Generator (Report Writer) which is a program to extract information from one or more files and is presented in a specific format .
• Data generated through is presented in the form of pie charts, bar charts.
• Wrote stored procedures and functions to be called from front-end developers.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created and managed users, roles and groups to handle database security.
• Tuned database by creating proper indexes.
• Created data dictionary for all columns and documented all the processes involved in maintaining the database for future .

Environment: SQL Server 2005/2008/2012 Enterprise Edition, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, Crystal Reports, SharePoint 2007, T-SQL, ODBC, Excel, Access, Windows 2000/XP

Confidential, Tampa, FL

SSIS/SSRS/SSAS Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in and support and also have experience in incremental data loading.
• Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Have good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005/2008.
• Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes and unattended Installations.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Building UAT and Test environments using Production back ups.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Wrote store procedures to generate account statements for different types of accounts
• Involved in migration of SSRS from SQL 2000 to SQL 2005
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005/2008 Enterprise Edition, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, Crystal Reports, SharePoint 2007, T-SQL, ODBC, Excel, Access, Windows 2000/XP

Confidential, Jacksonville, FL

SQL Server Developer/MSBI

Responsibilities:

• Loading data from various sources like, flat files, to SQL Server database Using SSIS Package
• Involved in Creation of Dimensions using STAR Schema
• Used Lookups Transformation to get the data from data sets
• Scheduling the SSIS packages and Jobs
• Created SSIS Packages to migrate slowly changing dimensions.
• Wrote DTS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
• Created tables for data ware housing applications and populated the tables from the OLTP database using DTS packages
• Transferring data between XML document and SQL server.
• Performed activities such as database creation, database tuning, performance planning, backup planning and database administration
• Actively involved in Normalization & De-normalization of database
• Materialized views, dimensions and stored outlines for optimal performance
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.

Environment: SQL Server 2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, Crystal Reports, Erwin, XML, VB.NET, MS PowerPoint, MS Project, MS Access 2000 & Windows Server 2000, Oracle.

Confidential

SQL Server Developer/MSBI

Responsibilities:

• Created new tables, written stored procedures for application developers and some
• User- defined functions. Created SQL scripts for tuning and scheduling.
• Performed data conversions from flat files to a normalized database structure.
• Created and managed users, roles and groups and database security.
• Created Triggers to enforce data and referential integrity.
• Defined Check and default constraints, Indexes, and Indexed Views.
• Configured Server for sending automatic mails to the respective people when a DTS
• Process fails or succeeds.
• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS) and bulk copy. Periodic monitoring of the system for bottlenecks.
• Created and maintained Indexes for various fast and efficient reporting processes.
• Analyzed database growth, space requirement and User/Login Roles.
• Managed test data and their updates between development and production databases and migrated stored procedures and database objects.
• Added replication definition and its function on Reporting Server and monitored replication.
• Configured Snapshot replication for reporting, user acceptance test and development servers. Created code documentation using Visual source safe.
• Experience in Configuring and Managing Linked Servers, data transfer between SQL Server and other heterogeneous relational database such as Oracle and DB2.

Environment: SQL Server 2000/2005, .NET Framework, ASP.NET, ADO.NET, WINDOWS 2000/2003

Confidential

SQL Developer

Responsibilities:

• Requirement gathering - Solution design
• Involved in the migration from SQL server 7.0 to 2000.
• Actively involved in Normalization of database.
• Designed DDL and DML for MS SQL Server 2000
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Optimize query performance by creating indexes.
• Involved in writing SQL batch scripts.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL
• Queries and Stored Procedures.
• Involved in merging existing databases and designed new data models to meet the requirements.
• Perform daily database backup & restoration and monitor the performance of Database Server.
• Create joins and sub-queries for complex queries involving multiple tables.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Install and Configured SQL Server 2000 on development server for designing and testing.

Environment: MS SQL Server 7.0/2000, T-SQL, DTS, SQL Server Enterprise Manager, SQL Profiler.