SUMMARY

• Over 8+ years of IT experience in Retail, Finance, Banking and Healthcare domains with expertise in Database Design, Development, Implementation and Support of MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 and over 4 years of experience in suite products like SSIS, SSRS, and SSAS.
• Efficient in creating, configuring and Fine - tuning ETL workflows designed between Homogenous and Heterogeneous Systems using DTS and SSIS of MS SQL.
• Firm Knowledge of Relational Database Management System(RDMS), OLAP&OLTP, Data Warehouse Concepts and experience with MS SQL Server in writing T-SQL, working on SSIS, SSRS, SSAS, using Visualization tools like Power BI, PowerPivot, Data Analysis and Data Migration.
• Adept in MS SQL Server Database administration with planning, backup and recovery strategies and using MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Worked in designing the Data model from the scratch for Normalized databases and data warehouses. Created Dimensional data models from scratch.
• Experience in writing Complex Stored Procedures, Indexed Views, DDL/DML/DCL, Triggers, and Joins, user-defined functions and created subqueries and Distributed queries.
• Experienced in Normalizing and De-normalizing the tables, Maintaining Referential Integrity by creating Triggers and Foreign Keys.
• Extensive knowledge of Software Development Life Cycle (SDLC).
• Expertise in Load Testing, Integration Testing and User Acceptance Testing (UAT).
• Skilled in High-Level Design and implementing ETL Packages using SSIS for integrating data from multiple Sources.
• Implemented Event Handlers, Loggings, Checkpoints, Package Configurations and Transactions.
• Experience in Designing and Building the Dimensions and Cubes with star schema using SSAS and snowflake dimensional schema using ERWIN tool and MS Office Visio.
• Wrote MDX queries to create a new calculation or support underlying reports/dashboards that rely on the SSAS cubes.
• Created Tabular models to replace SSAS Multidimensional Cubes and to enhance Self - Servicing BI so that DAX can be used by Business Analysts for quick analysis.
• Efficient in Designing Enterprise reports using SQL Server Reporting Services (SSRS), Datazen and Power BI.
• Skill in creating recursive CTEs, temporary tables, and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Worked on Mission Critical projects by providing on 24x7 support as needed.
• Worked as SME to different teams and acted as a liaison for the Onshore and offsite teams.
• Worked in both Agile and Waterfall Methodologies and acted as a Scrum Master or Release Engineer.
• Strong Communication Skills.

TECHNICAL SKILLS

Languages: C#, T-SQL, PL/SQL

RDBMS: SQL Server 2014/2012/2008/2005/2000 , MS-Access, Oracle Database, DB2, MySQL, and Teradata.

Version Controlling Tools: Visual Source Safe, Source Tree, Tortoise, Team Foundation Server

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Business Intelligence Development Studio (BIDS), SSIS, SSAS, SSRS, Data Transformation Services

Data Modeling Tool: MS Office Visio 2003/2007/2013

Operating System: Windows 2000, Windows Server 2003, Windows NT, Windows 95/98/2000 XP/Vista/7, Unix.

Database design models: Logical and Physical Database Design, Star Schema, Snow Flake Model, UML, Database Design, and Normalization.

Other Tools: Tableau, Red Gate, Pragmatic Works etc.

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

SQL Server/ BI Developer

Responsibilities:

• Using Data mapping we utilized ASAP methodology of project preparation to identify business objectives to integrate companies, the blueprint of the company requirements, the realization of the configuration, final preparation of testing, cutover, reporting, training and, go live and support, analyzing the gap, writing functional specifications, configuration, and testing.
• Experience in SQL joins, subqueries, tracing, indexing strategies and query/index tuning and performance tuning for better running of queries.
• Implemented Extraction Transformation and Loading (ETL) process by pulling a large volume of data from various data sources using SSIS.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Migrated data from different heterogeneous sources such as Flat file, Excel 2005 using SSIS.
• Used different data flow elements like FlatFile, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• Deployed different SSIS packages on test and production servers.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
• Created Clustered and Non-Clustered Indexes on tables for performance optimization of complex stored procedures.
• Did a lot of Performance Tuning by using unblocking Transformations and row transformations for better performance of SSIS packages.
• Upgraded existing packages developed using SSIS 2008R2 to SSIS 2012 packages.
• Daily, weekly, and monthly production data processing, monitoring, and troubleshooting in an environment of mission-critical operational systems, benchmark establishment, and capacity planning.
• Worked on Dimensional Data Modeling using Star and snowflake schemas for Fact and Dimension tables
• Designed, created, tested, and support over 60+ Enterprise Reports utilizing all aspects of Reporting Services (SSRS) functionality: Calculated fields, Formulas, Parameters, Sub-Reports, Conditional Formatting, and external web service calls
• Created reports that included formatting options such as Grouping, Sorting, Parameter prompts.
• Generated various reports with drill down, drill through, calculated members, and dropdowns from the cubes by connecting to Analysis server using Excel.
• Modified report content and exported reports in multiple formats based on user input.
• Used various report items like tables, sub report, and charts to develop the reports in SSRS and upload into Report Manager

