SUMMARY

• Around 5 years of professional experience in development, implementation and administration of database systems using MS - SQL Server 2014/2008R2/2008 for both OLTP & Data Warehousing Systems applications.
• Experienced in Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation.
• Well-developed skills in SQL Server Integration Services 2005/2008/2012 for data extraction, transformation and loading using different heterogeneous source systems like flat files, Excel, SQL Server.
• Strong knowledge of Data Warehousing methodologies and concepts including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Adept in RDBMS concepts and constructs along with Objects creation such as Database, Table, Normalization, UDF, User Defined Data Type, Indexes, Stored Procedures, Views, Cursors and Triggers.
• Experienced in using SSIS, SSAS & SSRS for various BI requirements.
• Experienced in Data Extraction, Transforming and Loading (ETL) using DTS package in MS SQL Server and SQL Server Integration Services (SSIS) in MS SQL Server with .NET, Import/Export data, Bulk insert and BCP.
• Experienced in SSIS script transformations and scheduling complex SSIS Packages for transferring data automatically from multiple data sources to SQL server.
• Expert in Database Normalization, Optimization, Tuning, Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization.
• Strong experience in creating various reports like Drill through, Drill down and Ad-hoc according to the user requirement using SQL Server Reporting Services (SSRS).
• Possess detailed knowledge of aggregation using OLAP analysis services cube.
• Experienced in developing Logical and Physical data models using data modeling tools such as Erwin and MS Visio.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports and MS Excel spreadsheets.
• Knowledge of developing cubes in SSAS and Analyzing Dimensions and Measures.
• Worked on SharePoint development and scheduling reports using it.
• Expert in automation of creating jobs, error reporting using Alerts, SQL Mail Agent.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out.
• Ability to quickly adapt to new environment and work with variety of people at various levels.
• Ability to work in environments with fluctuating priorities and deadlines, foresight to handle upcoming issues and dedication to solve complex problems with experience and research.
• Excellent communication skills, bridging Client Interaction and Team player.
• Organized professional with excellent oral and written communication skills, excellent presentation and interpersonal skills, problem solving skills, and a fast learner who also adapts quickly to new technologies with the ability to take new roles in minimum time with little training.

TECHNICAL SKILLS

RDBMS: SQL Server 2014/2008R2/2012, MS Access

Languages: C, VB.NET, C#, VB, ASP.NET, Java, Java Script, jQuery, Bootstrap-SQL, PL/SQL, PHP, HTML, XML

ETL Tools: DTS, SQL Server Integration Services (SSIS).

Tools: Business Intelligence Development Studio (BIDS), SQL Profiler, SQL Query Analyzer, SQL Server Management Studio, SQL Server data tools (SSDT).

Database Tools: SQL Server Enterprise Manager, SQL Server Management Studio, Query Analyzer, SQL Profiler, Data Transformation Services(DTS), ETL, Query Builder, BCP, Bulk Insert, SSIS, SSAS, SSRS, BIDS, VSS, Crystal Reports, ERWIN.

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports

Operating Systems: Windows NT/ 98/2000/2003/ windows 7/Vista/ Windows 8, UNIX

Case Tools: MS Office 2010/2007/2003 , MS Excel 2010/2007/2003 , MS Outlook 2010/2007/2003 , MS Visio, SharePoint Server.

PROFESSIONAL EXPERIENCE

Confidential, Bridgewater, NJ

MSBI Developer

Responsibilities:

• Experience in Development, Implementation and Reporting in MS SQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000 with Business Intelligence in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Proficient in Creating, Configuring and Fine-tuning SSIS packages, SSRS reports and T-SQL queries using tools like SQL Profiler, Performance Monitor and Database Engine Tuning advisor.
• Expertise in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.
• Expertise in creating reports such as Cascading, Drill down/Drill through Reports, Conditional, Table, Matrix, Charts, Ad-hoc Specialized in using Relational data warehouse and OLAP Cubes for producing Sub Reports.
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Performed DAX (Data Analysis Expressions) & MDX functions for the creation of calculations and measures in the Tabular Mode & multi-dimensional Cubes.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• Generating SSRS reports using drill down, drill through and other functionalities.
• Developed reports with charts, matrixes, and sub report. Deployed reports on web server for user viewing.
• Involved in unit testing against the developed packages and reports.
• Deployed and scheduled Report subscriptions using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Performed unit and system testing, troubleshooting and bug fixing in Prod and QA environments.
• Optimized the performance of reports by using various techniques like optimizing data-sets, making use of less number of input parameters along with caching and taking snapshot of reports.
• Implemented security on reports at Server Level, Report Level and Item Level according to the hierarchy in the organization and business requirement.
• Performed configuration and deployment of various reports using SQL Server Reporting Services (SSRS) on the report server.
• Experience in deploying SSIS Package, SSRS Reports and SSAS Cubes using command line utilities.
• Hands on experience on Data Warehouse Star Schema Modeling, Snow-Flake Modeling, FACT& Dimension Tables, Physical and Logical Data Modeling.

Environment: MS SQL Server 2012/2014, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS 2014), SQL Server Analysis Services (SSAS 2014), SQL Server Reporting Services (SSRS 2014), Power BI, Power Pivot, Windows 2010, MS Excel, SQL Server Profiler.

Confidential, Dulles, VA

MSBI Developer

Responsibilities:

