SUMMARY:

• 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, SSRS, SSIS, 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.

AREAS/APPLICATIONS:

• Knowledge of Big Data Hadoop and Spark Developer (HDFS, HBASE, Sqoop, Hue, HIVE, SparkSQL)
• ITIL Foundation Certified by EXIN
• Completed PEGA ROBOTIC AUTOMATION ARCHITECT ESSENTIALS 8.0
• Knowledge of data mining, data analysis and data modelling.
• Significant experience in Microsoft SQL Server, SSRS, SSIS, SQL Server jobs, Tableau, Python scripting, WinSCP scripts, SFTP, GPG Encryption
• Experience of various monitoring software such as Geneos, Splunk, Autosys
• Experienced in ServiceNow or equivalent ticketing systems
• Working knowledge of MS Word, MS Excel, MS Visio, MS Power Point, MS Project, JIRA, Confluence and SharePoint
• Experience in Linux, Unix, HTML, Python, Load Runner, C#, XML, JSON, SOAP, REST services, OOPS
• Experience and comfort executing projects in agile methodology and Sprints with development team from initial development of business requirements to providing on - going maintenance and support.
• Ability to effectively communicate technical details to non-technical users and business problems to technical team and provide solutions to business problems.
• Automating business solutions and promote engineering simplicity

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), Geneos (Server Monitoring), Autosys (Job Scheduling Software), Symantec (Authentication Service), ServiceNow (Service Management software), Splunk (Data and Log Analysis), WinSCP (SFTP Scripts), GPG Encryption, Python Scripting

Operating Systems: Windows XP/2000, Windows Server 2008

Version Control Tools: VSS, Clearcase, TFS

PROFESSIONAL EXPERIENCE:

Confidential, Greater Philadelphia Area, PA

Data Analyst/Developer

Responsibilities:

• 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
• Troubleshooting and fixing failed SQL jobs
• Maintaining/Developing SSRS/Tableau/OBIEE reports
• 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
• 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

Confidential

Robotics Process Automation Developer

Responsibilities:

• 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.
• 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 Analyst/Developer

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

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), Geneos (Server Health Monitoring), 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

Confidential, USA

Data Analyst/Developer

• 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

Responsibilities:

• 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