OVERVIEW:

Have over five years of focused experiences in IT industry in various fields like financial and telecom domain. Extensive experiences in Microsoft SQL Server Business Intelligence (BI) and data warehouse design, analysis, modeling, development, administration, implementation, trouble shooting and quality management. Comprehensive experience as senior Microsoft BI and SSIS ETL developer; proficient in designing the logical and physical model of the enterprise level databases. Have impeccable communication and interpersonal skills and an exceptional team player.

OBJECTIVE:

• Microsoft SQL Server T - SQL Developer
• Microsoft Business Intelligence Developer (SSIS/SSRS)

PROFESSIONAL SUMMARY:

• Over five years of work experience in Database Design, Coding and Testing of various Microsoft Data Warehouse and Business Intelligence Projects.
• Complete understanding of Software Development Lifecycle and core area of experience in validating end-to-end business scenarios of B2B (Business to Business) applications, Enterprise Applications developed expertise in SSIS/SSRS/SSAS.
• Good exposure to entire Software Life Cycle Phases (Feasibility, System studies, Design, Coding, Testing, Implementation and Maintenance).
• Solid skills in designing and implementing data warehouses and data marts using components of Kimball Methodology, like Data Warehouse Bus, Conformed Facts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, Snowflake Schema, etc.
• Experience in creating Index, Views, complex Stored Procedures, appropriate user-defined functions (UDF) and effective Triggers to facilitate efficient data manipulation and data consistency on Microsoft SQL Server database platform.
• Having over 8 years of strong ETL and data integration experience in developing ETL mappings and scripts using Microsoft SSIS.
• Extensive experience in MS SQL Server 2008R 2/2012/2014/2016 and solid hands on experience in installing, configuring, managing, monitoring and troubleshooting SQL Server in Development, Testing and Production environments.
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008R 2/2012/2014.
• Proficient with SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS)/SSDT, SQL Profiler, Performance Monitor.
• Experienced with the creation of SSIS packages in Data Extraction, Transforming, and Loading (ETL) from various sources using SQL Server Integration Services, Bulk Insert, and Bulk Copy Program (BCP).
• Extensive experience with writing T-SQL scripts, stored procedures, triggers and functions, creating SQL Server Jobs/alerts, and scheduled tasks to automate tasks.
• Strong experience with server/database/scripts Performance tuning and optimization.
• Experience with monitoring, troubleshooting and resolving database issues in 24×7 production environment.
• Strong experience with SQL Server performance monitor and performance tuning, maintenance and SQL Server version upgrade.
• Excellent communication skills. Proactive, independent, self-managing and teamwork spirits.
• Proven ability to approach and solve problems effectively and independently; Experience to manage multiple priorities and handle multiple tasks.

TECHNICAL SKILLS:

T: SQL, C/C++/C#, PowerShell

Microsoft BI Stack: SSIS, SSRS, SSAS, SSMS

Relational Database: Microsoft SQL Server 2008R 2/2012/2014/2016 , Oracle, MySQL

Operating Systems: Agile/Scrum, Rally, JIRA, SVN, Git/Github, Visual Studio 2012/2013/2015

PROFESSIONAL EXPERIENCE:

Confidential, Glen Burnie, MD

Senior Microsoft SSIS/SSRS Developer

Responsibilities:

• Working as the key role in maintaining and enhancing key back office financial applications originally developed using SQL Server2012.
• Participated in the full life-cycle development process from definition and design to production delivery.
• Created complex analytic queries on very huge data sets; developed T-SQL stored procedures, triggers and user-defined functions.
• Developed complex stored procedure, views and user-defined functions on SQL Server (2008R2 and 2012); Identified weaknesses in T-SQL code and then improved those weaknesses for future release.
• Created unit test cases and technical documentation, perform detailed code reviews, and create automated build and deployment scripts.
• Designed and implemented Modular and Reusable ETL processes and associated data structures for Data Staging, Change Data Capture (CDC), Data Balancing & Reconciliation, Exception Handling & Reject Recycling, Surrogate Key Generation & Assignment, Data Lineage Tracking, ETL Auditing, etc.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files, Oracle etc. to SQL Server using SSIS various features such as multitasking, conditional split, union, union all, merge, lookup, fuzzy lookup, data conversion.
• Utilized the Agile Scrum software development principles and experiences to develop within the full life-cycle of the mission critical production application.
• Analyzed data requirements for the business applications; Developed data models and planned data migration/conversion strategies for internal and externally hosted applications.
• Maintained and enhanced the existing Data Warehouse, exports and reports; developed vendor and client exports that meet provided specifications.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Performed quality checks on reports and exports to ensure exceptional quality; monitored jobs and transfer queues to ensure they were functioning as expected.
• Migrated the existing MS Access reports to SSIS/SSRS and developed new SSIS/SSRS packages to meet business needs.
• Provided business users the data required for metrics and analysis; created and maintained documentations for all related projects.

Confidential, Warren, NJ

Microsoft T-SQL Developer, Consultant

Responsibilities:

• Responsible for full product life cycle development of a 3-tier object-oriented grant tracking program for automation of the grant evaluation and funding process, as well as workflow through the life of the awarded grants.
• Configured SSRS instance for reconciliation reporting efforts and database monitoring reports.
• Created very complicated tabular, list, matrix, charts, drill-down and drill-through/linked reports and parameterized SSRS reports.
• Provided application development support and SSIS debugging solutions for database administrator and line of business.
• Creation of more than 180 custom reports and 600 stored procedure.
• Designed technical documentation, relational diagram (ERD) of residuals and participations application.
• Data analysis and design for an electronic submission system and the import of applications from the web to MS SQL server.
• Development of dynamic web reports, email-enabled mail merge directly from the program via a sub-classed WinSock control. Met tight deadline for merging legacy data into MS SQL Server.
• Optimized the existing SSIS frameworks for the data imports and exports per department request system and sharing documents with the offshore team members on SharePoint.
• Analyzed the existing star schema database and built a priority matrix to be implemented in order to optimize database reporting and user queries.
• Daily support, troubleshooting, monitoring, optimization and tuning of SQL Server Jobs, Package and SQL Server environment across entire system.

Confidential, Saint Paul, MN

Microsoft SQL Server SQL and SSRS Developer

Responsibilities:

• Generated variety of business reports using SQL Server 2008 SSRS including matrix report, parameter report, and dashboard with charts and drill down function.
• Assemble and convert user requirements into standard reporting solution and customize specific user requests when necessary.
• Gathering Information and requirements from IS developers, analyze data, build internal reports to track and monitor daily processes. Create a new report platform for mails, Emails and phone calls.
• Designed and deployed various different professional reports with SSRS tools, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports. Set up Advanced functions, dashboard, Drill-Trough/Drill-Down, KPI/Indicators in reports.
• Identify and analyze expensive T-SQL stored procedure by using the SQL Profiler, SQL analyzer, create the necessary indexes and SQL hints to improve query performance.
• Schedule and manage daily / weekly / monthly sales and operational reports based on the business requirements.
• Developed Complex SQL queries using various joins and developed various dynamic SQL’s thorough out the projects. Tuning long-running SQL Queries, Procedures and Functions using SQL Profiler, SQL analyzer, Index tuning wizard.
• Coordinate with the team that responds to all system problems in order to reduce or eliminate production problems by analyzing production usage information and using that information to design a better architecture.
• Increase availability and performance of applications by gathering and analyzing server and database metrics with various monitoring tools.