SUMMARY

• Around 8 years of experience as a SQL/Oracle Developer.
• Extensive Experience in using Microsoft BI Studio products like SSIS, SSAS,SSRS for implementation of ETL in data extraction, transformation and loading.
• Experience in using Oracle 12c, PL/SQL, Oracle Forms and reports 11g.
• Experience in SSMS, Oracle,1010 data, Power BI, Splunk, Dell Boomi.
• Experienced in whole cycle of DTS/SSIS packages (Developing, deploying, scheduling, troubleshooting and monitoring) for performing data transfers and ETL purposes across different servers.
• Using SSAS, analysis is performed on large amounts of data by using tabular model.
• Experience in using AWS Redshift to extract large amounts of data intoSSIS.
• Expert in database development using T - SQL by writing queries to perform operations in SQL Server 2014, 2016,2017 on large datasets.
• Involved in all phases of a migration project fromSQL Server 2014 to SQL Server 2016 and from SQL Server 2016 to SQL Server 2017.
• Used SQL Profiler for monitoring the performance of SQL Server.
• Expert in database development using PL/SQL queries in Oracle 12c on large datasets.
• Used UC4 job scheduler to schedule and monitor computer batch jobs by processing prepared job control scripts and statements.
• Used Toad database management toolset for managing relational and non-relational databases.
• Robust at building Macro language code for tabulations, cross tabulations, linking,mergingand sorting, in 1010data and developed blocks and libraries, conditional functions.
• Competent in performing various kinds of data transformations in 1010data and shrewdness in using G functions.
• Good understanding over design patterns, OOPS concepts.
• Proficient in building web applications using HTML, XML, Java Scripts.
• Experience in writing joins, normalization functions and sub queries for building complex queries to extract data involving multiple tables.
• Good knowledge on Excel VBA skills,MSAccess, C#,ASP.NET.
• Experience in creating packages in Visual Studio 2017.
• Experience in creating cloud-based integration processes like atoms using different logic shapes in Dell Boomi.
• Experience in creating data mappings using logic shapes that help in improving efficiency and accuracy for integrations in Dell Boomi.
• Recognized by the Client as a good team member with indomitable spirit, personal disposition and interpersonal skills.
• Possess ability to analyze ideas with pertinacious and strong fundamentals.
• Appreciated for the assimilation of new techniques and its utilization to enhance the work.

TECHNICAL SKILLS

Programming Languages: C, C++, JAVA, PL/SQL, Data Structures

Databases/RDBMS: Oracle, MySQL, SQL server, DB2,T-SQL.

Scripting Languages: HTML, CSS, JavaScript,Python

Operating Systems: Windows, Ubuntu, Linux, Unix

Tools: Tableau, Dell Boomi, Power BI, 1010 Data, Splunk,SSMS.

IDEs: Microsoft Visual Studio, Eclipse, Net Beans.

PROFESSIONAL EXPERIENCE

Confidential, TX

MSBI Developer

Responsibilities:

• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages with business rules and to load into data mart.
• Created SSIS packages which involved a variety of transformations such as Slowly Changing Dimension, look up, Aggregate, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join, and Data Conversion before loading the data into Data Warehouse.
• Created multiple SSIS packages and reports for delivering data to the end client through reports by emailing them directly the locations for the output files.
• Perform unit testing, integrated testing and handle deployment of SSIS packages.
• Experience in Data migration /data integration, data validation, data cleaning, and data mapping using SSIS.
• Experience in Importing data from AWS Redshift into SQL Server using SSIS.
• Follow proper Data warehousing concepts by creating the dataflow diagram within SSMS and use of surrogate keys for all the dimensions and use the same in the fact tables to improve join performance in the reporting layer.
• Experience in creating SQL Jobs and backup scripts, alerts, SQL Mail Agent, Database Mail, and Scheduled DTS and SSIS Packages based on Business or application needs.
• Designed, developed and deployed reports in MS SQL Server using Microsoft SQL Server Reporting Services (SSRS).
• Created Ad-hoc reports, data driven subscription reports by using report builder in SSRS.
• Developed single value and multi valued parameterized reports for Business users using Microsoft SQL Server Reporting Services (SSRS).
• Generated several interactivedrilldown reports and drill through reports using SSRS.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated fields with MDX code to meet additional measures that are calculated from existing measures.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Extract and analyze data from multiple databased to inform business decisions and action and create reports using MS Access and MS EXCEL.
• Strong knowledge of Data warehousing methodologies, concepts and implementation of star schemas, snowflake schemas, facts & dimensions.
• Designed and implemented T-SQL queries for reporting and complex solution development.
• Experienced in writing complex T-SQL queries, views, and stored procedures in a multi-database environment.
• Created both clustered and non-clustered indexes to improve performance of the data loads.
• Created views instead of exposing the static table to the tabular models.
• 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.
• Created notifications and alerts, subscriptions to reports in the Power BI service.
• Involved in creating user security, and roles in Power BI.
• Responsible for creating and changing the visualizations in Power BI reports and dashboards on client requests.
• Experience on publishing Power BI reports on dashboards in Power BI server.
• Experience in integrating Power BI app with Share Point.
• Create SQL Server agent jobs for automated Scheduling of the packages with dependencies.

Confidential

Oracle Database Developer

Responsibilities:

• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• UsedSQL*Loaderas an ETL tool to load data into the staging tables.
• Used SQL*Loader to load data from flat files obtained from various facilities every day into staging tables.
• Used standard packages likeUTL FILE, DMBS SQL, and PL/SQLCollections.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD. Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Developed and modified a number ofFormsand for various modules. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied.
• Developed and modifiedtriggers, packages, functionsandstored proceduresfor data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• WroteSQL, PL/SQL, SQL*Plusprograms required to retrieve data using cursors and exception handling.
• Worked onXMLalong with PL/SQL to develop and modify web forms.
• Performed SQL and PL/SQL tuning and application tuning using various tools like SQL*TRACE, AUTOTRACE.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage.
• Used UTL MAIL package to manage emails and to send emails to the clients.
• Created database objects like tables, views, materialized views, procedures and packages using oracle tools like TOAD, PL/SQL Developer and SQL*Plus.
• Partitioned the fact tables and materialized views to enhance the performance. Extensively used bulk collection in PL/SQL objects for improving the performance.
• Involved in scheduling and creating various UC4 jobs for running weekly and monthly.
• Participate in business and project meetings to get the business requirements.
• Perform unit testing, integrated testing and handle deployments.
• Track issues and risks and communicate status reports to clients on a periodic interval.

Confidential

Junior SQL Developer

Responsibilities:

• Created databases, tables, and store procedures using DDL & DML commands.
• Extract, transform, Load source data into respective target tables to build required data marts.
• Performed SQL query performance tuning by creating/modifying indexes and changing query structures using CTEs, Case statements.
• Created package using SSIS data flow such as derived column, data conversion, look up.
• Created reports in MS Excel and generated Pivot tables.
• UsedSSISto create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.
• Experienced to build an XML 1010 Macro Language code that creates a simple report on files loaded and the data accuracy in these loaded files.
• These Macro language codes are used for tabulations, cross tabulations, sorting, linking, and merging.
• Experienced in performing data transformations in 1010data using Quick queries, computations, tabulation, linking, cross tabulation, 1010data Macro language programming, data cloning.
• Expert in creatingG functions which are used to break a column in 1010data into different groups to perform operations like data summaries and aggregations.
• Experienced/Expert at data visualization and advance calculations using Power BI.
• Expert knowledge connecting OnPrem Power BI to various data sources
• Expert creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc.
• Creating multiple processes and mappings using logic shapes in Dell Boomi.
• Also transforming data from one tool to other using dell boomi.
• Experience in capturing, indexing and correlating data from a searchable repository and generating insightful graphs in Splunk.
• Experience in mapping knowledge to search, scheduling alerts, creating reports and visualizations using Splunk.