SUMMARY

• Over 8+ years of extensive experience in database design, development, and administration with MS SQL Server versions 2012/2008R 2/2008/2005/2000/7.0 using MSBI (SSIS, SSAS, SSRS). Experienced with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.
• Strong experience in logical and physical database design and development, Normalization and data modeling using CA Erwin and MS SQL Server Enterprise manager.
• Extensive experience in MS SQL Server 2008/2005, Business Intelligence technologies MSBI (MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Analysis Services (SSAS)).
• Excellent experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server by using SSIS and DTS (Data Transformation Services) utility.
• Experienced in designing high level ETL architecture for overall data transfer from the OLTP - Online Transaction Processing to OLAP - Online Analytical Processing with the help of MSBI.
• Strong experience in designing and developing large number of reports in SSRS/Business Objects using the data from ETL Loads, MS SSAS Cubes and various heterogeneous data sources and Creating and Deploying SSRS Reports on the portal for user accessibility.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• Expert in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS) AND used different data transformation including transformation of XML based on XSD FILE.
• Experienced in developing and modifying cubes using SSAS and transform into pivot table.
• Experienced in Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Expert in developing Drill through and Drill down reports using Crystal Reports and SQL Server Reporting Services (SSRS)
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Experienced in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Excellent inter personal skills and communication skills and ready to take challenges with proven ability.

TECHNICAL SKILLS

BI & DW Tools: SSIS, SSAS, SSRS, Data tools, PowerBI, PowerShell, crystal reports, Excel

Database Utilities: Enterprise Manager, SQL Server Management Studio, BI Development studio, Visual Studio, Configuration Manager, SQL Server Profiler, SQL Query analyzer, SQL Server Agent

ETLTools: Data Transformation Services (DTS), SSIS, Import/export wizard, Bulk Insert, BCP, Data Warehousing.

BI Tools: SSIS, SSRS, SSAS, Crystal ReportsXI/X/9/8, Report Designer, Business Intelligence Development Studio(BIDS),Cognos 10 BI tools (Report Studio, Analysis Studio, Query Studio, CognosConnection), Power Pivot

RDBMS: MS SQL Server 2016/2014/2012/2008/2005 , MYSQL,MS ACCESS, Oracle 11g/10/9i,DB2

Programming: SQL, T-SQL, Visual Basic, Visual C++, MY-SQL, java script. Classic ASP, Asp.net, .Net frame work.

ERP: MS Dynamics Axapta 2009 - Financials

Web Technologies: Html, CSS

Operating System: Windows 98/XP/Vista/7/8, UNIX, Linux, Mac OSX

Data Modelling tool: Visual Studio, Adobe Photoshop, MS Office Suite, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Sr. MSBI Developer

Responsibilities:

• Closely worked with Database Manager and under his supervision
• Worked on SQL SERVER 2012/ 2014 versions and respective data tools
• Worked on all the end to end TSQL operations such as inserting, updating and dropping/truncating, developing scripts, running scripts as per the requirement
• Created SSIS packages for loading data into Tables from various sources such as Excel, Text files
• Worked on complex SQL queries using joins, CTE for data retrieval process
• Worked on complex stored procedures, created and modified as per the requirement of the projects
• Used Merge statements for the incremental load process into the Data Warehouse on the daily basis
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database
• Worked on ticketing system and fixed all types of priority tickets
• Worked on the performance tuning the stored procedures for the timeout errors in the production environment using temp tables and table variables
• Worked on the achieve process of large volumes of tables with millions of records for the performance enhancement
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Involved in import / export process of the data with the vendors as per the requirement
• Generated Ad hoc reports, SSRS reports such as parameterized report, Drill Down, Drill Through, Cascading reports as per the requirement
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Schedule SSIS packages through SQL Server Agent - Jobs and make sure that the packages are executed for every 8 hours’ time span.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.

Environment: Microsoft SQL Server 2012, T-SQL, MSBI (SSIS, SSRS, SSAS),Visual Source Safe, SQL Profiler, Visual Studio 2010, Visual Intercept Enterprise Edition, MDS, DQS.

Confidential, Dallas, TX

Sr. SQL Developer\MSBI Developer

Responsibilities:

• Installed SQL SERVER 2008/2008r2/2012/2014 FAILOVER Cluster and standalone installation on Windows Server 2008 r2 64-bit system and VM WARE, Hyper - V in PROD/TEST/DEV from scratch.
• Regularly supported service packs and hot fixes for both clustered and standalone SQL Server.
• Extensive experience in developing Stored Procedures, Views, Cursors, Triggers, Scripts and Complex Queries in MS SQL Server.
• Developed SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, CTE,
• Tally tables accommodating complex filters and database links.
• Optimized the performance of queries in TSQL queries, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Extensively used BI tools like Integration service, Reporting Services and Analysis services in MS SQL server 2005 and 2008R2.
• Developed SSIS packages and SSRS reports in SQL Server 2005/2008/ 2008 R2/2012.
• Filtered and cleansed bad data from legacy system using complex Transact- SQL statements in staging area, and implemented various constraints for data consistency.
• Performed data cleansing by creating tables to eliminate the dirty data and implemented
• Error Logging using SSIS and involved in performance tuning of SSIS packages.
• Developed Packages using most of the Tasks, Containers and Transformations like full load, incremental load, and bulk insert, Aggregate, Slowly changing dimensions in SSIS.
• Involved in scheduling and deploying SSIS packages by using package configuration and project deployment model
• Strong background in Data Warehousing principles and methodologies.
• Designed different kinds of reports like Linked, cascaded and parameterized reports and
• Worked on Drill Down and Drill-through Reports, Tabular, Matrix etc.
• Retrofitting various Crystal and XML reports on various modules.
• Experienced in developing stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning f reports.
• Created Report Models for building Ad hoc reports using SSRS and deployed reports into SharePoint.
• Created new reports using XML Publisher and modified the existing ones as per the changes specified.
• Created and managed roles for security in Reports.
• Created Cubes with Star schema in SSAS and developed SSRS reports based on the cubes.
• Worked in AGILE methodology in development of Database Objects in SQL Server 2008R2/2012.
• Use Clear Case as a source controller for all this development.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: MS SQL Server 2012,2008R2, VS2010, Business Intelligence Development Studio (BIDS), T-SQL, XML, Performance Point Server 2007, SSIS, SSRS, SSAS,OLAP, OLTP, Windows 7,TFS, Microsoft Excel.

Confidential, Bakersfield, CA

Sr. MSBI Developer

Responsibilities:

• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Involved in complete SDLC life cycle.
• Extract, Transform and Load source data into respective target tables to build the required data marts.
• Understand user requirements and Data Model defined and developed by the business analysts and data architects.
• Performed DBA tasks like Backup, Restore of tables and Stored Procedures and Refreshing Database on weekly basis.
• Testing on Drivers and programs of kernel part (using TALx86)) of Cosmos.
• Hands on experience on Extract and aggregate data from COSMOS
• Experience with COSMOS (understanding COSMOS logs and views, SCOPE scripts).
• Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Implemented different types of constraints on tables.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created different Power Pivot reports as per the client requirement.
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Used Visual Studio 2008 as Source Control, to maintain drop location to test, all docs and scripts.

Environment: MS SQL Server 2008 R2/2012, DTS, T-SQL, XML, Flat File, COSMOS, SQL Server Reporting Services, Power BI, Visio, IIS, Windows XP/7, TFS 2012.

Confidential - Santa Clara, CA

Sr. MSBI Developer

Responsibilities:

• Worked with product owners, application developers, productionteams and across functional units to identify product and client specific needs and discuss solution options.
• Involved in Planning, Defining and Designing database diagram using Erwin 8.0 on business requirements and provided documentations.
• Worked in the Agile methodology using Scrum which has its primary focus on the management part of the software development, dividing the whole development period into small iterations (of thirty days) called "sprints."
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensuredatabase optimization.
• Created/Updated database objects like tables, views, stored procedures,function, packages.
• Created VB.Net Script for Data Flow and Error Handling using Script component in MSBI (SSIS).
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity ofthe data after the insert, update or delete.
• Created various MSBI(SSIS) packages using data transformations like Merge, Aggregate, Sort, Multicasting, Conditional Split, and SCD (Slowly Changing Dimension) and Derived column, transformation of XML based on XSD File Experience with designing the ETL process, including data read/write, data transformations, error handling, process design, logging and Development.
• Generated Drill down, Drill through, Adhoc, Matrix Reports, parameterized reports using MSBI(SSRS).
• Designed and developed monthly, quarterly and yearly reports at product and client level.
• Involved in table and indexpartitioning for performance and manageability.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Helped create process logging and new monitoringtools, integrity reports, and mapping tools.

