SUMMARY

• Over Seven plus years of extensive experience in IT with Microsoft SQL Server Database Design and Development.
• Extensively involved in logical database design, space analysis, and physical database design.
• Expert in TSQL. Wrote thousands of lines of TSQL code, developed many Stored Procedures, Triggers.
• Expert in MS SQL SERVER suite of products like SSIS, SSRS and SSAS
• Expert in utilizing ETL tools for data loads, database integration/conversions, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Over 2 years of experience in MySQL Database, and worked with writing complex SQL process using MySQL.
• Experience in Migrating from SQL Server 2000 to SQL Server 2005/2008, Oracle, and MySQL using DTS
• Hands on experience with Testing Life Cycle (Component testing, Unit testing, and System/Integration testing, User acceptance testing etc.)
• Hands on experience in creating ETL packages using SQL Server 2005/2008 Integration Services (SSIS).
• Working Knowledge in .NET/C# application development environment to use SQL Server Databases.
• Highly Proficient in creating and maintaining SQL SERVER Reports using SSRS (2005&2008)
• Worked with OLAP and Data warehouse application and worked with star schema, type1/type2/type3 dimensions and worked with implementing SSAS, and SSRS to support large Reporting needs.
• Hands on experience in creating OLAP cubes using SQL Server 2005 analysis services (SSAS) and ProClarity.
• Proficient in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
• Expert in creating complex Stored Procedures, User Defined Functions, and effective Triggers to facilitate efficient data manipulation and data integrity.
• Worked with handling high volume data on oracle and Sql server database on UNIX and Windows OS respectively.
• Worked with improving the performance on SQL, TSQL and SSRS procedures and provided the recommendation on server related tuning issues
• Worked with preparing the documentation for GAP analysis, Technical Specification documents, Functional Speciation documents, mapping documents etc.., for the various migrations and up gradation projects.
• Good experience in Dimensional modeling using Star Schema/Snowflake modeling concepts and Kimball/Inman strategies.
• Experience with Physical & logical data modeling using All - Fusion Erwin Data Modeler4.1.2
• Performed analysis, testing, and implementation of Business Objects solutions, including performance management, desktop intelligence, Crystal Reports, and Web Intelligence.
• Hands on experience in converting formerly dominant enterprise business intelligence systems such as COGNOS, Business Objects/Crystal, Micro strategy and others, to the Reporting Services architecture.
• Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2005.
• Excellent communications skills (verbal and written) for both highly technical and non-technical audiences
• Hands on experience in Software Development Life cycle (SDLC) and Testing Life Cycle (Unit Testing, Regression Testing etc.)
• Team Player, Able to Work with a new and fresh perspective on work assignments, good in debugging, creative and able to learn new things.
• Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organizational goals.
• Good ability to quickly grasp and master new concepts and technologies.

TECHNICAL SKILLS

Tools: SQL Server Management Studio, Query Analyzer, SQL ProfilerData Base Engine Tuning Advisor, SSIS, SSRS, Business Intelligence Development Studio, Data Transformation ServicesPerl, Crystal Reports XI, Performance point server

Database: Oracle 10g/9i/8i/7.x, MS SQL Server 2008/2005/2000/7.0/6.5 DB2 UDB, MS Access 2000/7.0, Sybase and Teradata V2RX

Database Tools: OEM, RMAN, SQL Backtrack, Query Analyzer, TKPROF Stats Pack, AWR, ADDM, OWB

Operating Systems: Microsoft Windows XP/2003/2000/9i/NT, IBM AIX UNIX 4.2, RedHat Linux 8, IBM OS/390 version 2.8 and DOS

Languages: SQL, PL/SQL, Transact SQL, C#, C++, VC++, VB6, ASP.NetUNIX Shell scripting, HTML, XML

PROFESSIONAL EXPERIENCE

Confidential

SQL Server BI Developer

Responsibilities:

• Involvement in the requirement phase to understand the requirements.
• Worked closely with the architect and team in designing, developing and implementing the logical and physical model for the Data mart.
• Designed ER diagrams and mapped the data into database objects.
• Wrote SQL scripts to Insert/Update and Delete data in MS SQL database.
• Involved in table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization
• Created schemas, views, stored procedures, Triggers and functions for Data Migration. Involved in the complete life cycle of the project, from Planning Staging and pushing the codes to production.
• Created SSIS Packages to import and export data from Excel, Xml and Text files.
• Extracting the data from the Legacy systems and staging the data into staging tables using Sql Server Integration Services (SSIS).
• Design and Data Analysis for the requirement.
• Development and Unit Testing and prepare the Unit Test case documents.
• Performed Database testing to verify data in the Data tables using Management Studio.
• Improve security and compliance with safe data requirements and other regulations of the state.
• Involvement in the System Testing and User Acceptance testing.
• Support the Development work.
• Analyzed web applications, documented detail test plans, test cases and expected results based on the business functional requirements.

