SUMMARY

• 7+ years of experience in SQL Server 2005/2008 as Developer/DBA with 3+ years of experience in SSIS/SSRS.
• Experience in Integration Service (SSIS), Reporting Service (SSRS) with Error Handling and Error logging techniques.
• Expert level skills in Data Modeling, Table Normalization, Optimization and Performance Tuning.
• Experience in migration/cleansing using store procedure, functions and cursors.
• Experience in large volume data processing especially Data Analysis, Integration, Migration, ETL design/Implementation, and Data Warehousing.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points.
• Extensive experience in performance tuning with Clustered and Non - Clustered Index.
• Expert in implementing business logic in backend using Stored Procedures with Dynamic SQL.
• Build and maintain SQL scripts and complex queries for data analysis and extraction.
• Excellent in developing OLAP cube and MDX queries for slicing and dicing of the cubes in SQL Server 2005 Analysis Services.
• Experience in data migration (using tools like DTS, BULK INSERT, BCP, XML and Replication) between different homogeneous/heterogeneous systems and SQL Server.
• Experience in Database administration activities like Backup & Recovery, log shipping, mirroring and Query optimization.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Experience in SQL Server Reporting Services (SSRS) designing various kinds of ad-hoc and drilled-down reports.
• Experience on database driven application using Visual Basic, ASP in .NET framework.
• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2005,MS Access

SQL: SQL Server Management Studio, SQL Server Business Intelligence Development Studio, T-SQL, Data Transformation Services

Operating Systems: Windows 7, Vista, XP, 2003.

Programming Languages: C++, XML, T-SQL

Business Tools: Word, Excel, Power Point, Outlook.

PROFESSIONAL EXPERIENCE

Confidential, NJ

SQL developer

Responsibilities:

• Involved in gathering different plans available from the legacy system (DB2 system) and third party.
• Designed and created mapping document in order to map the plans coming out from legacy system to the dimension table
• Involved with the Product and the Member DB team in order to bring the information into the EDW.
• Designed and implemented the EDW with facts and the dimension table on Star schema.
• Designed staging area in order to carry out data massaging and scrubbing to handle the inconsistent data and handling invalid records using SSIS transformation task ( lookup task, data conversion task, derived columns)
• Created complex Stored Procedures, Triggers, and Functions for validation process and for loading data from the staging area to the product database.
• Designed SSIS modules to transform and rollup 650 plans coming in from the sources to equivalent 90 plans.
• Implemented several stored procedures and function in order to map the many to many relationship from legacy system load to final dimension tables in the EDW.
• Designed and configured SSIS package to call dynamic stored procedure use expression to carry out data loads.
• Deployed and scheduled SSIS packages on the Autosys server.
• Implemented several Error logging techniques using the file based logging for debugging purpose.
• Configured SSIS modules using checkpoint file.

Environment: MS SQL Server 2008, MS SQL Server Reporting Services, Windows Server 2003 Enterprise Edition, SQL Query Analyzer, Internet Information Services (IIS) version 6.0.

Confidential, Tennessee

SQL Developer/DBA

Responsibilities:

• Interacted with Development Teams and Managers to analyze business needs and developed technical specifications
• Designed and implemented schema in more than five databases for various different kinds of storage as per the business requirement
• Created stored procedures and user defines functions to supports efficient data storage and manipulation.
• Developed objects (i.e. tables, views and stored procedures, functions, triggers, indexes) in SQL Server 2005 to get a batter and faster performance.
• Defined check constraints, rules, indexes and views based on business requirements.
• Implemented data staging environment in SQL 2005 for importing, parsing, scrubbing by using SSIS Packages and numerous complex stored procedures.
• Designed stored procedures to create XML for feeding data in the complex data-marts in the data warehousing environment.
• Performed intensive Data quality on various data migration and written various post scripts to perform data correction.
• Used of different transformation in SSIS like aggregation, conditional split, multicast, raw sampling etc. for meeting the needs of the Data Marts for data feed
• Actively monitored performances of the system in order to regulate efficient data load and batch processing.
• Generation of the weekly Drilled down Reports using SSRS for internal consumption deployed on IIS server.
• Actively involved in performance tuning and query optimization techniques.
• Worked with DBA’s and Business Needs team for deploying the packages and reports, using integration and reporting services.
• Documented all the processes for later easy reference.

Environment: Microsoft SQL Server 2005, SSIS, SSRS, Windows XP, Visual Studio 2005

Confidential, Cincinnati, OH

SQL Server Developer

Responsibilities:

• Worked with Business analyst and business users to understand business processes, documented project requirements.
• Used multiple SSIS packages for collecting data from heterogeneous sources like Excel, CSV, Oracle and flat file, Text Format Data to SQL Server databases using SSIS and loading to staging server.
• Performed various transformations like for each loop, Derived column, Multicast, conditional split, export column for elimination of duplicate Data, Null values, and converting data into require formats at staging environment before loading to Data Warehouse.
• Designed SSIS to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.
• Loading data in Dimension Tables in SQL Server using SSIS Packages.
• Performing Backup after data is secure, before loading to production environment.
• Created Parameterized reports, Linked reports, Snapshot reports, Cached reports, Ad hoc reports, Drilldown reports, Sub reports from Data Warehouse using SQL Server Reporting Services (SSRS).
• Involved in scheduling, creating snapshot and subscription for the reports and triggers to facilitate consistent data entry into the database.
• Embedded reports into web pages using ASP.NET Report Viewer Web Control.
• Troubleshooting DB performance issue and implementing necessary DB changes and implemented processes to ensure Optimal Query Performance by using SQL profiler.
• Created views and indexed views to reduce database complexities for the end users.
• Run Import/Export wizard to provide Excel files to Managers for particular reports.
• Used SQL Server Analysis Services (SSAS) to design cubes for summary reports.

Environment: Windows Server 2003/2008, SQL Server 2005/2008, IIS 6.0, ASP.NET, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

Confidential, woodlands hill, CA

SQL Developer

Responsibilities:

• Responsible for writing scripts in T-SQL to create stored procedures, views, triggers.
• Designed the Data warehouse data models using Erwin.
• Implemented Star Schema for OLAP cubes using SSAS.
• Created SSIS packages from scratch to move data from flat file, Excel and OLE DB sources.
• Used the concepts of Lookup, Derived Column, auditing, unpivot, priority constraints, conditional split to validate data for SSIS packages.
• Created SQL server configurationsforSSISpackages.
• Responsible for creating SSAS cubes using MS SQL Analysis Services to analyze the existing business.
• Responsible for cube deployment and processing.
• Created different type of reports including Cross-tab, Conditional, Drill-down, Sub reports also parameterized reports.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Responsible for creating T SQL scripts to create report models.
• Documented all database objects, which were used in the project and for further upgrades and maintenance.

Environment: MS SQL Server 2005/2008, SSIS, SSAS, SSRS, T-SQL, Windows 2003/2005/2008.

Confidential

SQL Developer

Responsibilities:

• Developed physical data models and created DDL scripts to create database schema and database objects
• Designed data models using Erwin.
• Wrote user requirement documents based on functional specification.
• Developed source to target specifications for Data Transformation Services.
• Developed functions, views and triggers for automation
• 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.
• Created indexes, Constraints and rules on database objects for optimization

Environment: MS SQL Server 2005, MS Access, DTS, Erwin, SQL Query Analyzer.