PROFESSIONAL SUMMARY

• Over 7 years of experience in Database Development with thorough knowledge of various RDBMS concepts and applications using SQL Server 7.0/2000/2005/2008.
• Thorough Software Development life cycle (SDLC) experience including development, designing, analysis, coding, testing and implementation.
• Extensive Experience and in-depth working knowledge in various SQL Server tools and IDE to work with databases, Reporting and Business Intelligence based applications like SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Visual Studio .NET 2005/2008, SQL Server Enterprise Manager, Query Analyzer.
• Extensive experience in all phases of Project Life Cycle Requirements, Analysis, Architecture, Design, Building, Unit & Integration Testing, Migration and Training, Deployment, Production Support and Help Desk support.
• Experience in developing applications applying Agile Software Development Methodologies.
• Good Experience in Data migration using SSIS and DTS services across different databases (SQL Server, Oracle, and MS access), flat files, Excel Files, CSV, and XMLetc.
• Experience with various databases including SQL Server, Oracle, and MySQL, MS Access etc.
• Experience in writing complex SQL queries, Stored Procedures, Views, Functions, Triggers, Cursors and Tables using SQL Server 2000/2005/2008.
• Conversion of DTS packages to SSIS and Interfacing Legacy components within SSIS for complex transformations and logic.
• Migrated Organization, Orders, Adjustments, Objectives and Callidus data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Exploring Report Models using the Report Builders and Ad-hoc Reporting.
• Worked with improving the performance on SQL, TSQL and SSRS procedures and provided the recommendation on server related tuning issues.
• Worked with using SSRS and SSIS package extensively produces massive OLAP reports.
• Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS in Visual Studio.
• Generated and published reports using third party enterprise tools Crystal Reports.
• Expert in creating, deploying, processing and maintaining Cubes using SQL Server Analysis Services (SSAS).
• Worked with building the dimensional modeling for data mart/data warehouse using the CA Erwin tool. And good hands on working with complex large data warehouse system.
• Strong Knowledge in development and implementation of internet/intranet applications using ASP.NET, C# and SQL.
• Exceptional ability to adapt to latest technologies, perseverant, innovative and organized aspects.
• Outstanding problem solving, strategic thinking and data analysis skills, strong focus on teamwork and achieving team goals, result oriented and excellent communication skills.

CERTIFICATIONS

• Microsoft Certified in .Net Framework - Application Development Foundation (ID: 6770153)

Technical Skills

Database: MS SQL Server 2008/2005/2000/7.0, Oracle 10g/9i/8i/7.x, MS Access  2007/2003/2000/97.
Database Tools: SQL Profiler, SQL Query Analyzer, DTS, Import/Export, Enterprise  Manager, Query Analyzer, SQL Profiler, SQL Backtrack.
DevelopmentTools: Microsoft VisualStudio.Net 2005/2003, FrontPage 2003, NUnit, Dream. Weaver, Flash, Adobe Photoshop.
Utility Tools: TOAD, SQL Navigator, SQL Developer.
Data modeling Tools: Erwin 4.0, Visio 5.0.
OLAP/Reporting Tools: SSRS, Micro strategy, Cognos, Hyperion (BRIO).
Languages: T-SQL, Pl/SQL, AJAX, C#, ASP.NET
Internet Technology: HTML, JavaScript, XML, UML, ASP.

Professional Experience

Client: Confidential, Parsippany, NJ Feb 09 - Present
MS SQL Server Developer

Confidential is one of the preeminent and most integrated providers of real estate and relocation services in the world, with leading real estate brands, brokerages etc...

Responsibilities

• Involved in requirements gathering, analysis, design, development, change management, deployment and user training.
• Involved in Physical / Logical design of database, creating and managing the database and all the database objects.
• Involved in writing stored procedures, triggers in TSQL.
• Converted various SQL Statements into stored procedures thereby reducing the number of database accesses.
• Developed and designed DTS package/application for importing the data from Access and Excel.
• Created and integrated user defined functions and stored procedures for reporting purposes.
• Created batch scripts to deploy large number of report and stored procedures and user defined functions to various databases and to the report manager at the same time.
• Used SQL Server profiler to tune the performance of the stored procedures and functions to improve the report generation time.
• Designed and deployed various complex reports.
• Created and generated reports to display data.

Environment: SQL Server 2000, MS Excel 2003, MS Access 2003, SQL Query Analyzer, SQL Profiler, Data Transformation Services, T-SQL, Visual Source Safe 6.0, SQL Server Reporting Services, Windows 2003.

Client: Confidential, NJ July 08 – Jan 09 
SQL Server Developer

Responsibilities

• Done initial Analysis and Planning for database structure under guidance of Data Architect while creating new database based on old system
• Developed ER diagrams (Physical and Logical using ERWIN) and mapping the data into database objects.
• Actively involved in Normalization (3NF) & Demoralization of database.
• Involved in Database creation; database tuning, performance planning, backup planning and database administration.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Capacity planning in estimating and sizing of tables.
• Materialized views, dimensions and stored outlines for optimal performance.
• Wrote Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis
• Designed and implemented Dimensions and Measures according to business requirement.
• Migrated data from text files and Excel spreadsheets to SQL Server databases using Integration Services (SSIS).
• Involved ETL process of the company to provide better business model and structure of database system in SSIS.
• Created and scheduled SSIS packages which monitors the jobs and sends the notification when the job fails.
• Schedule and Deploy schema changes, data conversion, data fixes and data movement through packages using SSIS
• Created a number of cubes, dimensions and business critical KPIs using SQL Server Analysis Services representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance(Used MDX Queries)
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).
• Supporting to the team with expert needs of creating and maintained company wide reporting structure in SSRS
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and other evens using Performance Monitor and SQL Profiler.
• Configured Transaction Replication (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors).
• Login and User Management: Adding logins, roles, groups to the Window NT and MS SQL Server.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Created SSIS packages to automate database back up, update statistics, re-build the index as well as create error log for every event during data load.
• Published high-level technical documentation to set standards, guidelines and best practices for SQL Server Database Administration, Backup & Restore, Procedures, Database Security, SQL Database Development and Access database upgrades across the enterprise.