Environment: Microsoft SQL Server 2012, T-SQL, MSBI(SSIS, SSRS, SSAS), Windows server 2003Visual Source Safe, SQL Profiler, Visual Studio 2010, Visual Intercept Enterprise Edition, TFS, Oracle 10g, VB.Net, MDS, DQS

Confidential, Madison,WI

Sr. SQL BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema in SSAS.
• Pulling data on a daily basis from OLTP database to OLAP or staging database using the SSIS packages.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase).
• Created packages in SSIS with error handling.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Worked with different methods of logging in SSIS.
• Extensive Knowledge inSSASstorage and partitions, and Aggregations, calculation of queries withMDX, Data Mining Models, developing reports usingMDXand SQL.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in incremental data loading.
• Excel spreadsheet, and flat files into SQL server 2008 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Develops KPIs and set analysis application with Qlikview functions (join, concatenate, keep, applymap)
• Writes QlikView and SQL scripts to load relevant data and uses VB macro and set analysis to create customized reports for regulatory reporting
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports usingSSRS.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Building UAT and Test environments using Production backups.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Wrote store procedures to generate account statements for different types of accounts
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Used indexes to enhance the performance of individual queries and enhance the stored Procedures.

Environment: SQL Server 2008 R2,2005 MS Excel 2010, Qlikview 10,SSAS,MS SQL Server Reporting Services, MS SQL Server Analysis Services,Oracle,PL/SQL, Erwin

Confidential - Philadelphia, PA

MSBI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirement and provided documentation.
• Engaged in gathering data and documenting it for further reference.
• Involved in installation and configuration of SQL Server 2008.
• Expert in designing database using ERWIN.v7.2
• Upgraded the server from SQL Server 2005 to SQL Server 2008.
• Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.
• Applied various MSBI data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column, and etc.
• Created SSIS packages for data Importing, Cleansing, and Parsing.
• Developed Unit Test Plans for SSIS packages.
• Modified the existing MSBI (SSIS) packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on daily basis.
• Designed, developed, and deployed reports in SQL Server environment using MSBI (SSRS 2008).
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for monitoring and tuning report performance.
• Involved in the design and development of web forms for the application using ASP.Net to take care the cosmetic works of the reports deployed on the server.
• Fine-tuned SQL Queries for maximum efficiency and performance.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Provided documentation for all kinds of reports, Stored Procedures and SSIS packages.

Environment: SQL Server R2, MSBI (SSIS, SSRS, SSAS), Oracle11g, Visual Studio 2005, VSS 2005, Erwin 7.3, Windows NT/2003,Microsoft .NET framework 3.5, C#, JavaScript, ASP.NET, XML

Confidential

SQL Server Developer / ETL Developer

Responsibilities:

• Worked with project lead and business users to understand business processes
• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2008
• Worked with T-SQL to create Tables, View and stored Procedures
• Created triggers on DML actions for security purpose
• Worked with Scalar and Table value User Defined Function as per business requirement
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables
• Encapsulated frequently used SQL Statements into stored procedures and reduced the execution time
• Wrote Merge Statement to handle insert, update and delete within single statement between source and destination table
• Scheduled jobs to call the packages and Stored Procedures as per business requirement
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle)
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS
• Created SSIS Packages to move the data from tab delimited flat flies into SQL database
• Made dynamic SSIS packages which did data scrubbing, including data validation
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them
• Developed Cascading, Drill-down Reports to get monthly card details and profits using SSRS 2008
• Deployed, configured and managed reports using Report Manager and Report Builder
• Created Cross-Tab and Sub-Report using RDL
• Promoted RDLs to Reporting Service Server

Environment: Microsoft SQL Server, SQL Server Integration Services tools (SSMS, BIDS and SQL Server Manager), SSRS, SSAS, Business Objects, Windows Server, MS Visio, Oracle, MS Excel.