SUMMARY:

• Extensive experience in SDLC methodologies and gathering business requirements.
• Created data models for relational schemas (OLTP) and dimensional schemas (OLAP) with proper normalization and de - normalization techniques.
• Exceptional understanding of Business Intelligence and Data Warehouse concepts.
• Design of databases through conceptual entity relationship diagrams, ER-win and ER/Studio.
• Hands on experience in creating database objects such as tables, views, stored procedures, triggers, user defined functions and 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 SQL queries as well as the stored procedure used to feed reports for better latency performance.
• Extensive experience in using SQL profiler and Database Tuning Advisor (DTA) for performance tuning, query optimization and database optimization.
• Used Netezza Administrator to identify the queries taking much time, queries that have high skew and performing necessary actions.
• Monitored the schedules and implemented SQL queries tuning (in Netezza) based on the Distribution of data in nodes (data slices), GROOM table - to remove deleted data, Split the table into smaller tables creating a view using UNION ALL operation Generating statistics on the table whenever data gets modified/inserted.
• Scheduled maintenance plans according to Microsoft best practices and implemented sound backup and restore strategies.
• 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.
• Created ad-hoc reports, and complex enterprise reports (parameterized, drill down, drill through and cascading) using SSRS.
• Managed large and complex reports that return a huge volume of records and improved performance of large parameterized reports by pre-populating the report cache using data-driven subscriptions.
• Used MKS, Red Gate, and TFS for project tracking and source control.

TECHNICAL SKILLS:

DATABASES: Microsoft SQL Server 2008/ 2012/2014, Netezza

DATABASE TOOLS: SSMS, ER-Win, Profiler, ER/Studio, Aginity, Winsql

DATABASE LANGUAGES: SQL, T-SQL

BUISNESS INTELLIGENCE: Microsoft BIDS SSIS, SSAS, SSRS 2008/2012/2014, DataStage, Tableau

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

LANGUAGES: HTML/XML, VB.net

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

WORK EXPERIENCE:

Confidential,Seattle, WA

Business Intelligence Consultant

Roles and Responsibilities:

• Participated in designing star schema models by using ER/studio based on the business requirements.
• Involved in redesigning the AADB data mart, which compromises the highly aggregated employer group claims and used as a backend for insight reporter.
• Created clustered and non-clustered indexes on SQL server views for faster process of the report using the views.
• Designed conformed dimensions and implemented the logic for incremental loads.
• Involved in implementing and testing the incremental load of the conformed master database.
• Involved in Netezza appliance upgrade and migration project and testing all the functionalities by running the existing jobs and scripts, and remediating if any exist for backward compatibility.
• Created clustered and non-clustered indexes on SQL server views for faster process of the report using the views.
• Designed data stage jobs to load data parallel from flat files to Netezza tables and to move data within Netezza databases and from Netezza to SQL Server.
• Designed and developed ETL modules and implemented SCD 2 dimensions for member and group hierarchies.
• Creating the documentation, Mapping document - during designing and Data modeling, Detailed Design document - before and during coding, SDLC Document - Unit testing and Peer review document.
• Created the schedule to load the dimensions and facts table from OLTP tables.
• Implemented the mechanism to track the schedule run times, completion and status.
• Utilized SSIS packages functionality to create a complete ETL process using transformations of data and loaded data from Netezza 7.2 to SQL server.

Environment: Server 2012/2014, SSIS Netezza, IBM InfoSphere (Data Stage), ERwin Data Modeler, WinSQL, Aginity Work bench, TFS, Final Builder, IBM Cognos, SQL

Confidential, Costa Mesa, CA

Sr. Database Engineer

Roles and Responsibilities:

• Collaborated in gathering business requirements through JAD sessions and designed the logical model by using ER Studio based on the requirement.
• Involved in code review and recommended new coding practices to the team and also prepared coding standard documents.
• Translated business requirements from a variety of users into technical design documents of report and schema specifications and provided feedback on their requirements vs. their stated goals.
• Created and maintained project plans and schedules for the ongoing development and maintenance of the project.
• Redesigned the existing member and public pages of the business websites which required changes to existing database and enhanced the database to in corporate the new functionalities.
• Created T-SQL batches, database scripts, indexes, stored procedures, views, tables, triggers, and scalar functions in SQL server.
• Involved in mentoring and giving trainings to developers in the department and also provided inputs for performance reviews.
• Wrote optimized scripts to remove data anomaly in production by handling production support tickets.
• Implemented various constraints such as Not null, primary key, foreign key and check.
• Participated in creating unit test plan and developed initial test cases for assigned tasks.
• Created staging DBs utilizing simultaneous pipeline loading procedure.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improved scalability.
• Created SSIS Packages to import and export data from Excel Spreadsheets, Text files and CSV files.
• Optimized ETL Packages by increasing the memory buffer size and by increasing the Maximum Concurrent executable.

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

Confidential, Los Angeles, CA

Sr. SQL/ETL Developer

Roles and 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.
• Modified 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.
• Developed SSIS packages to extract data from sources such as SQL Server OLTP, Excel, and Flat Files.
• Developed procedure to generate XML file according to the schema provided by the front end.
• Implemented security to the packages with encryptions and passwords and managed package configurations using xml files and SQL server configurations.
• Utilized different transformations available in SSIS such as look up, derived column, multicast, conditional split, union all and data conversion.
• Optimized issue resolution procedures for large-scale production environments in SSIS.
• Automated the ETL process with SSIS package execution schedules utilizing jobs.
• Performed database review for all the data base objects including stored procedures, tables and views by following coding standards and performance techniques.
• Worked on reporting services in which created several reports such as 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 utilizing report models and created them using Report Builder.
• Fixed issues and coordinated with QA team to fix the issues and make them to understand business flow.

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

Confidential, Mountain View, CA

Sr. SQL/BI Developer

Responsibilities:

• Collaborated with the project team and business users to gather business requirements.
• 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 foreign key, check, not null and unique constraints.
• Developed SQL queries to fetch complex data from different tables in remote databases using Joins, database links, 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.
• Tested Packages and fixed bugs using SQL 2005 Business Intelligence Development Studio.
• Automated the process of adding the metrics to the measure groups utilizing 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, Boise, Idaho

Sr. ETL Developer

Responsibilities:

• Collaborated with the project team to outline project requirements in JRD meetings.
• Participated in designing the logical model by using ER-Win based on the business requirement.
• Created database objects such as procedures, triggers, and indexes using T-SQL to create complex scripts.
• Created SSIS packages to achieve data clearance and loaded data into staging database.
• Used different transformations such as conditional split, lookup, slowly changing dimensions and derived columns.
• Implemented auditing in 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 model to ensure that only the master package is scheduled which will in turn fire the other packages.
• Managed package configurations to 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, San Francisco, CA

SQL/ETL Developer

Responsibilities:

• Coordinated with business users to clarify business requirements pertaining to the database application.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Utilized SSIS package functionality to create a complete ETL process using transformations.
• Migrated DTS packages of SQL Server 2000 to SQL Server 2005 to make them reused in new environment.
• Created SSIS package to import and export data from Excel Spreadsheets, Text files and CSV files.
• Optimized ETL packages by increasing the memory buffer size and by increasing the maximum concurrent executables.
• Created cubes with dimensions and facts to facilitate business analytics based on historical and current data.
• 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

Roles and 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
• 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.