SUMMARY

• Sound experience in Analysis, Design, Development and Data processing using SQL Server and BI stack.
• Extensively worked on Power BI, PL/SQL - Functions, Stored Procedures, Cursors, Triggers and SSIS Packages.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Tk-Prof and Table Partitioning.
• Proficient in advance features of PL/SQL programming like Records and Collections, Bulk load, Bind variables, Ref Cursors and Dynamic SQL.
• Good Knowledge on Client-Server application development using Oracle PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer.
• Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS and T-SQL Programming using DDL, DML, DCL commands for various business applications.
• Experience with Power BI as an Development, administration including providing installation, configuration, maintenance, scheduling, performance tuning and upgrade.
• Experienced in Creating DAX Expressions, create Date to yearly columns and implement partitions in Tabular Models for power BI.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards per the client Requirements.
• Experience on building SSAS cubes both Tabular cube and Multidimensional cube designs and created various reports and dashboards using Power BI.
• Experience in creating visualizations using Power BI and proficient in various chart types like, Bar, Line, Tree maps, Matrix and KPI's on graphs.
• Experience in designing, modeling, performance tuning and analysis, implementing process using ETL tool Pentaho data Integration tool for data extraction, transformation and loading process.
• Good experience in UNIX and Perl scripts to create reports and logs based on the business prerequisites.
• Worked in Agile Methodology.
• Worked on version control tools such as GitHub, ALM and used JIRA bug tracking tool.
• Experience in Azure Data Warehouse (ADW/Azure Synapse Analytics) using Azure data factory (ADF).
• Migrated Azure Data Lake (ADLS) from V1 to V2.
• Experienced in Production Support Role 24/7 to resolve the issues using in a ticketing system.
• Collaborate well with Project Management, Business Analyst and Department management teams.
• Worked extensively to deploy the UNIX and Perl code in Linux environment.
• Understanding the PL/ SQL code for issues in the database and advice the development team with logs.
• Experience in using UNIX Shell Scripting to automate the processes.
• Proficient with Data Modelling concepts like ER Diagram, UML, Use Cases, Data Normalization and De-normalization as of when required.
• Production support and involved in implementation of coding standards and Data Base change requests.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g/12c, DB2 and MS Access

Programming Languages: SQL, PL/SQL, Unix shell scripts, SAS, C/C++/C#, Perl, XML, HTML, VB.NET

ETL Tools: SSIS, Informatica

Data Warehousing: Star & Snow-Flake Schema Modeling, Erwin, Sybase Power Developer, SSAS, SSRS, OWB, ODI

Tools: TOAD, SQL*PLUS, SQL Developer, SQL*Loader, Power BI, Tableau, Work Flow Builder, Visual Studio code, Winscp.

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Sr. Power BI Developer

Responsibilities:

• Involved in various phases of Software Development Life Cycle (SDLC) such as requirements gathering, modeling, analysis, design, development and testing.
• Involved in development, maintenance of Triggers, Joins, Cursors and Views.
• Responsible for Maintaining, Monitoring Datasets, Performance tuning for reports/dashboards and control capacities in Power BI & Tableau Service Experience on publishing reports and dashboards in server.
• Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc.
• Developed procedures, functions and packages to implements the system's business logic using PL/SQL.
• Designed and developed Extraction, Transformation and Loading (ETL) processes using SSIS.
• Automating: used SQL server agent, created jobs, and orchestrated the jobs to run on a scheduled basis for automating batch processes.
• Created triggers on Azure Data Factory pipelined to run them on timed schedules.
• Fix open ticket as created by users that includes code modification and issue data analysis.
• Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming for generating worksheets.
• Providing support at customer site by solving bugs/problems and providing requested business information by building queries and/or extracting required data.
• Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools likeToad, PL/SQL DeveloperandSQL* plus.
• Used Hibernate as persistence Layer - using the SQL Server Database and configuration data to provide persistence services (and persistent objects) to the application.
• Used SQL BATCH jobs for the daily monitoring jobs run over night.
• Wrote SQL Queries to interact with SQL Server Database.
• Involved in designing, building the dimensions, cubes with star schema and snowflake using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Implemented slowly changing dimensions (SCD) type-1, Type-2 & Type 3 in the data warehouse design.
• Worked on issue tracking tool JIRA.
• Hands on experience in building tools like ANT, Maven, Gradle
• Used GIT for Source Control and Version Management of all codes and resources.
• Involved extensively in Code Reviews, Unit testing and Process Improvements.
• Involved in Daily SCRUM meetings and weekly SPRINT Meetings.
• Interacted with Product Managers to fine tune user stories and with testing team to approve Functional Specification and test cases.

Environment: Power BI, SSIS, SSRS, SSAS, ETL, Visual Studio, Oracle 11g, SQL * Plus, TOAD, SQL Developer, UNIX Shell Scripting, Windows X.

Confidential, Houston, TX

MSBI/ POWER BI Developer

Responsibilities:

