SUMMARY

• Expert in establishing relationships between tables using Primary Key & Foreign Key Constraints.
• Thorough knowledge in all phases of Software Development Life Cycle (SDLC), including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
• Expert in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
• Master in creating Databases, Tables, Joins, Stored Procedure, DDL/DML Triggers, Views, user - defined functions and Indexes using T-SQL.
• Knowledge of Crystal Reports, Impact, QNXT applications and experience with of database management and spreadsheet software.
• 4+ years of experience as a DataEngineerworking for a complex and fast-paced organization.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
• Experienced in Extraction, Transformation and Loading (ETL) process using MS-SSIS, DTS application tools.
• Excellent Knowledge of Integration Services (SSIS), Extracting, Transforming and Loading (ETL) data from Excel, Flat file, etc.
• Excellent in High Level Design of SSIS Packages for integrating data using OLE DB Connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Merge Join.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Created data sources, connection strings and defined the datasets for generating the report.
• Proficiency in creating different types of reports such as Cross-Tab, Drill-down, Drill-through, Parameterized reports, Linked reports, and Sub reports, and formatting them using both SSRS
• Experience in defining query for generating Cascaded Reports, Custom Reports and creating stylish report layouts in SSRS
• Good knowledge in deploying created reports in various sources like Web browser, XML and PDF.
• Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment.
• In depth understanding of SQL Server Migrations and problem management.
• Good experience in using tools such as SQL Profiler, Index tuning, Windows Performance for monitoring and tuning MS SQL Server performance.
• Experience in performing Back-up/Recovery, running Database Consistency Checks using DBCC, implementing security, configuring replication.
• Having excellent communication skills, analytical skills, understanding of business requirements in various domains.
• Actively participated in team building and led many operations for maintaining healthy work environment.

TECHNICAL SKILLS

Database Tools: SQL Server Management Studio, Query Analyzer, Business Intelligence Development Studio, SQL Profiler, QNXT

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Services (2012/2008(R2)/2008, 2005), MS Access, MS Excel.

Database: MS SQL Server 2012/2008/2005 , MS Access.

Languages: C, T-SQL

Operating Systems: Windows 2008/2012 server.

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), Visio, Team Foundation Server, DataEngineer

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr. SQL BI Developer/SSIS/SSRS/SSAS

Responsibilities:

• Developed ETL packages from scratch and transferred data from different sources to SQL and vice-versa.
• Well experienced in developing packages for transferring data from third party sources like Tangoe, SAP-Ariba, SAP-Concur etc. to the SQL database and vice versa.
• Developed packages to triggers ESS job schedules in the Oracle environment to load data from Zip files to Oracle.
• Involved in requirements gathering, analysis, design, development and implementation of various applications on PeopleSoft on MS SQL Server.
• Developed packages using the C# coding to call the web services to load the base and interface tables.
• Used SOAP UI for testing the web service request using WSDL.
• Involved in developing C# code that is used to convert the zip file to Base 64 string using SSIS
• Strong understanding of source to target mappings, used to build SQL tables and stored procedures.
• Developed stored procedures that generates header and detail files for different business processes.
• Created complex functions and stored procedures using the multi part identifiers, multi joins and T-SQL that support both OLAP and OLTP applications.
• Developed Backend by creating Tables/Store procedures and writing SQL queries in Azure SQL DB and Azure Data warehouse.
• Good Knowledge of ETLProcesses such source, mapping, transformation, staging areas and created various ETLdocuments such as ETLMapping documents.
• Implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS/ETL Packages.
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Experience in Converting legacy system data to Target applications and Systems.
• Experience in Designing and Implementing Data Warehouse applications, mainly Transformation processes using ETLtool also actively involved in Database Querying, Data Analysis, Production support, Review, on call support.
• Experience in writing parameterized queries for generating tabular reports Drill down, Drill Trough, Cascading, matrix chart, snap shot reports Formatting report layout, sub reports, using Global Variables, Expressions, sorting the data, defining data source and subtotals for the reports using SSRS.
• Strong experience in successfully implementing abrupt changes/updates in Business logics, which are critical to Client Reporting.
• Good understanding of SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Upgraded Excel reports to SSRS reports.Configured and deployedSSRS reports onto Report Server.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS and SSIS Packages.
• Assembled and converted user requirements from multiple clients into our standard reporting solution and customized specific client requests when necessary.
• Responsible for building Power BIDashboards using Tabular Models. Design and model data sets withPower BI desktop based on measure and dimension requested by customer and dashboard needs.

Environment: SQL server 2008/2012/2014 Enterprise Edition, Azure, ETL, SSRS, SSIS, SSAS, Power BI, .NET Framework, C#, ASP.NET, ADO.NET, Oracle 11g/10g, Visio, MS IIS, XML, MS Excel, Access and Visual Source safe.t

Confidential, Vestal, NY

SQL BI Developer (SSRS/SSIS)

Responsibilities:

• Creating Reports using Microsoft SQL Server Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder
• Developing highly optimized stored procedures, functions, and database views to implement the business logic.
• Creating reports to retrieve data using Stored Procedures that accept parameters.
• Administering interface to organize reports and data sources using SSRS.
• Developing Drill down Reports, Drill through Reports and Matrix Reports by using SSRS.
• Generate various Monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS and SQL server Management studio 2017
• Writing Parameterized Queries for generating Tabular reports using Expressions and Functions, Sorting the data and Subtotals for the reports using SSRS.
• Developing Charts (Pie Charts) and Graphs like Bar Chart using SSRS.
• Collaborate with teams to integrate systems.
• Develop and Execute database queries and conduct analysis.
• Design, build and deploy reporting solutions.
• Translate business needs to technical requirements.
• Created complex Stored Procedures, Functions, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements.
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
• Implemented data partitioning to improve the performance of large table, reduces contention and increases availability of data
• Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop. Documented User Stories and facilitated Story Point discussions to analyze the level of effort on project specifications
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Extensively used SSIS Import/Export Wizard for performing the ETL operations and various containers to do the looping operations.
• Setup and configured Database mirroring in High Performance, High availability mode as standard DR strategy.
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS and Scheduled package execution in SSIS and Installing packages on multiple servers in SSIS.

Environment: SQL Server 2008/2012, Microsoft Visual Studio 2013/2012, MS Server Integration services, SSRS (MS server Reporting Services), SSIS QNXT, T-SQL

Confidential, Virginia Beach, VA

MSBI Developer (SSIS/ SSRS)

Responsibilities:

• Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures.
• Involved in Database design & Data modeling various databases.
• Generated DDL scripts for database schema and created all other database objects.
• Involved in merging existing databases and designed new data models to meet the requirements.
• Developed highly optimized stored procedures, functions, and database views to implement the business logic and created clustered and non-clustered indexes.
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Used various SSIS tasks such as Conditional Split, Derived Column etc. which including data validation checks during Staging, before loading the data into the Data warehouse.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system.
• Identifies transition opportunities between various systems such as Case Trakker or IMPACT to QNXT and with other solutions, including development, crosswalks, SQL programming, system integration requirements, timelines and departmental updates
• Responsible for implementation of Data viewers, SSIS Logging, Error configurations for Error handling, Try Catch Blocks in the packages.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions and Functions, Sorting the data and Subtotals for the reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Created and deployed Adhoc reports, drill down reports as required. Performance tuning the existing reports.
• Developed various Charts (Pie Charts) and Graphs like Bar Chart using SSRS.
• Responsible for Performance Tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard.
• Involved in performance monitoring, tuning and capacity planning.
• Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database.

Environment: SQL Server 2008/2012, Microsoft Visual Studio 2013/2012, MS Server Integration services, SSRS (MS server Reporting Services), QNXT, T-SQL

Confidential, Richmond, VA

MSBI Developer (SSIS/SSRS)

Responsibilities:

• Gathered initial requirements from the users of various departments and corresponded with them throughout the process.
• Installed and upgraded from SQL Server 2008 to SQL server 2012 on Various Servers.
• Created DDL scripts to create Database schema and Database objects like tables, stored procedures, views, functions using T- SQL.
• Developed Views and Temporary Tables as per the requirement.
• Created Triggers to enforce data and referential integrity, on the specific table which helped users to prevent inserting invalid data or to respond to a certain event like INSERT, UPDATE and DELETE.
• Involved in database designing using Normalization and Normalized the entities and De-Normalized for data warehousing purpose.
• Worked with Integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, and Text Format Data.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
• Experienced in creating jobs Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL Server Agent job.
• Created complex reports which involve a greater number of groupings and multi-value parameters.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Designed and developed different type of reports including Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, custom report, Drill down reports using SSRS.
• Responsible for Deployment of the report-to-report server using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Created automated jobs to perform daily backups
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.

Environment: Windows server 2008, SQL Server- 2012/2008/2005 Enterprise Edition, SSIS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, QNXT, OLTP.

Confidential, Bronx, NY

SQL Server Developer /DBA

Responsibilities:

• Created Tables, Stored procedure, Functions, Triggers and Views using TSQL.
• Prepared Data Flow Diagrams, Entity Relationship Diagrams and Table Structure.
• Used DDL and DML commands for writing triggers, stored procedures, and data manipulation.
• Created joins and sub-queries for complex queries involving multiple tables.
• Created Temp Tables, and Views, Functions, Triggers, indexes and Stored Procedures to populate data into the SSRS reports.
• Wrote complex SQL statements using joins, sub queries and correlated sub queries.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Generated T-SQL scripts for application development.
• Created Stored Procedures and User Defined functions.
• Participated in re-design and development of back-end SQL Server database, wrote queries, triggers and stored procedure.
• Scheduled Jobs and Alerts using SQL Server Agent.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Designed developed and deployed Tabular and Matrix Type List, linked and Sub-Reports with Charts and Document maps using SSRS.
• Migrated data from an Access database to SQL Server 2008.
• Gathered requirements for the creation of Data Flow processes for the SSIS packages.
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Visual Studio 2010, Windows 7.0, SVN, MS Outlook 2010, SQL Server 2008/2005, SSRS