SUMMARY

• 10 Years of Experience in Database Design, BI - Development of Microsoft SQL Server 2008/2005 of various Test, Development and Production Environments in various business domains like Financial, Manufacturing, Medical, etc.
• SQL database experience in a High transaction and multi-server production environment.
• Hands on experience in MS SQL Server 2008R2/2008/2005 within SQL Server Integration Services, SQL Server Reporting Services and SQL Server Analysis Services.
• Creating Triggers, Tables, Stored Procedures, Functions, Views, Indexes and Constraints.
• Expert knowledge working with Business Intelligence Development Studio (BIDS).
• Created DTS/SSIS packages and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into Data Marts.
• Experience in building Data Integration and Workflow Solutions and Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Services (SSIS).
• Developed highly complex SSIS packages using various Tasks, Containers, Data transformations like Fuzzy Lookup, For Each Loop, For Loop Sequence Container and FTP.
• Extensive experience in generating different type of reports including: Parameterized queries, Formatted Reports, Tabular forms, Matrix (cross Tab report) form, Cascading, Drill Down, Drill through, List items, Charts and Sub reports using SSRS 2005/2008(R2).
• Expertise in developing OLAP cubes using SSAS for data mining and created reports from the OLAP cubes using SSRS and Report Builder 3.0.
• Excellent Knowledge of Dimensional Modeling using Kimball methodology, Star/Snowflake Schemas.
• Experience in Performance Optimization of SSAS cubes, by writing MDX Queries & expressions in Cubes for use in front end Business Intelligence applications.
• Experience in SQL administration activities like Installation, Configuration, Maintenance, Backup and Restore of SQL Server databases.
• Experience with Database Tuning Advisor, Performance Monitor and SQL Profiler for Tracing and Auditing.
• Extensive experience in using SQL Profiler, System Monitor, Query Analyzer and Performance Monitor for Troubleshooting, Monitoring, Optimization and Tuning of SQL Server and SQL code.

TECHNICAL SKILLS

• Tools: SQL Server Management Studio (SSMS), BIDS, SQL Profiler, Query Analyzer, Performance Monitor, Database Engine Tuning Advisor, SQL Mail, SQL Trace, Redgate.
• DBMS/RDBMS: MS SQL SERVER 2008R2/2008/2005, ORACLE 9i, MS Access 2003, MySQL.
• ETL Tools: SQL Server Integration Services.
• Reporting Tools: SQL Server Reporting Services, MS Excel, Crystal Reports, and Report Builder 3.0.
• Languages: SQL, T-SQL, PL/SQL, VB.NET, C#, C++.
• Data Modeling: ERWIN, MS Visio.
• Other Technologies: ASP.NET 3.5, JavaScript, AJAX.
• Operating Systems: Microsoft Windows XP/Vista, Microsoft Windows Server 2003/2008R2.

PROFESSIONAL EXPERIENCE

Confidential, Mountain View, CA

Data Specialist

Responsibilities:

• Working with Marketing team to ensure Data Reliability and Reporting that Data consistently using Business Intelligence Techniques.
• Create Scripts and Data Tables using Dremel( Confidential SQL) to fulfil required Business Objectives.
• Create Workflows to execute scripts and to ensure the Continuity of Data from one script to another.
• Building flexibility of work for both Performance Reporting and Day-to-Day granular Operational & Optimization of Reporting needs.
• Rework on code to ensure the best practices are in place, to Optimize the Queries and the CPU time.
• Building best practices around Version control, Script maintenance, Data architecture and Documentation of work in a proper fashion to ensure streamlining future work.

Environment: PLX, Dremel, Confidential Suite, Origami(for Dashboards).

Confidential, Portland, OR

Sr. SQL Developer / Sr. Data Analyst

Responsibilities:

• Worked with Business Users, and technical experts to drive a review of business rules, business processes and data and identify data quality issues, provide recommendations for improvements.
• Migrated Microsoft Access Queries into Microsoft T-SQL by analyzing data dependencies between tables and creating T-SQL queries, stored procedures and Views in T-SQL to ultimately retire Access.
• Automated the reports that are manually run from Access to Excel using SSIS ETL.
• Research data anomalies at their root source in Access reports and remedy them in reports from SQL Server.
• Design, develop and maintain data dictionaries.
• Assist in data design; create data related specifications for development team.
• Identify, plan and help oversee data sources.
• Manage key assumptions, risks, issues, and dependencies.

Environment: SQL Management Studio 2012, T-SQL and Microsoft Access.

Confidential, Sunnyvale, CA

MSBI Reporting & Integration

Responsibilities:

• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Triggers and Stored Procedures in SQL Server.
• Created ETL packages using SSIS for exporting heterogeneous data from OLE DB Source, Excel spreadsheet, CSV files to Oracle DW.
• 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 data transformations (DTS) using SSIS.
• Implemented Event Handlers and Error Handlers during creation of SSIS packages and notified process results to various users.
• Worked with Business users to refine requirements in converting data from a phone system and pulling into
• MSBI DW which was tan used for creating reports through SSAS Cube.
• Built MDX (Multidimensional expressions) queries and Data Mining Extensions (DMX) queries for querying Analysis Services and Reporting Services.
• Worked on separating massive SSAS Cubes into individual cubes to aid in shorter cube refresh schedules.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Implemented sales security using roles in SSAS cube for employee access which was defined in an excel file by the business users.
• Designed and deployed various SSRS Reports such as Parameterized and cascading parameterized reports using SSRS 2008.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code.
• Used SQL Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Involved in optimizing code and improving efficiency in databases by re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Used SQL Profiler and Query Tuning Wizard to troubleshoot problems and queries.
• Involved in tuning SQL Server Databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Experienced in troubleshooting production servers and user and application issues.

Environment: SQL Server 2008R2 Enterprise Edition, SSIS/SSRS/SSAS and SQL Management Studio 2008.

Confidential, New York, NY

SQL BI Developer/DBA

Responsibilities:

• Work collaboratively with the IT team and Business users to identify and refine requirements.
• Designing ETL packages for exporting heterogeneous data, different data sources (SQL Server, Flat Files, CSV and XML files etc.) and load the data into target data base servers by performing different data transformations (DTS) using SSIS SQL Server 2012.
• Implementing Event Handlers and Error Handlers during creation of SSIS packages and notified process results to various users.
• Automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data into consistent and reliable data, and finally load it into a Multi-dimensional data warehouse.
• Building MDX (Multidimensional expressions) queries and Data Mining Extensions (DMX) queries for querying Analysis Services & Reporting Services.
• Creating complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP reporting needs.
• Designing and implementing Parameterized and cascading parameterized SSRS Reports using SSRS 2012.
• Using SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Optimizing code and improving database efficiency including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Creating Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Triggers and Stored Procedures.
• Using SQL Profiler and Query Tuning Wizard to troubleshoot problems and queries.
• Involved in tuning SQL Server Databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Experience in troubleshooting production servers for user and application issues.

Environment: SQL Server 2012, SSIS/SSRS/SSAS and SQL Management Studio 2012.

Confidential, Farmington Hills, MI

QL Server SSIS/SSRS Developer

Responsibilities:

• Managed the ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to end users.
• Created Backend validations using Insert/ Update and Delete triggers.
• Created Indexes and used Scan and Seeks for performance tuning.
• Configured SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment.
• Utilized SSIS to produce a Data Mapping and Data Mart for reporting worked with Multi-threading Concepts with Synchronous and Asynchronous transactions in Production Server.
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Created SQL SSIS and SSRS infrastructure that pulls data from data sources and provides a sample to use reporting environment.
• Created SSRS reports using Report, Drop-Down, Multi-Valued Parameters and Debugging Parameter Issues in Matrix Reports and Charts.
• Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.
• Identified Dimensions and Facts, Used MDX to extract data from cubes and created MDX script for representing Cube Calculation, Actions and KPIs.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created logging, custom logging and error handling packages.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.

