SUMMARY

• Having 6 years of experience in the analysis, design, development, testing, deployment, maintenance, and documentation of Relational Databases, Data Warehouses, Data Marts and Client Server applications using MSSQL Server 2016/ 2014/2012 versions.
• Complete understanding of Software Development Lifecycle and core area of experience in validating end - to-end business scenarios of B2B (Business to Business) applications, Enterprise Applications developed expertise in SSIS/SSRS/SSAS.
• Good exposure to entire Software Life Cycle Phases (Feasibility, System studies, Design, Coding, Testing, Implementation and Maintenance).
• Experienced in Data modeling up to 3 NF normalization and Dimensional modeling with Star, Snowflake and Starflake schemas.
• Performed Normalization & De-Normalization of source data during data integration phase, designed tables to support faster data retrieval and manipulation.
• Solid skills in designing and implementing data warehouses and data marts using components of Kimball Methodology, like Data Warehouse Bus, Conformed Facts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Business Keys etc.
• Experienced on T-SQL, ETL Packages (SSIS), Multidimensional Cubes and Tabular models (SSAS),Reporting (SSRS), Data-warehouse on Microsoft SQL Server 2014/2016/2017 developed and enterprise versions
• Proficient in creating and using Database Schema, different types of Joins, Sub Queries, and Complex queries based on business rules using SQL Server Management Studio (SSMS).
• Experience in developing Index, Views, complex Stored Procedures, appropriate user-defined functions (UDF) and effective Triggers, analytical functions, aggregate function, cross/outer apply, group by, over partition by, cursors, merge, try/catch, dynamically generated scripts, scalar/table valued functions and primary/foreign key constraints to facilitate efficient data manipulation, to implement the configurable metadata driven business logic and data consistency.
• Extensive experience with writing T-SQL scripts, creating SQL Server Jobs/alerts, and scheduled tasks to automate tasks.
• Strong experience with server/database/scripts Performance tuning and optimization.
• Implemented optimization of database by choosing suitable RAID- JBOD configuration and slow performing queries by looking at Actual Query Execution Plan, Data Profiler trace files, Dynamic Management Views.
• Developed Staging and Data Warehouse ETL solutions using SSIS, and T-SQL user defined stored procedures, user defined views, transferred data from OLTP databases to staging area and finally transferred into data warehouse also implemented data migration strategies - Full load, Incremental i.e., Delta load and Remigration clean up load.
• Experienced with the creation of SSIS packages in Data Extraction, Transforming, and Loading (ETL) from various sources using SQL Server Integration Services, Bulk Insert, and Bulk Copy Program (BCP).
• Highly experienced in Dimension modelling using star and snowflake schemas, handling Slowly changing dimension using different techniques like row hash (MD5 and SHA), Slowly changing dimension wizard and Lookup, especially in incremental load of data.
• Experienced in handling late arriving dimension and late arriving facts scenarios in a Data Warehouse.
• Designed and developed SSIS packages to import and export data from various CSV files, Flat files, Excel spread sheets and SQL Server.
• Experienced on various SSIS control flow tasks like Execute SQL Task, bulk insert task, data flow task, file System task, ftp task, send mail task, active script task, Message Queue Task, XML task.
• Well versed with various SSIS data flow tasks such as conditional split, derived column, lookup which were used for data scrubbing, data validation checks during staging, before loading the data into the data warehouse.
• Experienced in Designing, Creating and processing of cubes using SSAS. Created and Configured Data Sources and Data Source Views, Cubes, and calculated measures for OLAP cubes.
• Experienced in SSIS utilities like Import/Export Wizard, Package ISPAC Installation ISDEPLOYMENT Wizard, and SSIS Package Designer in SSDT.
• Experienced in managing and automating Control flow, Data flow, Events and Custom Logging using Microsoft. NET framework and C# for SSIS packages.
• Worked as a team for defining Measures Groups and Dimensions by analyzing Data Warehouse in order develop multidimensional cubes and tabular models in SSAS and Responsible for developed MDX queries for faster retrieval historical data from cubes.
• Developed and Configured Data Sources and Data Source Views, Dimensions, Hierarchies - Levels, Measure Groups, Dimension Usage Tab to define relation between Dimension and Measure Groups, Calculated Measures, KPIs and Storage Partitions in OLAP Cubes.
• Designed and developed SQL server configurations for SSIS packages and experienced in creating jobs, alerts, and SQL mail agent to schedule SSIS packages and T-SQL code constructs.
• Expert on Configuring MS SQL Integration Service (SSIS)Catalogs
• Expert in creating DynamicSSISPackages with Parameters, local and environmental variables,XMLconfiguration and check points.
• Extensive experience in implementing event driven Error handlings, package logs.
• Designed and developed reporting data models i.e., user defined stored procedures to develop different types of reports like matrix, tabular, chart dashboards, ad hoc reports using SSRS.
• Developed different types of reports including financial reports, cross-tab, conditional, drill-down, sub reports also parameterized reports, ad hoc reports for existing databases.
• Designed and developed financial report templates, bar graphs and pie charts based on the financial data. Scheduled the monthly /weekly/daily reports to run automatically.
• Extensive experience and solid hands-on experience in installing, configuring, managing, monitoring, and troubleshooting SQL Server in Development, Testing and Production environments.
• Proficient in coordinating with onshore/offshore & stake holder’s team for task clarification, fixes and review.
• Assertive and maintained positive communication and working relationship with all business levels.
• Experience inDocumenting Existing Process, Creating and Analyzing Business Requirements, FunctionalandTechnical Documents.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills.
• Self-motivated, diligent with the ability to quickly adapt to new environments and changes

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQL. C, C++, C#, VB 6.0, HTML, XML, JavaScript

