SUMMARY

• Around 5 years of IT experience in Database Designing, Data Warehousing with MS SQL Server 2005/2008/2008 R2/2012 in OLTP and OLAP environments along with experience in Microsoft Business Intelligence tools viz. SSIS, SSAS and SSRS.
• Developed and created Logical and Physical Database architecture using ER - win Data Modeler.
• Worked on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflake schema.
• Well versed in designing and optimizing various T-SQL database objects like tables, views, stored procedures, functions, indexes and triggers using Management Studio and SQL Profiler.
• Created triggers on tables as well as database for auditing and to provide security for un-authorized user access to the tables and database.
• Created complex stored procedures for Data Profiling, backing up all the databases in a server and for other maintenance tasks.
• Experience in creating efficient ETL Strategies for initial and incremental load into a data warehouse.
• Skilled in creating SSIS packages providing specific functionality like data profiling and data cleansing which could be customized to the specific database source for a clean ETL process.
• Utilized the fuzzy logic transformations like fuzzy grouping and fuzzy lookup as cleansing techniques and also have excellent knowledge of other transformations like derived columns, lookups, SCDs, and conditional splits.
• Worked with XML and SQL Server configurations for modifying the SSIS packages from a test /development environment to the production servers for day-to-day operation.
• Skilled in proper scheduling for the execution of automated procedures, scripts, and packages for off peak hour operations using SQL Server Agent.
• Expertise in providing multiple types of reports from SSRS including drill-down, drill-through, linked and sub-reports.
• Created ad-hoc reports to the specific users in the requested format.
• Extensively used subscriptions in delivery of reports.
• Utilized Reporting Manager to secure the reports with windows user groups and roles for individual reports and also report folders.
• Hands on experience working on different type of report subscriptions and report caching.

TECHNICAL SKILLS

RDBMS Packages: SQL Server 2005|2008|R2|2012

Data Modeling: ER-Win, MS Visio

Database Languages: SQL, T-SQL, PL/SQL

Other Languages: Java, C++

Business Intelligence Tools: BIDS, DTS, SSIS, SSAS, SSRS, OLTP, OLAP, and ETL

Operating Systems: Windows 2000|2003|2008 Server, Windows XP| Vista| 7|8

PROFESSIONAL EXPERIENCE

Confidential

Database Developer

Responsibilities:

• Responsible for backend database developing of products. Attended scrum meeting, worked and communicated with project manager and front end UI team developers.
• Applied constraints for data integrity like Referential integrity with the use of primary and foreign keys.
• Created all database objects like tables, views, user defined functions, stored procedures and indexes with optimization in point of view in support of the databases.
• Designed and implemented SSIS packages including using various of control flow items and data flow transformations, such as Sequence Container, For Loop Container, lookup, Conditional Split, Derived Column etc.
• Used SQL Server Agent for creating, maintaining and scheduling Jobs.
• Used SQL Server Profiler to monitor running process on the server to coordinate with front end UI team.
• Implemented HTML daily email reports with error handlings using SQL stored procedures to send out daily emails based on daily data loading status.
• Created and maintained complex store procedures to cleanse and process data that were loaded from API to SQL server database. At the same time, generate logs and catch errors then load the messages into tables with detailed information.
• Investigated and debugged queries and SSIS packages to solve specific issues.
• Create SSRS reports with various functionalities such as drill down, drill through and sub-report etc.
• Create database documentations for complex store procedures and SSIS packages.

Environment: SQL Server 2008/ R2|2012, SSRS, SSIS, Access, MS Visual Studio 2008/2010, JIRA

Confidential

SQL/BI Developer

Responsibilities:

• Responsible for complete data modeling design, ERDs using MS VISIO and Erwin to be utilized in ETL development using SQL Server Integration Services (SSIS).
• Applied constraints for data integrity like Referential integrity with the use of primary and foreign keys.
• Created all data base objects like tables, views, triggers, stored procedures and indexes.
• Implemented various types of SSIS Transforms in Packages including Slowly Changing Dimension, lookup, Fuzzy Lookup, Conditional Split, Derived Column, Data Conversion etc.
• Used SQL Server Agent for creating, maintaining and scheduling Jobs.
• Optimized procedures and functions utilized by ETL Packages to reduce ETL Process time.
• Managed indexed database tables and views for peak performance as well as partitioned existing tables and indexes across several drives on the network.
• Implemented Master/Child Packages so only the Master Package has to be scheduled which will in turn fire the other packages.
• Responsible for monitoring all the packages that are scheduled, running completed and failed. Involved in debugging the Packages that failed.
• Redirected Error Outputs to Error Tables to identify dimensions and facts that were not properly populated.
• Implemented error & failure handling in SSIS packages using event handlers, row redirects, check points and used SSIS/Custom logging for monitoring the execution.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Designed ad hoc SSRS reports in the test environment for data validation.

Environment: SQL Server 2008/ R2|2012, Erwin, Business Intelligence Studio (BIDS), SSIS, Access, MS Visual Studio 2008/2010, Tableau Desktop, TFS.

Confidential

SQL Developer

Responsibilities:

• Designed relational database based on bussiness requirements.
• Created database objects like tables, stored procedures, functions and indexes, etc.
• Created complex SQL queries.
• Used SSRS to generate reports.
• Debugged and optimized slowing running SQL queries and stored procedures
• Created and mananged SQL server agent jobs.

Environment: SQL Server 2005, SSRS, MS Excel, MS Visual Studio 2005