Environment: SQL Server 2008/2005, Windows 2003/2008R2, SSIS, SSRS, SSAS, Visual Studio 2005.

Confidential, Erlanger, KY

SQL Server BI Developer

Responsibilities:

• Involved in data migration and used SSIS to import and export data into tables using SQL Server 2005/2008,
• Created Tables, Views, Triggers and Store Procedures using T-SQL.
• Using SSIS Data transfer from Development to Testing and tan onto Production Servers.
• Written Stored Procedures for Reporting purpose and developed various reports using SSRS.
• Involved in cube creation and browsing cube data using SSAS.
• Defined calculations which are Multidimensional Expressions (MDX) expressions or scripts.
• Calculated members, named sets, and execute other script commands to extend the capabilities of a MS SQL Server 2008 Analysis Services (SSAS) cubes.
• Worked on Key performance Indicators (KPIs) by designing star schema and snowflake schema in SSAS.
• Fine-tuned Queries for the performance of reports which were being developed in SSRS.
• Reviewed and optimized SQL queries, stored procedures, views & triggers from all Databases to achieve maximum efficiency and scalability.
• Responsible for creating users and roles for security purpose on the development server.
• Implementation and scheduling of backup and maintenance strategies on the development server.
• Automated daily Database backups, restores and integrity checks using Management Studio and creating or updating indexes using SQL Profiler and Good experience using DB Tools such as red-gate and Lite speed.

Environment: SQL Server 2005/2008/R2, Windows Server 2003/2008, SSIS, SSRS, SSAS.

Confidential, Minneapolis, MN

SQL Server Developer

Responsibilities:

• Developed SSIS packages to conduct simple and complex transformations, and executed these packages using the execution package.
• Implemented data migration processes in the 2005 SQL Server environment using SSIS.
• Extracted data from operational systems, including flat files, spread sheets and RDBMS like SQL Server and Oracle 10g.
• Implemented Common Table Expressions (CTE).
• Developed Triggers to raise events on executing insert, delete and update stored procedures.
• Created copies of operational Databases using the SQL Import/Export Wizard.
• Monitored the performance of Database objects using Performance Monitor with SQL Server 2005.
• Optimized existing stored procedures to achieve improved performance.
• Developed complex correlated and un-correlated sub-queries in T-SQL.
• Developed Cross-Tabbed and Sub-Reports in SSRS 2005.
• Generated reports using the Crystal Reports and Reporting Services 2005.
• Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2005.
• All processes were documented for future references.

Environment: SQL Server 2005, Windows Server 2003, SSIS, SSAS, SSRS, T-SQL.

Confidential

SQL ETL Developer

Responsibilities:

• Created Data model as per User requirements and studied the source system using Star Schema and Erwin.
• Transformed data for adding derived column, sorting of data, merging of data done while pulling data from SQL Server 2000 to Server 2005.
• Migrated data from SQL Server 2000 to Server 2005 using Data Transformation Services (DTS).
• Created Databases, Tables and triggers to validate the data to meet the specifications.
• Created views and indexed views as required by front end developer for easier implementation.
• Created stored procedures and functions to support data storage and manipulation.
• Used linked / replicated servers and high-volume data storage.
• Converted the DTS Packages into SSIS using Migration Wizards.
• Involved in Testing and Debugging the Stored Procedures and T-SQL. Worked on

Environment: SQL Server Enterprise Manager and Query Analyzer to Administer Server.

Responsibilities:

• Designed models in Framework Manager and worked with parameter maps.
• Involved in query tuning for increasing the query performance.
• Optimized the performance of various stored procedures by redesigning T-SQL queries and changing connection and server level settings.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Built test scenarios and test cases (negative/positive) to validate expected outcome.

Environment: Windows Server 2003, SQL Server 2005, Visual Studio 2005, T- SQL, DTS.