SUMMARY:

• Big Data Hadoop & Spark Certified - Data Analyst with 10+ years of experience in Business Intelligence involving Requirement Analysis, Design, Development, Maintenance, Enhancement, and Support. Extensive experience in the Enterprise SQL Server, .NET, SSIS (ETL tool), Tableau and OpenSpan/Pega Robotics (Robotic Process Automation Tool).
• Significant experience in Microsoft SQL Server, PL/SQL SSRS, SSIS, T-SQL, SQL Server jobs, Tableau, Python scripting, WinSCP scripts, SFTP, GPG Encryption
• Developed/Maintained SSIS packages that connect to Hadoop database (HBASE) and pull data. Access to HBASE (Hadoop database) and running HiveQL/Spark SQL queries for data validation
• Gather requirements and develop various SQL jobs, SSIS packages, SFTP tasks, scripts which involved extensive data analysis and understanding of data warehouse and ETL processes. This project was run on agile sprint process of 2 weeks per sprint using JIRA ticketing tool.
• Written HiveQL/Spark SQL queries to pull data from HBASE (Hadoop database)
• Developed SSIS/ETL packages for pulling data from different source systems like Salesforce, Oracle, Teradata, flat files into SQL Server database
• Good knowledge of Splunk, Tableau, Big Data, Hadoop, Pig, Hive, HDFS, HBase, Spark SQL, Load Runner and C#
• Python scripting to fetch data from JIRA ticketing system into SQL tables. Data Quality process implemented in SQL jobs to ensure data is tested before reports are generated.

TECHNICAL SKILLS:

