Developer Data

Neha Jain

Visa Status – L* EAD (valid till **/*021) - No sponsorship required in future

Mobile: +1-484-***-****

Email: adb5qr@r.postjobfree.com

Address: West Chester, PA-19380, United States

LinkedIn: https://www.linkedin.com/in/nehajain1728

SUMMARY

•10+ years IT experience in Design, Development, Maintenance, Enhancements and Production Support of which includes Data warehousing and Legacy applications using ETL tools like TALEND, SSIS.

•Data Modeling, SQL Server Optimization, Indexing, Database Design

•Experienced in API integrations and Postman

•IT experience in various industries like Financial, Telecom and Banking.

•Experience in adhering software methodologies like Waterfall, Agile.

•Extensive experience in the Microsoft SQL Server, T-SQL, PL/SQL, SSRS, database objects like complex dynamic Stored Procedures, Triggers, Views, etc.

•Experience with Talend to develop processes for extracting, cleansing, transforming, integrating, and loading data.

•Experience in Debugging, Error Handling and Performance Tuning of sources, targets, database objects, jobs etc.

•Additional experience in data visualization and data analysis – Tableau, Power BI & Splunk

•Knowledge of data modelling using ERWIN – creating database model – database objects schema with constraints and referential integrity

•Developed/Maintained SSIS packages that connect to Teradata/Oracle database and pull data.

•Developed ETL packages for pulling data from different source systems like Salesforce, Oracle, Teradata, flat files, excel files into SQL Server database

•Worked on TALEND 6.4 and 7.1 for creating ETL jobs to pull data into SQL database from different applications like API, files, databases, etc.

•Knowledge of Big Data, Hadoop, Pig, Hive, HDFS, HBase, Spark SQL, Load Runner and Python scripting, WinSCP scripts, SFTP, GPG Encryption

•Data Quality checks implemented in SQL jobs to ensure data is tested before reports are generated.

•Hands on experience in scheduling tools like Talend Administrator, Autosys, Windows Task Scheduler.

•Hands on experience in working with Jira, Rally, Ticketing & Change Request Management

•Experience in leading mid-size team and offshore-onsite team coordinator.

•Experience in 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

AREAS/APPLICATIONS:

•Knowledge of Big Data Hadoop and Spark Developer (HDFS, HBASE, Sqoop, Hue, HIVE, SparkSQL) https://certificates.simplicdn.net/share/887348.pdf

•ITIL Foundation Certified by EXIN

•OpenSpan certified developer

•Completed PEGA ROBOTIC AUTOMATION ARCHITECT ESSENTIALS 8.0

•Scrum Master Certified professional http://81cd1176253f3f59d435-ac22991740ab4ff17e21daf2ed577041.r77.cf1.rackcdn.com/Certificates/ScrumMasterCertified-NehaJain-721290.pdf

TECHNICAL SKILLS:

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

•Frameworks: Microsoft CCF, OpenSpan/Pega Platform

•Databases: Microsoft SQL Server 2019

•Scheduling Tools: SQL Job Monitor, Autosys, Windows Task Scheduler

•Tools: Data Warehouse – ETL tool – SSIS, TALEND 6.4 and 7.1

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

•Version Control Tools: VSS, Clearcase, TFS

EDUCATION:

•Bachelor of Technology (B.Tech) from HBTI, Kanpur (U.P. Technical University) in India from 2002-2006.

PROFESSIONAL EXPERIENCE:

Jan 2019 - Feb 2020

PetPlan (Pet Insurance Company), Newtown Square PA

Project Name: Rate Filing 2019 (Business Intelligence)

Data Analyst/Developer

•BI (Business Intelligence) team is the data team for Petplan that supports back-end data changes and reports. As part of RateFiling2019 project I had to design, develop and maintain a new database to support actuarial rate filing process for 2019 in US and CANADA.

•Created a database model in ERWIN 2018 and generated database script to create actual database in SQL server.

•Working as a Scrum developer for an agile development team of 6-8 members, working in 2 weeks sprints.

•Developed various database objects like stored procedures, triggers, views, indexes and SQL jobs.

•Created database backup and restore scripts to create DEV, UAT and PROD environments.

•Using SSIS for bulk import of data from excel or any other flat file formats.

•Using Postman for API call to verify data format

•Using TALEND 6.4 and 7.1 to develop/maintain ETL jobs that pull data from different APIs into SQL server database

•Develop and scheduling Talend jar files on Linux server and Talend batch files on Windows task scheduler.

•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.

•Using BI Tools like SSIS, Tableau for data ingestion, validation and reporting using SQL jobs.

•Creating T-SQL stored procedures for catering to new reporting solutions

•Troubleshooting and fixing failed SQL jobs

•Maintaining/Deploying Tableau dashboards

•Sending out automated emails from SQL server for proactive monitoring

•Using JIRA on daily basis to track defects and fixes.

•Creating detailed design documentation - Google drive used as project repository for documentation.

•Software/Web: Microsoft Business Intelligence Development Studio (BIDS)

•Database/Tools: Microsoft SQL Server 2019, Tableau Reporting Tool, TALEND 6.4

Aug 2017 - Jun 2018

Comcast, Greater Philadelphia Area PA

Project Name: BDI (Business Data Intelligence) and Xfinity Home Reporting

Data Analyst/Developer

•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 data analysis.

•Gathered requirements and developed 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.

•Deploying/Maintaining SSIS packages for pulling data from different source systems like Salesforce, Oracle, Teradata, Hadoop database, flat files into SQL Server database

•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 MS PowerPoint presentations for business stakeholders to derive at conclusions from report data trends.

•Creating T-SQL stored procedures for catering to new reporting solutions

•Troubleshooting and fixing failed SQL jobs

•Maintaining/Deploying SSRS/Tableau/OBIEE reports

•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 (data validations & testing) implemented in SQL jobs to ensure data is tested before reports are generated.

•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

Jan 2017 - Mar 2017

Accenture, Dallas TX

Robotics Process Automation (RPA) 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.

•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

July 2010 – May 2016

Tata Consultancy Services, India

Sep 2013 - May 2016

Client - Royal Bank of Scotland, UK

Data Analyst

•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)

Sep 2012 - Aug 2013

Client - Royal Bank of Scotland, UK

SQL ETL Developer

•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

Maternity Leave: Mar 2012 - Aug 2012

Oct 2011 – Feb 2012

Client - Hilton, USA

SQL ETL 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)

Aug 2010 – Sep 2011

Client - Hilton, USA

SQL ETL Developer

•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

June 2006 – July 2010

Infosys Technologies Ltd., India

Oct 2009 – Jul 2010

Client - Telstra, Australia

Robotics Process Automation (RPA) Developer

•IDA was a CCF Agent Toolbar within the Telstra 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

Nov 2007 – Sep 2009

Client - Telstra, Australia

Application Developer

•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

Nov 2006 – Oct 2007

Client - BMW Financial Services, Japan

SSRS Developer

•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

Contact this candidate