SUMMARY:

• Around 8 years of experience in analyzing, designing, and developing Client/Server, Data Warehousing/ Data Modeling /Business Intelligence (BI) Stack database applications using MS SQL Server 2016/14/12/08/05 , SQL Server Integration, and Reporting & Analysis Services. (SSIS, SSRS & SSAS),Azure Data Factory, Data Lake Store, Data Lake Analytics.
• Extensive Experience in database administration, design, development and business intelligence of cosmos Microsoft SQL Server 2016/2012/2008 R 2/2005/2000.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Responsible for troubleshooting and debugging the issues at last stage of Escalation level, Proficient in legacy data conversions and interface development using SQL, PL/SQL, UNIX and SQL*Loader.
• Proficient in advance features of PL/SQL programming like Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
• Expert in creating SQL Queries, PL/SQL package, Functions, Stored Procedures, Triggers, Cursors, materialized views and customized views .
• Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan and DBMS PROFILER.
• Extensively used packages like DBMS STATS, UTL FILE.
• Expertise in handling errors using Exceptions.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Had experience in data modeling using Erwin, Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Expert in configuring and creating SSIS solutions for high performance Data Integration, Data Migration and Business Intelligence Process that includes Merging Data from various Heterogeneous Data Stores, Populating Data Warehouses and Data Marts, Cleaning and Standardizing Data.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Strong Experience in creating different formats of reports for internal and external reporting purposes including Ad Hoc, parameterized reports, Linked reports, Snapshots, Tabular, Matrix, Drill Down, Drill Through using SQL SSRS.
• Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule DTS/SSIS Packages.
• Expert in monitoring SQL Server Performance using SQL Profiler.
• Involved in administration tasks such as Data Loading, Batch Jobs, Data Unloading, Backup and Recovery, Upgrades, Creating Databases, Files, File groups and Transaction logs.
• Expertise working with Oracle 11g/12c, Developer 2000, PL/SQL, Forms 10g/6i, Reports 6i/10g, SQL * Loader, xml Publisher and BI Publisher.
• Strong hands on experience in programming with RDBMS like Oracleconcepts its technologies and products like PL/SQL, SQL, SQL Loaderforms 6i and 10g & Reports 6i and 10g,), Shell Scripting.
• Build ETL’s to extract data from Microsoft Big Data platform, Flat files and SQL Sources.
• Worked with Flat file, Excel file, SQL server OLEDB destinations for loading data.
• Experience in generating Parameterized Reports, Custom generated reports, Charts, Drill down, Drill Through reports using Local and Global Variables, Expressions and Filters in SSRS.
• Oracle Applications ‘Business Flows’ are well known and plan detailed test cases and scripts based on the Business Flows to conduct conference room pilots, system integration and user acceptance testing.
• Acted as a communications liaison between applications end-users, the SOP and technical teams for any communications to improve end-user satisfaction for Oracle Applications.

TECHNICAL SKILLS:

BI & DW Tools: SSIS, SSAS, SSRS, Data tools, PowerBI, PowerShell, Azure Data Factory, Azure Data Lake Store, Azure Data Lake Analytics, crystal reports.

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

ETL Tools: Data Transformation Services (DTS), SSIS, Import/export wizard, Bulk Insert, BCPData Warehousing.

BI Tools: SSIS, SSRS, SSAS, Crystal Reports XI/X/9/8, Report Designer, Business Intelligence Development Studio(BIDS), Cognos 10 BI tools (Report Studio, Analysis Studio, Query Studio, Cognos Connection)

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

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

MS Dynamics Axapta 2009: Financials

Web Technologies: Html, CSS

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

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

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Sr. MSBI/SSIS/SSRS Developer

Responsibilities:

