SUMMARY

• 9+ Years of experience in IT, as MS SQL Server Database Developer in Windows environment, current experience with SQL 2008 R 2/2008/2005.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using SSIS 2008.
• Experience in dealing with high volume transactional data in SQL
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from 2000 to 2005/2008.
• Experience in migration of SSRS reports from SQL 2000 to SQL 2005 and SQL 2008 and SQL 2008 R2.
• Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Experience in Performance Tuning and Query Optimization.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, Profiler, Query Analyser, Export & Import (DTS), SSIS, SSRS, SSAS.

RDBMS: Microsoft SQL Server 2000/2005/2008/2008 R2, MS Access.

ETL Tools: DTS, SSIS, Data Stage.

Languages: Transact SQL, C, Visual Basic 6.0, VB.Net, C# ASP.NET, HTML.

Operating Systems: Windows95/98, Windows2000/NT/XP, MS DOS.

Reporting Tools: SSRS.

Other tools: Microsoft Visual Studio 2005, MS Office, Erwin4.0.

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

SQL Developer/ SSIS Developer

Responsibilities:

• Defined and documented requirements for conversion and interface programs
• Prepared technical design documents including detailed data mapping documentation
• Developed conversion and interface programs based on approved specifications (Combination of SSIS, T/SQL, and SQL)
• Created and developed the stored procedures, triggers, views and user-defined functions to support application development using T-SQL.
• Loaded data into target data tables in the application schema
• Worked with T-SQL, DDL, DML and DCL
• Conduct timing and capacity testing to ensure production support capability
• Developed exception and data validation reports for transformation and load jobs
• Conduct program walkthroughs with other team members as required
• Conduct walkthrough of test results for approval of data loaded as required
• Developed appropriate technical documentation, such as Visio flow-charts, as required
• Executed SQL scripts,TSQL (stored procedures) and ETL load processes
• Used Microsoft ETL/data integration tools, such as DTS/ SSIS to load the data.
• Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
• Worked on bug fixes and enhancements.
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.
• Assured that all artifacts are in compliance with corporate SDLC policies and guidelines.
• Performed small enhancements (data cleansing/data quality).
• Worked on daily basis with the main frame team to evaluate impact on current implementation.
• Maintain integrity, cleanliness, consistency and organization ofdatafrom various sources.
• Executed the test cases to test the functionality of the software as per the business rules.
• Interacted with the developers to resolve the technical and implementing issues.

Environment: MS SQL Server 2016, SSIS, MS-Office, Visual Studio 2015, Business Intelligence Studio (SSAS, SSIS, SSRS), SQL, TSQL, TFS.

Confidential, Eden Prairie, MN

SQL Developer/SSIS Developer

Responsibilities:

• Created complex SQL stored procedures using Microsoft SQL Server 2012, Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Worked in creating hierarchies for dimensional tables like date dimensions and region dimension tables.
• Created SSIS packages to Oracle and other SQL Server instances in SSIS 2012.
• Created several SSIS packages for performing ETL operations to transform data from OLTP to OLAP systems.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Performing the tasks of data conversions, adding derived columns, sending results in mails is done by making use of various tasks in SSIS.
• Deployed SSIS packages and Reports to Production Servers.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Created SSIS Packages from various data sources.
• For the data warehouse Analysis services and develops the different reports for the analysis.
• Used ProClarity for analysis services in some cases.
• Extracting the data from the different sources and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.

Environment: SQL Server 2012/2008 R2, Business Intelligence Studio (SSAS, SSIS, SSRS), SharePoint 2007, T SQL, Erwin, Oracle 10g, ProClarity, MS Excel.

Confidential, Denver, Colorado

SQL BI Developer (SSIS, SSRS)

Responsibilities:

• Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS).
• Created and developed the stored procedures, triggers, views and user-defined functions to support application development using T-SQL.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Deployed and configured the reports in the Report Server.
• Worked closely with IT project managers, programmers, and testers.
• Created SQL Server Reports using SSRS 2008R2 for the manager and the users involved.
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to end users.
• Developed and deployed SSIS packages in Production Server.
• Involved in performance tuning of T-SQL queries and Stored Procedure.
• Created parameterized reports for the users.
• Formatted the report layout for the requirement of the end users.
• Created complex SSAS cubes with multiple fact measures groups and multiple dimension hierarchies based on the OLAP reporting needs.
• 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 2012 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Microsoft Office Share Point Server, TFS 2010

Confidential, Eden Prairie, MN

SQL Developer/SSIS Developer

Responsibilities:

• Created complex SQL stored procedures using Microsoft SQL Server 2012, Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Worked in creating hierarchies for dimensional tables like date dimensions and region dimension tables.
• Created SSIS packages to Oracle and other SQL Server instances in SSIS 2012.
• Created several SSIS packages for performing ETL operations to transform data from OLTP to OLAP systems.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Performing the tasks of data conversions, adding derived columns, sending results in mails is done by making use of various tasks in SSIS.
• Deployed SSIS packages and Reports to Production Servers.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Created SSIS Packages from various data sources.
• For the data warehouse Analysis services and develops the different reports for the analysis.
• Used ProClarity for analysis services in some cases.
• Extracting the data from the different sources and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.

