SUMMARY:

• Around 7+yearsof experience in analyzing, designing, and developing Client/Server,Data Warehousing/ Data Modeling /Business Intelligence (BI)Stackdatabase applications using MS SQL Server 2016/14/12/08/05, SQL Server Integration, and Reporting & Analysis Services.(SSIS, SSRS & SSAS)
• 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.
• Expert in creating SQL Queries, Functions, Stored Procedures, Triggers, Cursors, materialized views and customized views.
• 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.
• 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 physicalData Modelingusingnormalizing Techniques.
• Had experience in data modeling using Erwin,Star SchemaModeling, andSnowflakemodeling, 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. Worked extensively on Extraction, Transformation, loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
• Extensively used Report Wizard, Report Builder and Report Manager for developing and deploying reports in SSRS.
• Experience in developing Dashboard, Ad-hoc and Parameterized Reports using SSRS.
• Strong experience in MS SQL Server with SQL Server Integration Services (SSIS)and SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Excellent analytical, high level and low-level design and problem solving skills.
• Expertise in Team Foundation Server (TFS) 2012/2010 & 2008 Administration Included Project Administration, Users, Groups, Permissions and Trigger, Data Tier.
• Good Knowledge onMicrostrategyreports, Development of Metrics, Attributes, Filters and various other Micro strategy components.
• Experience in handling Master Data Management (MDM) services and setting up the Master Data Services (MDS) to integrate and maintain various entities.
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Vision and Erwin Tool.
• Worked with Team Foundation Server (TFS), perforce as the source for version control and project/issue management.
• Skilled in design of logical and physical data modeling using Erwin data modeling tool.
• Strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.

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, VisualStudio, 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)

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.

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, Piscataway, NJ

Sr. MSBI/SSIS/SSRS Developer

Responsibilities:

• Actively participated in interacting with users, team lead, DBA’s and technical manager to fully understand the Application/System and Business requirements.
• Created several SSIS packages for performing ETL (Extract, Transform and Load) operations from OLTP to OLTP and OLAP systems.
• Assist data modelers in designing of dimensional model for Star schema.
• Involved in database Schema design and development.
• Created power shell scripts to transfer files from one folder to another and rename the files.
• Experienced in creating Standard and data-driven subscriptions with different delivery extensions like Windows File Share, E-mail and SharePoint Library.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, Unit testing to Go live production support.
• Used Power BI Power Pivot to develop data analysis prototype, for advanced visualize reports.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix and sub reports.
• Developed Oracle scripts, Functions and Packages using Oracle SQL developer.
• Created and managed database objects such as tables, views, indexes, stored procedures and user defined functions. Maintained user permissions, referential integrity, SQL agent jobs.
• Created Metadata reportsin SSRSthat gives the information about the metadata of the jobs like Effective from, Effective to, Current or not current report, Execution times and errors if there are any.
• Involved in creating measure groups using different fact tables and created calculated members, Advanced KPI’sand named set inSSAS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data as well as created interface stored procedures used in SSIS to load/transform data to the database.
• Migrating Oracle database source based SSRS reports to SQL source-based by changing the Oracle source code to SQL code compatible.
• Used Phabricator tool to verify the changes between existing script which is in source control to the script which I developed.
• Used JIRA project management system to track the enhancements and developments on a daily basis.
• Created SSIS packages to Oracle and other SQL Server instances in SSIS 2012/2014/2016.
• Expertise in building and migration of various DTS packages.
• Strong experience in creating and publishing packages in Framework Manager.
• Experience in creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.

Environment: Microsoft SQL Server 2005/2008/2012/2014/2016, SQLServer Reporting Services (SSRS), SQLServer Integration Services (SSIS), Power BI Desktop, SharePoint, TFS, Visual Studio 2015, SQLServer Analysis Services (SSAS), T-SQL, SQL Profiler, XML, Team Foundation Server (TFS) 2012, MS Excel, Excess, Windows 8.

Confidential, Jersey City, NJ

Sr. MSBI/SSIS/SSRS Developer

Responsibilities:

• Involved in installation of SQL server enterprise manager tools using SQL Setup.
• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
• Created database tables, Indexes, triggers by writing SQL queries as per the database change request by the business.
• Worked onBulk insert to load data from flat files obtained from various facilities every day.
• Created complex SQL queries, stored procedures, triggers, views, functions to implement business logic.
• Created and managed database objects such as tables, views, indexes, stored procedures, user defined functions. Maintained user permissions, referential integrity, SQL agent jobs.
• Created Ad-hoc reports with complex t-SQL queries based on business requirement.
• Wrote complex T-SQL queries and stored procedures for the building reports in SSRS.
• Developed, scheduled and generated variety of reports like List, Matrix, Drill-Down, Chart and Sub Report and standardize company report by implementing SQL Server Reporting Services (SSRS).
• Used SSRS to create reports, customized Reports, on-demand reports.
• Prototyped datavisualizations using Charts, drill-down, parameterized controlsusing Tableauto highlight the value of analytics in Executive decision support control.
• Enhancing and deploying the SSIS Packages from development server to UAT server.
• Worked on to develop Report Structure with data definition, report layout and report definition language.
• Created various Complex Formula Reports to query the database for business Intelligence.
• Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting the data, defining subtotals and handling parameterized reports and creating report layouts using SSRS.
• Developed different kind of reports such a sub reports, charts, matrix reports, linked reports. Creating SQL agent jobs after successful development of ETL packages and SQL codes.
• Good T-SQL Programming techniques in query optimization and performance tuning.
• Experienced in creating nested Grouping, sorting columns and writing expressions per the business requirements.
• Worked in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Developed Drill down, Drill through, ad hoc, sub reports, Dash boards, Cached reports in SSRS. Distributed reports via SSRS in different formats to users on a weekly, monthly basis.

ENVIRONMENT: Microsoft SQL Server 2005/2008/2012/2014/2016,, MS Access, ETL Packages (SSRS, SSIS),, PL/SQL, C#, HTML, IIS, Visual Studio 2012/2008/2005, Visual Source Safe, DTS, T-SQL, VSS, TFS.

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 azureDataWarehouse, 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 skillswith 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

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.