Environment: SQL Server 2008 Enterprise Edition, BIZTALK SERVER 2010, MS Visual Studio 2010, SQL Server Integration Services Tools (SSIS,SSMS),MS Office 2007,Erwin Data Modeler.

Confidential, Boston, MA

SQL Server BI Developer

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data and Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes, etc.).
• Developed and maintained data manipulation methodologies, procedures, standards, and performed data impact analysis.
• Performance Tune the Stored Procedures, User Defined Functions and long running queries migrating database systems from SQL Server 2003 to SQL Server 2005/2008.
• Migration of various SQL Server components, Database, DTS Packages, Logins and Analysis Server etc., of existing server.
• Used profiler to monitor the performance, Debug Transact-SQL statements and stored procedures in existing application, to identify slow running query etc.
• Built various packages in SSIS to load the data coming from various interfaces like OMS, Orders, Adjustments and Objectives.
• Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Automated the DTS/ETL to import and export data form text/ Excel file, in different format, to SQL Server and vice verse using SSIS.
• Actively supported business users for change requests.
• Demonstrated expertise utilizing ETL tools, including SQL SERVER Integration Services (SSIS), Data Transformation Services (DTS).
• Developed business Service based application (Polling Service) using C#
• Performed Client-Side and Server-Side form validations using JavaScript and ASP.NET Validation Controls
• Developed rich user interface to support different client browsers using ASP.NET 3.5, C#, Web Forms, User Controls, Web Controls and HTML Controls
• Designed and developed SSIS Packages, Stored Procedures, Configuration files, tables, views and functions.
• Implement best practices to maintain optimal performance.
• Created and Scheduled jobs, alerts, activity logs, error logs to capture any possible errors.
• Manage data population and migration architecture for application upgrades (PL/SQL)
• Worked as part of the architect team to develop complete star schema (Snow Flake)for the Phase I of the Data Warehouse
• Worked with writing the PL/SQL code to replace the legacy process with PL/SQL procedure and worked with tuning SQL quires generated by SSRS.
• Scheduling SSIS jobs (SQL Agent), Migrating DTS packages to SSIS packages
• Developed SQL SERVER Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005/2008 and reconciled data.
• Created interface stored procedures used in SSIS to load/transform data to the database. Extended Data to XML and Excel Spread Sheet.
• Involved in Capturing Requirements, Preparing Business Blocks UML Use Cases, Collaboration Sequence, and Activity diagrams, defined and Managed as Part of CMM
• Developed reports using SSRS 2005 and Crystal reports, used table control, matrix control for cross tab reports.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Written and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.
• Writing and testing stored procedures.
• Worked with writing the shell scripts for Unix OS to automated several manual process, and worked with DBA to tune the server related parameter
• Monitored performance and optimize SQL queries and Stored Procedures for maximum efficiency.
• Utilized SSIS (SQL SERVER Integration Services) to produce a Data Mart for reporting.
• Extract, Transfer and Load data into SQL Server Analysis Services Cubes and process cubes and maintain data up-to-date in cubes
• Developed various reports using SSRS
• Providing support to existing applications

SQL Server BI Developer

Responsibilities:

• Installed upgraded and migrated databases from Oracle database to MS SQL Server 2005/SQL Server 2008.
• Migrated databases from SQL Server 2000 to 2005 with multiple data refreshes in the SQL 2005 environment
• Performing substantial data cleanup, restructuring and reporting.
• Major responsibilities: administer database servers where necessary, perform or approve all database development, clean up existing database design, develop and maintain data extracts using SSIS, create reports on existing data.
• Designed ER diagrams and mapped the data into database objects.
• Involved in Normalization of the Database in OLTP.
• Involved in the analyzing and solved problems doing the Client Application system's installing, upgrading and running stages.
• Design and created different ETL packages using SSIS from Oracle source to SQL server as destination.
• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2005/SQL Server 2008.
• Wrote SQL scripts to Insert/Update and Delete data in MS SQL database.
• Involved in table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization
• Created schemas, views, stored procedures, Triggers and functions for Data Migration. Involved in the complete life cycle of the project, from Planning Staging and pushing the codes to production.
• Developed complex reports using (SSRS) multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries
• Creation of database, tables and procedures to update and clean the old data.
• Helped the front end application developers with their queries.
• Created SSIS Packages to import and export data from Excel, Xml and Text files.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Advisor.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Configured SQL mail Agent for sending Automatic emails on Errors.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize performance.
• Involved in writing different testing scripts for the testing of the Codes.
• Created star schema in SSAS and developed SSRS reports based on the cubes.
• Worked with Analysis services 2005/2008 and made various cubes based on the reporting requirement.
• Conducted unit and integration testing to ensure Accuracy.
• Generated Sales Ranking reports using SQL Server Reporting Services for different subjects.

