SUMMARY

• SQL Developer for more than 3 years of experience in Database Design, Development and implementation of Data Warehouse BI Solutions, Database Programming, Data Modelling, Testing SQL Server 2016/2014/2012.
• 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.
• Experienced in Analysis, Design, Implementation, Testing, and debugging new and existing client - server-based applications. Have strong experience in reverse engineering the back-end code.
• 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.
• Expertise working with SQL Server 2012/2014/2016 tools Such as Management Studio, Query Analyzer, SQL Profiler, SQL Agent, SSIS and SSRS.
• Extract Transform Load ETL development using SQL Server Integration Services SSIS and SQL Server 2014 Reporting Services SSRS.
• Experience with parameterized, custom reporting using SSRS for daily Ad-Hoc reports.
• Configured and administer BPA Business Process Automation for designing ETL workflow and including multiple packages within the workflow
• Documenting all ETL projects and workflows by using Bi Documenter and including supporting documents for troubleshoot for each project.
• Extensively used the native tools like Database Tuning Advisor, Profiler, Performance Monitor, Activity Monitor, and Event Viewer for performance analysis.
• Extensive experience in MySQL Server Installation, Configuration and upgrading, Performance Tuning, Query Optimization.
• Experience in Data Migration by using side-by-side upgrade process Management.
• Experience in Data modelling, Database design, normalization techniques using Database diagrams, Erwin, and other Data modelling tools.
• Experience in Dimensional Modelling, ER Modelling, Star Schema / Snowflake Schema, FACT and Dimensional Tables and Operational Data Store (ODS).
• Experience in creating and managing database objects like tables, views, stored procedures, Triggers, user defined data types and functions. Implementing SQL Server security and Object permissions.
• Experience in troubleshooting SQL issues by using SQL Tools Execution plan, Trace, and 3rdparty tools.
• Have experience in Performance Tuning, T-SQL Query Optimization and Solving Blocking issues.
• Experience in Query Tuning by Using Execution Plan, query analyser and tuning advisor.
• Good understanding and knowledge of Relational Database Management Systems RDBMS.
• Good Knowledge of MY SQL and SQL Server Clustering, Replication, Data Mirroring, Linked Migrated DTS Packages to SSIS using various versions of SQL Server.
• 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. Created SQL server configurations for packages and experienced in creating SQL mail agent and automate emails.
• 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.
• Developed and maintained Cascading, Drill-down, Drill-through, dashboards and parameterized Reports using SSRS.
• Managed security by defining roles and rights at database and active directory.
• Managing Production Server and Development server for SCCM Reporting.
• Expert in creating and developing Power BI Dashboards having rich look and feel.
• Highly organized with the ability to manage multiple projects and meet deadlines.
• A team player with excellent interpersonal, communication and presentation skills.

TECHNICAL SKILLS

Languages: C, C++, T-SQL, C#.Net, VB.Net

RDBMS: MS SQL Server 2016, 2014, 2012, Oracle, MYSQL, MS-Access

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

Analytics: SQL Server Analysis Services (SSAS), Power BI

Web Technologies: HTML, XML

Reporting Tools: SQL Server Reporting services (SSRS), Crystal Reports

Data Modeling Tool: ER Studio, Microsoft Visio

Operating System: Windows Server 2016, 2012 R2, 2008, Windows 9, 10

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, 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.
• T-SQL development included queries using complex joins, sub queries, case statements, Ranking functions, Derived tables, common table expressions (CTEs), views and constraints.
• Enhanced performance using optimization techniques-normalization and indexing.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• 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 of SSAS cube refresh and related 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 of 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 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 Unit testing in SSIS Packages, Query verification in SSRS and Stored Procedures.

Environment: MSSQL Server 2016/17, SSIS, SSRS, SSAS, TSQL, Power BI, MS Excel, MS Access, TFS, OLAP, Oracle 9i, Windows Server 2016.

Confidential, Dallas, TX

Jr. SQL Developer

Responsibilities:

• Closely worked with business users for gathering requirements and conducting a weekly meeting for BI team.
• Extracting data from Oracle, SQL 2014 and flat files using SSIS and performing all necessary procedures for data cleansing.
• Maintaining Landing zone and staging zone for data dumping.
• Running PL/SQL script and validate the data load for SQL server.
• Performed intensive data quality on various data migration and written various postscripts to perform data correction.
• Used various tasks like Data conversion, Derived column, lookup, for each loop, file system task for data cleansing and automate the process.
• Designed and created data extracts, supporting SSRS, Power BI, Tableau visualization tools reporting applications.
• Demonstrate expertise in utilizing load data in file tool, MYSQL dump, MYSQL hot copy, MYSQL import for data migration including SQL Server Integration Services SSIS, Data Transformation Services
• Involved in design and development of Tableau visualization solutions.
• Worked on multiple projects for ETL development and system integration for new environment.
• Extensive experience in MySQL Server Installation, Configuration and upgrading, Performance Tuning, Query Optimization.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Responsible for maintaining Servers, Log Shipping, and experience with MySQL Analysis Services for Data Warehousing.
• Multiple views were created to reduce the complexity of writing procedures and increase database performance.
• Extensively participated in functional and technical meetings for designing the architecture of ETL load process mappings, sessions, workflows from source systems to staging to DW and offshore team management.
• Extensively involved in Data Extraction, Transformation and loading from OLTP to OLAP system in SQL Server 2012 by creating cubes that uses the relational data warehouse as sources to its dimensions and facts. Experience in working with Azure SQL Database Import and Export Service, also deploying SQL Databases in cloud (Azure).
• Involved 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 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.
• Created SQL-Loader scripts to load legacy data into Oracle staging tables and wrote complex
• SQL queries to perform Data Validation and Data Integrity testing. Used TOAD against Database.
• Documented all ETL packages and applying versioning with other changes. Also created supporting documents for future failures.
• Worked with TFS 2012 for check in, check out and deploying packages to QA and PROD

Environment: MS SQL Server 2014, SSIS, SSRS, SSAS, TFS, Microsoft Visual Studio 2013, SQL Server Management Studio, MS Excel, T-SQL, PL/SQL, AS 400, MS Access, Report Builder 2.0/3.0, SEQUEL Viewpoint, System I Navigator, TFS 2010, Windows Server 2014.