SUMMARY

• Highly qualified MS BI consultant with over 5 years of experience in implementing end - to-end BI solutions using the Microsoft BI Stack (SSAS, SSIS, SSRS and Tableau) within several industries viz. Manufacturing, Health, Service, and Insurance.
• Involved in gathering business requirements from clients through Joint Requirement Development sessions for functional and non-functional requirements.
• Well versed with Software Development Life Cycle (SDLC) process and familiar with RUP, Spiral, XP and Agile and Scrum Models.
• Extensively worked on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflake schema.
• Knowledgeable about Multi-dimensional cube and tabular Models
• Very well versed in writing T-SQL and MDX for querying tables and Cubes
• Hands on experience with Erwin for data modeling.
• Extensively created and debugged large T-SQL database scripts and batches to facilitate effective database management.
• Highly Proficient in T-SQL programming in creating stored procedures, triggers, views and user defined functions on SQL 2005/2008/2008 R2 and 2012 Servers.
• Created partitions on tables, indexes and indexed views as well as querying and managing partitions from optimization point-of-view according to the business criteria.
• Optimized T SQL Scripts by analyzing Execution Plans as well as using Microsoft Tools like SQL Profiler and Database Tuning Advisor.
• Good understanding of OLAP data warehouse design practices to include the design of cube objects, the design of optimal and efficient cube processing strategies based on infrastructure as well as cube size in both multi-dimensional cubes and .
• Experience in Importing/Exporting Data from various data sources like Excel, SharePoint list, and Flat file using BCP, Bulk Insert & SSIS package.
• Experience using many of the SSIS transformations like derived column, Aggregate, Lookup, Fuzzy Lookup, Conditional Split, Derived Column, and Multicast.
• Designed ETL packages using proper Loggings and Checkpoints, secured packages with Encryption in conjunction with passwords.
• Well versed in creating Parameterized Reports, Drill down, linked, sub cascading Reports and Reports using SQL server Reporting Services.
• Proficient in using Report Manager for setting up roles, security on the reports and creating Standard and Data Driven Subscriptions in Delivery of Reports.
• Experience in using ProClarity Professional for browsing cubes and creating reports

TECHNICAL SKILLS

Database Tools: Management Studio, ER-Win, MS Visio

RDBMS: MS SQL 2014/2016/2017 R2/2017, Oracle 9i, 10g, 11g, MySQL

Business Intelligence: BIDS/SSDT, SSIS, SSAS, SSRS, SharePoint 2014, 2017, Tableau, ProClarity

Operating Systems: Windows Server 2012/2017/R2

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA

ETL Developer\Talend

Responsibilities:

• Developed mappings using talend to transform and load the data from various source system Server target staging database
• Created database objects like tables, views, stored procedures, performance tune them to facilitate reporting
• Created partitions on tables, indexes and indexed views as well as querying and managing partitions from optimization point-of-view according to the business criteria created native code generation on Talend that lets you run your data pipelines seamlessly across all cloud providers and get optimized performance on all platforms

Environment: s; Talend, MS SQL Server 2017 SSIS \excel\ Flat Files

Confidential, Costa Mesa, CA

SQL Server\ETL Developer

Responsibilities:

• Gathered business requirements as endeavor that will facilitate the planning and the implementation phase of a data warehouse for reporting.
• Conducted JAD sessions with different Auditors, Business Users to capture and document the BRD and transform the relevant /approved BRD into SRS and FRS.
• Developed and created logical and physical database architecture using Erwin.
• Created stored procedure for auditing purposes as well as triggers for data consistency checks.
• Dramatically increased query performance, necessary for statistical reporting after monitoring, tuning, and optimizing indexes by using Performance Monitor, Profiler, and Index tuning wizard.
• Examined and evaluated the data structures in the source and destination databases / staging Tables.
• Developed complex mappings using SSIS to transform and load the data from various source systems like Oracle into the SQL 2014R2/2016 Server target staging database.
• Used best practices for SSIS design such as Master Child architecture to leverage parallel execution of various packages.
• Managed SSIS Package Configurations in XML as well as SQL Server Formats when deploying to production.
• Created SSISDB catalog with SQL 2016 to support SSIS package deployments in SSMS with Environment variables respective to each environment.
• Optimized the performance of slow executing SSIS packages by making changes as Control Flow and Data Flow like avoiding blocking transformations, increasing buffer size.
• Designed and developed SSIS Package template, so similar development practices are followed by all SSIS developers for logging, configurations and error handling.
• Created QA (Quality Assurance) scripts and sanity checks to further test ETL packages by comparing QA output with output from ETL package.
• Designed and developed the most suitable User Interface such asDashboards, multiple charts types, Trends, KPI’s, custom requests for Excel Export and objects for Management Dashboard reporting using Excel Power Pivot.
• Generated different schedules for report delivery to e-mails and shared directories; enabled snapshots, subscriptions, caching to improve the response times and reduce traffic to the report server.
• Established connections to report server to browse the saved reports on SharePoint Integrated Mode.
• Designed strategies for securing the reports created depending upon the level of sensitivity of information that the report contained and for improving and further leveraging these reports in order to transfer / convert existing reports to SQL Server Reporting Service.
• Administered interface to organize reports and data sources, schedule report execution, delivery and track report history.

