SUMMARY:

• 5+ years of professional experience with knowledge in ETL Tester, Data Modeling, Data Warehouse, ETL, T - SQL development, MS Business Intelligence Tools like (SSIS, SSAS and SSRS) in SQL Server 2012/2017/2018.
• Having 5 years of extensive experience in IT industry as Business Intelligence Developer with Microsoft Business Intelligence Stack which includes Database Engine (SQL Server 2008/2008R/2012),Integration Services (+Custom Dataflow Destination), Reporting Services.
• Experienced in developing software in Software Development Life Cycle (SDLC) model using waterfall and agile modeling, which includes development, designing, analysis, coding, testing and implementation.
• Experienced in Database design using Normalization Forms, Entity Relationship Design (ERD) Model and application oriented design.
• Expertise in developing Transact-SQLscripts for reuse in normalizing incoming files along with creating SQL queries.
• Expert in creating Database Objects - Schemas, Tables, Indexes (clustered and non-clustered), Views, User defined functions (UDFs), Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Experience in Dimensional Data Modeling Star and Snow Flake SchemasAdept knowledge in creating calculated members and KPI's using basic MDX expressions.
• Expert knowledge and experience authoring, managing and deploying reporting solutions using SQL Server Reporting Services (SSRS).
• Well versed in designing complex reports like Drill-Down reports, Drill-Through Reports, Parameterized Reports, Sub Reports, Ad-hoc reports and Dashboard Reports using SSRS based on client requirement.
• Used expressions to calculate, group, filter, parameterize and format the contents of a report.
• Configured snapshot replication for reporting, user acceptance test and development servers.
• A well-organized, goal-oriented, highly-motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.
• Executed the testing of the application development - manual UI testing, automated regression testing using Selenium and backend data validation of SQL Server Databases.
• Skilled in writing and reviewing T-SQL code DDL, DML, DCL and maintaining coding standards.
• Created Automate test scripts for various testing stages like Functional, Performance, Regression, System and End-to end Testing.
• Strong knowledge and experience with Relational Database Management Systems, including E/R Diagrams, Normalization, Constraints, Querying, Joins, Keys, Indexes, and Data Import/Export.

TECHNICAL PROFICIENCIES:

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

Data Modeling: Erwin, MS Visio

SDLC Methodologies: Water Fall Model, Agile, SCRUM

WORK EXPERIENCE:

Confidential, Carson, CA

SQL Server/ETL/Reports Developer

Responsibilities:

• Experience in Error handling and debugging coding issues using Try Catch Block and error methodologies for troubleshooting coding issues.
• Experience in Object oriented Design and Development using Microsoft .Net technologies..
• Involved in Manual and Automated Testing of application in windows Environment.
• Strong experience in working with full life (SDLC) of Development and distributed computing technology.
• Application development was carried out following Agile Scrum methodology.
• Experience in Test Design, preparing Test Cases, Test Plans, Logs and bug reports.
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV's, DMFs and Query Execution Plans.
• Expert in Extracting, Transforming and Load data (ETL) from various heterogeneous sources and creating packages using SSIS, Import & Export Data, Bulk Insert and BCP utilities.
• Developed SSIS packages for importing and exporting data from various Databases like MS Excel, Flat files, Teradata, Oracle, DB2.
• Building and modifying the structure of the tables and executing the DDL statements, Using Primary key and foreign keys.
• Experience in converting ETL packages from legacy systems (DTS and SQL 2000 code) and migrating to Latest SSIS versions, deploying the packages across Dev/UAT/Prod environments.
• Designed and deployed SSIS packages using various Transformations such as Multicast, Merge Join, Lookup, Fuzzy Lookup, Fuzzy Grouping, Slowly Changing Dimension, Aggregate, Conditional Split, and Derived Column Transformations.
• Implemented master child packages so only the Master package has to be scheduled which will in turn fire the other packages.
• Implemented various different SSIS features like loggings, transactions, checkpoints, deployment, and configuration on designed end-to-end ETL strategy so that the developed packages could be optimized to the fullest depth.
• Added XML configuration files to each package to deal with different servers like Development, Testing and Production.
• Optimized SSIS packages by using various techniques such as use of non-blocking, synchronous communication nature transformations, optimizing sources as well executing packages in parallel.
• Designed SSIS package templates as base code for package development incorporating package configurations, connection managers and logging in it.
• Wrote SQL queries to validate data on staging tables and data warehouse tables to validate the data results.
• Configured Report Server with SQL Server 2008 to drive Reporting Services.
• Created Reports using SQL Server Reporting Services to report trends from existing data mart.
• Created complex reports that include multiple data sources and stores procedures with nested tabular and matrix forms and formatted the reports using the Global variables and expressions (conditional formatting).
• Involved in report execution based on caching and snapshot. Created and managed normal subscriptions and data-driven subscriptions.

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

