SUMMARY:

• 5+ years of professional experience with knowledge in Data Modeling, Data Warehouse, ETL, T - SQL development, MS Business Intelligence Tools like (SSIS, SSAS and SSRS) in SQL Server 2012/2008R 2/2008/2005.
• Expert in ETL, Data warehousing & OLAP technology.
• Daily monitoring of ETL and Data warehouse load and maintain the integrity and consistency between source, staging and data warehouse
• Experience in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Services (SSIS).
• Proven ability in utilizing ETL tools including SSIS, Data Transformation Services (DTS) and ETL package design.
• Experience in script tasks, look up transformations and data flow tasks using SSIS.
• Knowledge and experience in migrating SSIS packages.
• Experience in deploying and enhancing the SSIS Packages from development server to production server.
• Experienced in creating configuration files, Logging and Error handling using Event Handlers in SSIS.
• Experience in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using DTS utility. Involved in transformation of OLTP data to the Data Warehouse using ETL and SQL commands.
• Good understanding of Tableau Desktop architecture for designing and developing dashboards
• Experienced in creating reports using Grouping and Sorting and creating Sub Reports, Cascading parameterized Report, Report Snapshot, Drill-Through Reports, Parameterized Reports, and ad hoc reports using SQL Server Reporting Services 2012/2014/2017/ (SSRS).
• Expert knowledge and experience in authoring, managing and deploying reporting solutions using SQL Server Reporting Services (SSRS), and Excel Spreadsheet and Pivot tables.
• Delivered on demand reports in different rendering formats using Standard and Data Driven Subscriptions.
• Used conditional formatting and templates with the formatting of reports for various visual representations
• Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems.
• Experienced in configuring SSRS and rendering reports in .xls, .pdf, .TIFF, .csv, .html, .xml formats.
• Expert in performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.
• Capable of forming and maintaining positive and productive working relationships in internal/external and team environments

TECHNICAL SKILLS:

Operating Systems: Windows XP, Vista,7, Windows Server 2003/2008/R2/2012

Database Packages: SQL Server 2005/2008/R2/2012, MS Access

BI Tools: BIDS/SSDT, SSMS, SSIS/SSAS/SSRS, SharePoint, TFS, Power Pivot, Power View,Microsoft Power BI and Tableau

Data Modeling: Erwin, MS Visio

SDLC Methodologies: Water Fall Model, Agile, SCRUM

PROFESSIONAL EXPERIENCE:

Confidential, Long Beach, CA

ETL/Reports Developer

Roles and Responsibilities:

• Actively involved in gathering system specification requirements for the project through JAD sessions.
• Worked with the Business analysts for requirements gathering, business analysis, testing, and metrics and project coordination.
• Used Erwin tool for dimensional modeling (Star schema) of the staging database as well as the relational data warehouse
• Examined and evaluated the data structures in the source and enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2008 R2/2012.
• Designed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to the business
• Perform ongoing support and maintenance of data warehouse and ETL functions
• Designed the 'Dimensional model' of the Data warehouse and used Erwin to design the business process, grain of the data representation, dimensions and fact tables with measured facts.
• Redirected Error Outputs to Error Tables to identify dimensions and facts that were not properly populated.
• Designed and optimized ETL packages dealing with different data sources (SQL Server, Flat Files, Excel and
• 9i) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Developed complex mappings using SSIS to transform and load the data from various source systems like Excel, Flat files, Oracle into the SQL 2008R2/2012 Server target staging database.
• Created and deployed SSIS packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Fuzzy Grouping, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Developed complex Stored Procedures, Triggers and User Defined Functions for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Implemented incremental load using Check sum and CDC technique.
• Created various Reports using Reporting Services such as report by customer.
• Created Drill Down, Drill Through, Sub and Linked reports using the SQL Server Reporting Services SSRS as well as managed the subscription and authentication of these reports.
• Developed several Dashboards along with data visualization using Power BI for sales and Orders for yearly, monthly, weekly and daily with products as a slicer.
• Created Parameter-driven reports using parameters tab in the SSRS GUI procedures by Setting up the report-level parameters, along with Building parameter-driven queries and stored and placing them, in the data field.
• Wrote complex store procedures for data profiling process needed to define the structure of the pre staging and staging area, as well as triggers for consistency checks.
• Created several database objects like tables, dimensions, UDFs, indexed views, clustered and non-clustered indexes
• Created constraints and triggers to ensure database consistency and to enforce business rules and policies
• Created clustered and non clustered indexes on tables in OLTP and OLAP ensuring the efficiency and latency of queries against them.
• Used TFS (Team Foundation Server) for code check-in and check-out and manage different versions of complicated code and distribute them to different teams in the organization.
• Responsible for identifying and translating business requirements for the Enterprise Data Warehouse into data models

Tools Used: MS SQL Server 2012/2017, BIDS/SSDT (SSIS, SSAS, SSRS), Microsoft Power BI, Visio, Windows 2010 Server, SP 2010, Power Pivot, Power View.

