SUMMARY

• I am a highly experienced Microsoft SQL Server database (T - SQL) and Business Intelligence developer specializing in complex T-SQL programming, Microsoft BI stack (ETL/SSIS, reporting/SSRS), database design, and dataset analysis with the proven ability to work with and influence change in different industries (banking, telecom and insurance).
• More than six years of solid and hands-on experience with Data Warehouse and Business Intelligence field in System Analysis, Design, Development and Supporting in Microsoft SQL Server 2012/2014/2016 platform.
• Strong experience in all stages of Microsoft BI project work (requirements and logical design, physical design, implementation, testing and deployment).
• Experience in developing high performance data integration solutions with SSIS, including extraction, transformation, and load (ETL) packages for data warehousing.
• Strong experience in developing Transact-SQL (T-SQL) scripts, stored procedures, triggers and functions.
• In-depth knowledge of complex T-SQL. Power user of advanced SQL queries with multi-table joins, group functions, sub-queries, set operations and window functions.
• Expert in creating indexes, views, complex triggers, effective functions and stored procedures to facilitate efficient data manipulation and data consistency.
• 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 2012/2014.
• Sufficient skills of monitoring and optimizing system performance by optimizing SQL queries, using report cache and snapshot.
• 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.
• Solid knowledge and experience of Agile/Scrum software development life cycle and project management methodology.

TECHNICAL SKILLS

Operating Systems: Windows Server 2008R2/2012/2012R2, Redhat/CentOS Linux 6/7

SQL Server BI Tools: SQL Server Management Studio (SSMS), SSRS, SSAS, SSIS

Programming Languages: T-SQL, PowerShell, C/C++/C#, Java, HTML/CSS, JavaScript

Development Tools: Microsoft Visual Studio 2012/2013/2015

Relational Database: MS SQL Server 2012/2014/2016 , Oracle 11g/12c

PROFESSIONAL EXPERIENCE

Confidential, Chevy Chase, MD

Senior SQL Server and SSIS Developer, Consultant

Responsibilities:

• Review and assess existing enterprise databases and data warehouse solutions, to support new features, performance improvements, upgrades, and ongoing sustainment.
• Utilized the Agile Scrum software development principles and experiences to develop within the full life-cycle of the mission critical production application.
• Plan and conduct architecture assessments that examine server-side, client-side, and database system configuration and performance.
• Designed the reporting solutions utilizing company’s standard development procedures and techniques that support the project requirements.
• Converted existing reports and processes to the standardized set of data sources. Supported the complete software development lifecycle, including requirements gathering, design, specifications, development, change management, testing, and deployment activities.
• Analyze large, complex systems to determine performance bottlenecks, application bugs, and opportunities to improve efficiency.
• Investigate application anomalies to determine root cause. Resolve data issues per business needs. Perform ad hoc queries as needed. Develop and maintain general and online program reports.
• Assist application developers in designing program enhancements, database backup and recovery. Perform performance monitoring on database.
• Create data extraction, cleansing and load programs to move data into and out of the Data Warehouse by using SSIS package.
• Identify and analyze expensive T-SQL stored procedure by using the SQL Profiler, Extended Events, create the necessary indexes and SQL hints to improve query performance.
• Maintained data load operations using T-SQL procedures, SSIS packages and .Net applications; optimizations of data load operations; maintaining daily / weekly / monthly data loads and data distribution operations; troubleshooting of the existing code issues, data issues to meet data load SLAs as defined by the client.
• Maintained and enhanced the existing Data Warehouse, exports and reports

Confidential, Charlotte, NC

Senior Microsoft SQL / BI Developer, Consultant

Responsibilities:

• Worked as part of a team responsible for design and development of an enterprise wide business intelligence solution with SSIS/SSRS and Tableau.
• Provided functional and technical development support for comprehensive report development from various data sources.
• Met frequently with management to discuss needs or requirements and translate into intuitive information dashboards and visualization.
• Responsible for developing and implementing solutions using data visualization techniques, organizational data warehouse, data marts, and operational data stores.
• Consulted with business users regarding the use and management of data as well as work in design, maintenance, and completion of highly visible organizational projects and created efficient solutions.
• Developed, implemented and maintained schedule/dependency logic for automated SSIS ETL processing.
• Developed monitoring, logging, and error notification processes to ensure data was updated as expected and processing metrics reported.
• Composed various T-SQL 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.
• Developed and maintained reports and services using SSMS and SSRS. Worked with clients to define, analyze and document complex business and reporting requirements under the direction of upper-level Analysts.
• Created unit test cases and technical documentation, performed detailed code reviews, and created automated build and deployment scripts.
• Collaborated with other groups (business partners, developers, QAs and production support engineers) in implementation of analytical and technical solutions.

Confidential, Highlands Ranch, CO

MS SQL Server T-SQL Developer

Responsibilities:

• Designed, developed and optimized SSIS ETL data transformations to propagate analytical data from various systems.
• Participated in the planning and implementation of projects, which includes the design and execution of test plans to ensure a successful implementation.
• Developed system documentation for all Business Intelligence solutions, including design and technical specifications. Performed thorough testing of myself and other team members’ developed projects.
• Analyzed and identified data issues and worked with technical staff to resolve; recommended solutions to optimize reporting and other analytical goals.
• Built and maintained T-SQL scripts, indexes, and complex queries for data analysis and extraction.
• Worked with Agile team members to document and execute test plans for data loading and data validation scripts. Supported the code promotion process through development and production as required.
• Ensured the creation, delivery, and modification of queries, and reports and management of reports; ensured the successful deployment of business intelligence reports to the production environment.
• Documented functionality and technical design specifications; fulfilled other ad-hoc data requests for users.