SUMMARY

• Over 8 years of IT experience as a SQL Server Developer in Design, Analysis, Development, Modeling, Implementation and Testingof Decision Support Systems using MS SQL Server 2000, 2005,2008services.
• Extensive experience in MS SQL Server 2005/2008 Business Intelligent (BI), Reporting Services (SSRS), Sharepoint 2010, Integration Services (SSIS).
• Expert in TSQL, Entity Relationship Model, Crystal Report, ETL, SSRS and SSIS of MS SQL Server 2005 and 2008.
• Hands - on experience in gathering data for data warehouse from OLTP using SSIS.
• Highly proficient in designing queries in accessing data and hands-on experience in query structuring, performance optimization using SQL Server 2005 and 2008.
• Expert in development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Data Transformation Services (DTS) and SSIS wif MS SQL 2005.
• Experienced in Relational and Dimensional modeling techniques of Data warehouse concepts and principles-Star, Snowflake schema, SCD, Surrogate keys and Normalization/De normalization.
• Experienced in creating scripts for monitoring and maintenance tasks, automated Database & transaction dumps, monitoring data received at 15 min interval and populating reporting tables.
• Proficient in creating and designing the report layout, sorting the data, defining subtotals and generated Reports like parameterized reports, drill down, drill through, canned and cache reports using SSRS 2005/2008.
• Excellent hands-on experience wif data modeling tool like Erwin and strong noledge of Relational and Dimensional database modeling concepts wif star schema and snowflake schema’s design and implementation.
• Proficient in creating Data Mapping Document for providing source and destination mappings. Deployed reports on report server.
• Experience in Database Administration operations likeBackup,Recovery, Replication, Import and Exportand excellent noledge ofDDLandDMLinTSQL.
• Expert in Transact SQL Programming, query optimization and performance tuning using SQL profiler, Index tuning wizard, Performance Monitor and Execution plan.
• Proficient in scheduling and creating reports using SQL Server Agent.
• Expert database designer and fluent in all aspects of database development including, design, normalization and optimization.
• Expertise in complete Software development life cycle (SDLC) also TEMPhas strong understanding of Software Quality Assurance Methodology and Agile methodologies.

TECHNICAL EXPERIENCE:

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

Programming Languages: T-SQL, PL/SQL, MDX, C, Visual Basic 6.0, VB Script, Shell Scripting, C#

.NET: VB .NET, ASP .NET, ADO.NET, XML, HTTP, ActiveX, MsAccess

Databases: Confidential SQL Server 2008/2005/2000/7.0, MS-Access 97/2000/2003, Oracle 9/10g, Sybase Server

Tools/Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export, Visual SourceSafe 6.0, Visual Studio.Net, Confidential Management Console, DTS, SSIS, Business Intelligence Development Studio (BIDS), TOAD, Crystal Reports 9.0, ETL, IIS Erwin 4.0, Business Objects, ProClarity, Spotlight, Web Services, XML

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), Cognos SDK, Cognos Impromptu 7.1

Application Packages: MS Office, Ms Outlook ( Confidential Office Suite), Confidential Office SharePoint Server (MOSS) 2007

Version Control: Visual SourceSafe 6.0/2005, Remedy Change Management, Subversion

Portal: SharePoint Portal Server 2003/2007, Windows SharePoint Services

PROFESSIONAL EXPERIENCE

Confidential, Waltham, MA

MS SQL Server SSIS/SSRS Developer

Responsibilities:

• DesignedSSIS Packagesto transfer data from various sources likeText Files, XML Files, Excel, Oracle, Flat files to SQL Server.
• Worked on Cognos to explore and interact wif database..
• Actively involved in gathering requirements and acquiring application noledge from Business Managers.
• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Involved in designing the process flow for extracting the data across various source systems.
• Involved in building and maintainingSSIS Packagesto import and export the data from various data sources usingBIDSbased on the design data models.
• Has experience in doing excellent documentation on business requirements. Created reports to retrieve data usingStored Proceduresdat accept parameters.
• Expert in fuzzy lookups and fuzzy grouping transformation in data cleansing.
• Worked on various tasks and transformations likeExecute SQL Task, FTP, Execute Package Task and Conditional split while loading data into Warehouse.
• Involved in creating Database Objects like Tables, Views, Stored Procedures and Triggers as required in Data Warehouse.
• Designed, reviewed, and created objects (views, indexes, etc.) based on logical design models, user requirements staging area.
• Involved in Performance tuning of the slow running queries and Stored Procedures, Wrote variousT-SQLqueries,Stored Proceduresand used them to build packages.
• Created Triggers, Tables, Views and SQL Joins for various applications.
• Using SQL Server Reporting Services(SSRS)delivering enterprise, Web-enabled reporting to create reports dat draw content from a variety of data sources.
• Created Packages, Jobs and sending alerts using SQL mail, Database Backup, Recovery and Disaster Recovery Procedures, Planned and complete backup of various Databases for Disaster recovery scenarios.
• GeneratedSub-Reports,Drill down reports, Drill through reports and Parameterized reports using SSRS.

Environment: Confidential SQL Server 2008, T-SQL, SSIS, SSRS, Oracle, Oracle E-business Suite 12.1, Erwin, Windows server 2008, ASP.NET 2008, SQL Profiler, Visual Studio 2008, IIS (6.0). Websphere MQ 7.0

Confidential, Mattawan, Illinois

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Created complex stored procedures and functions to support efficient data storage and manipulation.
• Created Database, creating tables, views, indexes, stored procedures, triggers and constraints.
• Determined the SQL Server 2005 Installation. Installed SQL Server Management tools using SQL Server 2005 setup program.
• Designing standards for the database table, column, procedure and views.
• Created junked and conformed dimension in Data Warehouse Hardware/Software.
• Analyzed the requirements and fine tune the stored procedures to improve performance.
• Data transferred between various servers using BCP and Data Transformation Services in SQL Server Integration Services.
• Implemented Data Transformation Services Packages in SQL Server Integration Services (SSIS) for transferring data and Data Loads.
• Involved in writing T-SQL programming for implanting stored procedures and functions for different tasks.
• Involved in Query Optimization using extensive use of Index implementation and Index Tuning Wizard SQL Server 2005.
• Used SSRS to write complex formulas and to query the database different to generate different types of ad-hoc reports.
• Worked on Client/Server tools like SQL Server 2005 Enterprise Manager and Query Analyzer to administer SQL Server 2005.
• Created Database Maintenance Planner for the performance of SQL Server 2005, which covers Database Integrity checks, Database Statistics update.
• Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
• Worked on DTS Package in SQL Server Integration Services (SSIS), DTS Import/Export for transferring data from heterogeneous database. Generated ad-hoc reports using MS-Access and Crystal Reports.
• Createddegenerative dimension wifin OLAP Hardware/Software.
• Generated ad-hoc reports using MS-Access and Crystal Reports, Tuned SQL queries using show plans and execution plans for better performance.

Environment: MS SQL Server 2005, T-SQL, MS Excel, MS Access, Crystal Reports 10.0 and Windows NT, ASP.Net, Visual Basic, SQL Server Integration Services, SQL Server Reporting Services.

Confidential, WA

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data model.
• Installed, configured and maintained SQL Server Integration Services (SSIS).
• Develop the ETL for the warehouse and other applications using SSIS.
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually.
• Imported data from Text Files, Excel Spreadsheets and OLEDB sources into SQL Server 2005 databases using SSIS.
• Created master ETL packages which include various packages in them and scheduled them to execute based on the given requirement time.
• Developed New SSIS packages based on business requirement and also executed DTS packages from SSIS.
• Migrated DTS packages to SSIS Packages.
• Worked on Share point 2007 to upload the designed documents in to Web portal.
• ConfigureSSISPackage for run time Parameters and Config file.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Deployed reports into Report Manager.
• Designed the User Interface (UI) web interface of the application using prototyping.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Involved in Performance tuning wif the halp of Profiler Tuning advisor & windows performance monitor and fine-tuned the logic in stored procedures, Functions and Triggers for Optimum performance.

