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 teh 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 knowledge of high availability SQL Server solutions, including Log shipping, Replication, SQL Server clustering and space management.
• Good knowledge 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 teh 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 teh database using Credentials tool.
• Used Data Viewers in SSIS Packages to check teh flow of data during Execution of Packages.
• Generated reports using SSRS that 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 teh Reports in Report Manager.
• Scheduled and maintained routine jobs, tasks, and alerts. For instance an alert would be sent to teh manager of department, if teh entire field is not entered by teh 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 teh complete Software Development Life Cycle of teh system and also in teh design and development of teh database for teh system using various data modeling techniques.
• Participated in designing teh logical model using Erwin based on teh business requirement.
• Converted teh logical design into teh physical design by creating teh corresponding databases and tables.
• Designed SSIS packages to migrate teh data from different sources to ETL tier.
• Transferred flat files from different sources to teh ETL tier by using BCP.
• Tested, cleaned and standardized data meeting teh 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 (i.e. Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate).
• Created Stored Procedures that generated XML reports from SQL Server tables and vice versa using Open XML, For XML, and XML Paths.
• Created Database Maintenance Planner for teh 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 teh data entry and payment verification at early stages before calling them
• Created and executed teh stored procedures and complex queries to generate reports.
• Used DBCC commands to check physical and logical consistency of teh databases and rebuild indexes
• Optimized teh performance of queries by modifying teh existing index system and rebuilding indexes again wif respect to teh I/O.
• Maintained data integrity by creating constraints and triggers.
• Facilitated easy user interface implementation and consistent data entry into teh database by creating views wif triggers.
• Converted complex business logic into SQL Stored Procedures and User-defined functions to achieve functionality required by teh 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 teh packages accordingly to teh 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 teh DSS system during teh 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 teh database.
• Deployed reports to Report Manager and Troubleshooting for any error occurrences during execution.
• Scheduled teh 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 teh processes involved in maintaining teh database for future .
• Develop documentation that sufficiently describes technical deliverable as required for internal controls and maintaining documentation of teh 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 teh database, wif 2 file groups, created teh tables having required constraints.
• Analyzed business requirements and built logical data models that described all teh data and relationships between teh 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 teh 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 teh DTS Packages through ETL Process to vendors in which records were extracted from Flat file and Excel sources and loaded daily at teh server.
• Updated teh statistics information for both teh 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.