Environment: SQL Server Management Studio 2008, T-SQL, Windows 2003, SQL Server 2005, SSIS, SSRS, SSAS

Client: Confidential, St. Cloud, MN Sept 07- July 08 
Crystal Reports/ / MS SQL Server Developer

Confidential has a unique approach to banking is backed by ING, a global financial institution of Dutch origin offering banking, insurance and asset management to over 60 million private, corporate and institutional clients in more than 50 countries. 
The project dealt with the automation of entire transactions in the bank and making the data more secure by using various encryption algorithms and report generation for various departments.

Responsibilities:

• Served as a Crystal Enterprise Reports Developer/Administrator and SQL Server Developer in support of Service Management System.
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports.
• Created and performed user acceptance testing on new and modified reports.
• Created queries using Add Command object in Crystal Reports XI.
• Displayed pie charts, bar graphs for analysis by top-level management using Analyzer in the reports.
• Developed and tested complex Transact SQL on MS SQL Server.
• Created database objects such as tables, indexes, stored procedures, functions, and triggers.
• Designed, developed, and tested stored procedures, views and complex queries
• Developed database triggers and stored procedures using SQL cursors and tables.
• Managed all indexing, debugging, optimization and performance tuning using Profiler and SQL Server Agent.
• Designed and developed Data Transformation Process.

Environment: Crystal Reports 10, SQL Server 2000, DTS, BCP, T-SQL, TOAD.

Client: Confidential West Des Moines, IA June 06 - Sept 07 
SQL Server/SSIS, SSRS

Confidential is the leading provider of Managed Learning Services and on-demand performance and learning platforms. Hundreds of companies, government agencies and non-profit organizations have deployed GeoLearning\'s enterprise learning management platforms and rely on our learning services to drive organizational performance. GeoLearning is the ideal partner for organizations seeking to increase sales, accelerate time to market, raise productivity, generate new revenue streams, cut expenses or reduce training time.

Responsibilities:

• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008.
• Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created various Multidimensional cubes using SSAS.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services with the help of some XSTL Style sheets.
• Created multiple reports in Drill mode using tables, financial tables, crosses tabs and charts using Reporting Service (SSRS).
• Experience in MOLAP (Multi dimensional Cube) and ROLAP (RDBMS) to develop customized reports in MS SQL Server database.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008.
• Designed and implemented Parameterizedand Cascading Parameterized reports using SSRS.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Using VB.NET activities performed like Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Managing the security of the servers, creating the new logins and users, changing the roles of the users with the help of Visual Studio.
• Involved in developing logical and physical modeling of the database using Erwin.
• Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Used Microsoft Team Foundation Server (TFS) to get the lists of bugs that do not have test cases, regressions on previously passing tests.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Provided 24/7 production support for the production database and also to the code deployed into the production environment.

Environment: SQL Server 2008,DTS, SSIS, SSRS, SSAS,T-SQL, Microsoft Visual Studio 2008, SQL Server Management Studio, Crystal Reports, MS Office, Excel, Windows 2003 Server.

Client: Confidential, Cincinnati, OH Feb 05 – May 06 
SQL Server/ETL/ SSRS Developer

Confidential is a diversified financial service company. It is among the largest money managers in the Midwest. The company engages in five main lending and banking practices: Branch Banking, Consumer Lending, Commercial Banking, Investment Advisors and Fifth Third Processing Solutions. Branch Banking offers Checking Account, Savings Accounts, Online Banking and other retail banking products and services to consumers. This is a Data Warehouse project which helps in managing accounts involved in daily transaction, loans and other financial services. This system is useful in maintaining the reconciliation on daily basis and also meeting daily reporting requirements.

Responsibilities:

• Involved in installation and configuration of SQL Server 2000 and SQL Server 2005 with latest Service Packs.
• Developed SQL Scripts to Insert/Update and Delete data in MS-SQL database.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Maintaining records in Excel Spread Sheet and exporting data into SQL Server Database using SQL Server Integration Services.
• Built various packages in SSIS to load the data coming from various interfaces like Orders, Adjustments, and Objectives.
• Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005.
• Created / modified SSIS packages to load the data into the data warehouse environment.
• Import/Export and successfully migrated the Databases such as DB2 to SQL Server 2000 using SSIS.
• Assisted technical staff in data mapping and program logic and requirements for source system interfaces.
• Developed reports using SSRS 2005 and Crystal reports. Used table control, matrix control for cross tab reports.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Developed Custom Selection of reports ordering using SQL Server Reporting Services.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2005.
• Worked with different types of Replication Models like Snapshot, Merge and Transactional.
• Performed tune to optimize SQL queries using SQL profiler and query analyzer.
• Actively participated in (UAT), preparation of user manual and technical support manual.

Environment: SQL Server 2005/2000, SSIS, SSRS, SSAS,T-SQL, SQL Query Analyzer, SQL Profiler, Erwin, XML, Visual Studio 2005, Oracle 9i, Crystal Reports.

EDUCATION

• Bachelors Degree in Engineering