Languages: .Net 2.0 Technologies (C#, ASP.Net, VB.Net)

Frameworks: Microsoft CCF, OpenSpan/Pega Platform

Databases: Microsoft SQL Server 2005/2008, HBASE

Scheduling Tools: SQL Job Monitor, Autosys

Tools: Data Warehouse - ETL tool - SSIS

Reporting tool: SSRS, Tableau

Big Data: Hadoop HDFS, HBASE HIVE, HUE, SparkSQL

OpenSpan: (Automation Tool)

Operating Systems: Windows XP/2000, Windows Server 2008

Version Control Tools: VSS, Clearcase, TFS

PROFESSIONAL EXPERIENCE:

Confidential, Greater Philadelphia Area PA

BI /SQL/ Tableau Developer

Responsibilities: -

• BDI (Business Data Intelligence) team is the application team for Business Services. As part of this project I had to design, develop and maintain data warehouse to support reporting, analytics, building data models, data discovery and analysis.
• Had to gather requirements and develop various SQL jobs, SSIS packages, SFTP tasks, scripts which involved extensive data analysis and understanding of data warehouse and ETL processes. This project was run on agile sprint process of 2 weeks per sprint using JIRA ticketing tool.
• Understand business requirements and provide workable technical solution through Agile/Scrum steps after testing and user acceptance.
• Developing/Maintaining SSIS packages that connect to Hadoop database (HBASE) and pull data.
• Access to HBASE (Hadoop database) and running HiveQL/Spark SQL queries for data validation
• Using Microsoft BI Tools like SSIS, SSRS for data ingestion, validation and reporting using SQL jobs.
• Using Tableau for data visualization for users to understand the dataset better.
• Creating stored procedures in SQL Server 2016 for catering to new reporting solutions
• Experienced in Developing PL/SQL - Procedures, Functions, SQL Scripts and Database Triggers to populate the data applying business logic.
• Extensive knowledge in developing PL/SQL codes using Oracle 11g
• Troubleshooting and fixing failed SQL jobs
• Maintaining/Developing SSRS/Tableau/OBIEE reports
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information
• Developing SSIS/ETL packages for pulling data from different source systems like Salesforce, Oracle, Teradata, flat files into SQL Server database
• Creating batch scripts for download/upload files on SFTP server.
• Encrypting files before FTP push using SSH keys
• Create Tableau scorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality
• Sending out automated emails from SQL server for proactive monitoring
• Python scripting to fetch data from JIRA ticketing system into SQL tables
• Data Quality process implemented in SQL jobs to ensure data is tested before reports are generated.
• DQ checks were performed before reports are sent out every day using SQL procedures
• Interacting with business users to understand new reporting needs
• Writing HiveQL/Spark SQL queries to pull data from HBASE (Hadoop database)
• Using JIRA on daily basis to track defects and fixes.
• SharePoint used for project documentation and data dictionary.
• Software/Web: Microsoft Business Intelligence Development Studio (BIDS)

Database/Tools: Microsoft SQL Server 2016, SSIS (SQL Server Integration Services), Tableau Reporting Tool, UNIX Batch scripts, WinSCP (SFTP tool), GPG Encryption, HBASE/HIVE

Environment: SQL Server 2012, 2016, SQL Server Data tools (SSIS), AZURE, PL/SQL, Power BI, Tableau

Confidential

Developer/Analyst

Responsibilities: -

• Robotics Process Automation Developer
• Automating complex manual workflows for customer care representatives and improving day-to-day response time by saving manual effort and time.
• This was a working example of how to improve business efficiency by making data driven decisions without manual intervention.
• Creating Openspan automations.
• Interrogating controls on web application and automating the process to create a Word-Order.
• Creating automated workflows for complex business logic without manual intervention.
• Implement action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau
• Creating videos for client demo with manual and automation workflow demonstrating time saved.
• Troubleshooting and fixing failed automations.
• Automating manual file downloads and capture out of range data values to create report in another application.
• Software/Web: Pega Robotics 8.0 (formerly known as Openspan)

Database/Tools: RPA tools - Openspan/Pega

Confidential

Data Developer/Analyst

Responsibilities:

• Level 1, Level 2, Level 3 application support
• Incident/Change/Problem Management using ServiceNow
• Server health maintenance
• Developing SSIS packages, SQL jobs
• Scheduling jobs using AUTOSYS
• Troubleshooting and fixing failed jobs
• Analysing database growth using SPLUNK
• Create run-books for database or server changes
• Capacity planning of existing resources
• Server monitoring for different teams using GENEOS
• Using JIRA for defect tracking and Confluence, SharePoint for project documentation
• Created efficient stored procedures, triggers, user defined functions, tables, views, and other T-SQL join techniques for applications and improvement of database performance.
• Software/Web: ASP.Net Web services, Unix, BIDS

Database/Tools: Microsoft SQL Server 2008, SSIS (SQL Server Integration Services), Symantec VIP (Two Factor Authentication Service), Autosys (SQL Job Scheduling), ServiceNow(ServiceManagement), Splunk (Data Analysis)

Confidential

Data Analyst/Developer

Responsibilities:

• Travel Marker data from different feed files received from third party vendor was loaded into SQL tables using UNIX batch scripts.
• Created SSIS packages to fetch data from feed files and loading into SQL database
• Created SQL jobs to schedule packages
• Created UNIX batch scripts to read data from files
• Software/Web: Microsoft Business Intelligence Development Studio (BIDS)

Database/Tools: SQL Server 2005, SSIS (SQL Server Integration Services), UNIX Batch scripts

Environment: SQL Server 2012,2014 Data tools (SSIS,SSRS), .Net

Confidential

Data Analyst/Developer

Responsibilities:

• CLMS takes care of the ETL activities using Microsoft SSIS packages. Data is fetched into BI operational database from applications in different platforms
• Designing SSIS packages to pull data from FTP server via flat files and store in BI database after applying data transformations.
• Creating stored procedures, triggers for complex business logic
• Designing database using ERWIN Data Modelling Tool
• Software/Web: Microsoft Business Intelligence Development Studio (BIDS)
• Database/Tools: Microsoft SQL Server 2008, SSIS (SQL Server Integration Services), TFS (Team Foundation Server)

Confidential

Data Analyst/Developer

Responsibilities:

• BI takes care of the ETL activities using SSIS packages. Scheduled batch jobs are used to pull/push data from/to the various interfaces.
• Creation of SSIS packages
• Maintenance of existing SSIS packages
• Creation of SSRS reports
• Maintenance of existing SSRS reports
• Software/Web: Microsoft Business Intelligence Development Studio (BIDS)

Database/Tools: Microsoft SQL Server 2008, SSIS, SSRS

Confidential

Data Analyst/Developer

• IDA was a CCF Agent Toolbar within the Confidential environment. An instance of this application runs on each call center agent’s Windows XP desktop. It wraps up the existing call centre business applications into a single desktop client, thus providing greater productivity in call centre business.
• Developing SSRS reports
• Creating OpenSpan automation workflows as per business logic and use case
• Software/Web: Microsoft Visual Studio 2010, Microsoft Business Intelligence Development Studio (BIDS), OpenSpan Studio

Database/Tools: Microsoft SQL Server 2005, TFS, SSRS, OpenSpan Robotic Process Automation Tool

Confidential

Lead Data Analyst/Developer

Responsibilities:

• Incident/Problem Management
• Server health maintenance
• Supporting reporting solution built on SSAS
• Creating stored procedures and SQL queries
• Using Load Runner for performance/load testing of application
• Performance tuning of stored procedures in database to increase screen load time
• Software/Web: ASP.Net 2.0

Database/Tools: Microsoft SQL Server 2005

Confidential

Developer

Responsibilities:

• Developing SSRS reports for invoice generation
• Creating subscriptions in SSRS to email invoices to users
• Creating dynamic stored procedures
• Software/Web: ASP.Net 2.0
• Database/Tools: Microsoft SQL Server 2005, SSRS