Confidential, Pasadena, CA

SSIS/Reports Developer

Roles and Responsibilities:

• Worked with Business Analysts and end users in gathering detailed requirements and specifications.
• Involved in developing stored procedures, Triggers, Cursors, Joins, Views and SQL on databases: MySQL, MSSQL
• Performed Index analysis on tables and came up with more efficient solutions to use between different kind of indexes such as Clustered, Non-Clustered and Covering Indexes.
• Performance tuning by analyzing execution plans, creating and maintaining indexes (rebuild/reorganize), Statistics, partitions, Client/Server Connectivity and structure modification.
• Involved in the creation of scheduled jobs for Extracting, transforming and loading operations and database maintenance tasks like defragmentation, re-indexing, and recompiling
• Created T-SQL script to generate all the tables and relationships based on the finalized ER-Diagram.
• Extracted the data in Data Warehouse to provide information for system revision such as the using situation of existed criteria.
• Created several stored procedures for data profiling purposes to get a good understanding of duplications and anomalies already exist in the source databases.
• Involved in designing the physical database models on SQL Server 2008R2/2008 RDBMS.
• Designed several packages to schedule maintenance tasks, as well as to process SSAS cubes, and to import files from several location to the warehouse.
• Created the T-SQL script to generate all the tables and relationships based on the finalized ER-Diagram.
• Designed several packages to schedule maintenance tasks, as well as to process SSAS cubes, and to import files from several location to the warehouse.
• Created new SSIS packages and modified existing SSIS packages implementing auditing and error handling.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS .
• Implementing various SSIS packages having different tasks and transformations and scheduled SSIS packages.
• Created user variables, property expressions, script task in SSIS .
• Designed and developed SSIS Package template, so similar development practices are followed by all SSIS developers for logging, configurations and error handling.
• Deployed various types of SSIS Transforms in packages including slowly changing dimension, aggregate, fuzzy lookup, conditional split, row count, derived column etc. and handled erroneous output using event handlers.
• Set up alerts, operators, SQL Mail, SQL Agent Mail, and notifications
• Generated Reports weekly and monthly to an online management interface using SSRS.
• Installed, Configured and managed Report Server and scheduled report delivery using Data Driven Subscriptions in SSRS
• Created Ad-hoc and Parameterized Reports using SQL Server Reporting Services (SSRS) in BIDS.
• Facilitated JAD sessions to develop architectural solution that application meets the business requirements, resolve open issues, and change requirements.

Tools Used: SQL Server 2008R2/2008, SSIS, SSRS, Erwin, Windows Server, Visio, TFS, Power Pivot, MS Visual Studio 2008.

Confidential, CA

SQL/ETL Developer

Roles and Responsibilities:

• Gathered requirements from the client, Perform Gap Analysis, Facilitate JAD Sessions.
• Was responsible for analyzing various dimensions and facts that could be included in Data Warehouse design using best suited Star-Schema and created logical and physical model of DW in design software like ER-Win.
• Created and modified indexes to optimize query performance of several stored procedures supporting front end applications and reports.
• Created complex stored procedures to perform Index maintenance, data profiling, for loading data marts and generating datasets for reports.
• Worked with the Business analysts for requirements gathering, business analysis, testing, and metrics and project coordination.
• Developed complex Stored Procedures, Triggers and User Defined Functions for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
• Designed and developed several packages to schedule maintenance tasks, as well as to process cubes, and to import files from several location to the warehouse.
• Scheduled jobs like backups, restoring of databases using the SQL Server Job Agent.
• Created various Reports using Reporting Services such as report by customer.
• Created several complex packages using different transformations like fuzzy lookup, fuzzy grouping, conditional splits, multicasting and audit.
• Maintain and Modify database objects based on decisions taken in the Meetings
• Assist in developing Test Plans & Cases to be used by the QA team and in testing
• Assist in deploying final system in a Production Environment
• Involved in the documentation of the database and all the required deliverables
• Created several indexes in OLTP tables as well as the relational data warehouse dimensions like clustered and non clustered indexes
• Scheduled jobs like backups, restoring of databases using the SQL Server Job Agent.
• Design, development, unit and system testing of ETL process using SSIS to load data into data warehouse data mart using star schemas
• Responsible for the design of mapping and cleansing to deliver the data to the data warehouse from the data sources by profiling and massaging data in the source databases and files as well as creating a staging database to ensure that accuracy of data pushed to the relational warehouse
• Designed a complex schema in SSAS and deployed it to the SSAS server as well as forward it to SQL server as an acting staging database, this method was implemented to speed the processing of the cube.
• Created backup strategies like full backup with differential and transactional log in multiple environments.
• Designed and implemented ETL processes to make data available for reporting purpose within a data warehouse using SSIS
• Created several complex SSIS packages using different transformations like fuzzy lookup, fuzzy grouping, conditional splits, multicasting and audit

Tools Used: SQL Server 2005, BIDS, T-SQL, SSIS, SSRS, Erwin, Visio, Flat Files, Excel