SUMMARY:

As the experienced Microsoft SQL Server and BI developer, I have the genuine excitement and passion for developing and analyzing large, complex data sets and converting them into the information/insights that drive business decisions at all levels of the organization. I am looking for my next stop to utilize my hands - on experience and skills on Data Warehouse and MS business intelligence design, development filed to maximize the business value for my customers.

OBJECTIVE:

• Microsoft SQL Server Database T-SQL Developer
• Microsoft BI (SSRS & SSIS) Developer

PROFESSIONAL SUMMARY:

• Good IT experience in Analysis, Design, Development, Implementation, Testing & Support of Data Warehousing and Data Integration Solutions, using Microsoft BI stack (SSIS/SSRS).
• Proficient knowledge in developing SQL with various relational databases like Oracle and SQL Server, complete knowledge on reading and writing T-SQL and PL-SQL queries, including Stored Procedures, UDF and Triggers.
• Has deep understanding about how Microsoft SQL Server works, and rich experience in database design, performance tuning and complex problem troubleshooting.
• Expertise experience in relational database design, data extraction, transformation and writing stored procedures, functions, triggers, from large and complex data sources using Oracle(SQL * Plus, PL/SQL), MS Access and MSSQL Server (SQL,T-SQL).
• Involved in all phases of Software Development Life-Cycle (SDLC) like Agile/Scrum methodologies.
• Adequate experience with dimensional modeling using Star Schema and Snowflake Schema, OLAP/DW, OLTP, Physical and Logical Data Modeling using different data modeling tool Erwin; expertise in design and implementation of various types of Slowly Changing Dimensions (SCD).
• Good understanding of Data Integration patterns, ETL Performance, Parallelism Strategies and Debugging/Troubleshooting performance problems.
• Advanced SSIS concepts of DW package design for Incremental load, slowly changing Dimensions.
• Skilled at building and deploying multi-valued parameterized reports including matrixes, charts, and gauges in SSRS.
• Hands on experience on all phases of Software development life cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.
• Strong business understanding of financial institutes and pharmaceuticals, outstanding communication and interpersonal skills, ability to learn quickly, good analytic reasoning and high compliance to new technologies and tools.

TECHNICAL SKILLS:

SQL/T: SQL, C/C++/C#, PowerShell, Visual Basic, HTML5/CSS, JavaScript

Database: MS SQL Server 2012/2014/2016/2019 , Oracle 12c/19c

Data Tools: MS Excel & VBA, SSMS, Toad for SQL Server

MS BI Stack: SSRS, SSIS, Visual Studio 2013/2015/2017

Platform: Windows Server 2012R2/2016/2019, CentOS/Redhat Linux 6/7/8

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Senior Microsoft SQL Server and SSIS Developer

Responsibilities:

• Effectively managed day-to-day tasks / activities in coordination with a team of developers to effectively meet the deliverables and schedule of a data solution component within a larger application project.
• Used Agile/Scrum methodology to complete each task on its complexity level and worked on Sprint methodology.
• Collaborated with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.
• 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.
• Scheduled jobs to execute SSIS packages which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks.
• Performed tune to optimize SQL queries using SQL profiler and query analyzer. Involved in performance tuning of the database and T-SQL queries using Explain Plan. Created Indexes, Constraints and Rules on database objects.
• Developed cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes, dimension members, calculation, actions, partitions and perspective using SQL Server Analysis Services 212 to analyze data based on sales information.
• Worked on Sev1, Sev2 Issues and also providing 24x7 On-Call Support and provided on-call and day-to-day support.
• Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases.

Confidential, Englewood, CO

Senior Microsoft SQL Server Developer

Responsibilities:

• Partnered with program manager to identify requirements, identify and evaluate alternatives, and implement solutions.
• Architect, design, and develop data models, multi-dimensional schemas and SSRS reporting systems for internal partners based on business requirements.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Used SSIS Packages for importing and exporting the data from various databases to excel, XML and flat files by making use of BCP, Bulk Insert.
• Developed enterprise KPI’s into Dashboards - Summery with Details for Accounting, Marketing, Scheduling
• Planed, Analyzed, Designed, Developed, Implemented, Maintained, and Controlled Application Databases for online channels / Equipment Inventory and Maintenance.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Involved in VB and C# coding for the customization of the SSIS packages.
• Using SQL Server Analysis services 2016 created & enhanced Cubes, Dimensions, Measures based on the business requirement.
• Using Dimension Creation wizard created Standard Dimensions with attributes, relationships, Levels and hierarchies and tested using Dimensions browsers.

Confidential, Highlands Ranch, CO

SQL Server T-SQL Developer

Responsibilities:

• Responsible for requirements gathering, status reporting, creating various metrics, project deliverables.
• Designed, developed, tested, and implemented SSRS reports with multi-parameter, chart, drill-down, drill-through, sub-report and interactive sorting capability for business teams.
• Generated variety of business reports using SQL Server 2008 SSRS including matrix report, parameter report, and dashboard with charts and drill down function.
• 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.
• Work with development teams to make best schema design that balances feature requests with performance concerns.
• 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.
• Built efficient ETL packages with SSIS to fetch, cleanse and transform data from various types of sources.
• Develop package configurations dynamically as well as populating variables dynamically.
• Increase availability and performance of applications by gathering and analyzing server and database metrics with various monitoring tools.