Environment: MS SQL Server Management Studio 2008 R, SSDT, BIDS, SSIS, SSAS, SSRS, Visual Source Team Foundation Server (VSTS), Team Foundation Server (TFS)

Confidential, Santa Ana, CA

SQL Server Developer/SSIS/SSRS/SSAS Developer

Responsibilities:

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created Tables, Stored procedures, and defined functions. Created SQL scripts for tuning and scheduling.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008R2.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill-down Reports and Charts using SQL Server Reporting Services (SSRS).
• Created Query Parameters and Report Parameters to control data returned by the query and filter data at the report level.
• Created linked, unlinked and on-demand subReports.
• Understood the various complex reporting requirements of the company and created web reports using Reporting Services.
• Developed Tables, Views, Stored Procedures and Triggers using SQL Server Management Studio.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Developed logical and physical data models, design data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008R2. Create Calculate member in MOLAP cube using MDX in SSAS 2008R2.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
• Scheduled the reports to run on daily/weekly/monthly basis and email the results to the users in the required format.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data warehouse.
• Involved in dimensional modeling with Star &Snowflake schemas and created the Data Source Views Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Create ad-hoc SQL queries for customer reports, executive management reports
• Written MDX Scripts in order to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.

Environment: MS SQL Server 2008R2, SSRS, SSAS, SSIS,BIDS, T-SQL, PL/SQL,, MS Excel, Visual Source Team Foundation Server (VSTS), Team Foundation Server(TFS)

Confidential, Atlanta, GA

SQL/ SSIS /SSRS Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Maintained data integrity by performing validation checks.
• Responsible for creating the reports basing on the requirements using SSRS 2005.
• Defined the report layout.
• Identified the database tables for defining the queries for the reports.
• Identified and defined the Datasets for the report generation.
• Wrote the queries for the drill down reports and cascaded reports.
• Identified and added the report parameters.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.
• Imported data from various sources into a staging area, merge the data into the OLTP data model and presents it to all levels of the over-600 users.
• Deployed the generated reports on to the server.
• Formatted the reports using the Global variables and expressions.
• Optimized Queries, Tuned and Monitored server performance.
• Create Parameterized SSRS Reports and ETL packages using SSAS Cubes
• Involved in the Fine tuning of database objects and server to ensure efficient data retrieval.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Developed SSIS solution for developing a full-fledged data warehouse solution
• Developed, monitored and deployed SSIS packages.
• Assisted in migrating denormalized report DB into a Star Schema design.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.

Environment: MS SQL Server 2005, MS SQL Server Reporting Services 2005,MS SQL Server Integration Services 2005 Windows Vista, MS Office.

Confidential, Chicago, IL

SQL Server BI Developer (SSIS/SSRS)

Responsibilities:

• Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Constraints and Roles.
• Creating Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing Stored Procedures.
• Created Logical and Physical data models using ERWIN data modeling tool.
• Assisted in migrating de-normalized report Database into a Star Schema design.
• Extracted data from various heterogeneous sources and created packages using SSIS, Import/ Export Data, Bulk Insert and BCP utilities.
• Worked with various SSIS Data transformation tasks like Data conversion, Derived Column, Lookup, Fuzzy Lookup, Conditional Split etc.
• Used various Control flow tasks like For Loop, Execute package/SQL tasks, Script task, send mail task and different data flow tasks/transformation.
• Developed the reports using stored procedures by adding variables such as Language translation and Time zone by considering different scenarios according to business requirement and Executed to get the required output.
• Responsible for ongoing maintenance and change management to existing reports and Optimize report performance in SSRS-2008.
• Experience in developing Summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• CreatedSSRSReport Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields, and expressions.
• Enhanced performance using optimization techniques-normalization, indexing, and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts, and processes.
• Created Linked Servers to connect OLE DB data sources and providers.

Environment: SQL Server 2005/2008R2 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS), TSQL, TFS, XML, MS Visual Source Safe and Windows Server 2003.

Confidential

SQL/BI Developer

Responsibilities:

• Handling the requirements and analysis of source systems & the database architecture of the Wind database
• Managing development with SQL Server Reporting Services using SQL (Stored procedures, function, views creation, exception handling, cursor creation, transaction control)
• Managing SQL Server Integration Services for data migration process
• Involved in functional analysis and all data design discussions
• Developed database objects like stored procedures, views, tables and other objects to meet the requirements.
• Involved in the maintenance and support operations

Environment: SQL Server 2005, SSIS, SSRS, TSQL, XML, SQL Profiler, MS Access, Hyperion EssBase.