SUMMARY:

• 6+ years of work experience across multiple industry technology and domains including Business & Data Analysis, Database Development and Business Intelligence Development.
• Experienced in Oracle - SQL, PL/SQL Packages, Stored Procedures, Functions, Packages, Cursors, Triggers, Views, Materialize Views.
• Worked on SQL Server Management Studio SSMS, Integration services SSIS, Analysis services SSAS and Reporting services SSRS in analyzing data and deploying business reports.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Experience in performing system/data analysis and reporting using BI reporting tools (Tableau, Power BI & Business Objects).
• Experience in all stages of SDLC including knowledge transition, requirements gathering, designing & documenting architecture, application development, testing, implementation and post-implementation support.
• Skillful in Data Analysis using SQL on Oracle, MS SQL Server, Netezza & Teradata.
• Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, PL/SQL table, Cursors, Nested tables, V arrays, Records, Types.
• Experienced in PL/SQL Performance Tuning using Bulk Collections and other optimization techniques
• Proficient in Ref cursor, Cursor, collection Records, bulk collect, Bulk binding, stored procedure, user defined function, Packages and Exception handling.
• Extensive knowledge on Tableau Server, Tableau Reader, Tableau Public - ability to create dashboard reports, aggregate data, slice and dice data, perform data connectivity to external sources for analysis, create data options, data interpretation techniques and pivot data to meet reports specifications. Worked on SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service & Report Server.
• Excellent experience in trouble shooting SQL queries, ETL jobs, data warehouse/data mart/datastore models.
• Experience in UNIX shell scripting includes file monitoring scripts, data manipulation scripts and data load scripts.
• Good understanding of Star and Snowflake Schema, Dimensional Modeling and Slowly Changing Dimensions.
• Hands on experience in optimizing databases by creating appropriate indexes on Tables.
• Monitoring databases and tuning SQL Server performance with performance monitor, SQL Profiler and Index Tuning for better performance.
• Ability to extract information accurately and interpret it, work on own initiative and organize and prioritize own work.
• Responsible for Gathering requirements and Coordinating with Offshore team, creating Model, creating different types of reports, performance tuning and trouble-shooting of reports, scheduling the reports, and Creating project supporting documents.
• Excellent team player with problem-solving and trouble-shooting capabilities.

TECHNICAL SKILLS:

Operating Systems: UNIX, LINUX, Windows, MS-DOS

Programming Language: C, SQL, PL/SQL, MySQL, JAVA, C#, Python

Databases: SQL Server 05/08/12/14/16, Oracle 12c/11g/10c, Netezza, Teradata

Reporting Tools: SQL Server Reporting Service, Tableau, ThoughtSpot & Power BI

Web Technologies: HTML5, XML, Java Script, VB Script, Web Services

Confidential Tool: SSIS, SSAS, SSRS, Excel (Pivot tables, V-lookup), Word, Access, MS-Project, MS VISIO

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Data Analyst

Responsibilities:

• Strong experience in data mining tools used in creating and analyzing complex data and SQL queries such as T-SQL, PL-SQL, Tableau and excel statistical modelling techniques.
• Determined business objectives, assessed the decision situation and determined data analytic goals as part of the data analytics project.
• Experienced in Extracting, analyzing data and presenting data in graphical format that helped managers to make business decisions.
• Created complex plsql scripts using cursors, xml extract to get desired output and load the data into ThoughtSpot.
• Proficiently developed new Packages, Functions, and Stored Procedures using PL/SQL as well as modified the existing ones as per the user requirement.
• Involved in periodic Performance Tuning and Unit Testing of the PL/SQL code by using appropriate joins, indexes, and partitions
• Wrote (Back-end) PL/SQL code to implement business rules through triggers, cursors, procedures, functions, and packages using SQL*Plus Editor or TOAD
• Migrated data from Flat Files to Oracle database using SQL*Loader.
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL
• Developed complex PLSQL queries for data retrieval from various database objects including tables and views.
• Created answers, pin boards, various dashboards and wrote TQL scripts to create tables in ThoughtSpot.
• Assisted ETL team for transformation rules documentation for data migration for OLTP to warehouse for reporting.
• Analyze business requirements and Design, Develop ETL processes to load data from various sources like Flat files, XML files, Oracle Database.
• Used Tableau desktop as a decision-making tool for identifying the appropriate business model to initiate a customer risk analysis project, the flow of the project monitored through Gantt charts made using Tableau and MS project schedule.
• Created visually impactful dashboards in Excel and Tableau for data reporting with respect to customer, policy information and analyzed to identify the key metrics.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and excel.
• Worked on shell scripting to load data automatically using Autosys.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting data from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Implemented various UNIX scripts to generate the data in CSV and txt format
• Extensive documentation of the source and target tables and the description of the objects in the Excel document and developed Excel Report using the procedural code.

