SUMMARY

• High proficiency with around 7 years of IT experience in database design, development and support of Microsoft SQL Server 2005/2008 for Production/Development environments.
• Hands on experience in dealing with Relational Database Management Systems.
• Extensive experience in T - SQL to creating Indexes, Joins, Data Import/Export, User defined functions, complex Stored Procedures, Triggers and Cursors
• Experience in usingT-SQL (DML, DDL)in SQL Server 2012 platform
• Worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server.
• Performed several transformations and data cleansing on data including lookup, slowly changing dimension, union all, merge join, and check points/break points.
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Reporting solutions using Microsoft by Play Now Radio">SQL Server Reporting Services (SSRS)
• Extensive knowledge of transforming data and loading data from different sources to different destinations through SSIS
• Integrated and transformed data from different data sources like Oracle, DB2, Excel, and Flat Files to SQL Server 2008R2 using OLE DB connection providers by creating various SSIS packages
• Hands-on experience in development of strategic and complex reports using most of the features and tools included within the report builder (list, matrix, graphs, sub-reports, tablix)
• Good knowledge of Database Administration operations like Backup and restore strategies.
• Experience indata warehousingincludingbusiness intelligence tools- DTS, SSIS
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages
• Experienced in handling Slowly Changing Dimensions while loading data into data warehouse.
• Excellent verbal, communication and interpersonal skills to understand business requirements in various domains and ability to interact with clients.

TECHNICAL SKILLS

Langages: C, SQL, TSQL, Oracle, PL/SQL, HTML, DHTML, XML

Databases: MSSQLServer 2005/2008/2008 R2/2012, Access 97/2000/2003/2007 , My SQL

Database Management tool: SQL Server Management Studio, SSIS, SSRS

Data Modeling Tools: Microsoft Visio, My SQL

Reporting Tools: SQL Server Reporting Services (SSRS)

Operating System: Windows 95/98/NT/2000/XP, UNIX, Linux

ETL & OLAP Tools: SQL Server Integration Services (SSIS) 2005/2008/2012

Other Tools: MS Visual Studio, MS-Office

PROFESSIONAL EXPERIENCE

Confidential, NY

SQL Developer

Responsibilities:

• Created complex T-SQL queries, stored procedures, and user defined functions (UDF’s)
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible
• Modified stored procedures to implement the complex business needs
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, established joins and created indexes whenever necessary.
• Documented all database objects, procedures, views, functions & packages for future references.
• Created SSIS package to extraction and load data into the Data warehouse and Report-Data mart
• Created SSIS packages (ETL) to migrate data from heterogeneous sources such as MS Excel, Flat Files, .CSV files, Oracle etc.
• Created SSIS package to load data from Flat File to Flat File and Flat File to Data warehouse and Report-Data mart using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation and Slowly Changing Dimension.
• Experience in Developing, Monitoring and Deploying SSIS packages.
• Experience in generating on-demand and scheduled reports for business analysis or management decision.
• Configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS)
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS)
• Generated parameterized/Drilldown, drill through using SSRS

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSIS, SSRS)

Confidential, Sunnyvale, CA

SQL Developer

Responsibilities:

• Plan, design, and implement application database code objects, such as tables, stored procedures, functions and views in partnership with business analysts and technical architects.
• Implemented complex business logic and processes through T-SQL stored procedures, Functions, Views and advance query concepts.
• Reported financials to the management with variety of SSRS reports and dashboards for better and effective decision making.
• Good experience interacting with end users for understanding bussiness processes and implementing the same through T-SQL for process automation.
• Designed complex and custom reports using SSRS with drilldown features, sub reports, charts.
• Compressed data files by removing empty database pages and updating index statistics.
• Created SSIS packages to transform data from different data sources into application required formats for e.g. Unpivoting.
• Designed and deployed SSAS cube for reporting P&L's in an effective and efficient way to users and to overcome the drawbacks of excel pivots.
• Testing software to ensure the code is correct, fixing ('debugging') errors where they occur, and rerunning and rechecking the programme until it produces the correct results.
• Working with trainers and technical writers to develop user support materials.
• Automated redundant and repetative tasks using different tools and objects available in SQL Server.
• Timely support and maintenance of the application to ensure uninturepted business deliverables.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSIS, SSRS)

Confidential

SQL Developer

Responsibilities:

• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
• Enhanced the business logic using User Defined Functions to retrieve information on the services like billing and customer requests from various databases
• Designed and developed dimension and fact tables using star schema to extend the existing data warehouse
• Transformed data from different data sources like Oracle, DB2 to SQL Server 2005 using OLEDB connection providers by creating various SSIS packages
• Involved in the usage of variables to make the packages dynamic and scheduling the package in SSIS
• Maintained records in Excel Spread Sheet and exported data into SQL Server Database using SQL Server Integration Services (SSIS)
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all
• Generated Sub-Reports, drill down reports, drill through reports and Parameterized reports using SSRS
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status
• Highly responsible for development and management ofSSISand SSRS projects
• Scheduled reports to run weekly, monthly and quarterly to be reviewed by the manager.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSIS, SSRS)

Confidential

SQL Developer

Responsibilities:

• Involved in installation and configuration of SQL Server 2000 and SQL Server 2005 with latest Service Packs.
• Database Design, Optimization of queries and Database, Performance Tuning using Index Wizard, SQL Profiler and Query Analyzer. Installed SQL Server Desktop Database and Standard Database.
• Created Stored Procedures, User Defined Functions, and Triggers to work consistently with the dynamic databases.
• Investigating and fixing the root cause of the problems that are encountered on in production environments on day to day basis.
• Wrote and maintained database documentation, including data standards, procedures, definitions for data dictionary and logical and physical models of the database.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Involved in SQL Tuning by creation of Indexes, Rebuilding Indexes, and Clusters
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XML etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)
• Involved in Data Migration and used SSIS to import and export data into the tables using SQL Server 2005
• Loading and extracting data into multiple tables using SSIS
• Designed reports, Graphs and deployed reports to web applications using SSRS
• Provided 24/7 production support for the production database and also to the code deployed into the production environment.
• Involved in analyzing business requirements and design documents.
• Involved in interacting with business people on daily basis for better understanding and implementation.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSIS, SSRS)