PROFESSIONAL SUMMARY:

• Highly motivated IT Professional over 8 years of experience in Database Development, Design, System Analysis and Support of MS SQL Server R 2/2008/2005/2000 and Data Warehousing, Business Intelligence applications design, development and Maintenance of DTS/SSIS,SSRS,SSAS
• Expert in all areas of SQL Server development including T - SQL Queries, Stored Procedures, User-defined Functions, Views, Triggers, Cursors, T-SQL relational database models and data integrity
• Expert in using SQL Server Agent to Schedule and monitor Jobs
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes using DDL, DML, DCL commands
• Experience in Error handling and debugging coding issues and troubleshoot production problems
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE, Table Variables and strong noledge of SDLC principles
• Performing Data transfer between different heterogeneous systems (Excel, MS Access, Flat Files, XML file, Oracle and DB2) and SQL Server as a part of Data Migration, Data Maintenance and other ETL tasks
• Expert in usage of SSIS Control Flow items(for each Loop, Execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Union all, Pivot/ Unpivot)
• Expertise in creating and managing Package Configurations, Logging system, Package deployment and User-defined Variables for SSIS Packages
• Strong Experience in generating On-demand (Table format, Matrix format, Drilldown, Drill-Through, Multi-valued parameters etc.) and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services (SSRS)
• Expertise in Developing and Extending MS SQL Server Analysis Services 2008 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects
• Experience in Microsoft visual studio C#, .net 2005 win forms in developing data applications
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor(DTA), DBCC & Index statistics, Windows Performance Monitor and Query Execution Plans
• Proficient in performing DBA tasks including installing and configuring SQL servers and backups/restore and recovery of databases
• Extensive experience in using SQL Server Profiler to monitor teh SQL server for deadlocks, long running queries and tune teh same to improve performance
• Expertise in implementing efficient Disaster Recovery Strategies and High availability like Snapshot, Transactional and Merge Replication, Log shipping, Clustering (Active/Passive) and Database Mirroring
• Worked wif end users/customers to understand business requirements, recommended technical solutions and documented functional requirements
• Good team player, strong interpersonal and communication skills combined wif self-motivation, initiative and quick learner

TECHNICAL SKILLS

Database: RDBMS, SQL Server 2000/2005/2008, MS Access, Oracle

Data warehouse Tools: SSIS, SSAS

Reporting Tools: SSRS, Cognos, Crystal Report

Languages: C, C#, T-SQL, PL SQL, .NET

Operating Systems: Windows NT/98/2000, DOS, Windows Server 2003, Windows Server 2005

Web Technologies: HTML, ISS, and XML, XSLT, Dream weaver

Packages / Applications: MS Office, Visual Source Safe, SQL Log Explorer, Visual Studio, Visual Basic 6.0, MS Visio, Remedy, XML Spy, Microsoft Project, Red-gate Bundle, Ultra edit

PROFESSIONAL EXPERIENCE:

Confidential, Manhattan, NY

SQL SSIS SSRS Developer

Responsibilities:

• Installed and configure servers and clients using SQL Server 2008 R2, Upgraded SQL databases
• Created Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for teh applications following SQL code standards
• Used Data Manipulation Language (DML) to insert and update data, satisfying teh referential integrity constraints
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted teh results into reports and kept logs
• Rewrite teh existing code, queries, stored procedures for long running queries by replacing cursors wif various joins, common table expression (CTE), indexing and applied MS best practices for query tuning
• Worked wif front end team to enhance and develop new application using ASP.net platform
• Developed DTS/SSIS Packages dat loads data files/EDI files, extracted from SAP and Oracle DB, into SQL database wif necessary transformation
• Created SSIS package using for each loop, sequence container, Script task to load multiple files from same source folder on different FTP location and to perform group task
• Migrated SQL 2000 DTS packages to SQL 2008 SSIS packages using SQL Server 2008 Upgrade Advisor
• Configured SSIS packages wif XML file using package configuration to deploy teh packages on different environment
• Created SSIS packages wif error handling and worked wif different methods of logging in SSIS
• Maintained teh physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler
• Performed DBA activities of daily backup and failover restore of database, monitoring/scheduling jobs on different production servers using Red Gate tool
• Created data flow model using MS Visio
• Worked wif end users to analyze data flow process and understand requirement for teh finance reporting
• Perform performance tuning, optimization, Bug Fixing and Enhancement during teh various quality assurance testing cycles and for teh Production dash board report using Database Performance monitoring tools
• Created monthly and quarterly sales reports using SSRS, maintained and enhanced teh existing enterprise data warehouse(EDW) reports
• Worked very closely wif SAP and Cognos team to analyze teh organization’s dashboard, critical reporting requirements of business & end-users
• Coordinated wif offshore team to resolve production issues