Environment: SQL Server 2014/2016, Oracle, Netezza, XML, ThoughtSpot, Tableau (Desktop/Server), JIRA, UNIX, Autosys, SharePoint, SQL*Loader, Power BI, TOAD .

Confidential, Seattle, WA

MSBI Developer

Responsibilities:

• Developed SSIS, SSRS / T-SQL Code and scheduled jobs for Jobs Monitoring Automation.
• Gathered, organized and validated data to answer business questions as need by the management.
• Defined report layouts for formatting the report design as per the needs. Written Complex Stored Procedure for the reports using T-SQL and dynamic SQL.
• Scheduled the reports to run automatically and send the reports in different formats via email or upload the reports to shared folder or a SharePoint website
• Identified slow running query and optimization of stored procedures to tweak the performance.
• Involved in day-to- day maintenance and solved any issues related to reports.
• Created different visualization in Power BI per the requirements.
• Created calculated measures in tabular model using DAX Queries according to end user requests and reporting needs.
• Expertise in publishing Power Bi reports of dashboards in Power BI server and scheduling the dataset to refresh for live data in Power BI server
• Worked extensively on creating Relationships, Measures, and Calculated Columns in the Power BI.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Managed relationship between Power BI using Schemas such as Star & Snowflake.
• Created calculated columns and measure in Power BI and Excel depending on the requirement using DAX expressions.
• Responsible for deploying the SSIS packages and scheduling the package through jobs in all tiers Including dev, test and production.
• Experience in managing and automating Control flow, Data flow and Events using Confidential .NET framework for SSIS packages.
• Created classes/modules in C# using Visual Studio.Net.
• Worked on Type 1 and Type 2 packages for incremental to load data from source to DataMart.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables and views.
• Performed tuning of tables using normalization and by creating indexes.
• Used Confidential Azure as the back-end for rendering reports and dashboard for the Pow er BI
• Managed day-to- day operations of the database systems activities and worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS.
• Developed Data Source, Data Source View to create a logical view of the data to be placed in OLAP Cubes using SQL Server Analysis Services (SSAS).
• Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries.
• Code Reviews, customization and maintenance of code across applications using TFS
• Designed and developed STAR schema and multidimensional (OLAP) objects. Created cubes and populated the data using SSIS 2014 packages.
• Worked with scheduling and publishing of reports in SQL server reporting services and integration with Confidential Office tools like automatically emailing reports in various formats such as Excel, PDF etc.
• Responsible for release of code into QA and production.

Environment: SQL Server 2012/2014/2016, SSIS, SSRS, C#.Net, Excel, Power Pivot, Power BI Desktop, Power BI Web, TOAD, TFS, VB.Net, C#.Net, Visual Studio 2010/2013, AZURE Database, SharePoint, XML, HTML.

Confidential, New York City

Data Analyst

Responsibilities:

• Perform data profiling in the source systems that are required for financing.
• Strong experience in data mining tools used in creating and analyzing complex data and SQL queries such as T-SQL, Access, Tableau and excel statistical modelling techniques
• Execute analytics projects that involve data collection, filter and clean data to interpret and analyze data to provide reports for a broad array of issues across discipline and functional areas
• Developed many complex PL/SQL programs and modified the existing PL/SQL program units.
• Developed scripts using UNIX commands to perform complex file processing.
• Involved in writing complex SQL Queries to implement the business requirements.
• Created standalone procedures using Dynamic SQL and cursors to migrate data within the same database
• Performed unit test on the developed code to ensure that its bug free.
• Leverage Change Control processes for all SQL Server changes made in Production environment
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Document data quality and traceability documents for each source interface
• Strong experience in mentoring team members and writing documentation.
• Designed the Data warehouse and data Marts with Facts and dimensions.
• Performed database cloning and refreshes from production to UAT/DEV environment
• Rebuilding / monitoring the indexes at regular intervals for better performance.
• Experience in ORACLE XML DB. Extensively used Oracle XML DB to generate XML files and parse the XML Files and validate the XML Files using XML Schema Definition (XSD)
• Involved in Sql scripts Macros, stored procedures in Teradata to implement business rules.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Complex dashboards and used advance chart visualizations in Tableau like Dual Water Fall charts, Axis, Bullet Graphs, Bubble Charts, etc. to assist business users in solving complex problems. Built Complex Reports using advanced reporting functions like with YTD calculations, MTD calculations, percentage differences, sets and groups etc. in Tableau.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Enhancing and deploying the SSIS packages from development server to production server.
• Created XML configuration files to dynamically alter package properties.
• Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
• Wrote customized Python scripts for automation, data parsing, database operations, data extraction, text manipulation, files parsing and reports generation.
• Remain knowledgeable in all areas of business operations to identify systems needs and requirements.
• Creating connections and data extracts for different tableau applications with different database sources including Oracle, Db2, MySQL, SQL server etc.
• Responsible for developing PL/SQL Functions, Procedures, Packages, Cursors and Triggers
• Analyze the database using TKPROF, EXPLAIN PLAN, and SQL TRACE for performance issues
• Involved in Unit testing, QA and User Acceptance testing.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA).

Environment: SQL Server 2012, T-SQL, MySQL, PL/SQL, SSIS, TOAD, Oracle 10g, Excel, C#, MS Access, Visual Studio, Query Analyzer, Teradata, SQL Server Profiler, Actuate, JIRA, Tableau 9.0, Python, XML, Tableau Server.

Confidential, Oaks, PA

Data Analyst

Responsibilities:

• Written the design documents for the reports.
• Coordinated with the business to make sure that there is not much change during the migration of the reports.
• Assessed the pros and cons of migration and conveyed the same to the Business Analyst.
• Written stored procedures for those reports which use multiple data sources.
• Implement PL/SQL jobs as per the client requirements.
• Worked on creating package to add partitions on a transaction table and scheduled it through dbms scheduler.
• Developed Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
• Designed the Data warehouse and data Marts with Facts and dimensions.
• Reviewed and corrected PL/SQL codes.
• Experience working in agile environment and supported iterative testing methodology.
• Normalizations of the new tables wherever required.
• Created and scheduled SQL server agent jobs and alerts, scheduled reports for daily, weekly, monthly.
• Built SSIS Packages which pull the data needed for reports.
• Scheduled and maintained various daily, weekly and monthly ETL packages and jobs through SQL Server Agent in SSMS
• Built Tabular model cubes using SSAS involving dimensions and fact tables
• Used SQL Developer for creating all types of PL/SQL objects like tables, Indexes, packages, triggers, sequences and stored procedures.
• Experience with stored procedure driven reports, building custom application on reports, formula writing/editing in reports and performance tuning of reports.
• Scheduled the reports to run automatically.
• Strong Experience in conducting User Acceptance Testing (UAT), Unit Testing and documenting Test Cases and Test Scripts.

Environment: SQL Server, SQL Server Profiler, Toad, SQL*Loader, SSIS, SSRS, SSAS, Java Script, My SQL, HP ALM, Oracle 10g, PL/SQL, Actuate, SQR.

Confidential

SQL BI Developer

Responsibilities:

• Maintenance of the various database objects, tables/views/stored procedures in SQL Server 2005.
• Prepared development documents, and testing documents and architectural documents.
• Designed and developed complex SSRS reports.
• Used the maintenance Plan for SQL Server databases to recreate indexes and statistics for the performance.
• Effectively worked on Facts, Dimensions, and Cubes and wrote MDX queries using MS Analysis Services (SSAS).
• Experience with Dimensional modeling including star/snowflakes schemas and OLAP data architectures.
• Responsible for designing, developing and implementing SSIS packages for ETL processes
• Developed ETL Package in SSIS for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Built several reports with high complexity.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Troubleshooting ODBC and OLEDB connection issues in SSIS packages after Upgrading packages.

Environment: MS SQL Server 2005/2008, Reporting service (SSRS), Integration Services (SSIS), Analysis Services (SSAS), T-SQL, Windows 2007, SQL Profiler, MS Excel