SUMMARY

• More than 7 years of experience in Software Analysis, Design, Development, Testing and Implementation of Business Intelligence/Data Warehouse Solutions using Microsoft SQL Server 2012/2008 R2/2008/2005
• Extensively worked on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflake schema.
• Experienced in all the stages of Software Development Life Cycle and in the migration and up gradation of databases.
• Accommodated and facilitated Joint Application Development (JAD) session, documented, analyzed and synthesized the results as parts of business requirements.
• Hands on experience with Erwin to forward and reverse engineer data models.
• Expert in developing T - SQL (DDL, DML) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization.
• Responsible for designing test cases for testing the ETL packages.
• Actively involved in the enterprise Data Warehouse designing using Kimball design methodologies and following DW Design best Practices.
• Created Indexes, Views, Index views, Constraints, Stored Procedure, User-Defined functions, CTEs, and TEMPeffective DDL/DML Triggers to facilitate efficient data manipulation and data consistency.
• Monitored and tuned the performance of Complex T-SQL queries and stored procedures by analyzing the execution plan and also using tools like SQL Server Profiler.
• Worked on data import from different file systems including XML, text, and CSV and Excel files.
• Created partitions on tables, indexes and index views as well as querying and managing partitions from optimization point-of-view according to the business criteria.
• Responsible for Database consistency checks using DBCC utilities, Performance Tuning and Query Optimization.
• Performed data cleansing using different transformations within SSIS packages to eliminate redundant data from the pre-staging database.
• Designed SSIS packages using various Transformations such as Fuzzy Lookup, Fuzzy Grouping, Aggregate and Derived Column Transformations.
• Experience in Error Handling and Debugging packages using Checkpoints, Data Viewers, Breakpoints, Event Handlers and Loggings (SSIS or Custom Loggings).
• Created package configurations to provide an easy solution to migrating packages from different business environments like development to testing or testing to production.
• Designed ETL packages using proper Loggings and Checkpoints, secured packages with Encryption in conjunction with passwords.
• Involved to planning and designing SSAS Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Optimized cubes by assigning appropriate storage modes to partitions, and created usage based optimizations for better query performance.
• Created automated backup of OLAP cubes as well as normal backup using SQL server management studio.
• Generated various reports like tabular, matrix, parameterized, sub reports, drill down and drill through reports using SSRS.
• Experience with the formatting of reports for various visual representations using conditional formatting and templates.
• Hands-on experience of setting up schedules for push and pull delivery methods for SSRS reports using Standard and Data Driven Subscriptions.
• Deployed different type of report on Share Point 2010 and used dashboard.

TECHNICAL SKILLS

Data Modeling Tools: Erwin, MS Visio

ETL Tools: SQL 2012/2008 R2 /2008 Integration Services (SSIS)

Databases: MS SQL Server 2012/2008 R2/2008, MySQL

BI & Reporting Tools: Analysis Services / Reporting Services, Crystal

Operating Systems: Windows 7/Microsoft Vista/XP/NT/2003

Language/Web technology: C#, ASP.Net, HTML, JavaScript

PROFESSIONAL EXPERIENCE

Confidential, Santa Ana, CA

SQL/SSRS/SSAS/Tableau Developer

Responsibilities:

• Used various approaches to collect the business requirements and worked with the business users and SMEs for ETL application enhancements by conducting various JAD sessions.
• Used Erwin to design the ‘Dimensional Model' of the Product Data mart with team.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules using SSMS.
• Created complex stored procedures to perform Index maintenance, data profiling, metadata search, critical staging procedures for loading data marts and reporting database.
• Worked on the Optimization and restructuring of stored procedures for the application by evaluating indexing and partitioning large tables.
• Optimized the existing Index by analyzing and came up with more efficient plan to use Clustered and Non-Clustered Indexes for significant performance boost.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Designed and created Data Mapping Document (DMD) by analyzing various data sources and mapping it to the data mart schema using timestamp and hash bytes incremental load techniques.
• Developed SSIS Packages for ETL process to load and transform the data from multiple sources like SQL server/Oracle into the data mart.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• CreatedScript Task to capture the Load counts, Miss Counts and Hit counts ofdata from one source to anotherusing C#.NET
• Made use of Event Handlers, Loggings, Breakpoints and Data Viewers for TEMPeffective debugging of packages and scheduled package processing from staging database table using SQL Server Agent
• Used checkpoint to make the package more robust and reduce the time for subsequent execution and implemented transactions at package level and task level to meet the business requirements.
• Used parameters to configure packages to make it dynamic and work in different environments like DEV and PRODUCTION.
• Involved in the troubleshooting of SSIS Packages, managing their configurations to transfer them from production to other databases.
• Created several application-specific reports, drill through, drill down, linked, sub reports and parameterized reports for better business analysis using Reporting Services.
• Formatted the reports by applying parameters, and assigned parameter defaults and data types and extended reports as well as invoked embedded functions and integrated assemblies using expressions.
• Designed and developed the most suitable User Interface such asDashboards, multiple charts types, Trends, KPI’s, custom requests for Excel Export and objects for Management Dashboard reporting using Excel Power Pivot and published them using Power BI.
• Used Power View and created various analytical reports andDashboards from Tabular Models tohalp managers to identify critical KPIs and facilitate strategic planning in the organization.
• Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems.
• Scheduled delivery of several reports to multiple users through the use of Subscriptions in different formats like Excel, PDF and Text.
• Creating Reports using ASP.net and also for customization of reports.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Worked on Team Foundation Server (TFS) to synchronize the data with different-2 sources and for version control.