• Designed and developed packages for Data warehouse using Integration Services (SSIS) SQL Server 2014.
• Created Packages which includes Control flow tasks, Data flow tasks, Event Handlers, Breakpoints and Checkpoints in SSIS.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Developed SQL Scripts to dynamically manipulate data and generate well-formatted reports based on user requirements.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS) and OLAP.
• Automate the generation of various dynamic reports on a daily and weekly basis.
• Optimize SQL 2014 stored procedures for enhanced performance and robustness.
• Worked with T-SQL to create Tables, Views, Stored Procedures, CTE and Temp tables.
• Responsible for testing and debugging the SQL Scripts.
• Efficiently identified business user needs. Created complex Stored Procedures, DTS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Experienced in developing T-SQL (DDL, DML) statements using dynamically generated SQL.
• Generated reports using SSRS 2014 as per business requirements.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split, Execute SQL Task) and more.
• Used Breakpoints & Event Handlers to debug packages & capture errors.
• Designed SSIS Packages to transfer data from various sources like Text Files, SQL Server, Excel and Access to SQL Server using Business Intelligence Development Studio.
• Closely worked with DBA’s and Business Needs team for deploying the packages.
• Used Merge statement to update rows, to insert new rows, and to delete invalid rows in destination table.
• Loaded Fact/Dimension Tables using Lookups, and Conditional Splits.
• Developed objects (i.e. tables, views and stored procedures, functions, indexes) in SQL Server 2014 to get a better and faster performance.
• Optimized long running Stored Procedures and Queries for effective data retrieval.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.

Environment: Microsoft SQL Server 2014, Visual Studio 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

Confidential, Tampa, FL

MSBI Developer

Responsibilities:

• Prepared the complete data mapping for all the migrated jobs using SSIS
• Responsible for creating and designing SSIS package
• Designed Extraction Transformation and Loading (ETL) process using SSIS to extract data from flat files, excel files and SQL server database
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations
• Use different control flow control like for each loop container, sequence container, execute SQL task, send email task
• Use package configuration to migrate SSIS package from one environment to other
• Use event handing to send e-mail on error events at the time of transformation
• Use login feature for analysis purpose
• Added intelligent system in SSIS to identify actual change and new change in dimension
• Involved in gathering business requirements and development of data modelling to facilitate business and operational needs.
• Database and Log Backup, Restoration, Backup Strategies, Scheduling Backups.
• Improved the performance of the SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.
• Perform tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Defined Indexes, Views, Constraints and Triggers to implement business rules.
• Involved in Writing Complex T-SQL Queries.
• Backing up master & system databases and restoring them.
• Developed Stored Procedures and Functions to implement necessary business logic for interface and reports.
• Involved in testing and debugging stored procedures.
• Designed, built and tested SSAS Cubes on SQL Server.
• Created Excel workbooks to enable Cube (SSAS) access for business users.
• Process the cubes (SSAS), partitions as and when required.
• Writing the DAX statements for Cube
• Designing Visualizations in Tableau 9.2

Environment: MS SQL Server 2008/2008R2/2012, SSIS, SSAS, TFS, Windows 2003/2008, Deployment Wizard, Visual Studio 2010, MS Excel 2007, Tableau, C#, ASP .Net

Confidential, Houston, TX

MSBI Developer

Responsibilities:

• Analyzing the requirements and preparing technical design documents/ updating the existing documents as per the latest requirements.
• Responsible for resolving issues that get raised in the supporting applications within the timeline provided.
• Ensured that none of the solutions breached the committed timeline and are of perfect quality.
• Responsible for enhancing the code wherever required in the existing solutions as part of maintenance, which includes performance optimization.
• Developed new BI applications using ETL tool SSIS, Cube designing SSASmulti-dimensional model and SQL Server. Majorly part of Cube designing.
• Created the SSIS packages to extract financial metric data from formatted excel sheets to the system database.
• Used control flow elements and dataflow elements and several data converters to transfer data from any source including OLEDB source to destination element.
• Added several logics to divert the data from one source to several tables based on the business logic.
• Merged the data using Merge components in SSIS from several data sources and transfer to the destination.
• Created Views and Stored Procedures, Constraints and Indexes on the database tables.
• Created User defined functions and called from Stored Procedures.
• Expertise in building complex SQL Joins
• Modified queries and stored procedures and performed performance tuning to execute the query faster and efficiently.
• Tested SSIS Packages and reports
• Performed Unit testing, Integration testing, moving it to Production environment and data loading.
• Quality Assurance.
• Worked on Remedy tool for requirements and issue tracking.
• Worked on Team Foundation Server for source code management.

Environment: SQL Server 2008 R2/2012, Visual Studio 2008/2010 Business Intelligence Development Studio (BIDS), Remedy tool, Team Foundation Server (TFS).

Confidential

SQL Server BI Developer (SSIS, SSAS, SSRS)

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, FTP Server, Excel, DB2 and SQL 2012).
• Actively participate in the Design, Build, Test and Deploy phases of Siebel UCM implementations for Oracle customers.
• Project-manage Oracle MDM implementations for Oracle customers.
• Set Customer best practices expectations revolving around MDM.
• Advise Oracle MDM usage and design to best fit customer business process requirements
• Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes, if SSIS packages extract row from DB2 to CDC DB, or any insert, update or delete rows in dimension or fact tables in DW.
• Filtered data from Transient Stage to EDW by using Complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, FTP Task Package Execution task to achieve business needs.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Developed SSIS Packages to move data from one database of a server (Partner) to another (CRM) using Web Services Call.
• Wrote and modified various Stored Procedures used in the application using T-SQL.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent.
• Responsible for creating partition function and schema for the table partitioning.
• Involved in creating counter logs and trace logs for advanced performance analysis and data logging over a period of time.
• Created SSIS 2012 Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Created various jobs using SQL Server Agent.
• Used SQL Server Profiler to trace the slow running queries and the server activity.

Environment: Microsoft SQL Server 2012, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) Visual Studio 2010/2008, SQL Server Agent, Windows server 2008, Erwin 7.2, Visual Source Safe 2005, C#, SQL Profiler.