SUMMARY

• Microsoft BI developer with over 5 years of extensive experience in design and development of databases and BI/EDW Applications with MS SQL Server versions 2016/2014 using SSIS, SSRS, SSAS and Power BI at major corporate clients.
• Experience in using the Microsoft Suite SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)
• Extensive experience in all SDLC phases - Business Analysis, Requirements elicitation, architecture, design, development, Test Planning and Execution, User Acceptance, implementation and production support
• Well versed in the ETL Lifecycle and client-server as well as Batch systems
• Experience in logical and physical Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, Fact and Dimensional tables and Operational Data Store (ODS).
• Proficient in authoring Business Requirements (BRD), System Requirement Specifications (SRS), Design and Test Case and Results Documents.
• Worked on projects using Agile and Waterfall model methodologies.
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.
• Experience in Microsoft Power BI Suite (Power Query, Power Pivot, Power BI Pro, Power BI Desktop), Microsoft Excel Pivot Table, and Data Models to gather information from multiple sources and deliver information to the end user.
• Knowledge of building statistical KPI reporting dashboards with predictive analysis.
• Excellent Data Analysis Expression Language (DAX) Skills and the ability to create and troubleshoot complex calculations and measures
• Expert in Data Extraction, Transformation and Loading (ETL) using SSIS, DTS, Bulk Insert, BCP.
• Experienced in transforming unstructured data from various data sources such as Excel Spreadsheets, OLDB sources databases, flat files, XML files etc.
• Developed SSIS package to import data into the data warehouse dimension and fact tables from various sources using SQL merge and slowly changing dimension (SCD).
• Created complex SSIS packages using various tasks and transformations in Control flow and Data flow.
• Implemented Various Error handling and Event Handling Techniques to ensure efficient package execution.
• Designing and Implementing Database Schema, Data modeling, creating normalized datasets, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Views, Temp tables and complex SQL statements.
• Establishing referential integrity, data consistency, indexing and data cleanup procedures to maintain high quality data that can be used for reporting.
• Query Optimization and Performance Tuning of Stored Procedures using SQL Profiler and Estimated Query plans, normalization, indexing and Transaction Isolation levels
• Experience in managing alerts, operators and jobs through SQL Server Agent.
• Experienced in routine Database Backup/Recovery procedures
• Experience in the design and development of Dashboard and different types of Reports including Sub-Reports, drilldowns, drill-throughs, Parameterized reports, Charts, Gauges, Maps (by territory, country, state).
• Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).
• Experience with Report Server and Report Manager.
• Ability to Schedule standard and data driven Subscriptions.
• Ability to apply security roles to prevent unauthorized use of data.

TECHNICAL SKILLS

Operating Systems: Windows Server 2008/XP/Vista, Windows 7/8/10

Database/BI Tools: SQL Server Management Studio(SSMS), SQL Profiler, Query Analyzer, Visual Studio 2010, Business Intelligence Studio (BIDS)

Languages: T-SQL, DAX, C#(For Script Task)

OLAP Tools: SQL Server Analysis Services

Source Control Tools: Team Foundation Server (TFS)

Databases: SQL Server 2016/2014/2012

ETL Tools: SQL Server Integration Services(SSIS), SQL Server Import/Export Wizard

Report Tools: SQL Server Reporting Services (SSRS), Power BI

Data Modeling: SQL Server Analysis Services (SSAS)

Job Scheduler: SQL Server Agent

Other Tools: HP Quality Center, JIRA, SharePoint, MS Word, PowerPoint, MS Excel, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

BI Developer

Responsibilities:

• Collaborated with Sales, Risk, Accounting and business development teams to understand and deliver reporting solutions to meet analytical and reporting needs, including critical metrics.
• ETL and Reporting developer for System Integration effort for Bartaco acquisition. Worked on re-engineering Bartaco’s system landscape and reporting capabilities to integrate their data in Confidential ’s legacy data warehouse.
• Delivered complex data mapping specs and developed ETLs to map Bartaco’s sales and GL data to Confidential ’s data.
• Performed ETL operations to support incremental, historical data loads and transformations using SSIS.
• Created Database Objects like Stored Procedures, Triggers and User Defined Functions (UDF) for this project.
• Created Indexes, table partitions and tuned stored procedures to optimize performance.
• Integrated the Sales / Tip Collection systems to Microsoft Dynamics for GL using SSIS.
• Participated in identifying data migration issues and resolved them.
• Extensively used Control Flow and Data Flow transformations like Execute SQL Task, FTP Task, Send Mail Task and Conditional Split. Involved in creating C# scripts using script task in SSIS.
• Developed Financial Dashboards, Scorecard Reports, KPI and Sales dashboards using Power BI to illustrate sales figures, trends, comparisons and forecasts.
• Handled daily production support for all ETL related issues and continuous performance tuning and enhancement

Technologies Used: SQL Server 2016, SSIS, SSRS, Visual Studio 2017, MS Excel, Power BI, DAX, Agile

Confidential, Westlake, TX

BI Developer.

Responsibilities:

• Worked with business teams to gain a rich understanding of their business, analytical, and reporting needs, including the identification of critical metrics.
• Performed detailed data analysis to determine the structure, content, and quality of the data through examination of source systems and data samples.
• Involved in creation of various Business Intelligence/ Analytical Dashboards utilizing Power BI with global filters, calculated columns and measures using complex DAX calculations and transformations using Query Editor.
• Worked extensively building Power BI Dashboards with quick insights into KPIs and Advance analysis actions, Calculations, Parameters, Maps and Scatter plots.
• Used Trend Lines Statistics and Log Axes, Groups hierarchies, time intelligence to create detailed and summary level reports and Dashboards with KPIs using Power BI.
• Worked on Power BI dashboards using stacked bars, bar graphs, Matrix, scattered plots, waterfall charts, geographical maps and Gauges.
• Publishing of various kinds of live interactive data visualization dashboard reports and workbooks from Power BI Desktop to Power BI servers.
• Developed SQL queries/scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
• Supported the Business Intelligence/Analytics data analyst with the understanding of business and data requirements and iteratively designs visualizations for initial concepts and prototypes that can be presented to customers for feedback.
• Conducted Training sessions for Power BI users and created the documents for end user support.
• Write and execute data retrieval queries for adhoc business data requests
• Enhanced performance using optimization techniques-normalization and indexing
• Designed various SSRS reports as requested by the client to view P&L and portfolio diversity.
• Rendered reports in different formats like pdf, excel etc. to be executed automatically on daily, weekly or monthly basis and managed subscriptions.
• Used SSIS to create ETL packages to validate, extract, transform and load data from InvestOne to warehouse databases for analysis and reporting.
• Used advanced SSIS tools (i.e. Derived Columns, Condition Split, Data Conversion, Aggregations, Multicasting)
• Build the customized SSIS packages using c# script Tasks and components.
• Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality
• Contributed in the development of knowledge transfer documentation

Technologies Used: SQL Server 2016/2014, SSIS, SSRS, Visual Studio 2015, MS Excel, Power BI, DAX, Agile