Environment: MS SQL Server 2012, Visual Studio 2010, .Net, Oracle, SAP, Windows Server, T-SQL, ASP.NET,EDI, TFS, XML, ER Studio, Crystal Reports, SSIS, SSAS, SSRS, Power BI

Confidential, Irvine, CA

BI/Reports Developer

Responsibilities:

• Actively participated in gathering of User Requirement and System Specification.
• Developed database objects like tables, views, stored procedures in SQL Server 2012.
• Created Partition Tables based upon Partition Functions and Partition Schemas to improve the performance.
• Involved in Performance Tuning of the Stored Procedures, User Defined Functions and long running queries.
• Documentation of all the processes involved in maintaining the database for future reference.
• Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer.
• Created front endUser Interface and developed Web Forms using C#.Net and ASP.NET for data management.
• Used ADO.NET technology such as Data Adapter, Data Reader, Dataset and Data View, for consistent access to the data store to connect Business Layer to SQL Server 2012 database in Data Layer using C#.Net.
• Used Web Services to fetch data from Different types of sources and used C# (Object Oriented Concepts) as Script language.
• Involved in creating SSIS Packages to extract, transform and load data from multiple input sources like flat files, Excel sheets, and OLTP servers into SQL Server Staging Database.
• Created SSIS packages providing specific functionality like Data Profiling and Data Cleansing for a clean ETL process and populating Data-Marts.
• Used Script Task and Script Component in SSIS for Data Extraction and used C#.Net language for write the Script.
• Designed and developed a master plan to handle errors and notification emails using custom loggings.
• Maintained and used package and project level parameters to configure package properties to provide an easy solution for migrating towards different environments.
• Created SSISDB catalog with SQL 2012 to support SSIS package deployments in SSMS with Environment variables respective to each environment.
• Created reports based on the format specified in the design document.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and super user reports using SSRS.
• Involved in creating Dataset in the MS reporting services (SSRS) for calling the stored procedures and passed the parameters to the dataset.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Generated reports using Crystal report and also migrated some old Crystal Reports into SSRS using Crystal Migration tool in Visual Studio 2010.
• Used Crystal report created couple of business oriented reports as per business requirement like parameterized, Drill down etc.
• Extensively used crystal reports advanced functionalities like formula, Header/Footer formatting using conditional formatting.
• Involved in development and modification of existing Financial Reports and Marketing Reports, which include Corporate Consolidation Reports, Financial Reports and Planning Reports for management.
• Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
• Created number of standard reports and complex reports to analyze data using Slice & Dice and Drill Down, Drill through using SSRS.
• Created reports using SQL Server reporting services SSRS, which is tan exported as PDF. Reports variables are passed from ASP.NET web pages.
• Involved in Unit Testing, Integration and deployment in Production and Staging Servers.
• Used .Net Framework for creating Reports and also for customization of reports.

Environment: MS SQL Server 2012, Visual Studio 2010, C#.Net, SAP, MySQL, Windows Server, T-SQL, ASP.NET,EDI, TFS, XML, ER Studio, Crystal Reports, SSIS, SSAS, SSRS, Power BI

Confidential, Franklin Lakes, NJ

SQL/BI-ETL Developer

Responsibilities:

• Actively involved in gathering system specification requirements for the project.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Created tables, views, stored procedures and indexes in support of various databases and ETL applications.
• Created complex stored procedures with proper error handling, transactions and performance tuning features.
• Used various integrity constraints for data integrity like Referential integrity using primary key and foreign key relationships.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Created Triggers to enforce data and referential integrity and defined Check constraints, Business Rules, Indexes, and Views.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Involved in debugging of packages with halp of Breakpoints, Checkpoints, Event Handlers and Loggings.
• Implemented Master/Child Packages so only the Master Package TEMPhas to be scheduled which will in turn fire the other packages.
• Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Worked on extending SSIS Packages using script components (using C#.Net) as source, destination and transformations.
• Written script using C#.Net, to load data from excel sheets and flat files as per the business requirement.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Implemented event handlers, logging and error redirection in SSIS to debug SSIS packages.
• Automated the ETL process by scheduling SSIS package execution by creating jobs.
• Involved to planning and designing SSAS Cubes and building attribute relationships, aggregation KPIS’s for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Involved in Staging Partitions and Usage Based Optimization (UBO) mechanisms for SSAS OLAP databases.
• Optimized cubes by assigning appropriate storage modes to partitions, and created usage based optimizations for better query performance.
• Assess the risks and recommend/ install service packs or hot fixes when needed.
• Created several reports using SSRS like drill through reports, linked and sub reports.
• Generate reports with parameters, sub reports, cross tabs, charts using Crystal Reports.
• Developed complex formulas in Crystal Reports for reporting calculations and metrics.
• Use prompts, alerts, drill down analysis as per the end user requirements
• Create nested, conditional subgroups and formatting features in reports
• Managed very large reports that return a large volume of records and optimized their performance using techniques like cascading parameters and filters.
• Deployed SSRS reports to the reporting server in SharePoint Integrated mode and assisted in troubleshooting deployment problems.
• Optimized reports by optimizing the embedded queries, or optimized the stored procedures that generate them.
• Responsible for defects raised during testing of the reports
• Used TFS for version control for updating in database in a Team.

Environment: Microsoft SQL Server 2012, SSIS, SSAS, SSRS, SSDT, SQL Profiler, Power BI, SharePoint 2010, TFS, Microsoft visual Studio 2010, Crystal Report, C#.Net

Confidential, Philadelphia, PA

SQL/ETL Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis.
• Worked in conjunction with the data warehouse architect on the development of logical data models.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Extensively used System as well as User-Defined functions to enhance the functionality of T-SQL code.
• Wrote complex stored procedures for Data Profiling, Backup the databases as well as handling the index fragmentation.
• Implemented error handling techniques like try catch blocks, error functions in T-SQL scripts and stored procedures to support the applications.
• Involve in Query Optimization and Performance Tuning using tools SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Used proper indexing strategies including covering indexes, indexed views and index defragmentation. Created views as required by front end developer for easier implementation on web pages, and wrote instead of triggers on those views to provide efficient data manipulation.
• Utilized Dynamic SQL for user customizable queries to be answered by the SQL Server.
• Encapsulated frequently used SQL Statements into stored procedures thereby reducing the query execution time.
• Tuned and monitored the performance of T-SQL queries and SSIS packages.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access and excel.
• Written basic VB.Net scripts to implement Type 1 and Type 2 Slowly Changing Dimensions for Incremental load.
• Involved in the design of data marts using star schema and Kimball Methodology.
• Implemented SSIS Packages to perform ETL Operations from multiple data sources including excel and text files.
• Was responsible for detecting errors in ETL Operation and rectify them.
• Incorporated Error Redirection during ETL Load in SSIS Packages.
• Implemented various types of SSIS Transformations in Packages including Aggregate, Fuzzy Lookup, Conditional Split, Row Count, Derived Column etc.
• Implemented the Master Child Package Technique to manage big ETL Projects efficiently.
• Generated and partitioned the cubes and selected appropriate storage modes for the cubes that are used as sources for my reports
• Developed SSRS Reports like drill through, drill down, linked, sub reports and parameterized reports.
• Optimized reports by optimizing the embedded queries, or optimized the stored procedures that generate them.
• Formatted the reports by applying parameters, and assigned parameter defaults and data types and extended reports.

Environment: Microsoft SQL Server 2008R2, BIDS, SSIS, SSAS, SSRS, Erwin, T-SQL, TFS, Access, Excel.

Confidential, Mclean, Virginia

SQL/SSIS Developer

Responsibilities:

• Extensively created all data base objects like tables, views, stored procedures and indexes with optimization in point of view in support of the databases.
• Captured and documented data business rules and definitions.
• Involved in designing and developing efficient ETL strategy to integrate existing and new data into newly created Data Warehouse.
• Involved in designing and applying constraints and rules for data integrity.
• Created Indexes and Views on various entities of the databases.
• Optimized procedures and functions utilized by ETL Packages to reduce ETL Process time.
• Created cover indexes and applied various work around methods to halp improve processing time of ETL.
• Implemented Master/Child Packages so only the Master Package TEMPhas to be scheduled which will in turn fire the other packages.
• Responsible for monitoring all the packages which ran, were scheduled, completed or failed.
• Involved in debugging of packages with halp of Breakpoints, Checkpoints, Event Handlers and Loggings.
• Involved in developing Package Configurations to test packages on different servers.

Environment: Microsoft SQL Server 2008/2008 R2, SSMS, BIDS, SSIS, SSRS, SQL Profiler, DTA

Confidential, Reinbeck, IA

SQL Developer

Responsibilities:

• Design/develop database using SQL SERVER.
• Created High level Normalized Database and Detail Design using Erwin.
• Wrote stored procedures, tables, triggers, indexes and views using Detailed Design Specifications.
• Fine-tuned queries, assigned proper Indexes for better performance.
• Used BCP and SSIS utility for Meta data transfer across servers.
• Implementation of MS SQL database Replications methodologies.
• Configuration of client workstation with client operating system.
• Prepared trace files using SQL profiler to fine tune the application
• Used visual source safe as configuration management tool.
• Provided training sessions to the SQL developers to maintain the application integrity

Environment: SQL Server 2005/08, SSIS, SSAS, SSRS, Windows XP/2003, Windows NT