Environment: SQL Server 2005/2000, SQL Server Integration Services (SSIS), SSRS, Visual Basic 6.0,DTS, T-SQL, Share point 2007, Oracle 9i, Teradata, Active X, C#.NET, XML, MS-Access, Clear Quest, Windows 2003, Erwin.

Confidential, Minneapolis, MN

MS SQL Server Developer

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers, and Functions.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database.
• Creating SSIS packages for Extraction, Transformation and Loading operations.
• Created SSIS/DTS packages for Finance application dat would transfer data among servers and perform other data transformations; scheduled the same SSIS packages by creating the corresponding job tasks.
• Migrated SQL Server 2000 DTS packages to SQL Server 2005.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Responsible for gathering/refining requirements from the customer for developing reports.
• Responsible for creating the reports based on the requirements using SSRS 2005.
• Created Cross-Tab, Drill-down, Drill-through Reports .
• Identified the data source and defined them to build the data source views.
• Identified and worked wif Parameters for parameterized reports in SSRS 2005.
• Responsible for scheduling the subscription reports wif the subscription report wizard.
• Deployed the generated reports directly on the client’s workstations.
• Developed, monitored and deployed SSIS packages.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Maintained the physical database by monitoring performance, integrity and optimized SQL queries for maximum efficiency using SQL Profiler.
• Performed backup/restore of database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Created SQL Server Database objects including Tables, Views and Indexes.
• Involved in all stages of the project life cycle, from Requirements Analysis through Design, Development, Testing & Implementation.

Environment: MS SQL Server 2005/2000, T-SQL, SQL Server Analysis Services (SSAS), DTS, SQL Server Enterprise Manager, SQL Server Integration Services (SSIS), SQL Server Query Analyzer, SQL Server BIDS, MS- Visual Studio 2005, Asp.net, C#.net, ADO.net, XML.

Confidential, Syracuse, NY

MS SQL Server Developer

Responsibilities:

• Created new Databases and maintained existing User / System Databases. Involved in Logical/Physical design of database and maintenance.
• Creating Database objects - tables, views, and functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Design and implementation of Security Model, policies and procedures.
• Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• Performing query plans and making sure each and every query is using appropriate useful indexes.
• Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other .
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Set up some tables in the main server as a snapshot publication and push them to the warehouse server (Subscriber) on the nightly basis. This eliminated the old way of emailing spreadsheet on the weekly basis.
• Successfully migrated data to new location using Snapshot Replication, and implemented Merge Replication to support up to date record of Inventory Information.

Environment: MS SQL Server 2000, Crystal Reports 8.5, Windows 2000 Advance Server, ASP, Erwin 4.1, VFP 7.0, VB 6.0, MS Excel, Oracle and MS Office.

Confidential, Piscataway, NJ

Database Developer

Responsibilities:

• Extensively created and used stored procedures and tuned them for good performance.
• Analyzed, designed and developed intranet Bug tracking system.
• Designed and created database and developed store procedures in SQL Server 2000.
• Managing schema objects such as tables, views, indexes, procedures, triggers. Performed tuning of SQL queries using Show Plans and Execution Plans.
• Participated in various meetings and conferences wif application team to meet corporate goals for project.
• Used notification services mainly to manage packages on success, completion and failure of deployments and other tasks.
• Generated ad-hoc reports using MS-Access and Crystal Reports, Tuned SQL queries using show plans and execution plans for better performance.
• Createddegenerative dimension wifin OLAP Hardware/Software.

Environment: SQL Server 2000, T-SQL, DTS, VB 6.0, Visual Source Safe, MS Office, and Windows 2000, Crystal Report, ODBC, MS Access.