ETL Tools: Import/Export Wizard, SSIS (SQL Server Integration Services)

Databases: SQL Server 2012, 2014, 2016, 2017 and Oracle 9i/8.x, DB2 MS Access, Azure DB.

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports XI/10/9, MS Excel, Tableau, Power BIAnalytical Tools SSAS - multidimensional and tabular model

Other Software: MS Office- 2010/2007/2003 , TFS (Team Foundation Server), Visual Studio 2013, Git Hub, and JIRA (JQL queries)

Methodologies: Agile, Scrum

Operating Systems: Windows 98/2000/2003/ XP/Vista/7, Windows Server 2012, 2012 R2, 2016

Database tools: SQS Plus, TOAD, SQL Server Management Studio

PROFESSIONAL EXPERIENCE

Confidential, WA

SQL/ETL Developer

Responsibilities:

• Coordinated with Business Analysts and customers to develop business requirements and specifications documents using Microsoft word and Power Point.
• Worked with IT and Business users to help implement solid, extensible warehouse models that support new analytic requirements using the most relevant techniques.
• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Designed physical and logical data models and handling data repository for data models.
• Understand business requirements by having grooming sessions with Business Analyst, Created high level and low-level technical design documents.
• Analyzed and performed Data modeling and mapping which involved identifying the source data fields, identifying target entities and their lookup table ids and translation rules.
• Responsible for the development and management of Enterprise Data Warehouse processes and policies, following strategic direction on best practices for holistic architecture.
• Developed source queries, user defined views and user defined stored procedures and used them in SSIS package data flow source components.
• Developed data profiling reports using T-SQL custom queries and SSIS data profiler task to understand quality and statistics of different source systems’ data.
• Developed T-SQL programs to create database, programmed queries, sub-queries, ranking functions, derived tables, common table expressions, stored procedures, views, user defined functions, constrains and database triggers using T-SQL.
• Review and create logical and physical design and stored procedures.
• Optimized stored procedures and long running scripts using execution plan, temp tables, and code rewriting and indexing strategies to increase speed and reduce run time.
• Developed new stored procedures and triggers, modified existing ones, and tuned them to achieve optimum performance using execution plans and trace files.
• Designed Data Warehouse ETL packages to handle data change tracking using slowly changing dimension transformation for type 1 and type 2 dimension attributes.
• Design, develop, and implement SSIS packages and projects to efficiently process high-volumes of data from multiple sources and meet nightly processing windows requirements.
• Developed configurable metadata driven ETL solution to track execution parameters, logging, and decision-making during jobs’ execution in order to ease debugging process in case of job failure.
• Designed and developed ETL packages using SQL Server Integration Services (SSIS) to load the data from SQL server, XML files to SQL Server database through custom C# script tasks.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup, for each loop container, sequence container, script task etc. for Data Scrubbing, data validation checks during Staging.
• Utilized SSIS Project Configuration to enable ease of deploying between dev, test, stage, and prod servers, by configuring environment variables to assign project parameters.
• Used ETL tools to maintain the quality of data and also to improve the metadata capabilities.
• Designed, developed, and deployed OLAP cubes and SSIS packages to process OLAP cubes through source views having dimension and fact tables listed. Utilized XMLA file for deployment of cube.
• Involved in development of MDXqueries for cubes inBusiness Intelligence Development Studio (BIDS), deploying them on the server through SSIS package for cube processing.
• Conduct analysis and design of data models for the development and maintenance of existing Enterprise systems.
• Create and maintain comprehensive documentation describing the structure, configuration, and functionality of data management systems and data structures.
• Automate processes using Control M and custom SQL metadata driven solution for jobs and error logging.
• Prepared the complete ETL specification document for all the ETL flows.
• Added additional error handling for low priority jobs to archive bad data to a shared folder where on call developer would review and fix the file during normal business hours to avoid midnight or early morning calls between developers and DBA’s.
• Upgraded legacy SSIS packages to 2016 SSIS and converted to project configuration during later part of ETL development.
• Generating Corporate Reports for Management Committee using SQL Server Reporting Services (SSRS) and Excel.
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurring in execution.
• Generated reports using Tableau for internal and external customers for business performance monitoring and business decision making.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and emailing them to director and analysts to be reviewed in Excel Sheet.

