SUMMARY

• 9+ Years of experience in IT, as MS SQL Server Database Developer in Windows environment, current experience wif SQL 2008 R 2/2008/2005.
• Extensive knowledge and Experience in dealing wif 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 teh development, implementation, administration and support of ETL processes for large - scale Data Warehouses using SSIS 2008.
• Experience in dealing wif 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 teh SQL server for deadlocks, long running queries and tune teh same to improve performance.
• Developed ETL process using SSIS wif 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 wif 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 wif 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 teh stored procedures, triggers, views and user-defined functions to support application development using T-SQL.
• Loaded data into target data tables in teh application schema
• Worked wif 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 wif 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 teh data.
• Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
• Worked on bug fixes and enhancements.
• Worked wif project team representatives to ensure that logical and physical ER/Studio data models were developed in line wif corporate standards and guidelines.
• Assured that all artifacts are in compliance wif corporate SDLC policies and guidelines.
• Performed small enhancements (data cleansing/data quality).
• Worked on daily basis wif teh main frame team to evaluate impact on current implementation.
• Maintain integrity, cleanliness, consistency and organization ofdatafrom various sources.
• Executed teh test cases to test teh functionality of teh software as per teh business rules.
• Interacted wif teh developers to resolve teh 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 complexSQL stored procedures using Microsoft SQL Server 2012, Designed teh functional and technical documents, report templates and reporting standards for teh developers to work on teh 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 teh 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 teh 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 teh cubes by connecting to Analysis server from SSRS.
• Developed teh SQL Server Integration Services (SSIS) packages to transform data as well as Created interface stored procedures used in SSIS to load/transform data to teh 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 teh data warehouse Analysis services and develops teh different reports for teh analysis.
• Used ProClarity for analysis services in some cases.
• Extracting teh data from teh different sources and stored teh data into teh intermediate Staging Database using teh SSIS ETL tool.
• Transform teh data from teh staging database and perform teh transformation using teh Data Flow Tasks.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Prepared teh reports for teh 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 teh 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 teh reports in teh Report Server.
• Worked closely wif IT project managers, programmers, and testers.
• Created SQL Server Reports using SSRS 2008R2 for teh manager and teh users involved.
• Based on teh required reports, identified various data sources and established teh connections using SSIS and constructed data source view.
• Managed teh entire ETL process involving teh 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 teh users.
• Formatted teh report layout for teh requirement of teh end users.
• Created complex SSAS cubes wif multiple fact measures groups and multiple dimension hierarchies based on teh 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 complexSQL stored procedures using Microsoft SQL Server 2012, Designed teh functional and technical documents, report templates and reporting standards for teh developers to work on teh 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 teh 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 teh 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 teh cubes by connecting to Analysis server from SSRS.
• Developed teh SQL Server Integration Services (SSIS) packages to transform data as well as Created interface stored procedures used in SSIS to load/transform data to teh 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 teh data warehouse Analysis services and develops teh different reports for teh analysis.
• Used ProClarity for analysis services in some cases.
• Extracting teh data from teh different sources and stored teh data into teh intermediate Staging Database using teh SSIS ETL tool.
• Transform teh data from teh staging database and perform teh transformation using teh Data Flow Tasks.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Prepared teh reports for teh 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 developedSSIS Packagesto 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 teh packages in both teh 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 teh loading of data into Slowly Changing Dimensions using Slowly Changing Dimension wizard. Also implemented checksum SCD method to load teh data into data warehouse.
• Developed complex SSAS cubes wif multiple fact measures and multiple dimension hierarchies based on teh OLAP reporting needs.
• Improved teh performance of teh cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing teh attribute hierarchy options in SSAS.
• Experience in developing reports using SSRS.
• Designed and implemented Dashboards and Scorecards wif 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 wif 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 teh 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 teh 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 teh manager and teh brokers involved.
• Based on teh required reports, identified various data sources and established teh 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 teh brokers and clients.
• Formatted teh report layout for teh requirement of teh end users.
• Deployment of teh developed reports on to teh server for teh end users.
• Deployed teh developed reports and upgraded teh 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 teh analysis of managers and end users.
• Supported 24/7 for teh production system for post deployment Reports on teh 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 teh database.
• Calculated members, named sets, and execute other script commands to extend teh capabilities of a MS SQL Server 2005 Analysis Services (SSAS) cube.
• Created complex SSAS cubes wif multiple fact measures groups, and multiple dimension hierarchies based on teh 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 wif 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 teh statistical analysis of teh data using SQL Server Reporting Services (SSRS).
• Created On demand (Pull) and Event Based delivery (Push) of reports according to teh requirement.
• Deployed and configured teh reports in teh 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 wif 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 teh 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 teh data extracts and record counts in teh database tables by writing complex SQL minus queries.
• Tested teh ETL mappings from Source to Target.
• Extensively used SQL Queries to verify and validate teh Database Updates.
• Written test cases for checking teh populated data correctly into fact and dimension tables.
• Created Test Case documents in MS Excel template from teh Test Plan and teh 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 teh business requirements.
• Worked in creating hierarchies for dimensional tables like date dimensions and region dimension tables.
• Processing teh cubes and dimensions on a daily basis using teh SSIS tasks.
• Built cubes for production application, Partitioned Cubes to decrease teh processing time and increase teh performance of teh 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 teh 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 wif Team and Analysis, Design and Develop database using ER Diagram, Normalization and relational database concept.
• Involved in Design, Development and testing of teh 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 wif development teams
• Wrote store procedures for some job automations.
• Generated test data and tested database to meet teh functionalities deliverables in teh 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 teh Referential Integrity.
• Implemented Exceptional Handling.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Creating and automating teh 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.