• Actively involved in business rule analysis and gathered user requirements.
• Created ETL packages using SSIS to extract data from different data sources, reformats the data and load the reformatted data into destination tables.
• Designed Extraction Transformation and Loading (ETL) process using SSIS to extracted data from Flat files, excel files and SQL server database.
• Developed multiple test plans and test case documents working with Product Owners and Developers.
• Worked on data migration from Oracle sources to SQL server 2014.
• Expertise in optimizing long running T-SQL lookup queries by managing Clustered and Non Clustered Indexes, Stored Procedures for Incremental Loads and long data load by dividing the large data loads into Batch Tables with optimum batch size using execution plan.
• Worked on Dimensional modeling of the data from Scratch (Extracted the scratch data from heterogeneous sources and doing the ETL for incremental data loads using SSIS and building them into Dimension and Fact tables using Star Schema).
• Experience in using T-SQL for creating stored procedures, indexes, cursors and function.
• Interacted with Business Analysts for UAT (User Acceptance Testing), and tested the possibilities of system failure with UAT.
• Performed all development activities required for delivery of BI solutions including ETL, data modeling, cube development, solution deployment and maintenance.
• Responsible for data extraction, transformation and load for Trade Order Management Systems and Investment Analytic tools.
• Worked on various tasks and transformations like Execute SQL Task, Execute Package Task, and Conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Built new MDS (Master data services) and data warehouse application for business users and Migrated data from old data warehouse to new data warehouse. Developed and maintained Crystal reports as per the user requirement.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and Linked reports using SSRSand deploying them on the server.
• Build different types of chart reports using SSRS like column chart and Pie charts
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Handling and troubleshooting the scripts in failure to load the data into database.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Expert in SSIS Deploying and Scheduling jobs in TIDAL.
• Used Plan.io for Project tracking and worked in Agile Environment.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created reports and Dash boards using Microsoft Performance Point service.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.

ENVIRONMENT: SQL Server 2008/2 Enterprise Edition, MDS, Power BI, SSIS, SSRS, MS PowerPoint, MS Project, Oracle, PL/SQL, C#, Business Intelligence Development Studio (BIDS), UNIX and MS Visio, XML, Visual Studio 2008 & 2014.

Confidential, Bentonville, AR

MSBI/SSIS/SSRS Developer

RESPONSIBILITIES:

• Understand user requirements and Data Model defined and developed by the business analysts and data architects.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Involved in Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Created User Defined Functions (UDF’s) to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Designed & developed ETL procedures, Data dictionaries, D ata M appings involving Data A nalysis, Data V alidations and Data M igrations.
• Scheduled reports deliveries in multiple rendering formats with data-driven subscriptions.
• Extensive experience in Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment.
• Worked on SQL Server integration service (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources CSV, EXCEL, DB2, SQL 2005, 2008, 2012, 2014 and 2016.
• Create SSIS Package to Extract, Transform and Load Data using different transformations Such as Lookup, Derived column, Conditional Spilt, Aggregate, Pivot Transformation and slowly changing Dimension.
• Creating tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures. Wrote the ETL scripts to load the data into database from various source files. Experienced in error
• Created SSIS packages, cleaning data and loading data from various sources.
• Worked on various tasks and transformations like Execute SQL Task, Execute Package Task, and Conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Involved in populating data, generating reports using Reporting Services (SSRS) and deploying them on the server.
• Tracked and reported key metrics.
• Scheduled and monitored night work processes.
• Build ETL processes utilizing SSIS, including FTP data from remote location, transform it, mart it to data warehouse and provide proper error handling and alerting.
• Create triggers to keep track of changes to the fields of tables when changes are made.
• Assisted in SQL Server optimization including indexing and query optimization
• Created Drill Down, Drill Through, linked, matrix, Charts, lists, Sub reports using Power BI and SSRS and managed their subscriptions.

Environment: MS SQL Server 2008/2012/2014, SSIS,SSAS, SSRS,SQL Server Management Studio, Windows Server

Confidential, Arlington, VA

MSBI/SSIS/SSRS Developer

RESPONSIBILITIES:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Created SQL scripts for tuning and scheduling. Performed data conversion from flat file into normalized data structure.
• Created new SSIS Package to extract date from legacy to SQL SERVER objects using BIDS and Visual studio 2012.
• Written with Complex Queries, stored procedures, Batch Scripts, Triggers, indexes and Functions using T-SQL for SQL Server 2012/2014.
• Designed and provided Ad-hoc and Parameterized clinical reports using SSRS in SQL Server Data Tools for the internal use and client presentation.
• Created Subscriptions for the users to deliver the reports in a timely manner.
• Diagnosing and tuning the server and query optimal performance using SQL Server Profiler and Database Tuning Wizard.
• Involved in Debugging reports on the production and UAT servers by modifying the RDL files using XML.
• Developed complex Stored Procedures and Views to generate various reports using Excel and SSRS.
• Understanding the OLAP processing for changing and maintaining the azure Data Warehouse, Optimizing Dimensions and adding new Aggregations to the Cube.
• Created Jobs, Alerts, Activity logs, Error logs to capture any possible errors using SQL server Agent.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Responsible for creating and maintaining the documentation for implementation and for future changes.
• Used different transformations (Derived Column, Data Conversion, Condition Split, Lookup transformation, multicast, and script component transformation) under Data Flow Task while pulling and loading data from one source to another source to makes the data clean and consistent.
• Creating Indexes and used Scan and Seeks for performance tuning.
• Created subscriptions to provide a Daily/Monthly/Quarterly basis reports.
• Involved in performance tuning of T-SQL queries and Stored Procedure.
• Formatted the report layout for the requirement of the end users.
• Created indexes on selective columns of patient records for the faster retrieval of data in SQL Server Management Studio.
• Strong communication & Management skills with Excellent Role playing capabilities.

Environment: MS SQL Server 2008/2008R2/2014, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Data Tools, SQL Server Migration Assistant, SQL Server, SQL Server, TFS, Windows XP.

Confidential, Basking Ridge, NJ

MSBI Developer

RESPONSIBILITIES:

• Experience in Software Development Life Cycle (SDLC) including requirements gathering, writing technical specifications, Production support and Maintenance Activities.
• Involved in gathering business requirements and provided documentation to plan, define and design data.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Managed SQL Servers in 32/64bit Clustered environments. Implemented Database Mirroring on SQL Server 2008 environments.
• Migrated Database from SQL Server by using side-by-side migration.
• Designed and optimized dynamic SQL batches to perform bulk operations in the OLTP environment.
• Designed and developed efficient SSIS packages for processing fact and dimension tables.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Monitored performance with SQL Profiler and Windows System Monitor.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, Web Services) and loaded the data into target data sources by performing various kinds of transformations using SQL Server Integration Services (SSIS).
• Troubleshoot database performance issues and tune database objects. Set up traces and Profiler to troubleshoot performance.
• Administered the created Reports by assigning permission to the valid user for executing the reports.
• Created and maintained Databases, created Roles and managed user permissions and resolved blocks and deadlocks.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.

Environment: MS SQL Server 2008/2010/2012, SQL Server Integration Services (SSIS) 2010, SQL Server Reporting Services (SSRS) 2010, SQL Profiler, Database Engine Tuning Advisor, Tableau 7.0, MS Office, Windows 7.

Confidential

SQL Developer

RESPONSIBILITIES:

• Plan, design, and implement application database code objects, such as tables, stored procedures, functions and views in partnership with business analysts and technical architects.
• Implemented complex business logic and processes through T-SQL stored procedures, Functions, Views and advance query concepts.
• Collaborated and coordinated with business analysts to gather requirements for implementing data mart.
• Created required SQL procedures, functions, triggers, and views to supports OLTP and ETL application.
• Rewrote SQL queries to upgrade SQL Server performance using SQL Server 2005/2008.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Experienced in Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Involved in project planning also schedule for database module with project managers.
• Wrote T-SQL statements using DML and DDL for retrieval of the data.
• Extract data from database and export to Excel files for Data Analyst to analyze the data.
• Scheduled Packages using SQL Server Agent Jobs to execute at specified time on weekly and monthly basis.

Environment: MS SQL Server 2008/2005, SSIS, SSRS, T-SQL, Windows 2008 Advance Server, MS Excel, and MS Office.