SUMMARY

• Have more than 5 years of experience in diverse business and technical environments with main area of focus in design, development, implementation and support of relational databases, data analysis, business intelligence, ETL, and data visualization using RDBMS databases and various reporting and visualization tools.
• Well versed in all Software Development Life Cycle (SDLC) phases of specifically waterfall and Agile Scrum methodology.
• Strongly experienced on SQL Server 2017/ 2016/2014/2012 as a Developer, experience includes Database DesignandDevelopment, ConfidentialBI Solutions, ETL Development, Data warehouse Implementation, Report Development usingSSAS, SSIS, SSRS and TSQL.
• Experienced in executing activities related to end - to-end project management, including project plans and estimates, scoping and requirements through implementation, Requirement Gathering, Requirement analysis, Application environment Setup, Preparing Test Scripts, Project Status reporting, bug fixing and deployment.
• Experience in coordinating with users in gathering source data files, defining data elements, business rules, data, and process flow documentation, prepare High level and Low-level design documents.
• Proficient in design and development of Relational Database Management Systems, with strong experience on Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Proficient in Data Modeling up to 3rd Normalization form and Dimensional Modeling using Star and Snowflake schemas.
• Have excellent command writing ad hoc queries utilizing dynamic SQL. Strong Transact-SQL query writing skills (DDL, DML, TCL, DQL and DCL).
• Excellent Experienced in monitoring SQL Server Performance tuning in SQL Server
• Implemented Full, Incremental and Remigration ETL workflow and data pipelines for Staging, Data mart and Data Warehouse databases.
• Experienced in handling late arriving dimension and late arriving facts scenarios in a Data Warehouse.
• Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Access/Excel Sheets using SQL Server SSIS.
• Experienced in creating jobs, SQL Mail Agent, Alerts and schedule DTS/SSIS Packages.
• Experienced in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Designed and developed ETL SSIS process design, architecting the flow of data from various sources to target.
• Experienced in SSIS utilities like Import/Export Wizard, Package ISPAC Installation ISDEPLOYMENT Wizard, and SSIS Package Designer.
• Thorough working knowledge on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.
• Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence and writing MDX Scripting.
• Have implemented Features, Structure, Attributes, Hierarchies, Star and Snowflake Schemas of Data Marts.
• Experience in creating Ad hoc reports and reports with complex formulas and to query the database for Business Intelligence.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using Drill-down, Drill-through And Cascading reports using SSRS.
• Having experience in developing end-to-end Business Intelligence solutions in accordance with Standard OLAP Methodologies using Tableau.
• Proficient with SQL Server, BI Stack (SSIS, SSAS, and SSRS), Power BI, and Tableau within large and complex environments. Expertise in Power BI, Power Pivot and Tabular Model, DAX, MDX queries.
• Experienced in managing security of SQL Server 2016/2014/2012 databases by creating OLTP database users and roles and assigning proper permissions according to business requirements.
• Good Knowledge in design and implementation processes for deploying, upgrading, managing, archiving and extracting data for reporting using SQL Server Reporting Services (SSRS)/Power BI.
• Experienced in Agile Methodology.
• Working knowledge on data modelling techniques towards building enterprise data warehouse.
• Worked on SQL Server Analysis Services (SSAS) including in building cubes and writing MDX queries.
• Worked on SQL Server Reporting Services in generating parameterized, linked, drilldown and sub reports.
• Intermediate expertise in ASP.NET, C#.NET
• Very good communication, analytical, interpersonal, presentation skills and Team skills combined with selfmotivation, initiative and the ability to think out of the box and worked as lead to carry out deliverables.
• Responsible for the Deliverables, Scheduling, Resource allocation and requirement gathering for the project.

TECHNICAL SKILLS

Methodologies: Agile, Scrum, Waterfall

Reporting Packages: SSRS (SQL Server Reporting Services), Import Export Data, MS Excel, Power BI, Tableau

ETL Tools: SSIS (SQL Server Integration Services), DTS

SQL Server and Database Tools: Business Intelligence Development Studio (BIDS), Enterprise Manager, Profiler, Query Analyzer, Storage, Data Mining Models, Bulk Insert and BCP, Export & Import (DTS), SSIS, SSRS, SSAS.

RDBMS: MS SQL Server 2016/2014/2012 , MS Access

Programming Languages: C#, ASP.NET, T-SQL, PL/SQL,MDX, and DAX.

