SUMMARY:

• Over 7 years of experience in IT industry performing database design, development and database administration using SQL Server 2008/2005/2000 in DEV, UAT and PRODUCTION environments in financial, insurance and health care industry.
• Highly organized wif the ability to manage multiple projects and meet deadlines.
• A team player wif excellent interpersonal, communication and presentation skills.
• Involved in different phases of Software Development Life Cycle (SDLC).
• Experience in Software Analysis, Design, Development, Testing, Implementation and Production Support of Client/Server and Web based applications.
• Expertise in T - SQL (DDL, DML), Complex Queries, Tables, Views, Stored Procedures, Indexes, Cursors, User Defined Functions and Triggers.
• Experience in Installing, Configuring, Managing, Upgrading, Migrating, Monitoring and Troubleshooting of SQL Server SQL Server 2008/2005/2000.
• Experience in Extract, Transform and Load (ETL) data from Excel, Flat file, MS Access, Oracle to MS SQL Server by using BCP utility and DTS/SSIS services.
• Expertise in Configuration, Logging, Error Reporting and Variables in SQL Server Integration Services to make package portable during deployment and troubleshooting.
• Designed and developed OLAP Cubes wif star schema and dimensions using SSAS. Involved in querying and manipulating multidimensional cube data through MDX Scripting.
• Experience in performing Data Conversion, Data Scrubbing, and Data Transformations wif SSIS Packages and Stored Procedures.
• Strong working experience of Data Warehouse techniques and practices, experience including ETL processes, Dimensional Data Modeling (Star Schema, Snow Flake Schema), OLAP and Database performance tuning.
• Experience in designing and implementation of processes for deploying, upgrading, managing and extracting data for reporting using SQL Server Objects.
• Experience in creating SSIS packages using Active X scripts including appropriate Error Handling.
• Experience in creating jobs, SQL Mail Agent, Alerts and schedule DTS Packages.
• Experience in data normalization and data modeling using Erwin and Visio.
• Experience in Performance Tuning, T-SQL Query Optimization and Solving Blocking issues using Execution Plan, Profiler and DTA.
• Solid experience and outstanding noledge of high availability SQL Server solutions, including Log shipping, Replication, SQL Server clustering and space management.
• Good noledge of working wif MySQL, Oracle, DB2 and OOPS Concepts.

TECHNICAL SKILLS:

SQL Server Tools: MS SQL Server 2008, 2005, 2000, Management Studio, Business Intelligence Development Studio, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, DDL, DML, Stored Procedures, UDF, Triggers, DTS, Database Tuning Wizard, SSIS, SSAS, SSRS.

Operating Systems: Windows Server 2008/2003/2000 , Windows XP, Windows Vista, Windows 7.0

Data Migration: MSDTS, SSIS, BCP, Data Migration, Import/Export Wizard.

Languages/IDEs: C, C++, T-SQL, VB6.0

Data Modeling: Erwin 4.x, MS Visio 2000/2003.

Web Technologies: HTML, XML, Visual Studio 2008, MS FrontPage 98/2000

Reporting Tools: SQL Server 2008/2005 Reporting Services, Crystal Reports

Office Suite / Tools: MS Office 2010/2007

PROFESSIONAL EXPERIENCE:

Confidential, Waltham, MA

SQL Server Developer

Responsibilities:

• Installed and configured MS SQL Server 2008 on Windows XP Professional and Windows Server 2003.
• Actively participated as in team to gather requirements to develop BI Project and also designed physical and logical data warehouse.
• Participated in design of Staging Databases and Data Warehouse database using Star Schema which include Table Store Procedure and Indexes in SSMS
• Applied Configuration, Logging, Error reporting to all packages to make package deployment easy and troubleshoot package during run time easy.
• Loaded the data in Data ware House by using Slowly Changing Dimension (SCD - Type 1, 2, 3).
• Implemented Logic wif lookup table to maintain Parent- Child relationship and hierarchy.
• Used transformation like Merge Join, Lookup, Pivot, and Fuzzy lookup.
• Used Package Configuration to Migrate SSIS package from one environment to other.
• Used different control flow controls like for each loop container, Sequence container, Execute SQL task, Send mail task.
• Used event handler to send E-mail on event like on error.
• Designed OLAP cube using SQL Server Analysis Service. Design natural and navigational hierarchies in dimension.
• Created Profiling, Cleansing and Auditing plans wif SSIS Packages.
• Deployed cube on SSAS server and Created partitions on cube.
• Created different user level groups, and assigned appropriate permission level to the database using Credentials tool.
• Used Data Viewers in SSIS Packages to check the flow of data during Execution of Packages.
• Generated reports using SSRS dat could be used to send information to different managers of Different Branch.
• Standardized company reports by implementing SQL Server Reporting Services.
• Created different type of reports including: Cross-tab, Conditional, Sub reports, Drill-down and Parameter prompt.
• Designed and deployed reports wif Drop-down menu option and Linked reports.
• Deploying and scheduling reports using SSRS to generate daily, weekly, monthly and quarterly reports including current status.
• Deployed and Scheduled the Reports in Report Manager.
• Scheduled and maintained routine jobs, tasks, and alerts. For instance an alert would be sent to the manager of department, if the entire field is not entered by the data entry person regarding screening using SQL Server Agent
• Prepared user manual and technical support manual

