SUMMARY

• Highly - motivated BI developer with over 8 years of experience in development of Business Intelligence applications.
• Extensive experience in building OLTP and data warehouse applications using SQL Server and MS BI stack.
• Comprehensive knowledge within multiple industries such as finance, Education, Insurance, healthcare, and banking.

TECHNICAL SKILLS

• MS-SQL Server 2008 R
• SSIS/SSAS/SSRS
• Power BI
• SSMS
• BIDS
• SSDT
• ERwin
• MS Visio
• Agile
• Scrum
• Waterfall and Spiral
• ASP.Net
• ADO.Net
• C#.Net
• VB.Net
• Classical ASP
• HTML
• Java Script
• MVC
• LINQ
• SharePoint
• Team Foundation Server (TFS)

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

MSBI Developer

Responsibilities:

• Collaborated with Project Managers, Business Analysts, Developers and testers to discuss on project next steps and update within the team.
• Converted business requirements into logic for query/script creation.
• Dived into the initial set up for a new project within the company.
• Translated business logics into entity relationship/data models per ETL specifications.
• Created scripts within SSMS to look through, analyze and validate the data.
• Designed CTEs for code management and for querying hierarchal data structures.
• Designed ETL mapping document for business requirement using FRD documents.
• Improved query performance by redesigning, managing indexing strategies and understanding execution plans.
• Designed SSIS Packages to transfer data between servers and load data into OLAP database.
• Created complex packages utilizing different transformations such as conditional splits and multicast.
• Implemented script task and components in checking flat files inconsistencies using C# scripts.
• Adapted advanced SSIS features such as event handlers, loggings, breakpoints, and data viewers for debugging
• Implemented parameters in the SSIS packages to configure properties.
• Managed reporting server, created ad-hoc, and designing reports from OLAP.
• Deployed SSRS reports to the report server in native mode.
• Managed security at server and report level in report manager.
• Discovered bugs within the front-end application using different browsers and versions.
• Completed tasks given little to no information/requirements based on the project needs.
• Contributed during scrum meetings and sprint status’ about Jira stories, and bugs.

Environment: SQL Server 2014, SSDT, Erwin, SSIS, SSAS, SSRS, .Net, Excel, Erwin, SQL Profiler, DTA

Confidential, Minneapolis, MN

SQL BI Developer

Responsibilities:

• Participated in meetings with project managers, team leads, and analysts to gather business requirements.
• Validated the system end-to-end testing to meet the approved functional requirements.
• Prioritized requirements to be developed according to Agile methodology.
• Provided IT support to the health systems and program administration division.
• Assisted in the maintenance support of legacy programs and systems as determined by the IT manager.
• Improved query processing with normalization and de-Normalization of existing tables as needed.
• Developed stored procedures for .Net applications and SSDT (SQL Server Data Tools).
• Performed dimensional modeling with ER-win; designed and built relational data mart utilizing Kimball approach.
• Designed the ETL process to pull and populate data from OLTP sources to the data mart.
• Created and deployed SSIS packages with different transformations such as fuzzy lookup, fuzzy grouping, and data conversion.
• Designed and developed SSAS cubes with KPIs, aggregation, calculated members, and partitions for reporting.
• Created sub, drill-down, summary, and matrix reports in SSRS.
• Generated reports utilizing SSRS and Excel with power pivots.

Environment: SQL Server 2014/2012, SSDT, Erwin, SSIS, SSAS, SSRS, .Net, Excel, Power Pivot

Confidential, Irvine, CA

SQL/ETL Developer

Responsibilities:

• Analyzed and interpreted business requirements and specifications through all phases of the project development life cycle utilizing agile methodology.
• Involved in the data movement between systems and validated the business requirements.
• Created databases, tables, views, stored procedures, functions, and triggers.
• Implemented joins and sub-queries which retrieve data from multiple tables.
• Wrote CTEs and ranked functions to remove duplicate records in OLTP tables.
• Managed consistent layout and interface in ASP.net web page utilizing master page concepts.
• Implemented client-side scripting for autocomplete, tabs, validation, date picking, sorting, auto-submit, and other functions utilizing JavaScript.
• Successfully managed the extraction transformation and loading (ETL) process by pulling large volumes of data from various data sources in SSIS.
• Created different control flow elements (such as data flow task, bulk insert task, executeSQLtask, script task, send mail task, and XML task).
• Wrote VB.Net scripts for a custom logging for ETL packages.
• Creating ad-hoc and parameterized reports in SQL server 2008 R Reporting Services.
• Created various ad-hoc SQL queries for customer, executive management, and other reports (such as tables, matrix, and sub reports).
• Formatted reports for various visual representations utilizing conditional formatting, report expression, and templates.
• Collaborated with Microsoft Team Foundation Server and SharePoint to collaborate and publish.

Environment: SQL Server 2014/2012/2008 R2, SSDT, Erwin, SSIS, SSAS, SSRS, TFS, SharePoint, ASP.Net, VB.Net.

Confidential, San Diego, CA

BI/Reports Developer

Responsibilities:

• Assisted health services staff and business analysts to gather requirements, analyze the business, test, acquire metrics, and coordinate the project.
• Implemented agile/scrum methodology to complete tasks, based on complexity levels.
• Enhanced the functionality and performance of various SQL scripts and stored procedures utilizing UDFs, CTEs, and system stored procedures.
• Optimized and restructured stored procedures for the application by evaluating execution plans, indexing, and partitioning large tables.
• Implemented transactions with the appropriate isolation level for maximum resource utilization.
• Created SSIS Packages for ETL process to load and transform data from flat files to the data warehouse.
• Designed, created, and implemented complex ETL Strategies via SSIS Packages which extract data from multiple heterogeneous sources (such as flat files, Excel files).
• Created package configurations to deploy in multiple environments such as development, testing, and production.
• Created SSAS cubes by selecting proper user defined hierarchies, dimensions and aggregations.
• Extended reports through invoking embedded functions and integrated assemblies with expressions.
• Created report models from cubes and the data warehouse to create ad-hoc reports and chart reports with report builder.
• Created analytical reports/dashboards from multidimensional models to identify critical KPIs utilizing Power Pivot.
• Created drill down, drill through, sub, and linked reports in SSRS.
• Managed subscriptions and authentication of reports.
• Implemented security to manage user access to reports based on clearance level.

Environment: MS SQL Server 2012, SSDT, SSIS, SSAS, SSRS, ER-win, VB.Net, HTML, Java Script, TFS, SharePoint 2010.

Confidential, San Diego, CA

SQL/SSIS Developer

Responsibilities:

• Planned, coordinated, and monitored project levels of performance and activities to ensure project completion in time.
• Designed conceptual, logical, and physical database models.
• Wrote SQL queries to create tables, stored procedures, and triggers.
• Implemented error handling in TSQL code using try-catch and error handling functions.
• Monitored and tuned the performance of complex T-SQL queries and stored procedures; analyzed the execution plan.
• Designed and developed ETL processes and SSIS packages for the entire project.
• Developed SSIS packages to extract data from sources such as SQL Server OLTP, Excel, and Flat Files.
• Created packages with multiple transformations such as data conversion, derived column, fuzzy lookup and fuzzy grouping to cleanse data and apply business rules
• Managed and migrated SSIS packages in staging and pre-production environments.
• Managed large reports which return a large quantity of records; optimized report performance utilizing techniques such as cascading parameters and filters.
• Scheduled report deliveries in different formats such as PDF and Excel utilizing standard and data driven subscriptions in SSRS.
• Utilized report manager to administer roles and security on reports.

Environment: SQL Server 2008R2/2012, SSIS, SSRS, SQL Profiler, DTA, JavaScript, Share Point, ER-win.

Confidential, San Diego, CA

MSBI Developer

Responsibilities:

• Analyzed business requirements to facilitate planning and implementation phases of the data mart.
• Created stored procedures, triggers, user define functions, indexes, and views to support front-end applications.
• Optimized T-SQL scripts, stored procedures, and ETL logic to improve loading and processing.
• Optimized existing queries to improve performance utilizing profiler and execution plans.
• Implemented SQL Profiler and Database Engine Tuning Advisor (DTA) to analyze and optimize the performance of workloads.
• Created fact tables with multiple granularity levels and maintained fact table relations with alternate keys.
• Extracted and loaded data from multiple sources (Excel, CSV, flat files, SQL Server, Oracle) to the staging area.
• Performed data profiling, cleansing, validation, and verification with SSIS tasks and SQL stored procedures.
• Developed new and modified existing SSIS packages, implementing auditing and error handling functions.
• Created multiple layouts (such as matrix, tabular, chart, and Tablix) to display data in a grid format.
• Developed multiple schedules to deliver reports to e-mails and shared directories; enabled snapshots, subscriptions, and caches to improve response times and reduce traffic to the report server.
• Installed, configured, and managed report server; scheduled report deliveries via data-driven subscriptions in SSRS.

Environment: SQL Server 2008/R2, SSIS, SSAS, SSRS, DTA, SQL Profiler, ER-win.

Confidential, San Diego, CA

SQL BI Developer

Responsibilities:

• Gathered system requirements through end-user collaboration sessions.
• Designed, developed, and implemented an ETL framework with SSIS, stored procedures, and functions to extract into SQL Server 2005.
• Implemented the newly developed database into SQL Server 2008.
• Facilitated data retrieval and manipulation by implementing views, procedures, triggers, and cursors.
• Analyzed and tuned complex queries/stored procedures in SQL Server 2005 to improve execution and developed database structures.
• Imported data from MS Access, MS Excel, and text files; consolidated data with SQL server 2005 in SSIS.
• Provided back-end support for functional and performance testing.
• Drafted all system documents with a user manual, flowcharts, and source code.
• Performed data migration with MS Access, Excel, and text files; scheduled tasks in SSIS.

Environment: SQL Server 2008/ R2, SSIS, SSRS, BIDS, ER-Win, SQL Profiler.

Confidential, San Diego, CA

SQL Developer

Responsibilities:

• Designed stored procedures and complex queries to acquire the business logic and reporting standards.
• Analyzed historical data and extracted required data to support managerial decisions.
• Created various DB objects (to include: views, UDFs, stored procedures, cursors, and indexes) to meet functionality and performance standards.
• Developed ETL data mapping documents and data dictionaries.
• Designed cubes from relational data warehouses; created the KPI for the front-end team.
• Created linked, sub, and parameterized reports in SQL Server Reporting Services (SSRS).
• Implemented report models from cubes and the data warehouse to create ad-hoc reports with Report Builder.
• Optimized report performance by modifying stored procedures, creating report snapshots, and caching reports.

Environment: SQL Server 2005/2008, BIDS, MS Visio, ER-win