SUMMARY

• SQL Developer for more than 5 years of experience in Database Design, Development and implementation of Data Warehouse, BI Solutions, Database Programming, Data Modelling.
• Strong Customer Centric Approach, with Process Orientation; Motivated by internal standards of performance to deliver quality results.
• Extensively involved in all phases of software development life cycle (SDLC) and experience in Agile / Scrum and Project Management Methodologies.
• Highly proficient in the use of T - SQL and PL/SQL for developing complex Stored Procedures, indexes, Tables, Views, User Defined Functions, Relational Database models, Data integrity and SQL joins.
• Hands on experience in monitoring SQL Server Performance tuning in SQL Server 2 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Highly experienced in Data modelling (till 3NF normalization level) and Dimensional modelling (using Star and Snowflake schemas)
• Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers.
• Experienced in creating Database Objects like Tables, Constraints (Primary key, Foreign Key, Unique, Default) Views and Indexes.
• Well versed in Relational Database Management Systems, including Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export Wizard, Triggers and Normalization.
• Performed complex queries, data scrubbing, data gathering, data consultation and data analysing on large volume of data sets. Experienced in Tuning SQL queries and T-SQL queries, MDX, & improving the performance of the queries.
• Experienced in Database Administration operations like Backup, Restore and Transact- SQL (DDL, DML, DCL).
• Experienced in the development and implementation of Data Warehouse solutions: Data Warehouses and Data Marts and ETL processes and designing of Star and Snowflake data models Schema.
• Experience in installation, configuration of MS SQL Server.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Extensive hands-on experience in Database development for both OLTP Batch Processing and Online Processing.
• Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and load the Data from various Databases and into Siemens Servers using SQL Server Integration Services SSIS.
• Designed ETL workflows to load data into Staging / Landing, Data Mart / Data Warehouse databases for full, incremental and remigration of data.
• Proficient in Dimensional modelling, defining dimension attributes, hierarchies and different types of fact tables and measure granularity.
• Implemented ETL workflow packages using SQL Server Integration Services (SSIS) to extract, clean, transform, and load data into data warehouse.
• Experienced in designing SSIS packages for integrating data using OLEDB connection from heterogeneous sources (Excel, CSV, flat file, OLEDB) by using multiple transformation provided by SSIS such as Data Conversion, conditional split, merge, union all etc.
• Created SQL server configurations for SSIS packages and experienced in creating jobs, alerts, and SQL mail agent and schedule SSIS packages.
• Experience in creating Jobs, Alerts, and scheduling SSIS Packages in SQL Agent.
• Deployed SSIS Package and SQL objects into Production and used Package configuration to export various package properties to make package environment independent.
• Designed and developed multidimensional OLAP cubes using SQL Server Analysis Services (SSAS) and leveraging the advanced BI functionality of SQL Server.
• Experienced in creating custom columns and measures using DAX, developing Page level Reports, Dashboards, dynamic Navigation bars & Stories in Power BI.
• Experienced in Enterprise Data Warehouse environments, including experience with dimension modelling and performance optimization.
• Designed, developed, and deployed reports using SQL Server Reporting Services (SSRS) reports in support of productivity enhancements
• Developed, maintained, and supported operational reports, dashboards and scorecards using Microsoft Power BI through relational database queries.
• Working knowledge of Agile Methodology of Project Management.
• Articulate communicator with strong analytical and interpersonal skills, skilled at collaborating with project teams, interfacing with clients.
• A systematic, organized, hardworking and dedicated team player confident in handling multiple assignments under pressure and meeting tight deadlines.
• Experienced in Project management tools like Trello.

TECHNICAL SKILLS

Database Tools: SQL Server Management Studio, SQL Profiler, Query Analyzer, Visual Studio

ETL Tools: SQL Server Integration Service (SSIS) 2017/2016/2014/2012

Data mining tools: SQL Server Analysis Service (SSAS) 2017/2016

Reporting Tools: SQL Server Reporting Service (SSRS) 2017/2016/2014/2012, Microsoft Power BI, MS-Access, MS-Excel, Report Server

Programming Tools: T-SQL, C#

Web Technologies: HTML, DHTML, Java Script

Operating Systems: Windows 2016/2012 R 2/2012 Server, Linux

Other Tools: MS Office Suite (Microsoft Word, Power Point, Microsoft Visio), ERWIN, Oracle-SQL Data modeler, AutoSys, Jira, Amazon Web service AWS

PROFESSIONAL EXPERIENCE

Confidential, Shelby, NC

SQL/ETL Developer

Responsibilities:

• Interact with various Business Analysts, Management, and IT Units to analyse business & functional requirements, Convert business requirements into technical use cases.
• Responsible for preparing high level and low-level design documents for change requests and bug fixes.
• Maintained business intelligence models to design, develop and generate both standard and ad-hoc reports using SSMS, SSIS, SSRS and Microsoft Excel.
• Involved with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
• Worked in designing and optimizing various T-SQL database objects like tables, views, stored procedures, user defined functions, indexes, and triggers.
• Enhance existing stored procedures, views, functions, database objects to meet additional requirements of latest releases, Involved in the performance tuning of table valued functions.
• Analysed source data to determine the data model and ETL solution that will meet business requirements.
• Designed SSIS packages utilizing tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, send Mail Task, Foreach loop Container, Derived Column, Conditional Split and Derived Column.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Implemented complex SSIS packages’ error handling and package logging that stores the logging results in SQL table and flat files on error, on warning, on task failed event types.
• Used SSIS package and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design and other Data Warehouse concepts.
• Created Packages to group logically related column types and to transfer data.
• Involved in Dimensional modelling by identifying the fact and dimension tables and design start/snowflake schemas for the Sql Server Analysis services.
• Played a major role in production support o SSAS cube refresh, SSIS jobs.
• Worked on creating calculated measures that fits business logic, using MDX queries.
• Handling Initial and Delta loads and processing Cubes Star Schema across all environments.
• Worked on Key performance Indicators KPIs, design o star schema and snowflake schema in Analysis Services SSAS
• While developing reports from Cubes also used the KPI's for decision making, also implemented Cube Partitions, and also debugged data connections, data sources and Data Source Views.
• Created different type of reports including Cross-tab, Drill-through, Drill-down, Sub reports and parameterized reports
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, XML etc.
• Created Drill Down, Drill Through and Cascaded Parameterized reports according to the customer requirement.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Involved in SSIS Packages, Query verification in SSRS and Stored Procedures.