Environment: SQL Server 2000/2008/R2, Windows Server 2003/2008, Enterprise Manager, SSMS, Oracle 10g, SQL Server Business Intelligence Studio, SQL Server Profiler, TFS,XML, SAP, MS Visio,, Cognos 8, Excel, T-SQL, SSIS,SSRS

Confidential, NYC, NY

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Developed T-SQL (DDL-Data Definition Language, DML-Data Manipulation Language) statements using dynamically generated SQL.
• Prepare design documentation and submit for review.
• Code and unit test solutions independently or as part of a development team.
• Perform technical support activities required for execution of test plans.
• Created complex Stored Procedures, triggers, cursors, indexes, views and SQL joins and statements for applications wif SQL Server 2005/2008
• Created several tables, views using SQL Server management studio(SSMS), based upon teh functional specifications and primary key & foreign key constraint
• Perform defect correction dat maintains or enhances application integrity
• Created SSIS package to export and import data fromSQLServer to Access, text and Excel file. Used Event Handlers for Exception Handling in SSIS packages
• Used Aggregate, Conditional Split, Union All, Lookup, Derived Column, Data Conversion, Multicasting and Merge Join Data Flow transformations in SSIS
• Modified teh existing SSIS packages to meet teh changes specified by teh users.
• Modified teh existingSQLqueries according to teh requests and executed them to check teh performance.
• Monitored performance andoptimized SQL queriesfor maximum efficiency.
• Worked wif .net team to enhance teh performance of application using ASP.net
• Performed T-SQL tuning and optimization of queries for reports dat took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005
• Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star/ Snowflake schemas using Dimensional data Modeling principles in SSAS.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for teh reports (SSRS 2008).
• Scheduled Jobs and Alerting using SQL Server Agent

Environment: SQL Server 2008, Windows 2003, SSIS, SSRS, Excel, T-SQL, SQL Server Management Studio (SSMS)

Confidential, Parsippany, NJ

SQL SSIS SSAS SSRS Developer

Responsibilities:

• Performed various SSIS tasks such as Conditional Split, Derived Column on teh data retrieved, performed Data Validation Checks during Staging, and then loaded teh data into teh Enterprise Data warehouse (EDW)
• Worked on all activities related to teh development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS and DTS
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources
• Created SQL Server Reports using SSRS 2005
• Created detailed reports for teh customers to halp them to understand detail of products and demographic information based on various parameters
• Configured XML config files (.dtsconfig files) to change properties of packages dynamically
• Fine-tuned DML, DDL scripts wif lock hints for performance boost
• Designed and developed Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX
• Created complex SSAS cubes wif multiple fact measures groups, and multiple dimension hierarchies based on teh OLAP reporting needs
• Extensively worked on Dimensions and measures using SSAS
• OLAP model based on Dimension and Facts for efficient loads of data based on Star Schema structure on levels of reports using SSAS
• Used SQL profiler to view indexes performance to mostly eliminate table scan
• Used highly complex TSQL Queries and SQL Scripts to perform efficient data load based on complex Business rules
• Created stored procedures, views, triggers, user defined functions to in corporate teh flow of business and called various stored procedures from DTS to make teh flow of DTS effective
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis
• Extensive Data Modeling skills for Logical and physical database design using Erwin tool
• Helped Development Team in deploying and testing teh application, which uses SQL Server as a database
• Used DBCC utilities to fix data corruption in application databases
• Used third party tools like Red gate for compressed backups and easy to restore
• Documented all teh new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain teh database for future
• Involved in administration, performance analysis, and production support for large (VLDB) databases up to 1 TB

Environment: SQL Server 2003/2005, SQL Server Management Studio(SSMS), SQL Server Business Intelligence Studio, SQL Server Profiler, XML, Erwin, Microsoft Visio 2003, TFS,, UML, XML, C#, T-SQL, ODBC, Excel, SSAS, SSIS, SSRS

Confidential, St. Louis, MO

SQL SSIS SSRS Developer

Responsibilities:

• Involved in gathering teh requirements from teh client and converting them in to design specifications
• Created logical and Physical database design, data structures, primary key, foreign key and implemented large databases using Erwin
• Involved in extracting teh data using SSIS from OLTP to OLAP, Creation and execution of TSQL Scripts
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic email notification and SQL Server backup strategy and automation
• Used Active-X Scripting in SSIS (SQL Server Integration Services) for transformation of data in to staging tables and also to extract data from database tables and write teh data to text files
• Proper use of Indexes to enhance teh performance of individual queries for very fast and efficient reporting process
• Developed and optimized database structures, Stored Procedures, Indexes, Views, Triggers, Cursors and User Defined Functions (UDF)
• Perform weekly database checkup, shrink database according to instructions, and document weekly database activities
• Experience in generating reports and deploying it in to teh server using SSRS (SQL Server Reporting Services)
• Provided back-end support for functional testing and performance testing
• Organized data from Enterprise data warehouse into multidimensional cubes wif SQL Server Analysis Services (SSAS) to allow teh execution of sophisticated reports and complex queries
• Monitoring teh CPU usage, IO statistics, Memory usage to identify any OS level performance killers, enabling database level trace for performance test
• Extensively involved in maintaining & updating teh database documentation

Environment: SQL Server 2000/2005, Windows 2003/XP, Enterprise Manager, SQL Server Management Studio(SSMS), SQL Server Business Intelligence Studio, C#, .Net 2.0, SQL Server Profiler, SSRS, SSIS, SSAS, T-SQL, PL/SQL MS Visual Source safe

Confidential, Berkley, MI

SQL SSIS SSAS SSRS Developer

Responsibilities:

• Evaluated data storage considerations to store databases and transaction logs, Optimized teh physical disk performance through RAID-1, RAID-5 levels for fault tolerant database partitions
• Worked in teh development of complex Stored Procedures, Triggers, functions, DTS packages to support multiple business applications. Developed and maintained Stored Procedures using T-SQL
• Worked extensively in tuning and optimizing teh performance of production databases by creating new indexes and re-writing SQL queries to utilize indexes
• Participated in Test Plan, test case review meetings and Supported QA activities
• Extensive experience in trouble shooting of client connections, viewing error log and applications
• Created application Schema (Database, Tables, Views and Indexes) and implemented various SQL, Transact-SQL statements, stored procedures and UDF (User Defined Functions) according to teh requirements of teh project
• Used DBCC utilities to fix data corruption in application database
• Followed teh Microsoft recommended best practices in designing, developing, and implementation and testing of teh ETL using SQL Server Integration Services
• Created teh Data Model for teh Marketing Information System Team using Erwin
• Created and modified procedures, triggers and functions
• Writing and Scheduling Execution of Scripts to update converted data from teh Holding Tank data, to validate teh converted data
• Managing logins, roles, assigning rights and permissions. Created views to implement security
• Used profiler to monitor teh performance, Debug Transact-SQL statements and stored procedures in existing application, to identify slow running query etc.
• Modified teh existing SSIS packages to meet teh changes specified by teh users
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Extensively used Ultra-Edit to verify teh text file provided by employer/agency and keep trace of files provided by employer/agency
• Transformed data from text file to SQL server using SSIS
• Deployed database objects from development/testing environment to production environment
• Migrated data from legacy system (text based files, Excel spreadsheets, and Access) to SQL Server databases using DTS, SQL Server Integration Services (SSIS) to overcome teh transformation constraints
• Debugging and troubleshooting teh technical issues while implementing teh applications
• Created, designed and deployed drill down reports using MS SQL Server reporting services (SSRS)

Environment: Windows XP, Windows 2003, Terminal Server, T-SQL, C#, .NET, ADO.NET, SQL Profiler, SQL Jobs, SQL Server Management studio(SSMS), SQL Server 2005, SSIS, SSRS, SSAS

Confidential

SQL Server Developer/DBA

Responsibilities:

• Installation and configuration of SQL Server 2000 on Window 2000 OS
• UsedT-SQLfor programming forstored proceduresandqueries
• Handling Database Objects wif Enterprise Manager and Query Analyzer
• High level of expertise in implementing different types of Replication Models such as Transactional, Snapshot and Merge Replication and failover clustering
• Managing of database objects like Tables, Views, stored procedures, Indexes etc.
• Maintained login and user management in SQL Server database by managing of users including creation/alteration, grant of system/db roles and permission on various database objects,
• Developed DTS packages to transfer teh data between SQL Server and other database and files
• Automated teh DTS/ETL to import and export data form text/ Excel file, in different format, to SQL Server and vice versa
• Well experienced wif tools like Query Analyzer, SQL Enterprise Manager
• Used Data Transformation Services (DTS), an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources using teh concept of OLE DB
• Creation and management of database maintenance plan for various database consistency checks
• Used SQL Profiler to monitor teh server performance, debug T-SQL and slow running queries
• Automation and execution of data transformation scripts
• Developed T-SQL scripts to enforce business rules and creating reports from OLAP database

Environment: SQL Server 2000, Windows NT, Visual Studios 2005,Visual Basic 6.0, VBScript, Excel, MS Access, T-SQL, SQL enterprise manager, DTS