PROFESSIONAL SUMMARY:

Over 6 years of experience in design, development, and maintenance of BI applications using MS SQL Server, BI Stack (SSIS, SSAS, SSRS), Power BI, Tableau, and Azure in multiple industries such as healthcare, finance, insurance, and technology.

TECHNICAL SKILLS:

Database: SQL Server 2012, 2008R2, 2008, Azure SQL, T - SQL Programming, Dynamic SQL

Data Modeling: ER-win, MS Visio

BI Tools: Power BI, Tableau, Integration Services (SSIS), Analysis Services (SSAS, OLAP Cubes), Reporting Services (SSRS, Report Builder)

Development Tools: BIDS, SSDT, SSMS

Source Control: Team Foundation Server (TFS)

Programming Language: Java, HTML, CSS

Microsoft Azure: Cloud Services (PaaS & IaaS), PowerShell, Azure SQL Database (PaaS), Azure Storages (Blob, Tables, Queues), Backup/Recovery

SDLC: Agile, Scrum, Waterfall, and Spiral

Collaboration Tools: SharePoint

PROFESSIONAL EXPERIENCE:

Confidential, Anaheim, CA

MSBI Developer

Technical Environment: SQL Server 2012, SSIS, SSAS, SSRS, SSMS, SSDT, T-SQL, Erwin, TFS, Power BI, SQL Profiler, DTA

Responsibilities:

• Participated in creation of functional requirement specifications and supporting documents for business systems, and designed database architecture.
• Designed and developed physical and logical designs, and generated all the tables and relationships based on the finalized ER-Diagram.
• Modified both relational and staging databases to maintain data quality and consistency.
• Created various database structures such as tables, views, and stored procedures, as per the client requirements.
• Created complex stored procedure for various purpose such as data profiling, and implementing business logic for parameterized reports.
• Designed database optimization plans (including creation/implementation of table partitions, statistics, and indexes.)
• Involved in defining the source to target data mappings, business rules and data definitions.
• Transferred data from flat files and heterogeneous data sources to SQL Server utilizing SSIS packages.
• Utilized various transformations such as lookup, derived column, data conversion and fuzzy lookup to implement data cleansing process during ETL operations.
• Optimized SSIS packages by avoiding use of non-blocking transformation, executing tasks in parallel and utilizing different properties at data flow and control flow level.
• Designed and implemented report layouts according to reporting standards of the department.
• Utilized Power BI to implement interactive visualization, business analysis, and publishing reports to users.
• Implemented common data shaping tasks such as changing data type, grouping rows, and filtering data utilizing Power BI.
• Defined calculations (measures) to generate new fields in Power BI reports with Data Analysis Expressions (DAX) formulas.
• Designed ad-hoc reports, and complex enterprise reports (drill down, and drill through reports, parameterized reports, cascading report) in SSRS.
• Utilized email subscription to automate monthly reports in different formats with SSRS.

Confidential, Scottsdale, AZ

SQL/BI Developer

Technical Environment: SQL Server 2012, Erwin, SSDT, SSIS, SSAS, SSRS, Power BI, T-SQL, Erwin, MS Excel, TFS, DTA

Responsibilities:

• Collaborated with team members in JAD sessions for understanding business needs utilizing agile methodology.
• Created technical specifications documents based on the functional design document for the ETL coding to build the data mart.
• Utilized SQL Server and T-SQL (DDL and DML) in constructing tables, and implemented normalization techniques on database tables.
• Implemented error-handling mechanism in T-SQL scripts and stored procedures utilizing try-catch block, and error functions.
• Redesigned and tuned stored procedures, triggers, UDF, views, indexes to increase the performance of the slow running queries.
• Designed dynamic SSIS packages to transfer data across multiple platforms; and performed data profiling to validate data.
• Performed various transformations such as conditional split, merge, union-all and merge join to implement different business rules during ETL process.
• Maintained batch logging, and error logging with event handlers and configuring connection managers utilizing SSIS.
• Involved in troubleshooting of several SSIS packages and solved several issues related to execution, development and performance.
• Created SSAS cubes with dimensions, perspectives, measure groups, hierarchies, and KPIs to analyze business units.
• Designed interactive reports with SSRS, using features such as report parameters, query parameters, filters and expressions.
• Generated and scheduled on-demand reports in various formats for business analyses and management decisions with subscriptions.
• Generated dashboards with power BI desktop for improved clarity and decision-making.
• Explored data in different ways and across multiple visualizations such as bar chart, pie chart, and maps utilizing Power BI.
• Implemented TFS for BI application and SQL code source control.