Environment: Oracle 10g, Microsoft SQL Server 2005/2008 Enterprise Edition, SQL Server Integration Services tools (SSMS,BIDS and SQL Server Manager), SSRS, SSAS, Windows Server 2003, Serena Change man Version Control, MS Visio, MS Excel, ERWIN.

Confidential, Baltimore, MD

SQL Server BI developer

Responsibilities:

• Participated in Design and Architecture meetings and proposed technical solutions to resolve business requirements.
• Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.
• Extensively involved in gathering user and system requirements for the URS Data mart.
• Worked closely with the architect and team in designing, developing and implementing the logical and physical model for the Data mart.
• Analyzed various processes like Orders, Metrics, Adjustments and Objectives.
• Followed the Microsoft recommended best practices in designing, developing, and implementation and testing of the ETL using SQL SERVER Integration Services.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS) (2005).
• Interact with customers and internal engineers, design of data architecture for two lines of application development (OLTP and OLAP)
• Create software design documents; review technical design; define data architecture standards and change control mechanisms
• Design ETL processes, mentor development teams in terms of data access programming (SQL development)
• Built various packages in SSIS to load the data coming from various interfaces like Orders, Adjustments, Objectives
• Worked with moving data from Oracle to SQL server and migrated the PL/SQL code to SSIS packages
• Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Migrated Organization, Orders, Adjustments, Objectives and Ariba 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.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Scheduled and maintained daily and monthly loads of Orders, Objectives and Adjustments data through jobs, tasks, and alerts.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis.
• Worked with the team in building the daily dollar, summary, funnel genie, objective and adjustments reports.
• Worked with using SSAS, SSRS and SSIS package extensively produce massive OLAP reports.
• 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 reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users like VP, AVP, CD, Coach, Lead, SA, SR, Office Clerk.
• Involved in end to end documentation of all the processes including aggregation, metrics and all the relevant customizations made in the system.

Environment: SQL SERVER 2000/2005, Microsoft Business Intelligence Development Studio, .Net Frame work, T-SQL, XML, SSIS, SSAS, SSRS, ERWIN, Ariba

Confidential, Baltimore, MD

SQL Server Developer

Responsibilities:

• Gathered requirements from business users, Wrote user requirement documents based on functional specification.
• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects.
• Developed source to target specifications. Developed stored procedures, functions, views and triggers.
• Developed scripts to load data from Oracle tables and flat files into Enterprise data warehouse.
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Created DTS package to schedule the jobs for batch processing. Supported the application developers for queries for development hierarchies, file upload and validations using ASP. Net.
• Performed tune to optimize SQL queries using SQL profiler and query analyzer.
• Created Indexes, Constraints and Rules on database objects.

Environment: MS SQL SERVER 2000, MS Access, DTS, Erwin, SQL Query Analyzer, SQL Developer, Cognos Power Play, XML, ASP.NET, JD Edwards ERP data tables on Oracle 8i, VB.NET

Confidential, Union, NJ

SQL server developer/Data Base Developer

Responsibilities:

• Involved in designing the physical databases model on SQL Server 2000 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database.
• Installed SQL Server 2005 with latest Service pack and established connectivity with the database created, configured and maintained database maintenance plans and also database backup and recovery.
• After installing the SQL server 2005, migrated the existing DTS packages into SSIS packages using SSIS services provided by SQL Server 2005 Manager studio.
• Import/Export and successfully migrated the Databases such as DB2 to SQL Server 2000 using DTS.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Migrated SQL server 2000 DTS packages to SQL Server 2005 SSIS packages using SQL Server 2005 Upgrade Advisor.
• Experience in writing MDX and designing DW schemas
• Worked on other packages of the SQL server 2005 Edition SSRS (SLQ Server Reporting Services), SSAS (SQL Server Analysis Services).
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Implemented Disaster Recovery plan using Log Shipping method.
• Monitored database status including CPU, memory, I/O, space and dead lock using SQL Server Utilities.
• Created and maintained Database Maintenance plans and also created logins and assigned roles and granted permissions to users and groups.
• Performed optimization of query, triggers, and stored procedures, their testing focusing on stability and execution plan which has resulted up to 45% increase in performance of numerous modules.
• Identify and resolve problems encountered during both development and release of the SSIS code
• Designed new dynamic DTS Packages to transfer data between servers, load data into database and tuned the existing packages.
• Worked in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications. Developed complex TSQL code for the application.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Ensured developers coordinated their efforts in managing and maintaining different application databases.

Environment: DB2, SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003, BizTalk Server 2004, IIS 6.0, .NET framework, Erwin, Microsoft Visio 2003, SFTP, Microsoft Reporting Service