SUMMARY

• Over 7+ years of IT experience in software development, designing and implementation with major focus around Business Intelligence, Data Warehousing and Database Applications.
• Experience in requirements gathering, data analysis & validations and resolving data quality issues.
• Good experience in building Dimensional Models in various business domains like Mortgage, Banking, Insurance and Pharmaceutical verticals.
• Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Hands on experience in designing of conceptual, logical and physical data models for OLTP/OLAP systems using Ms SQL Server, Oracle and MySQL.
• Involved in creating stored procedures, triggers, functions, Indexes, tables, views and other T - SQL code and SQL joins for applications by maintaining best standards to perform efficiently.
• Expertise in Analyzing and Optimizing the slow-running queries, cost-based queries using SET operations, Query plans, Statistics and Indexes.
• Hands on experience in implementing Data Warehousing solutions using ETL tools like Microsoft SQL Server Integrations Services (SSIS) and Informatica Power Center and reporting tools like Ms SSRS.
• Hands on experience in Extraction, Transformation and Loading data from Ms SQL Server, Oracle, DB2, Ms Access, Excel and flat files using Ms SSIS and Informatica Power Center.
• Involved up gradation and migration from MS SQL Server 2005 to MS SQL Server 2008.
• Good Business and System Analysis skills to understand the requirements and customize client applications.
• Ability to work with an aggressive and demanding project schedule and environment.
• Self-starter, with strong analytical and troubleshooting skills, ability to work independently or as part of a team.
• Strong communication and interpersonal skills.
• Working experience in designing, implementing, maintaining, and documenting complex database applications and data warehouse in financial environments.
• Familiar with Onsite - Offshore model and Agile methodology.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN.
• Ability to adapt to fast changing skills and work
• Has strong Object Oriented Analysis, design and programming technical skills, ability to learn new emerging technologies and adapt quickly.

TECHNICAL SKILLS

ETL Tools: Microsoft SSIS, Datastage XE 7.5/7.1/6.0/5.2/5.1 (Parallel Extender, Quality Stage)

OLAP Tools: Microsoft SSRS, Business Objects 6.1/5 (Supervisor, Designer, BO Reporter, BCA, Info View)

Data Modeling Tools: Microsoft Vision, Erwin 4.1/3.5

Databases: Microsoft SQL Server 2012/2008/2005/2000 , Oracle 9i/8i/7.x, DB2 UDB, MySQL

Tools: SQL*Plus

Operating Systems: Windows 2003/2008 server, Win 9x/NT/2000/XP, UNIX

Programming: SQL, PL/SQL, Unix Shell Scripting, Java, VB.NET HTML, DHTML,AWK,SED

PROFESSIONAL EXPERIENCE

Confidential, Sacramento, CA

MS SQL Server Developer

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created new tables, written stored procedures for application developers and some User- defined functions. Created SQL scripts for tuning and scheduling.
• Developed backup restore scripts for SQL Server as needed.
• Created scripts and SQL jobs to facilitate database backup and recovery, server and data processing monitoring and alerting.
• Create joins and sub-queries for complex queries involving multiple tables.
• Created DTS package to schedule the jobs for batch processing
• Designed and implemented user log in and security.
• Performed data conversions from flat files to a normalized database structure.
• Created and managed users, roles and groups and database security.
• Updated existing models to integrate new functionality into an existing application.
• Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL Queries and Stored Procedures.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Defined Check and default constraints, Indexes, and Indexed Views.
• Configured Server for sending automatic mails to the respective people when a DTS Process fails or succeeds.
• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS) and bulk copy.

Environment: Ms SQL Server 2012,Ms SQL Server 2008 R2, DTS, Query Analyzer, BCP, SQL Profiler, Import & Export Data.

Confidential, Sacramento, CA