Web Technologies: HTML, CSS, JAVASCRIPT

Cloud Technologies: Azure SQL Database

Analytical Tools: SSAS - multidimensional and tabular model

Languages: Transact - SQL, PL-SQL, MDX/DMX, HTML, DHTML, XML, VB.Net, C and C++

Other Tools: TFS (Team Foundation Server), Visual Studio 2013, GitHub, and JIRA (JQL queries)

PROFESSIONAL EXPERIENCE

SQL/ETL Developer

Confidential, Fort Worth, TX

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Interact with various Business Analysts, Management, and IT Units to analyze business & functional requirements, Convert business requirements into technical use cases.
• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Responsible for preparing high level and low-level design documents for change requests and bug fixes.
• Analyzed source data to determine the data model and ETL solution that will meet business requirements.
• Involved in the full lifecycle of ETL software development - analysis, design, build, documentation, and testing for the project.
• Writing Triggers, Stored Procedures, Functions, User Defined Data Types, TSQL, and Create and maintain physical structures.
• Working with Dynamic Management Views, System Views for Indexing and other Performance Problems
• Create / Manage Table Indexes, Query Tuning, Performance Tuning, Deadlock Management
• Defect tracking and closing by using HP Quality Center
• Design and Deploy SSIS Packages. Research with team members and came up with the high-level design, impact analysis document with several solutions to the problem during implementation proposed new system.
• Designed and normalized the database and created different objects like Tables, Views, Stored Procedures, UDFs, Indexes Rules and defaults on MS SQL Server.
• Involved in installing and migrating legacy databases to MS SQL Server.
• Contributed to programming complex T-SQL queries and Stored Procedures for generating reports and various business logic / scenarios.
• Developed new stored procedures and triggers, modified existing ones, and tuned them to achieve optimum performance using execution plans and trace files.
• Responsible to monitor performance and optimize SQL queries for maximizing efficiency
• Designed, developed, deployed, and tested the ETL workflow to load data from source to staging and Data Warehouse through Microsoft ETL SSIS.
• Developed several SSIS packages to import Flat files CSV into data tables. These packages were scheduled in a regular time interval.
• Applied various data transformations like Lookup, Sort, Multicasting, Conditional Split, Derived column etcetera.
• Perform data validation checks and filtered bad data.
• Used Sequence Container, Execute SQL Task, Send Mail Task, Precedence Constraint, Script Task to achieve business requirement in the control flow.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• 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.
• Extensively worked with OLAP cubes to generate drill through reports in SSRS
• Developed SQL Server reports using SSRS and exported them to Excel format for managers and QA team for easy validation.
• Responsible for the ad-hoc reporting, modification and regenerating on request.
• Building scorecards and dashboards using the Performance Point Services 2010 with BI application.
• Schedule the reports to run daily, weekly, and monthly and automatically emailed reports to department directors and analyst to review it.,

Environment: SQL Server 2016, T-SQL, SSIS, SSAS, SSRS, C#, VB.Net, TFS, Windows 10, Windows Server 2016, Visual studio 2017, TFS, Git Hub, Point Services 2010, Microsoft office, T-SQL

SQL/SSIS Developer