Confidential, Brownsville, TX

ETL Developer

Responsibilities:

• Participated in Planning, Defining and Designing database based on business requirements and provided documentation.
• Translated requirements, designs and functional specs into use case document, test plans and test cases documents.
• Involved in coordinating with source systems owners to fix issues in the daily ETL supporting multiple applications.
• Developed logical and physical data models using Erwin for new requirements after discussion with technical team and application users as per agile methodology.
• Worked on Metadata Repository (MRM) for maintaining the definitions and mapping rules up to mark.
• Involved in several facets of MDM implementations including Data Profiling, Metadata acquisition and data migration
• Involved in design and deployment of Report Models for generating Ad-Hoc reports as per the client requirements.
• Developed databases, tables, stored procedures, indices, foreign keys, and any other objects within the databases based on requirements from Developers.
• Implementation of Data Migration, Change Data Capture (CDC), Data Masking, Metadata Management for Customers’ data and transactions’ files.
• Implemented Normalization and De-Normalization of existing tables for faster query retrieval.
• Utilized Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports
• Developed user defined stored Procedure, scripts, cursors for the bulk application, tested them on the test servers and moved them to the production.
• Assisted on the Ad hoc-Query Requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs. Performed Performance Tuning of the Stored Procedures and Experience in trouble shooting database issues.
• Implemented triggers to keep track of changes to the fields of tables when changes are made especially for metadata tables.
• Performed performance tuning and optimization, query optimization, index tuning, caching, and buffer tuning for better performance of queries, packages, cubes, and reports.
• Created Microsoft Access project and connect it to an existing Microsoft SQL Server database.
• Developed SSIS Packages using SSIS Designer for import heterogeneous data from Access, OLE DB Source Oracle, Excel Spreadsheet to SQL Server staging database.
• Worked on various work flows like Data flow Task, Script Task, Execute SQL Task, Containers and File System Task.
• Implemented the logging, Breakpoints, handled errors especially foreach loop and continued execution logging previous iteration error(s).
• Designed high level ETL Extraction Transformation Loading architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Designed and developed SSIS packages to move data from production environment to different environments within the organization.
• Maintained warehouse metadata, naming standards for future application development.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Developed reports and dashboards into Centralized reporting system then deployed the reports to Report Server.
• Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using MS Reporting Services.
• Managed security roles and permissions on SSRS report at item level and group level
• Created complex reports in Crystal Reports using procedures from SQL Server by passing in stored procedure parameters.
• Developed windows-based applications in VB.net for interacting and retrieving data from SQL Server, also made applications for entering criterion and opening reports from Crystal Reports.
• Experience in Control-M for job scheduling and workload automation in enterprise IT environments to manage and automate batch jobs and other processes.
• Used Power BI for business intelligence by providing real-time dashboards that allow users to monitor key performance indicators (KPIs) and make data-driven decisions.
• Used Power BI tools for date analysis, data integration and data visualization to create interactive and dynamic charts, graphs, and dashboards.
• Created Report Email Subscription using Data and Time Driven Report Subscriptions.
• Created web parts, workflows, info path forms and used SharePoint designer for master page creation.
• Involved in the development of an internal portal to publish reports across organization.
• Identified VP-ASP framework as most cost-effective solution for the client. Managed a team of three developers during implementation.
• Worked with Offshore team for ticketing issues, Development process and Quality support for various Subject areas
• Incorporated Team Foundation Server for source control, check-in, and check-out.

