SUMMARY

• Proficient in developing SQL Server objects such as stored procedures, user - defined functions, views, tables, and table variables to meet business requirements.
• Excellent in SQL Server error handling methods that tackles errors at their appearance to increase the accuracy, integrity and efficiency of the system.
• Experience in Tableau, and ETL (extracting, transforming, and loading) process using SQL Server, Data Analytics and SSIS (SQL Server Integration Services).

TECHNICAL SKILLS

Database: SQL Server 2017, Oracle Database 11g, MySQL 5.6

Business Intelligence Tools-: SSIS, SSRS, SQL Server Management Studio 2017, Tableau 2020.2, Visual Studio 2017, etc.

Programming Languages: T-SQL, P/L SQL, PostgreSQL, MySQL

Big Data tools: Hadoop.

Cloud Services: AWS

Data Analysis Tools: SPSS,SAS Enterprise.

Project Management Tools: JIRA/ Agile

Script: HTML,XML,JSON,YAML

IDE & Text Editor: Notepad ++

Planning Tools: ATOLL, Info Vista Xeus Express 5, MapInfo, Tems Discovery, Actix.

Optimization Tools: Moshell, ErissonBussiness Object, InfoVistaXeus Express 5, FACTS, Actix, Winfiol, Citrix, SecureCRT 6.7, Nexplorer, MCOM

Operation System: Linux, Windows

PROFESSIONAL EXPERIENCE

Confidential, Newark, DE

ETL Developer / Data Analyst

Responsibilities:

• Developing logical and physical data flow models for ETL applications.
• Translating data access, transformation, and movement requirements into functional requirements and mapping designs.
• Leading the design of the logical data model and implements the physical database structure and constructs and implements operational data stores and data marts.
• Creating and enhancing data solutions enabling seamless delivery of data, collecting, parsing, managing and analyzing large sets of data.
• Analyzing performance, tuned and optimized, supported database objects to migrate to production level, executed stored procedures, index sizing.
• Debugging processes, triggers, views, monitored the system and SQL server job schedule and recorded any errors.
• Data architecture, designing and creation of MS SQL tables, views, triggers and other objects required for web statistics & analysis.
• Creating and troubleshooting stored procedures and queries performances using SQL Server Profiler, Performance Monitor and DBCC Commands.
• Assessing tests and implementing new or upgraded software and assisting with strategic decisions on new systems.
• Providing technical expertise on data storage structures, data mining, and data cleansing.
• Providing quality assurance of imported data, working with quality assurance analyst if necessary.
• Conceiving, designing, and developing SSIS solution to compare databases to data model
• Migrating databases from Oracle and Access to SQL Server to preserve historical data.
• Collaborating with team members to transition and optimize legacy software from Oracle to SQL Server.
• Configured SQL jobs and maintenance plans to ensure database stability and integrity.
• Conducting preliminary testing of the warehousing environment before data is extracted.

Environment: Oracle, SQL Server, SSIS, SSRS, Tableau, ETL, Data WarehousingXML, ODS, DM, ADAPT Platform, RHEL 4 -5 workstations.

Confidential

ETL Developer/Data Analyst

Responsibilities:

• Designing tools & processes to move from a system of querying data from log files to aggregated data stored in persistent tables. Scheduled loading of persistent tables on hourly basis.
• Conducting meetings with stakeholders throughout development to gather system requirements from users and ensuring user acceptance testing was performed.
• Migrating databases from Oracle and Access to SQL Server to preserve historical data.
• Collaborating with team members to transition and optimize legacy software from Oracle to SQL Server.
• Configured SQL jobs and maintenance plans to ensure database stability and integrity.
• Designing and implementing complex SSIS package to migrate data from multiple data sources.
• Creating SSIS package to extract, validate and load data into Data warehouse.
• Extensively worked on creating SSIS packages and have used for each Loop containers, Sequence Container for developing processes and loaded data using different transformations such as Derived Columns, Condition Split, Aggregate, Merge Join and Union all.
• CreatingStored procedure, Views, Cursors and functions to support application.
• Developing reports in SSRS and QlikView for executives and managers.
• Designing and creating the data warehouse and all related extraction, transformation and loading of data functions in the company.
• Testing designs to ensure the system runs smoothly after installation.
• Designing and coding the data warehousing system to desired company specifications.
• Conducting preliminary testing of the warehousing environment before data is extracted.

Environment: Oracle, SQL Server, SSIS, SSRS, QlikView, ETL, Data Warehousing,Java, XML,ODS, DM.

Confidential

SQL/ETL Developer/Data Analyst

Responsibilities:

• Managing and designing the reporting environment, including data sources, security, and metadata.
• Supporting the data warehouse in identifying and revising reporting requirements.
• Providing technical expertise on data storage structures, data mining, and data cleansing.
• Troubleshooting the reporting database environment and reports.
• Evaluating changes and updates to source production systems.
• Assessing tests and implementing new or upgraded software and assisting with strategic decisions on new systems.
• Developing, implementing and optimizing stored procedures and functions using T-SQL.
• Developing procedures and scripts for data migration.
• Analyzing existing SQL queries for performance improvements.
• Developing SSRS reports and configure SSRS subscriptions per specifications provided by internal and external clients.
• Maintaining existing Crystal Reports against legacy system and rewriting these reports in SSRS against new data warehouse.
• Gathering business requirements and converting it into SQL stored procedures for database specific projects.
• Coding and testing SQL queries based on the persistent table using Inline Views, Dynamic Sql, Merge statements. Built and monitored indexes to bring down processing times from minutes to seconds.

Environment: HTML, Linux, JavaScript, T-SQL, Excel, SPSS, SAS, ETL frameworks, SQL, SSRS, SSIS, SSAS,