• DevelopedPowerBImodel used for financial reporting of P & L and Headcount.
• Designed and documented the entire Architecture of Power BI POC
• Expertise in writing complex DAX functions inPower BI and Power Pivot.
• AutomatedPowerQuery refresh usingpowershell script and windows task scheduler.
• Used various sources to pull data intoPower BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
• Weekly presentation to the business users about the reports and their changes as required.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Worked on all types of transformations that are available in Power bi query editor
• Created stored procedures and SQL queries to pull data intopowerpivot model.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Database creation(DDL, DML, DCL), database tuning, SQL tuning, performance planning.
• Extensively usedJoins and Sub-Queriesto simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report usingPivot/Un pivotinT-SQL.
• Transformed complex business logic into Database design and maintaining it by using SQL objects likeStored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Creating and Modifying Tables,Stored Procedures, Views,Indexes, User-defined Functions, andTriggersas required.
• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration usingSSRS.
• Created Datasets in T-SQL, stored procedures for SSRS.
• Developed Excel Power View, Power Query and PowerPivot dashboards for data analysis
• Developed confidential proprietary analytical tools and reports with Confidential Excel, and Power Pivot and Power Point.
• Performed Index analysis for tables and came up with more efficient solutions to useClusteredandNon-Clustered Indexesfor significant performance boost using index tuning wizard.
• CreatedSSISpackages to import data fromAccess,Excel, XML, OLE DB Source and Flat Files.
• Filtered bad data usingDerived column, Lookups, Fuzzy Lookups,Conditional split.
• DesignedSSISpackages to import and transform data between databases and external data sources using various transformations likeData conversion,File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task.
• Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications.
• Debugging SSIS packages, Performance tuning onslowly running SSIS Packages.
• Configure and maintain usingReport ManagerandReport ServerforSSRS,DeployedandScheduledthe Reports inReport Manager
• Created Reports usingCharts,Gauges,Tables,and matrix.
• CreatedParameterized Report,Dashboard Report,Linked reportandSub Report by Year, Quarter, Month, and Week.
• CreatedDrill Down Reports, Drill Through Reportby Region.

Environment: Power BI,SQL Server 2012, SSMS, SSIS, SSRS, SSAS, T-SQL, Tableau, Power BI, Windows 7, MS Word, MS Excel, C#, Visio, Share Point Jira, SQL Profiler.

Confidential, Hartford, CT

SQL/ETL Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, and testing.
• Wrote packages, stored procedures for storing the client information and modifying the views to resolve any possible bugs.
• Created database objects such as tables, views, synonyms, indexes and sequences.
• Created views based on multiple tables and performed data changes using Instead of triggers for the underlying tables.
• Setup run time environment, creating and maintaining shell scripts to run stored procedures, packages to populate the valid data in staging tables and invalid data into error tables which will be sent back to sender notifying the errors.
• Constructed the required data involving complex JOIN statements, including outer-joins, intersect and union all.
• Worked with Collections and improved the performance of multi-row queries by using Bulk Collect and Bulk binds.
• Worked on SSIS Package, DTS Import/Export for transferring data from database to other.
• Implemented SQL standards in writing stored procedures, Triggers, Views and SQL functions.
• Experience with Data Cleansing in SSIS using the Derived column and Fuzzy Lookup transformations.
• Wrote SQL, PL/SQL programs to retrieve data from data repository using cursors and exceptional handling.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Created PL/SQL Procedures, Functions, Triggers and Packages to meet the business requirement of the project.
• Avoided mutating table errors using the new functionality in Oracle 11g i.e., Compound triggers.
• Used Global Temporary tables to access the repeated data within a session and improved the performance.
• Used SQL loader for importing the flat files which consists of several records of customer's information into the different tables in the database.
• Performed Unit testing using the PL/SQL code.

Environment: SQL Server 2012, T-SQL, SSIS, SSRS, ETL, Oracle 11g, SQL, PL/SQL, EXPLAIN PLAN, SQL developer, UNIX.

Confidential

SQL/ETL Developer

Responsibilities:

• Created logical models using Erwin; generated and maintained databases schemas.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Extract Transform Load (ETL) development using SQL Server 2008 Integration Services (SSIS).
• Created complex SSIS packages using proper control and data flow elements with error handling.
• Installation and configuration of SQL Server 2008.
• Involved in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2008.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Created Drill-down, Drill-through and Sub-Report using RDL and deployed RDLs to Reporting Service Server.
• Developed the chart type, Tablix, matrix reports in SSRS (SQL Server Reporting Services) like enrollment status, Financial Aid, Degree Objective from the OLAP system.
• Created reports with different features like drill through capabilities jump to another report, use of pie charts and bar charts.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Involved in modifying report content and exporting reports in multiple formats based on the business requirements.
• Designed and implemented Parameterized and cascading reports using SSRS 2008.
• Developed data model based on the BA's and the reporting Team using SSAS, SSRS.
• Created derived columns on the production fact and dimension tables as per the business requirements.
• Played a major role in production support of SSAS (cube designing) and debugging SSIS jobs.

Environment: SQL Server 2012/2008, SSMS, SSIS, SSRS, SSAS, T-SQL, Windows 7, MS Word, MS Excel, C#, Visio, Visual Studio.