SUMMARY

• Over 8 years of IT experience in Data Design and Development on Microsoft SQL Server, T - SQL, Performance Tuning, Troubleshooting, SSIS Package Configuration, SSRS, SSAS and Data-warehousing.
• Effective in handling applications with end-to-end responsibilities using Business Intelligence Solutions like SSIS, SSAS, SSRS and expertise in design and implement Relational Database model as per business needs.
• Actively involved in design and implementation phase of the project and prepared documentations.
• Specialized in working with both functional and technical teams to interpret, create and implement business requirements into technical specifications, code and deliver.
• Worked in Agile environment, Kanban board under various phases of Software Development Life Cycle including development with continuous integration and delivery.
• Excellent T-SQL development skills to write complex queries involving multiple tables.
• Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, Data Dictionaries and Data Integrity.
• Experience in Performance Tuning and Query Optimization.
• Expertise in designing complex SSIS packages for migrating the data and used various containers and Task that are available and used enhanced Error handling mechanism and check points in SSIS
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS).
• Designed SSIS Packages to import/export data from flat files to SQL Server and other data sources.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Experience in creating OLAP Data marts, Partitions, KPI’s, and Perspectives, slow moving dimensions using SQL Server Analysis Server (SSAS)
• Strong development skills with Azure Data Lake, Azure Data Factory, Azure Synapse Analytics.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.
• Experienced in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS.
• Strong Experience in creating Ad Hoc, parameterized reports, linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005/2008.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing.
• Proficient in working with .NET features like Inheritance, Polymorphism, Abstract, Classes, Generics & Collections, threading, Exception, handling, Debugging, and Tracing in .NET application.
• Created Tableau visualization reports using map, pie, bar, Histogram, bubble, circle, combo, and scatter.
• Created cubes in Board dashboard tool and created dashboard using cubes and created Capsule’s.
• Created visualization reports using Microsoft Power BI.
• Ability to handle Multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.

TECHNICAL SKILLS

Languages: T-SQL, SQL Server 2017, Oracle, PL/SQL, UNIX, Visual Studio, C

Scripting Languages: C#, Java Script, Shell Script

ETL Tool: SQL Server Integration Services SSIS

Database: MS SQL Server, SQL Server Management Studio SSMS, SSAS, Oracle 9i/10g/11g/12c

Version Control: TFS, GitHub, Tortoise SVN

Reporting Tools: SSRS (SQL Server Reporting Services), Crystal Reports, Tivoli Common Reports

PROFESSIONAL EXPERIENCE

ETL Lead Developer

Confidential, Portland, OR

Responsibilities:

• Designing BI solutions with Microsoft SQL Server R2 / 2012
• Create and Manage tables, views, stored procedures, custom queries, views, and reports for top level management using SSMS.
• Create stored procedures using SQL Server Business Intelligence Development Studio, and use them to create dashboards, charts, tables and raw data reports.
• Prepared documents to define strategies for business data integration.
• Actively taken part in presenting implemented features and updated to client.
• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities
• Deploy and manage reports, including subscriptions in SSRS.
• Create, modify and manage SSIS and SSRS reports to provide statistical analysis.
• Design queries using T-SQL in the SSMS environment.
• Design reports in the Visual Studio development environment and Microsoft Excel.
• Develop, maintain and update relational databases for accuracy of all reports.
• Follow change management process to resolve application defects on production and for implementing development enhancements.
• Identify problems, develop ideas and propose solutions for situations requiring analytical, evaluative or constructive thinking in daily work.
• Evaluating data file submissions and developing/maintaining SSIS packages for ETL processes.
• Responsible for extracting the data from OLTP and OLAP using SSIS
• Developed SSIS packages that can extract data from various sources and merge into one only source for Power BI reports
• Deliver projects/work on-time, on-budget, and in a way that accomplishes client goals
• Experience in publishing the Power BI Desktop models to Power Bi Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets
• Analyze data and identify opportunities to support reporting improvements.
• Developed SSIS packages for ETL and data manipulation processes.
• Created Package Configurations, Error Handling using Event Handlers for On Error, On Warning, On-Task Failed Event Types
• Involved in automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler and Autosys.
• Designed new process flow that pulls data and transformation as required and process it.
• Created Drill Down and Drill Through report and used Expression builder to build complex expression and used report builder for ad-hoc reports.
• Created new source control location in Git Hub and moved all the source code into that.
• Created new security principles for SSRS reports and Database.
• Migrated SSRS reports to Tableau by redesigning the report.

Environment: MS SQL Server, T-SQL, BI, Azure, MS SQL Integration Services, Tableau, Power BI, MS SQL reporting Services, SQL Server Management Studio, Oracle 11i, 12c.

ETL Lead

Confidential, Portland, OR

Responsibilities:

• Designed and Created databases, tables, views, stored procedures and triggers.
• Created groups, roles, users and assign access privileges to users.
• Optimized the performance of queries by removing unnecessary columns, eliminated redundant and inconsistent data.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Responsible for gathering business requirements to create business user reports.
• Developed optimal stored procedures and queries to create data sets for reports.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Performance tuning on existing stored procedures and reports for faster processing on large data sets.
• OLAP model based on Dimension and Fact tables for efficient loads of data based on Star and Snowflake schema structures on levels of reports.
• Highly involved in maintain data dictionary, data standards process
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Worked on Powe BI reports for visualization of growth.

