SUMMARY

• Over 10 years of IT experience with focus on the Analysis, Development, Implementing, Maintaining, and Testing Business Application using Microsoft SQL Servers and Oracle Relational Database Management Systems (RDBMS.)
• Experienced in Microsoft Business Intelligence stacks such as SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and Power BI.
• Experience in writing T - SQL (DDL, DML, Views, Stored Procedure, User Defined Functions, Triggers, CTE, temp tables, table variables, Cursors, Constraints and Indexes etc.)
• Well-versed with design goals of ER modeling for OLTP and Data modeling (Dimensional & Relational) OLAP concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Designed and developed SSIS packages for transforming data from heterogeneous sources systems into data warehouse.
• Worked on complete SSIS life cycle by creating SSIS packages, building, deploying and executing the packages in both development and production environments.
• Delivered BI reporting solution using SQL Server Reporting services (SSRS.) and Power BI.
• Designed, developed and delivered visualizations and analytics to business stakeholders.
• Proactively Liaison by assisting build team manager and various stake holders of the company to meet project timeline.
• Worked on both Development and Production environment, supervised the workload, and managed multiple escalations by meeting SLA guidelines across various client applications.
• Experienced in Tuning Queries for better performance with large volume of data.
• Manage deployment using MS Visual Studio, Team foundation server, and Azure Dev Ops.
• Troubleshoot and fix production issues. Identify root cause, and improve performance of the Datawarehouse and ETL process.
• Experienced in agile work environment and used team Collaboration Software like Confluence & JIRA.
• Strong in the complete Software Development Life Cycle (SDLC) including planning, requirement, design, development, testing, deployment, and maintenance of systems.
• Excellent communication skills, strong analytical, managerial, and problem-solving skills.

TECHNICAL SKILLS

Operating System: Windows 10/8/7/vista/XP/ Linux

RDBMS: MS SQL Servers, Oracle SQL Developer, MS Access.

Languages: SQL, T-SQL (Transact SQL), PL/SQL, HTML

Database Tools: SQL Server Management Studio (SSMS), SSDT, TFS, Visual Studio, Oracle SQL developer, Azure DevOps

ETL Tools: SSIS (SQL Server Integration Services), MS Azure.

Reporting/Analysis: SSRS, Power BI, SSAS, Report Builder.

PROFESSIONAL EXPERIENCE

Confidential, Olympia, WA

Business Intelligence Lead Developer

Responsibilities:

• Business Intelligence Development and maintenance using SQL, SSIS, SSAS, SSRS, Power BI, and MS Azure technologies.
• Work on Datawarehouse modernization to enhance performance and quality of the data.
• Create and maintain ETL packages. Migrate data from multiple data sources to Datawarehouse and Data cubes.
• Worked on complete SSIS life cycle by creating SSIS packages, building, deploying and executing the packages in both development and production environments.
• Design, Develop and maintain Fact and Dimension tables.
• Develop reports using SSRS and Power BI.
• Manage deployment using MS Visual Studio, Team foundation server, and Azure Dev Ops.
• Provide production support by identifying production issues during batch cycle processing, communicate with impacted user group, and work with database/development teams to fix issues.
• Troubleshoot and fix production issues. Identify root cause, and improve performance of the Datawarehouse and ETL process.
• Involved in gathering requirements, analyzing the functional specifications, and writing technical documentation.
• Work on Multi-Dimensional Expressions (MDX) to query the SSAS Cubes, identifying Key Performance Indicators (KPIs), and in creating Dashboards and Score Cards.
• Effectively deal with legacy systems and provide input on re-architecture and refactoring.

Environment: MS SQL Server, Oracle SQL Developer, SSIS, SSRS, Power BI, SSAS, TFS, Agile, Azure Dev Ops, Visual Studio, .NET.

Confidential, Topeka, KS

SQL BI Lead developer

Responsibilities:

