PROFESSIONAL SUMMARY

• MS BI Developer with 6 years of experience in the design, development, and support of the business intelligence applications in production and development environments.
• Highly organized and efficient in fast - paced multitasking environments to accomplish objectives.
• Experience within multiple industries such as legal, insurance, banking, finance, and healthcare.

PROFESSIONAL EXPERIENCE

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)

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, Wilmington, DE

SQL/BI Developer

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

Responsibilities:

• Participated in JAD meetings and documented functional requirements of the project.
• Documented and maintained database system specifications, diagrams, and connectivity charts.
• Generated TSQL scripts for creating tables and relationships based on finalized ER-Diagram.
• Utilized Dynamic SQL for user customizable queries on SQL Server.
• Implemented error handling mechanisms in SQL code utilizing try catch blocks, throw and other error functions.
• Modified code with temporary tables, indexes to optimize SQL stored procedures.
• Created SSIS packages for implementing ETL routines with incremental load techniques such as checksum and timestamp to populate data mart.
• Created SSIS Packages to import and export data from excel spreadsheets, text files and CSV files.
• Debugged SSIS packages with features such as breakpoints, data viewers, and checkpoints
• Implemented parameters to configure SSIS package properties for dynamic executions.
• Created complex SSAS cubes with multiple measure groups and dimension hierarchies.
• Developed drill through, drill down, linked, sub reports and parameterized reports in SSRS
• Subscribed SSRS reports to users in different formats utilizing both standard and data driven subscriptions.
• Deployed SSRS reports to the report server and troubleshoot deployment issues.
• Added scorecards into Power BI report showing performance indicator for certain activities.
• Designed Dashboard in Power BI including rich dashboards showing trend and pattern from data.
• Maintained dashboards and scheduled data refreshes through Power BI gateway.
• Configured Resource group, SQL Server, and SQL database in MS Azure Portal.
• Migrated schema and data from local SQL Server database to Azure SQL Database.

Confidential, San Diego, CA

SQL/MSBI Developer

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

Responsibilities:

• Communicated with business analysts and product owner collecting business requirements.
• Utilized Erwin data modeler to design dimensional models of data mart in logical and physical phase.
• Developed complex SQL stored procedures, views, triggers, and user-defined functions in SQL Server.
• Implemented referential integrity through foreign key and primary key constraint.
• Made use of CTEs and other temp objects to achieve performance.
• Created scripts with CTEs (Regular and Recursive) to replace self joins for better performance.
• Modified SQL Script by adding error handling strategies to SQL code to process run time issues.
• Enhanced stored procedure performance and rectified parameter sniffing issues with SQL profiler and DTA.
• Defined correct business logic by implementing IF-Else, case statements, and loops in SQL script
• Designed data mappings from source to target tables on the OLAP data mart design.
• Developed SSIS packages for the ETL process; loaded and transformed data from multiple sources into the data mart.
• Utilized SSIS transformations for data scrubbing and validation checks prior to loading into the data mart.
• Built SSAS MDX and Tabular cubes to handle different departmental data.
• Created Calculations, KPI’s and named sets utilizing multi-dimensional expressions (MDX).
• Designed multiple reports with SSRS report designer for business analyses.
• Optimized embedded queries and/or stored procedures in reports to improve the performance of reports.
• Adapted techniques such as caching and snapshots for improved response from reports.
• Created different types of SSRS reports including sub report, drill-down report, and matrix report.
• Applied various DAX expression into Power BI reports constructing derived field as per requirement.
• Designed many analytical reports utilizing Power BI desktop from various data sources.
• Created dashboards and scorecards with good visuals such as gauges, charts, scatter plots using Power BI.
• Designed calculated field in Tableau by implementing LOD expressions to achieve complex business requirement.
• Designed Dashboard in Tableau Desktop with Actions and Quick filter for High user interactivity.
• Published Tableau reports and Dashboards on Tableau Server and scheduled report subscriptions to multiple users.
• Managed multiple version of SQL codes and BI solution using Team Foundation Server (TFS).

Confidential, Birmingham, AL

Data Warehouse Developer

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

Responsibilities:

• Created stored procedures and complex queries for achieving the business logic, testing and reporting.
• Analyzed the historical data and extracted required data to support the management decisions.
• Created and optimized database objects such as: stored procedures, triggers, user defined functions, indexes and views.
• Designed ETL strategy to insure accuracy, consistency and integrity of the data mart.
• Created and designed dimensions and fact tables for the staging database following Kimball Methodology.
• Performed Extraction, Transformation and Loading of data from flat file into target database per business requirements.
• Debugged multitude of SSIS packages on development and testing server utilizing breakpoints including watch windows.
• Extended the functionality of existing and newly designed SSIS packages by implementing appropriate error handling at control flow/data flow level and setting up loggings.
• Built SSAS cubes depending upon business needs for analyzing data for different business perspectives.
• Created cubes from relational data mart and created KPI’s for the front-end team.
• Produced SSRS report models to help in creation of ad hoc reports utilizing report builder.
• Created various SSRS reports such as linked reports, parameterized reports, sub reports as demanded by business users.
• Utilized Power View and Power Map to visualize reports.
• Developed prototypes using Power Pivot for data analysis
• Tested various database objects and applications for better functionality and to make sure it adheres quality standards and principles.

Confidential, Woodland Hills, CA

SQL Developer

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

Responsibilities:

• Collaborated with the business users and business analysts for requirements gathering via JRD sessions.
• Created technical design specification documents based on the functional design documents and physical data model.
• Handled many to many relationships by adding conjunction tables in data model.
• Wrote complex queries, stored procedures, UDFs in support of the ETL processes, front-end applications and reports.
• Created temporary objects such as CTE, temporary tables, table variable to implement business logic.
• Developed complex mappings utilizing SSIS to transform and load data from various source systems.
• Created SSIS packages using various transformations and tasks such as SCD, Conditional Split, Containers, Execute SQL task.
• Implemented various SSIS features like logins, transactions, checkpoints, deployment, and configuration.
• Added XML configuration files to each package to deal with different servers like Development, Testing and Production.
• Developed Aggregations, partitions and calculated members for cube as per business requirements
• Assigned different storage modes for the partitions based on the frequency of data usage.
• Involved in complete User Acceptance Testing (UAT) to track the defects of the application.
• Formatted and extended reports by creating parameters within reports, multi value parameters.
• Provided security for accessing the reports at the server level, report level and report item level.
• Implemented TFS to update project documentation by check-ins and checkouts.

Confidential, Los Angeles, CA

Database Engineer

Responsibilities:

• Analyzed and documented database objects and SSIS packages from existing system.
• Optimized SQL queries, created proper non-clustered Indexes for better performance.
• Implemented incremental load utilizing CDC and checksum/timestamp.
• Created DDL and DML triggers to maintain database integrity as per business requirements.
• Embedded complex queries and procedures in SSIS Packages based on business requirements.
• Wrote multitude of complex SSIS packages dat would grab data coming in from various heterogeneous sources such as SQL Server database, flat files, excel files to be loaded into existing data warehouse.
• Utilized SSRS as the reporting tool to create, design and manage complex reporting structures for drill down, drill through (managed reports) and ad-hoc reports based on user needs.
• Performed optimization of reports using multitude of SSRS report optimization techniques at report level and query database level.