Environment: MS SQL Server, T-SQL, MS SQL Integration Services, Tableau, Power BI, MS SQL reporting Services, SQL Server Management Studio, Oracle 11i, 12c.

ETL Lead Developer

Confidential, Salt Lake City, UT

Responsibilities:

• Involved in gathering, understanding and validating the project specifications.
• Created and maintained databases, tables, stored procedures, indexes, database check constraints, and business rules using T-SQL.
• Created SSIS packages to populate data from various data sources.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
• Created script task in SSIS using Visual studio.
• Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS).
• Involved in Performance Tuning and Query optimization of the Database as required by the application.
• Developed a Tabular Reports, ad-hoc reports using SSRS Report Designer.
• Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star and Snowflake Schema for generating reports using SSRS.
• Involved in migration of large amount of data from OLTP to OLAP by using ETL Packages.
• Tuned the existing the procedure by redesigning the logic for better performance and Created T-SQL scripts like Store Procedures, CTE, Functions, Indexes and other database objects.
• Implemented Package configurations for smooth transfer across the environment and used event handler, set points for troubleshooting.
• Created and modified the Crystal reports and SSRS reports and migrated the Crystal reports to SSRS reports by redesigning using Tables, Charts, grouping, expressions and created subscriptions.
• Expertise in Managed Services, Incident/Problem Management, Frequent Failure Analysis and Continuous Service Improvements
• Resolve user support queries, change requests by investigating various applications, database analysis and perform code change meeting the client requirements.
• Solved system issues through application logs analysis and file manipulations using UNIX.
• Analyze the data flow in the application and fix the data issues in production.
• Analyze and find out long running jobs to fine tune SQL queries to save critical SLA time.
• Interact with end-users while managing multiple tasks and responsibilities under pressure.
• Perform detailed root cause analysis, and worked with the cross-functional team on improvements and preventive actions.
• Actively participated in collaboration with the team to launch newly implementation changes on time.
• Manage critical 24*7 batch jobs and real-time production processes (L2 & L3 support).
• Translated business goals, concepts and customer needs into product requirements and use cases.
• Established criteria for each milestone within the project roadmap to measure developmental progress.
• Conduct feedback meetings with team after end of every phase to get inputs to identify scope of improvements for next phase.
• Conduct demos/trainings for clients at end of each development phase to keep track of progress of product
• Involved in technical aspect of standard including schema testing and end user standard awareness.
• Train and lead new teammates on daily activities and system investigation issues.

Environment: MS SQL Server, T-SQL, MS SQL Integration Services, MS SQL reporting Services, Microsoft Visual Studio, SQL Server Management Studio, Oracle 11i, 12c.

Confidential

ETL Developer

Responsibilities:

• Involved in Requirement analysis, worked with various vendors, users and business to evaluate the tools to fit the business requirements.
• Prepared functional and technical database design documents and process flow diagrams.
• Developed PL/SQL packages, procedures and functions based on business requirements.
• Backend database development in MS SQL Server, writing complex queries, stored procedures, views, triggers, cursors, UDFs.
• Responsible for database design, create schema objects like tables, views, stored procedures and indexes.
• Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Extensive use of Triggers to implement business logic and for auditing changes to critical tables in the database.
• Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts
• Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints in SSIS.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL.
• Experience in generating reports using linked reports, sub reports and filters in SSRS.
• Linked business processes to organizational objectives, performing critical path analysis.
• Involved in trouble shooting performance issues and bugs in packages.
• Migrated SQL objects like Functions, Stored procedures from Oracle to SQL server using TSQL.
• Worked on transactions, resolved Dead lock issues and used cursors to achieve business logic.
• Developed Shell scripts for scheduling or running the scripts for day-to-day transactions.
• Analyzed SQL statements, used cursor variables, reorganized database objects and indexes to improve application performance
• Implemented range partitioning for tables, materialized views and use of global temporary tables.
• Involved in preparing test cases and perform unit testing before handing it over to QA.
• Generated Reports as per the client requirements with multiple options like PDF, Excel.
• Reading the Excel-file as an input, perform validation checks and insert the formatted data into table without any data loss and truncation.
• Interaction with client and solving daily issues for the users of OFSS across world.
• Supported operations during the build/deployment of new release to QA, UAT and PROD.

Environment: MS SQL Server, T-SQL, Oracle 10g, 11g, PL/SQL, UNIX-HP-UX11IV3

ETL Developer

Confidential

Responsibilities:

• Gather requirements, develop, test, support and maintain all the database objects using Oracle PL/SQL.
• Coordinated with the front-end design team, provided necessary stored procedures, database packages and perform deep insight to the data.
• Worked on complex SQL, PL/SQL, stored procedures, functions and Dynamic SQL.
• Experience in Migration of Scripts, Packages, Enhancements for Production Releases.
• Involved in the continuous enhancements and fixing of production problems.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created indexes on the tables for faster retrieval of the data to enhance database/application.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Ensured that weekend data loads, end-of-month & end-of-quarter processing ran successfully and completely, transparent to user community.
• Created SSRS reports using Report Parameters, Drop-Down Parameters and Charts.
• Formatted Reports using Global Variables, Expressions and Functions for the reports.
• Design and develop SSIS packages, generated reports, fixing issues add exception handling, add Logging for the SSIS packages.
• Participated in code reviews, unit test plan reviews, and other quality reviews defined by the Software development lifecycle (SDLC).

Environment: Oracle 9i, 10g, Java, SQL, UNIX Shell Scripting, SQL Loader, SSIS, SSRS.