Confidential, Jacksonville, FL

ETL/ SSIS Developer

Technical Environment: SQL Server 2012, T-SQL, SSIS, SSAS, SSRS, SSDT, SQL Profiler, Erwin, DTA, Windows Server

Responsibilities:

• Collaborated with business analysts and the project manager to gather business requirements.
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, and coding.
• Created complex SQL statements with joins, sub queries, set operators and correlated sub queries.
• Created and modified T-SQL stored procedures/ triggers for validating the integrity of the data.
• Created indexed views and appropriate indexes to reduce the running time for complex queries.
• Designed dynamic packages for incremental loads and data cleaning in data warehouse using SSIS.
• Performed operation such as data reconciliation, validation and error handling after extracting data into SQL Server.
• Implemented parameters to configure package properties for dynamic executions.
• Wrote C# scripts with script tasks to extract data from flat files, iterating object variables and custom logging.
• Created OLAP cubes in SSAS for data mining and created reports from OLAP cubes using SSRS.
• Developed complex SSRS reports involving sub reports, matrix/tabular reports, charts and graphs.
• Deployed and uploaded the SSRS reports to SharePoint server for end users, and involved in enhancements and modifications.
• Collaborated with team members on project updates by checking in and checking out on TFS.

Confidential, Irving, TX

DWH Developer

Technical Environment: SQL Server 2008 R2, T-SQL, SSIS, SSRS, BIDS, SQL Profiler, MS Visual Studio, Erwin, MS Excel, TFS

Responsibilities:

• Analyzed standards and specific business requirements utilizing JRD session.
• Wrote DML/DDL statements to define structures of different objects and manipulate data in the database to meet business rules.
• Wrote SQL queries to fetch data using inner/outer Joins, sub-queries, and CTE to combine datasets for various applications.
• Checked configuration and performance of the OLTP databases including data file allocation, index, fill factor, and fragmentation
• Designed the ETL process; accessed, manipulated, analyzed, interpreted, and presented information from multiple sources.
• Mapped documents and developed logic for data migrations, data imports, initial loads, and incremental loads.
• Configured complex packages into a master-child architecture utilizing execute package task for improved maintenance and performance.
• Implemented event handlers and error handling in SSIS packages and logged results into log files.
• Monitored and configured SSIS packages for dynamic execution; deployed packages to the testing environment.
• Designed and developed SSAS cubes with KPIs, aggregation, calculated members, and partitions for reporting.
• Created analytical reports/dashboards from multidimensional models to identify critical KPIs utilizing power pivot.
• Managed report delivery schedules by configuring standard/data driven subscriptions within report manager.

Confidential, San Diego, CA

SQL Developer

Technical Environment: SQL Server 2008, T-SQL, SSMS, BIDS, SSRS, SQL Profiler, DTA, Windows Server, TFS

Responsibilities:

• Involved in the complete software development life cycle (SDLC) process by analyzing business requirements.
• Designed functional specifications of requirements according to the product requirement documents.
• Wrote complex stored procedures, functions, and triggers to implement business logics in the OLTP database.
• Redesigned and improved existing procedures, triggers, UDF, and views with execution plans, SQL profiler, and DTA.
• Performed data profiling, cleansing, validation, and verification with SSIS tasks and SQL stored procedures.
• Enhanced the performance of the cubes through creating perspectives, KPI’s, and calculated members.
• Developed complex reports with multiple datasets and sources in SSRS.
• Generated test data and tested the database to meet the functionalities deliverables in the project documentation and specifications.