Environment: SQL Server 20172016,, SSIS, SSAS, SSRS, MDX, OLAP, XML, Microsoft Visual studio 2019, C#, OLAP, XML, Windows Server 2016

Confidential

SQL/BI Developer

Responsibilities:

• Participated in Planning, Defining and Designing database based on business requirements and provided documentation.
• Liaised with Project Managers, Business Analyst, Business Stakeholders, and other cross-functional groups to resolve business queries, defects, and mitigate escalations
• Responsible for Data Profiling to determine data integrity for transformation of Data from Source
• Programmed Queries in T-SQL, Stored Procedures and Views to store the data of clients, advisors using SQL Server, Lead Data Mapping activity extensively.
• Worked in designing and optimizing various T-SQL database objects like tables, views, stored procedures, user defined functions, indexes, and triggers.
• Worked on Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Utilized Integration Services for transferring and reviewing data from heterogeneous sources like (Flat file, Excel, CSV, Oracle, MS Access).
• Designed and Developed complex SSIS packages for performing ETL process using SQL Server Integration Services.
• Monitored time taking queries with Performance Tuning to reduce the execution time and created packages in SSIS with error handling
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data and finally load it into the multi-dimensional data warehouse.
• Designed dynamic visuals using Bookmarks, Slicers, custom tooltips in Power BI
• Published and Shared Power BI reports and Data models in Power BI workspaces
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).
• Extensively used UNIX commands for fetching and checking files.

Environment: Environment: SQL Server 2014, SSIS, SSAS, SSRS, MDX, OLAP, XML, MS PowerPoint, MS SharePoint, MS Project, MS Access, Windows Server 2012 R2 & UNIX.

Confidential

SQL/SSIS/SSRS Developer

Responsibilities:

• Involved in source Data Analysis, Design and Creation of Data Mappings for Extraction o bulk data from heterogeneous sources like Oracle, ADSI and other OLEDB data sources.
• Involved in writing stored procedures for both Online and Batch requests handling business logic and Functionality of various modules
• Worked with various upstream and downstream systems and customers in interfacing various systems for Data extractions, ETL, Analytics and reporting needs
• Worked on developing Tables, Indexes, Views, Creating complex stored procedures, Triggers, Functions
• Tuned several slow running queries in Production. Implemented Indexes to achieve time Performance.
• Developed Data-data packages in SSIS as part of the automating the process for billing method.
• Extracted data from various sources like SQL server, Oracle, CSV, Excel and text file from Client servers and through FTP.
• Scheduling and Maintaining SSIS Packages and batch jobs thru SQL Server Agent and using Shell Scripts, VB Script and batch .bat files on a day-to-day basis
• Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Worked on Transforming and Loading data using SSIS,Import/Export wizard.
• Developed Enterprise reports using SQL Server Reporting Services SSRS and Excel pivot tables based on OLAP Multidimensional cubes which make use of multiple value section in parameters pick list, cascading prompts, matrix dynamics reports and other features of Reporting service.
• Developed Tabular Reports, Sub-Reports, Matrix Reports, Drill Down Reports, Dashboard, Cascading, and charts using SSRS.
• Interacted with Developers in troubleshooting application and Report Developing.

Environment: SQL Server 2012 Enterprise Edition, SQL BI Suite (SSIS, SSRS), VB Script, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MS Project, MS Access & Windows Server 2012, Oracle.

Confidential

Jr. SQL Developer

Responsibilities:

• Built SSIS package to load data from different files and databases using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Pivot, Slowly Changing Dimension and other transformations.
• Writing SQL Scripts, Store procedures, Views and Functions and cursors in T-SQL using SSMS.
• Creating Scable Solutions and providing support on Application Goverance and Deliveriables.
• Troubleshooted and monitored daily execution and implementing enhancement on existing SSIS packges.
• Building and Maintaining SQL Scripts, Indexes, Store procedures, Views and Functions and cursors.
• Worked on Data Mapping and Data Dictionary to create New CRM interface with Wholesale Line of Business.
• Documenting and analyzing workflows & use cases, business rules, prototyping, data mapping & data modelling
• Developed SSIS packages pulling data from Hadoop, Teradata and other sources.
• Develped new process to pull the data from Hadoop and Teradata into SSIS and provide report to LoB.
• Upgraded and automated manual jobs and scripts in to SSIS and scheduled in sql agent.
• Prepared Production support documents for new process and updating documents for existing process for Production Support
• Worked on Debugging and Fixing of failed SSIS jobs.
• Used SSRS to create, customized, On-Demand and Ad-Hoc reports and involved in analyzing multi-dimensional reports inSQL Server Reporting Services.

Environment: SQL Server 2012, SSIS, SSAS, SSRS, BIDS, ETL, T-SQL, MS Excel, MS Access, MS Visio