MS SQL Server Developer

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views usingT-SQL in Development and deployed over in TFS.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Generated Matrix reports, tabular, drill-down, drill-through, sub reports, chart reports, multi parameterized reports thru Report Manager.
• Implemented multiple grouping into several reports using visibility and toggle options on SSRS.
• Generated various charts like Pie Charts and Line Charts for easy analysis of the reports
• Developed Cascading Reports for Employee Reports, Ad-hoc Reports using Report Builder, SSRS.
• Integrate SQL Server 2005 reporting services with Microsoft Share point Portal Server to deliver automatically generated reports to the Share Point portal
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Involved in implementing SSIS package security, checkpoints, protecting packages, executing, monitoring and managing them.
• Migrated data from the MS Access database using SSIS Packages.
• Extensively involved in designing the SSIS packages to export data to flat file and Excel destination from SQL Server database and Worked with different methods of logging in SSIS to track the status of the package.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.

Environment: Ms SQL Server 2005, DB2, Ms SSIS 2005, Ms SSRS 2005, TFS, Visual Studio, DTA, Report Builder 2.0

Confidential, Silver Spring, MD

MS SQL Server Developer

Responsibilities:

• Created new tables, written stored procedures for application developers and some User- defined functions. Created SQL scripts for tuning and scheduling.
• Performed data conversions from flat files to a normalized database structure.
• Created and managed users, roles and groups and database security.
• Created Triggers to enforce data and referential integrity.
• Defined Check and default constraints, Indexes, and Indexed Views.
• Configured Server for sending automatic mails to the respective people when a DTS Process fails or succeeds.
• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS) and bulk copy. Periodic monitoring of the system for bottlenecks.
• Created and maintained Indexes for various fast and efficient reporting processes.
• Analyzed database growth, space requirement and User/Login Roles.
• Managed test data and their updates between development and production databases and migrated stored procedures and database objects.
• Added replication definition and its function on Reporting Server and monitored replication.
• Configured Snapshot replication for reporting, user acceptance test and development servers. Created code documentation using Visual source safe.
• Experience in Configuring and Managing Linked Servers, data transfer between SQL Server and other heterogeneous relational database such as Oracle and DB2.

Environment: MS SQL Server 2000, MS SQL Server 2005, DTS, Query Analyzer, BCP, SQL Profiler, Import & Export Data.

Confidential, Basking Ridge NJ

MS SQL Server Developer

Responsibilities:

• Worked as a Developer on Databases like MS SQL Server 2000, MS Access (using DTS, T-SQL, scripts, stored procedures and views)
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project
• Managed requests that came from the client as well as the development teams
• Involved in Design and Developed the Logical and Physical Model of the database
• Worked as a Developer in creating Complex Stored Procedures, and other SQL Joins and statements for applications
• Developed complex T-SQL code for the application
• Developed User Defined Functions and created Views
• Created Triggers to maintained the referential integrity
• Implemented Exceptional Handling
• Generated reports using MS Reporting Services
• Generated various charts like Pie Charts and Line Charts for easy analysis of the reports
• Worked on Complex Data Loading (implemented the batch data cleansing and data loading)
• Creating and automating the regular Jobs
• Rebuilding Indexes and Tables as part of performance tuning exercise

Environment: Ms SQL Server 2005, Ms SSIS 2005, DTS, BCP, MS Access, Load Runner, QTP and Win Runner, SQL Profiler

Confidential

MS SQL Server Developer

Responsibilities:

• Actively involved in Normalization of database.
• Designed DDL and DML for MS SQL Server 2000
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL Queries and Stored Procedures.
• Involved in merging existing databases and designed new data models to meet the requirements. .
• Resolved any deadlocks issues with the Databases/Servers on a real-time basis.
• Create joins and sub-queries for complex queries involving multiple tables.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created many complex Stored Procedures / Functions and used them in Crystal Reports directly to generate reports on the fly.
• Designed crystal reports based on requirements and hosted it in the web for the users.

Environment: MS SQL Server 7.0/2000, T-SQL, DTS, SQL Server Enterprise Manager, SQL Profiler, Crystal Report 8.5