Confidential, El Segundo, CA

SSIS/Reports Developer

Responsibilities:

• Participated in JAD sessions with Business Users to capture and document the BRD and transform the relevant /approved BRD into SRS and FRS.
• Involved in designing the physical database models on SQL Server 2008R2/2008 RDBMS.
• Created the T-SQL script to generate all the tables and relationships based on the finalized ER-Diagram.
• Wrote complex stored procedures for Data Profiling, Backup the databases as well as handling the index fragmentation.
• Implemented error handling techniques like try catch blocks, error functions in T-SQL scripts and stored procedures to support the applications.
• 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.
• Involved in Query Optimization and Performance Tuning using tools SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Created views as required by front end developer for easier implementation on web pages, and wrote instead of triggers on those views to provide efficient data manipulation.
• Developed complex mappings using SSIS to transform and load the data from various source systems like Excel, Flat files, Oracle into the SQL 2008 R2 Server target staging database.
• Designed the ETL process using SQL Server 2008R2 SSIS Packages in which the data sources include Oracle.
• Involved in Full and daily Incremental loads into Staging and ODS areas, troubleshooting process issues and errors using SQL Server Integration Services (SSIS) 2008 R2.
• Included transformations like Slowly Changing Dimensions (Type 1 & 2), Look up, Derived Column, Aggregate, Fuzzy Lookup, Multicast, Conditional Split, Data Conversion, etc. in SSIS Packages.
• Implemented the Master/Child Package Models to ensure that only the Master Package is scheduled which will in turn fire the other packages.
• Created event handlers on every executable in an SSIS package.
• Optimized ETL packages by optimizing queries and using proper transformations.
• Implemented package configurations on the development and test environments.
• Created several ad hoc reports, drill down, drill through, sub, linked, cached and snapshot reports using reporting services.
• Involved in Report generation using SSRS and Excel services and deployed them on SharePoint Server.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Formatted and extended interactive SSRS reports by creating parameters within reports, multi-value parameters as well as embedding functions with expressions.
• Designed and deployed 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.
• Designed and developed the most suitable User Interface such as Dashboards, multiple charts types, Trends, KPI’s, custom requests for Excel Export and objects for Management Dashboard reporting using Power Pivot.
• Actively involved in securing the reports created depending upon the level of sensitivity of information that the report contained.
• Supported the logging framework by generating reports to identify the trends and set up the strategy to find bug trends, code changes using Team Foundation Server.

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

Confidential, Cypress, CA

SQL/ETL Developer

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 Stored Procedures, Views, and User Defined Functions to facilitate the automation of data entry by a front end application.
• Utilized the Dynamic SQL for user customizable queries to be answered by the SQL Server.
• Was responsible for identifying sources, creating staging database, and data warehouse (Facts and Dimensions).
• Managed the entire ETL process involving the extraction, analysis, transformation, loading and presentation of information to the end users.
• Created packages with several Transformations in each Package making sure that the data is cleaned and confirmed before being sent to the Staging Area.
• Created complex SSIS packages to pull data from Excel and flat files to SQL server
• Implemented various different SSIS features like loggings, transactions, checkpoints, deployment, and configuration on designed end-to-end ETL strategy so that the developed packages could be optimized to the fullest depth.
• Implemented the Master Child Package Model for easier maintenance and better performance.
• Implemented package configurations on the development, test, and production environments.
• Was responsible for securing the entire database with various types of encryption techniques along with the use of s.
• Implemented appropriate high-availability solution like log-shipping and mirroring which best suited the business needs according to the functionality and the budget requirements.
• Created several reports using SSRS such as Drill Through reports, Linked, and sub reports.
• Managed very large reports that return a large volume of records and optimized their performance using techniques such as Cascading Parameters and Filters.
• Devised dashboards to contain drill-down capabilities to view requested user information through summary reports and trend charts.
• Scheduled jobs like backups, restoring of databases using the SQL Server Job Agent.

Tools Used : SQL Server 2008R2/2008, SSIS, SSAS, SSRS, Erwin, Windows Server 2008, Visio