• Work on multiple development projects, production support incidents, and manage escalations items reported by clients.
• Work on various technologies using SSIS, Power BI, SSRS, SSAS, SQL Server, Oracle RDBMS, and Visual Studio.
• Develop SQL queries using stored procedures, functions, views, triggers, CTE’s, temporary table, indexes, ad-hoc queries, etc.
• Experienced in agile work environment and used team Collaboration Software like Confluence & JIRA
• Build ETL solutions for transforming data from heterogeneous source systems into data warehouse and performance tuning.
• Build efficient SSIS packages for processing fact and dimension tables with various transformations and components of SSIS.
• Worked on complete SSIS life cycle by creating SSIS packages, building, deploying and executing the packages in both development and production environments.
• Designed, developed and delivered visualizations and analytics to business stakeholders utilizing Power BI
• Implemented data model and DAX functions for efficient data visualization in Power BI.
• Developed visual reports, dashboards and KPI scorecards using Power BI desktop to make analytical decision.
• Maintained, Published, and scheduled Power BI reports as per the business requirements.
• Proactively assisted build team manager and project managers by setting right expectations for development work and ensure work is completed in timely manner to meet client expectations
• Involved in gathering requirements, analyzing the functional specifications, and writing technical documentation.
• Effectively deal with legacy systems and provide input on re-architecture and refactoring.
• Lead the daily scrum calls with L2/L3 technical teams to expedite resolution and provide solution for knowledge gap.
• Contributed in automation BOT project to reduce human intervention by automating routine updates.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards.
• Create and maintain complex Stored Procedure, Views, Triggers and functions for database for fast retrieval of data.
• Develop database objects like tables, views, sequence, synonym, indexes, partitions, and sub queries.
• Provide critical thinking on how we can constantly improve our technology, delivery, user experience, and keep existing application systems running smoothly.
• Performance tuning of SQL statements using Hints, Indexes, and identify system calls to reduce costs
• Participated in Agile/Scrum process, Sprint Planning Sessions, Daily Scrum, and Breakout Design Sessions.

Environment: MS SQL Server, Oracle SQL Developer, TOAD, SSIS, SSRS, Power BI, SSAS, FAST, LifeCAD, BOT, TFS, Agile, Confluence, JIRA, Office 365, WebEx, NTT Cloud Infrastructure application, UC4, Putty, Linux, Unix, Visual Studio, .NET.

Confidential, Northville, MI

Senior Programmer Analyst

Responsibilities:

• Created tables, stored procedure, functions and views per business requirements.
• Created SSIS packages to extract data from OLTP sources like MS SQL Server, Oracle Database, Text Files, Excel and Access to OLAP systems and scheduled jobs to call the packages and stored procedures.
• Performed data cleansing by creating tables to eliminate the bad data using SSIS.
• Delivered BI reporting solution using MS Power BI and SQL Server Reporting services (SSRS)
• Responsible for query optimization to improve the quality of software by using SQL Profiler.
• Performed daily tasks including backup and restore from disaster recovery by using SSMS and SQL server Profiler.

Environment: SQL Server 2012, MS SQL Profiler, SQL Query Analyzer, Visual Studio, Report Builder, Power BI.

Confidential

SQL Developer/ BI Programmer Analyst

Responsibilities:

• Analyzed the existing tool and participated in meetings with the business users to gather requirements and design goals of data warehouse.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL Server using SQL Server Data Tools (SSDT BI).
• Worked on complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Used Lookup transformation to create the SSIS package for inserting the new entry from excel master defective parts source spreadsheet to the SQL Server table and updated the old data.
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Experience in using Multi-Dimensional Expressions (MDX) to query the SSAS Cubes, identifying Key Performance Indicators (KPIs), and in creating Dashboards and Score Cards.
• Developed several detail and summary reports including line and pie charts, trend analysis reports according to business requirements.
• Developed different types of reports like Tabular Reports, Matrix Reports, Cross Tab Reports, Ad hoc reports, Drill through and Drill down reports using SSRS.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report and responsible for the deployment of the reports on the reporting server and scheduled subscription for the windows file share.
• Proficient in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.

Environment: MS SQL Server 2012, SSIS, SSRS, SSAS, Visual Studio 2010, Windows 2007, ASP.Net, C#.