Confidential, Reston, VA

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of agile model system.
• Closely worked with Business analyst for gathering requirement and Architects. Involved in providing presentation to clients and conducting group meeting with team members.
• Involved in complete Software Development Life Cycle (SDLC), which includes requirement gathering, analysis, design, development, and Implementation.
• Involved in design and development of Data Warehouses, Data marts and Business Intelligence reports using multi-dimensional models.
• Modified the existing ERD's to insert more tables, columns and constraints using MS Visio 2008 for more refined data models.
• Worked inActive passive clusterenvironment. Usedlog shippingfor synchronization of databases.Update statistics, database integrity check andBackupoperations
• Assisted on theAdhoc-QueryRequests based on the requirement by usingJoins, Sub Queries and Co-related Sub Queries.
• Worked on complex SQL, Stored Procedures, Triggers, and packages in very large databases from various servers.
• Created scripts to verify and reconcile the migrated data from legacy system to SQL Server.
• Filtered and cleansed dirty data from legacy system using complex T- SQL statements in staging area, and implemented various constraints and triggers for data consistency
• Developed interface stored procedure to upload Record from XML format to Customer System Format i.e., EDI 219 format.
• Actively participated in daily calls with Client and Client Team.
• Developed master and child packages, using package configurations (SQL Server) and SSIS logging.
• Analyzed and enhanced the existing ETL strategies to populate the existing data warehouse with facts and dimensions based on new requirements in a multi-application environment.
• Planning Complete Back-up of Database and Restored the Database from Disaster Recovery.
• Designed, developed, and delivered business intelligence solutions using Power BI, SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Developed stored procedures and triggers to facilitate consistent data entry into the database. • Wrote store procedures to generate account statements for different types of accounts
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Used indexes to enhance the performance of individual queries and enhance the stored Procedures.
• Involved in programming and solving the issues in the complex SQL statements and performing the query optimization.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase). Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Contributed to creating complex SSIS packages using proper control and data flow elements. Worked with different methods of logging in SSIS.
• Responsible for ETL support operation using SQL Server Integration Services (SSIS) and worked with users to train and support
• Thorough analysis and testing of database objects & T-SQL statements before deployment to the production server.
• Applied Multithreading techniques for creating high performance applications.
• Involved in Creating User Security and Roles in Reporting Services at both Parent Level and Report Level.
• Responsible for admin related tasks like adding users, backup and restore database, adding linked servers, Job scheduling, configured SQL server maintenance plans grant database access roles to the other users.
• Created and maintained various views and dashboards in Dynamics CRM
• Handled ad hock data requests and tickets for CRM, provided general production support for CRM related tickets
• Provided back-end support for functional testing and performance testing. Developed scripts to migrate data from multiple sources to desired destination using ETL tools.
• Created Data Sources, Datasets and Parameters as per the requirements of the reports
• Designed reports based on new requirements for Design and Project Planning with SQL report service (SSRS).

Environment: SQL Server Management Studio, Confidential Visual Studio, MS BIDS, SQL Server 2014 Data Tools, SSRS, SSIS, SSAS, Active Directory, .NET 4.5 Framework, MS Visio, Dynamics CRM, Windows Server 2012 R2

Jr. SQL Developer

Confidential, Newton, MA

Responsibilities:

• Interact with clients to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Developed and maintained clearly written technical, user, and system documentation.
• Worked on complex SQL, Stored Procedures, Triggers, and packages in very large databases from various servers.
• Created scripts to verify and reconcile the migrated data from legacy system to SQL Server.
• Filtered and cleansed dirty data from legacy system using complex T- SQL statements in staging area, and implemented various constraints and triggers for data consistency
• Developed interface stored procedure to upload Record from XML format to Customer System Format i.e., EDI 219 format.
• Developed complex Stored Procedures to process prospective customer information and balanced the processing load between front end and back end
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Programmed Triggers, Stored Procedures, Functions, Coding using Transact-SQL (TSQL), Create and maintain Physical Structures.
• Utilized Dynamic Management Views, System Views for Indexing and other Performance Problems
• Liaison with ETL Team to convert ETL requirements as Standard Database solutions to boost the performance.
• Involved development of automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Used SSIS and T-SQL stored procedures to transfer data fromOLTP databases to staging areaand finally transfer into data warehouse.
• Usedvarious SSIS tasksuch 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.
• Performed the Migration the Existing DTS packages to the SSIS Batch jobs.
• Used Email Notification package success or failure. If the package is success send the mail with package name, how many records inserted, updated and total records using Send Mail Task. If the package is failed it will send the mail package name and error description using On Error Event handlers in Send Mail task.
• Provided Package Configuration, Custom Package Logging, Error Handling, and Email Notification to SSIS packages.
• Created SQL server configurations for SSIS packages and experienced increating jobs, alerts, and SQL mail agent and schedule SSIS packages.
• Developed and maintained ETL packages to extract the data from various sources and Responsible fordebugging and upgrading of several ETL structuresas per the requirements.
• Workedvarious SSIS Taskslike 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.
• Worked as a team for defining measures and dimensions by creating cubes in SSAS and Responsible for developed MDX queries for faster retrieval historical data from cubes.
• Responsible for creating reports based on the requirements using SSRS and Defined the report layout and identified datasets for the report generation.
• Flexible, enthusiastic, and project-oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs

Environment: SQL Server Management Studio, Confidential Visual Studio, MS BIDS, SQL Server 2012 Data Tools, SSRS, SSIS, SSAS, MS Excel 2007, MS SQL Server Integration Services SSIS, Team Foundation Server, SQL Profiler, Windows 2012 Advanced Server, Oracle 9i.