Environment: MS SQL Server 2005/2008, SQL Server Integration Services, MS Access 2003/2000, Enterprise Management Studio, MS Query Analyzer, SQL profiler and SSRS.

Confidential, Memphis, TN

SQL Server Developer/ BI Developer

Responsibilities:

• Involved in the complete Software Development Life Cycle of the system and also in the design and development of the database for the system using various data modeling techniques.
• Participated in designing the logical model using Erwin based on the business requirement.
• Converted the logical design into the physical design by creating the corresponding databases and tables.
• Designed SSIS packages to migrate the data from different sources to ETL tier.
• Transferred flat files from different sources to the ETL tier by using BCP.
• Tested, cleaned and standardized data meeting the business standards using Fuzzy /exact lookups.
• Extracted, cleaned and validated from XML file into database using SSIS task (XML source).
• Created SSIS Packages by using advance tools (me.e. Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate).
• Created Stored Procedures dat generated XML reports from SQL Server tables and vice versa using Open XML, For XML, and XML Paths.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Database Statistics update and Re-Indexing.
• Used DDL and DML to write triggers, stored procedure to check the data entry and payment verification at early stages before calling them
• Created and executed the stored procedures and complex queries to generate reports.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes
• Optimized the performance of queries by modifying the existing index system and rebuilding indexes again wif respect to the me/O.
• Maintained data integrity by creating constraints and triggers.
• Facilitated easy user interface implementation and consistent data entry into the database by creating views wif triggers.
• Converted complex business logic into SQL Stored Procedures and User-defined functions to achieve functionality required by the UI team and to support efficient data storage.

Environment: Microsoft SQL Server 2005, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft Access 2003, Microsoft Excel 2003, XML, SQL Profiler, ER-Win, T-SQL.

Confidential

SQL Server Developer

Responsibilities:

• Created new database logical and physical design to fit new business requirements and implemented new design using SQL Server 2005.
• Migrated DTS packages to SSIS and modified the packages accordingly to the new features of SSIS and carried out a migration of databases from SQL Server .
• Participated in database logical design to fit new business requirement, and implemented new design in SQL Server 2005
• Filtered bad data from legacy systems using T-SQL statements, and implemented various constraints and triggers for data consistency.
• Dropped and recreated Index on the DSS system during the migration of data.
• Wrote complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Deployed reports to Report Manager and Troubleshooting for any error occurrences during execution.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also emailed them to director and analysts to review in Excel Sheet.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization
• Maintained remote and central databases for Synchronization of data and prepared plans for Replication.
• Documentation of all the processes involved in maintaining the database for future .
• Develop documentation dat sufficiently describes technical deliverable as required for internal controls and maintaining documentation of the database for future .

Environment: s: SQL Server 2000/2005, SQL Server Integration Services, MS Excel 2003, MS Access 2003, Enterprise Manager, Management Studio, SQL Profiler, and SSRS.

Confidential

SQL Server Developer

Responsibilities:

• Created and configured the database, wif 2 file groups, created the tables having required constraints.
• Analyzed business requirements and built logical data models dat described all the data and relationships between the data.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2000.
• Worked on Log Shipping, Replication to restore Database backup.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/development environment to production. Coordinated and communicated production schedules wifin development team.
• Modified database structures as directed by developers for test/develop environments and assisted in coding, design and performance tuning.
• Backup and restore databases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created the DTS Packages through ETL Process to vendors in which records were extracted from Flat file and Excel sources and loaded daily at the server.
• Updated the statistics information for both the old and new servers.
• Managing logins, roles, assigning rights and permissions. Created views to implement security.
• Backing up master & system databases and restoring them when necessary. Supported production environment.
• Managing logins, roles, assigning rights and permissions. Created views to implement security.

Environment: - MS SQL Server 2000 Query Analyzer, Enterprise Manager, DTS Designer, SQL Profiler, Index Tuning Wizard, MS Access & Windows XP platform.