Confidential, Tacoma, WA

Jr. SQL Developer

Responsibilities:

• Involved in requirement analysis for new development or change requests, understanding existing defect in system.
• Work closely with Report Analysts and Operation Staff for support in problem resolution and root cause analysis.
• Worked on change requests pertaining to existing database objects that include Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers to support ongoing business change requests.
• Developed new user defined stored procedures, user defined functions, and triggers using T-SQL as part of adding new data elements in the Data Warehouse.
• Created Clustered and Non-Clustered Indexes to improve the performance of database access by looking at actual execution plans and index suggested by plans.
• Established referential integrity, data consistency, and indexing and data clean-up procedures to maintain high quality data that can be used for reporting.
• Used Execution Plan, SQL Profiler, and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Extensively worked on Dynamic Management Views (DMV's) and Dynamic Management Functions (DMF's) to find what queries are being executed during job execution.
• Worked on existing SSIS Packages, Import/Export wizard for transferring data from Database (Oracle and Text format data) to SQL Server.
• Extensively used SSIS Data Profiler Task to profile target source systems (tables & views) prior to building ETL solutions, which was instrumental in cleaning data for data consistency and designing the table structures.
• Data Cleaning and data manipulation such as Concatenation, LEN, Find & Replace, Filter & Sort, Conditional Formatting, Index Match, Remove Duplicates, Logic Functions were done using Microsoft Excel on sample data.
• Extracted data from Oracle and migrated into SQL Server Database using SSIS and developed Package labels for test and production environments and execution of SSIS packages automatically.
• Used various SSIS tasks such Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS Control Flow and Data Flow tasks such as Pivot Transformation, Execute SQL Task, Data Flow Task, etc. to import data into the data warehouse.
• Responsible for implementation of SSIS Logging, error configurations for Error handling the packages.
• Updated Package Configurations of entire database from XML Configurations to SQL Server Configurations so as to assist in execution of packages in various environments.
• Experienced with Business Intelligence Development using Power BI Cloud and SQL Server Reporting Services (SSRS).
• Created interactive dashboards using parameters, actions and various data visualizations with Excel Power Pivot.
• Developed, scheduled and generated variety of reports like List, Matrix, Drill-Down, Chart and Sub Report and standardize company report by implementing SSRS.
• Created dashboards with charts, graphs that convey meaningful data and insights using Power View.
• Deployed reports to Report Manager and involved in troubleshooting for any error occurs in execution.
• Manage subscriptions and rendered reports in different formats (PDF, Excel, etc.) to be executed automatically on daily, weekly and monthly basis.