Environment: MS SQL Server 2012 R2/2014, SSIS, SSAS, SSRS, Erwin, Excel, Windows server, SharePoint 2014Power Pivot, TFS

Confidential, Brea, CA

SQL / BI Developer

Responsibilities:

• Participate in sprint planning session to elicit requirement, design decisions and estimate effort required to complete a product backlog item (PBI) using agile scrum methodology.
• Gathered business requirement from users and involved in designing conceptual, logical and physical model of the relational databases and multi-dimensional cubes(OLTP and OLAP)
• Created database objects like tables, views, stored procedures, performance tune them to facilitate reporting
• Created various complex cubes with usage based aggregations and set-count aggregations and used appropriate storage modes like MOLAP, HOLAP and ROLAP depending upon how important the data is and how frequently it needs to be fetched from the DW.
• Implemented Key Performance Indicator Objects, Actions, Hierarchies and Attribute Relationships for added functionality and better performance of SSAS Warehouse.
• Defined different Calculations and Named Sets in cubes using MDX queries
• Designed and created SSRS reports from SSAS cubes using SSAS cubes and connections and MDX to query the data
• Created complex Tabular Model cubes where data is pulled from different sources like tables, and different cubes. Wrote DAX calculations
• Created Excel Services report and dashboards using SharePoint 2010 and 2013, set refresh schedule and appropriate security.
• Migrate a several of SSIS packages from, tested and deployed them to production
• Developed complex ETL Packages using SQL Server 2008R2/12 Integration Services to load data from various sources like SharePoint list/SQL Server/DB2 to Staging Database and then to Data Warehouse.
• Used various transformations such as Derived Column, conditional split, fuzzy grouping, lookup etc.
• Created Tableau Reports and Dashboards for data visualization using cubes and stored procedures and views as sources.

Environment: MS SQL Server 2014 R2/2012, SSIS, SSAS, SSRS, Erwin, Excel, Windows server, SharePoint 2010/2013, Power Pivot, TFS, ProClarity, Tableau, Active Batch, DAT.

Confidential, Pasadina, CA

ETL/Reports Developer

Responsibilities:

• Created an estimate of the project time based on specified business requirements as been followed up by JAD and JRD sessions.
• Worked with database objects like Stored Procedures, User Defined Functions, Triggers and Indexes using T-SQL to create complex scripts and batches.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Involved in adding Dimensions and Facts for insurance policy (Auto Coverage) to existing Data warehouse.
• Managed existing ETL strategy to extract, clean and deliver data to OLAP environment and ensure accuracy, consistency and integrity of the data warehouse.
• Created and deployed SSIS packages using various Transformations such as Fuzzy Lookup, Fuzzy Grouping, Aggregate and Derived Column Transformations.
• Created complex SSIS packages to pull data from Oracle, Excel, flat files to SQL server.
• Designed SSIS package templates as base code for package development incorporating package configurations, connection managers and logging in it.
• Implemented the Master Child Package Model for easier maintenance and better performance of the ETL strategy.
• Implemented package configurations on the development, test, and production environments.
• Analyzed queries for optimization and performance tuning using SQL Profiler and Database Tuning Advisor.
• Followed the regular reporting life cycle Analysis, Design, Development, Testing and Scheduling to develop User Interface Reports.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Delivered on-demand and scheduled reports for business analysis or management decisions using SQL Server Reporting Services.
• Deployed reports on SharePoint servers for easy access to the users by setting permissions and roles at report server in SharePoint Integrated mode.
• Scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Environment: MS SQL Server 2012 R2, SSIS, SSAS, SSRS, Erwin, Excel, Windows server, Flat Files, SharePoint 2012, Team Foundation Server (TFS)

Confidential

MS SQL Server/ SSIS/SSRS

Responsibilities:

• Created an estimate of the project time based on specified business requirements as been followed up by JAD and JRD sessions.
• Worked with database objects like Stored Procedures, User Defined Functions, Triggers and Indexes using T-SQL to create complex scripts and batches.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Involved in adding Dimensions and Facts for insurance policy (Auto Coverage) to existing Data warehouse.
• Managed existing ETL strategy to extract, clean and deliver data to OLAP environment and ensure accuracy, consistency and integrity of the data warehouse.
• Created complex SSIS packages to pull data from Oracle, Excel, flat files to SQL server.
• Designed SSIS package templates as base code for package development incorporating package configurations, connection managers and logging in it.
• Implemented the Master Child Package Model for easier maintenance and better performance of the ETL strategy.
• Implemented package configurations on the development, test, and production environments.
• Analyzed queries for optimization and performance tuning using SQL Profiler and Database Tuning Advisor.
• Followed the regular reporting life cycle Analysis, Design, Development, Testing and Scheduling to develop User Interface Reports.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Delivered on-demand and scheduled reports for business analysis or management decisions using SQL Server Reporting Services.
• Deployed reports on SharePoint servers for easy access to the users by setting permissions and roles at report server in SharePoint Integrated mode.
• Scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Environment: MS SQL Server 2012 R2, SSIS, SSAS, SSRS, Erwin, Excel, Windows server, Flat Files, SharePoint 2014, Team Foundation Server (TFS)