SUMMARY

• More than 9 years of combined industry experience as a backend developer using SQL Server 2000/2005/2008/2012 and Business Intelligence Development Studio (BIDS)
• Created data models for relational schemas (OLTP) and dimensional schemas (OLAP) with proper normalization and de - normalization techniques.
• Design of databases through conceptual Entity Relationship Diagrams, Erwin and ER/Studio
• Hands on experience in creating database objects like Tables, Views, Stored Procedures, Triggers, User defined functions, indexes.
• Created partitions on tables, indexes and indexed views as well as querying and managing partitions.
• Excellent experience working on different types of indexes like clustered, non-clustered, filter, covering index according to business needs.
• Highly Proficient in creating complex stored procedures and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency.
• Optimized T-SQL queries as well as the stored procedure used to feed reports for better latency performance.
• Excellent T-SQL programming skills and highly efficient in performance tuning.
• Extensive experience in using SQL profiler and Database Tuning Advisor (DTA) for performance tuning, query optimization and database optimization.
• Automated Administrative tasks, event notifications, and scheduled maintenance plans using SQL Server Agent according to Microsoft best practice.
• Scheduled maintenance plans according to Microsoft best practices and implemented sound Backup and Restore Strategies.
• Experience in requirements gathering, analysis & design of ETL processes using SQL Server Integration Services (SSIS).
• Extensive experience in creating ETL packages, validating data, optimizing, deploying and scheduling packages, using SQL Server Integration Services (SSIS)
• 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 SQL Server configurations for modifying the SSIS packages from a test/development environment to the production servers for day to day operation.
• Experienced in extraction & migration of data from heterogeneous data sources like Flat Files, Excel, and MS Access to MS SQL Server by using import/export Wizard, SSIS.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008/R2/2012).
• Implemented Error handling strategies by providing Custom/SSIS Logging, Checkpoint, Error redirection using Event Handlers for SSIS Packages.
• Used Script Task and Script Component in SSIS for Data Extraction and used C# language for write the Script.
• Created SSIS script task, look up transformations and data flow tasks using T- SQL and C# scripts.
• Worked with SQL Server SSIS packages that include designing and implementing ETL process which involves data extraction from various heterogeneous sources like SQL Server, Excel, Oracle, DB2 and CSV.
• Proactively handled errors in ETL packages using Event Handlers and secured packages with Encryption in conjunction with Passwords.
• Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with C#.NET in SSIS.
• Created Master Child Packages to break large packages for better analysis.
• Created and optimized OLAP Cubes by creating partitions, assigning MOLAP, HOLAP, ROLAP storage modes, designing aggregations and implementing proactive caching mechanisms in SSAS.
• Experience in creating Ad-hoc reports, Data Driven Subscription by using Report Builder in SSRS.
• Generated various types of reports like Drill-Down Reports, Drill-Through Reports, Parameterized Reports, Cascading Parameterized Reports, Chart Reports, Linked Reports and Sub Reports in SSRS.
• Experience in working with Power Pivot and Power View to make better analysis and presentation of the data.
• Worked with SharePoint and Team Foundation Server for synchronization, bug tracking and deployment.
• Used MKS and TFS for project tracking and source control
• A well-organized, goal-oriented, highly-motivated effective team member with excellent analytical, troubleshooting, and problem solving skills

TECHNICAL SKILLS

DATABASES: Microsoft SQL Server 2000 / 2005 / 2008/ 2012

DATABASE TOOLS: SQL Server Management Studio, ER-Win, Profiler, ER/Studio

DATABASE LANGUAGES: SQL, T-SQL

BUISNESS INTELLIGENCE: Microsoft BIDS SSIS, SSAS, SSRS 2005/2008/R2, SSDT

DATABASE MODELING: ER-Diagrams, Dimensional Diagrams, Star and Snowflake Schemas

LANGUAGES: HTML/XML, C#.Net

OPERATING SYSTEMS: Windows 2003/2008 Server, Windows XP/2000

PROFESSIONAL EXPERIENCE

Confidential

Lead SQL Developer

Responsibilities:

• Created System requirement-gathering document based on extensive JAD sessions, that yielded the conceptual design.
• Architected the Dimensional data warehouse project approach, based on source data, requirement as well as infrastructure.
• Designed rigorous ETL strategy to insure accuracy, consistency and integrity of the data warehouse.
• Designed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to the business.
• Designed a database optimization plan involving the creation of Table Partitions and the use of appropriate Indexes as recommended by Microsoft’s Index Guidelines and used SQL profiler/DTA.
• Developed complex mappings using SSIS to transform and load the data from various source systems like Excel, Flat files, Oracle into the SQL 2012 Server target staging database.
• Designed and deployed SSIS packages using various Transformations such as Multicast, Merge Join, Lookup, Fuzzy Lookup, Fuzzy Grouping, Aggregate, Conditional Split, and Derived Column Transformations.
• Used master-child SSIS packages for better design and ease of maintenance.
• Implemented error & failure handling in SSIS packages using event handlers, row redirects, and checkpoints and used loggings for monitoring the execution.
• Used Script Task and Script Component in SSIS for Data Extraction and used C# language for write the Script.
• Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with C#.NET in SSIS.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and C# scripts.
• Used Web Services to fetch data from Different types of sources and used C# (Object Oriented Concepts) as Script language.
• Deployed SSIS packages to the production server using XML and SQL server configurations.
• Used SQL 2012/2008R2 Server Analysis Services to design cubes with dimensions and facts and created different cube objects like KPIs, Drill through Actions, Perspectives, Aggregations, and Translations.
• Optimized the cubes by creating usage based optimization and assigning proper storage modes (MOLAP, HOLAP, and ROLAP) to different partitions.
• Created several reports using SSRS like drill through reports, linked and sub reports.
• Managed very large reports that return a huge volume of records and optimized their performance using techniques like cascading parameters and filters.
• Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems.
• Optimized reports by optimizing the embedded queries, or optimized the stored procedures that generate them.
• Supported the logging framework by generating reports to identify the trends and set up the strategy to find bug trends, code changes using Team Foundation Server.
• Improved the performance of reports by optimizing data sets, making use of report caching and snapshots along with taking into consideration networking aspects.
• Used Script Task and Script Component in SSIS for Data Extraction and used C# language for write the Script.
• Built Tableau reports to assist visual data analysis and created concise and actionable dashboards.
• Created reports to retrieve data using stored procedures that accepts parameters and provided data visualization using Tableau.
• Implemented data visualizations on Power Pivot.

Environment: Microsoft SQL Server 2005/2008, SSIS, SSRS 2005/2008, SQL Server Management Studio, ER/Studio, C#.Net

Confidential

Sr. SQL/BI Developer

Responsibilities:

• Involved in JAD sessions with business analyst to understand the client system and requirements.
• Developed several stored procedures to avoid SQL Injection and converted cold fusion code into SQL Stored Procedures.
• Involved in creating several staging tables from Data mapping documents and developed several complex packages to import data (property) from client system to Equator system.
• Developed complex stored procedures to validate the data in several stages and successfully import into our systems.
• Modification of existing SSIS packages for error logic rectification and implementation of optimization techniques.
• Included checkpoints and custom loggings and handled errors by redirecting it to the exception tables.
• Designed complex ETL Strategy that would grab data coming in from different heterogeneous sources like Oracle, DB2, and Flat Files and dump it into pre-staging, staging and Data Warehouse according to the business requirements.
• Developed a proc to generate XML file according to the schema provided by the front end.
• Also added security to the packages with encryptions and passwords and managed Package configurations using XML files and SQL server configurations, scheduled Packages using SQL Server Agent Jobs.
• Used different transformations available in SSIS such as execute process task, script task, script component, Look up, Derived Column, Multicast, Conditional Split, Union all, Data Conversion etc.
• Involved in performance tuning projects of Scripts, Procedures and packages which slow down the production server.
• Optimized stored procedures and SSIS packages which are degrading the performance.
• Created and scheduled jobs for different SSIS packages.
• Optimized the OLAP cube performance by partitioning the measure groups, designing aggregations and assigning proper storage modes like MOLAP, HOLAP and ROLAP based on the frequency of data usage.
• Constructed SSIS packages to process the OLAP cubes and scheduled the process based on the ETL incremental load.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS.
• Created ad-hoc, parameterized, drill down, and drill through reports and formatted reports with parameters.
• Scheduled performance with integration of EPM Dashboards into the SharePoint-based PerformancePoint.
• Generated reports using SSRS and Excel Spreadsheets with Power pivots and deployed them in SharePoint integrated mode.
• Performed Database Review for all the data base objects including stored procedures, tables and views by following coding standards and performance techniques. Also helped in tuning TSQL queries and complex procedures.
• Worked on Reporting Services in which created several reports like drill down reports, drill through reports along with parameterized reports for business users and stake holders with upper management.
• Designed and Implemented several ad-hoc reports using report models and created them using Report Builder 2.0 + on Report Server for users that are not very familiar with technical aspect for SQL Server.
• Fixing issues and coordinating with QA team to fix the issues and make them to understand business flow.

Environment: Microsoft SQL Server 2008/ 2008R2, SSIS, SSRS 2005/2008, SQL Server Management Studio, SSIS/AS/RS

Confidential

Sr. SQL/BI Developer

Responsibilities:

• Extensively involved in gathering business requirements as endeavor that will facilitate the planning and implementation phase of a data warehouse / data mart.
• Involved in designing and documenting Logical and Physical data model and normalization processes.
• Implemented various integrity constraints to ensure entity, referential and domain integrity using primary key and foreign key relationships as well as Check, Not Null and Unique constraints.
• Created T-SQL batches, database scripts, indexes, stored procedures, views, tables, triggers, table-valued and scalar functions in SQL Server 2008.
• 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.
• Optimized the performance of queries by modifying the existing index system and rebuilding indexes again with respect to the I/O.
• Developed SSIS packages included various transformations such as Slowly Changing Dimensions, Derived Column, Aggregate, Fuzzy Lookup, Lookup, Multicast, Row Count, Conditional Split, and Data Conversion etc.
• Tested Packages and fixed bugs using SQL 2005 Business Intelligence Development Studio.
• Scheduled and executed SSIS Packages, using SQL Server Agent.
• Created cubes with dimensions and facts to facilitate business analytics based on historical and current data.
• Automated the process of adding the metrics to the measure groups by using Powershell Script and AMO namespace.
• Optimized OLAP cube performance by creating aggregations, usage based aggregations and partitions
• Implemented calculated members and key performance indicators (KPI) as well as defined Actions, translations and perspectives.
• Created ad-hoc reports, and complex enterprise reports (parameterized, drill down, drill through and cascading) using SQL Server Reporting Services and Report Manager

Environment: Microsoft SQL Server 2008, SSIS, SSAS, SSRS, SQL Profiler, SQL Server Management Studio (SSMS), Power Shell.

Confidential

Sr. SQL Developer

Responsibilities:

• Actively involved in gathering business requirement and also providing the solution.
• Participated in designing the Logical model by using Erwin based on the business requirement.
• Work efforts include design, development, testing, debugging and documentation of the required SSIS processing.
• Created database objects like Procedures, Triggers, and Indexes using T-SQL to create complex scripts.
• Created SSIS packages to achieve data clearance and load data into desired destination production compliance Database.
• Used different transformations such as conditional split, lookup, slowly changing dimensions and derived columns.
• Responsible in auditing SSIS packages with the help of SSIS loggings or custom logging, as well as responding to errors using send mail task.
• Implemented the Master/Child Package Models to ensure that only the Master Package is scheduled which will in turn fire the other packages.
• Managed package configurations to efficiently deploy ETL packages from Development Environment to Production Environment.
• Created ad-hoc reports and enterprise reports such as parameterized, drill down, drill through and cascading using SQL Server Reporting Services and Report Manager

Environment: Microsoft SQL Server 2005/2008, SSIS, SSRS 2005/2008, SQL Server Management Studio

Confidential

SQL/ETL Developer

Responsibilities:

• Participated in designing the Logical model by using Erwin based on the business requirement.
• Created T-SQL batches, database scripts, indexes, stored procedures, views, tables, triggers, and scalar functions in SQL Server 2005.
• Extensively utilized SSIS packages functionality to create a complete ETL process using transformations of data
• Migrated DTS packages of SQL Server 2000 to SQL Server 2005 to make them reused in new environment.
• Created SSIS Packages to import and export data from Excel Spreadsheets, Text files and CSV files.
• Used different transformations such as conditional split, lookup, slowly changing dimensions and derived columns
• Optimized ETL Packages by increasing the memory buffer size and by increasing the Maximum Concurrent Executables.
• Managed package configurations to efficiently deploy ETL packages from Development Environment to Production Environment.
• Extensive experience auditing SSIS packages with the help of SSIS loggings or custom logging, as well as responding programmatically to errors using several work flows in event handlers.
• Created cubes with dimensions and facts to facilitate business analytics based on historical and current data
• Optimized OLAP cube performance by creating aggregations, usage based aggregations and partitions
• Created ad-hoc reports, and complex enterprise reports (parameterized, drill down, drill through and cascading) using SQL Server Reporting Services and Report Manager
• Used complex expressions to calculate, group, filter, parameterize and format the contents of a report in SSRS.
• Created data models with Report Builder to provide a template for end-users for creating reports by themselves with preselected group of relational tables.
• Effectively handled data errors during the modification of existing reports and creation of new reports.

Environment: Microsoft SQL Server 2005, SSIS 2005, SSAS 2005, SSRS 2005, SQL Profiler, SQL Server Management Studio (SSMS), Windows Server 2003

Confidential

SQL Developer

Responsibilities:

• Worked with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options
• Converted customer requirements into logical and physical database designs and models
• Developed and maintained databases, stored procedures and user defined functions
• Implemented various integrity constraints to ensure entity, referential and domain integrity using primary key and foreign key relationships as well as Check, Not Null and Unique constraints.
• Performed consistent data entry into the database by developing stored procedures and triggers.
• Responsible for query optimization and indexing in the databases.
• Responsible for troubleshooting and resolving database issues
• Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability
• Ensured best practices are applied and integrity of data is maintained through security, documentation, and change management
• Performed data management tasks including automation of data loads, performance tuning, SQL programming and data manipulation
• Responsible for Defining, testing and executing data validation routines
• Successfully resolving SQL Server problems in conformance with SLAs, which involves in-depth knowledge of SQL Server architecture, connectivity, replication, DTS, backup/restore.
• Performed Database Administration like Database Backup, Recovery procedures, Performance Monitoring/Profiler to solve Dead Locks/Long running queries.