Environment: SQL Server 2012/2008 R2, Business Intelligence Studio (SSAS, SSIS, SSRS), SharePoint 2007, T SQL, Erwin, Oracle 10g, ProClarity, MS Excel.

Confidential, Topeka, KS

SQL BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Designed and developed SSIS Packages to import and export data fromMS Excel, SQL Server 2005 and Flat files.
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS)
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured the loading of data into Slowly Changing Dimensions using Slowly Changing Dimension wizard. Also implemented checksum SCD method to load the data into data warehouse.
• Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options in SSAS.
• Experience in developing reports using SSRS.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Microsoft Office Share point Server (MOSS).
• Defined Key Performance Indicator metrics to create scorecards.
• Involved in creating report models and applying row level security filters for report model.
• Involved in designing Web based ASP.NET applications.
• Coordinated with front-end for implementing logic in Stored Procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2008 to SQL Server 2012
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.

Environment: SQL Server 2012 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Net framework, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.

Confidential, LA, CA

SQL Server/ BI Developer

Responsibilities:

• Created SQL Server Reports using SSRS 2008 for the manager and the brokers involved.
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Involved in performance tuning of T-SQL queries and Stored Procedure.
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Created parameterized reports for the brokers and clients.
• Formatted the report layout for the requirement of the end users.
• Deployment of the developed reports on to the server for the end users.
• Deployed the developed reports and upgraded the system.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Generated Daily, Weekly and monthly reports for the analysis of managers and end users.
• Supported 24/7 for the production system for post deployment Reports on the server.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Designed and created views for security purposes, implemented rules, defaults and user defined data types.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.
• Calculated members, named sets, and execute other script commands to extend the capabilities of a MS SQL Server 2005 Analysis Services (SSAS) cube.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

Environment: MS SQL Server 2008, MS SQL Server Reporting service 2008, MS SSIS, T-SQL, Windows XP

Confidential, Cincinnati, OH

SQL BI Developer (SSIS, SSRS & SSAS)

Responsibilities:

• Key role in team of 4 in brining 2005 SQL database environment to SQL 2008R2 by migrating, converting and re-writing DTS packages and updating them to SSIS packages.
• Extensively worked on Data Flow tasks like For each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and Un-pivot Control Flow Transformations.
• Used SQL Server Package Configuration technique to make Dynamic configurations.
• Used Text Files/ SQL Server Logging for all SSIS packages.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created On demand (Pull) and Event Based delivery (Push) of reports according to the requirement.
• Deployed and configured the reports in the Report Server.
• Extracted Data from various Heterogeneous Databases such as Oracle and Access database, DB2, flat files to SQL server 2008R2 using SSIS.
• Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Worked with various SSIS packages which involve Transactions, roll back techniques.
• Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
• Worked on Error Handling.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Performed SQL validation to verify the data extracts and record counts in the database tables by writing complex SQL minus queries.
• Tested the ETL mappings from Source to Target.
• Extensively used SQL Queries to verify and validate the Database Updates.
• Written test cases for checking the populated data correctly into fact and dimension tables.
• Created Test Case documents in MS Excel template from the Test Plan and the Business Requirements documents.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Used SQL Server Agent for scheduling jobs and alerts.
• Experience in developing reports using SSRS 2008 and SSRS 2008 R2
• Created cubes and dimensions and measures and calculated measures according to the business requirements.
• Worked in creating hierarchies for dimensional tables like date dimensions and region dimension tables.
• Processing the cubes and dimensions on a daily basis using the SSIS tasks.
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS 2008.
• Deployed SSIS packages and Reports to Production Servers.
• Configuration and Deployment of all reports across various SDLC environments.
• Deployed the packages to production using XML package configuration.

Environment: SQL Server (SSIS, SSRS, SSAS) 2008R2/2008/2005, DB2, HP Quality center 10.0, Visual Studio 2005, XML, XSLT, MS Office and Visual source safe.

Confidential

SQL Server Developer

Responsibilities:

• Interacted with Team and Analysis, Design and Develop database using ER Diagram, Normalization and relational database concept.
• Involved in Design, Development and testing of the system.
• Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes and Execution Plan).
• Performing DBA functions, installing, configuring and supporting database systems.
• Reported all events and requirements through established reporting mechanisms in SSRS.
• Fully supported change management procedures.
• Reviewed and developed data models and database designs with development teams
• Wrote store procedures for some job automations.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS
• Designed and developed OLAP using MS SQL Server Analysis Services
• Designed and developed MS SQL Server Reporting Services(SSRS) under SQL Server 2000 and SQL Server 2005
• Developed User Defined Functions and created Views.
• Created Triggers to maintain the Referential Integrity.
• Implemented Exceptional Handling.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler.
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise.
• Involved in performing database Backup and Recovery.
• Worked on Documentation using MS word.

Environment: SQL Server 7.0/2000, SQL, T-SQL, BCP, Visual Basic 6.0/5.0, Crystal Reports 7/4.5,ASP/VB.NET.