SUMMARY:

• A proficient well rounded IT professional with myriad interests and 7 years of experience ranging from legacy systems to contemporary data tools. Looking to expand the horizon and trying to find the next gig in Python development and data analysis.
• Experience in building data flows and doing extensive data analysis using Python,R,SQL
• Experience in building end to end web application using a nosql database (Neo4j), Flask, d3.js, javascript
• Experience in database development and administration in SQL server, Oracle 10 g
• Experience in writing complex stored procedures using TSQL, PL/SQL
• Experience and hosting web applications from a docker container
• Experience in UNIX command line and shell scripting
• Good understanding of Hadoop Ecosystem

TECHNICAL SKILLS:

Programming Languages: Python, R, Javascript, C++, T SQL, PL/SQL, JCL.

Platforms: Windows XP, Windows Vista, Windows 7, Linux Redhat ER5, Debian,Ubuntu

Databases: Neo4j, Oracle9i/10g, MS SQLServer2005/2008

Software Tools: Docker, Rational Rose, SQL editors, PL/SQL Editors, Putty, MS Visio, MS Project, SSRS, SSIS,SSAS, Hive, Pig, CA - ESP(scheduling package), TSO & TPX, JCL, Sysview, Planet, Tandem, C1 Endeavor, Netcool

WORK EXPERIENCE:

Lead Software Engineer

Confidential, Englewood, CO

Responsibilities:

• Transaction data was extracted from various data sources like Sql server and Hive using python module called sqlalchemy
• Performed extensive data wrangling on the extracted data using pandas and numpy modules in Python
• Pushed the transformed data back to a table in SQL server
• Encapsulated the entire process into a single workflow using the luigi module in Python so that it runs perpetually in small batches
• Used Python’s multiprocessing capabilities to run multiple processes for different time periods based on available memory on the server

Technical environment: SQL server 2008, Debian, Python 2.7, Hive

Confidential

Responsibilities:

• Built a Neo4j database (graph database) by using the relational data from SQL server database
• Neo4j database served as the data source for the tool
• Used python modules like Py2neo to connect to the Neo4j db from python
• Wrote nosql queries to come up with networked data which was up to 5 levels deep
• Built a python class and used pandas and igraph modules to perform necessary aggregations on the raw networked data
• Transformed the aggregated data into JSON
• Built a website using Python microframework called Flask
• Used ajax,jquery to link the drop down buttons to the back end
• Used d3.js library to render graphs from the JSON data
• Added various buttons on the front end
• Used extensive javascript to filter through the graphs based on button clicks
• Deployed the web application on a private IP from a docker container

Technical environment: Debian, Python 2.7, Neo4j 3.0, Sql server 2008, d3.js v3, jquery, ajax, HTML

Developer/Analyst

Confidential, Ashburn, VA

Responsibilities:

• Worked with application and development teams such as Abinitio, DBAs, Hadoop support in recovery of complex technical problems from a UNIX standpoint
• Wrote shell scripts to load data from flat files to Oracle DB
• Checked system logs and troubleshot various applications for connectivity issues and memory leak
• Supervised and managed application team implementations such as new releases and enhancements with no impact to Service Levels and minimizing outages
• Supported initiatives such as mock disaster recoveries and tools enhancement to make the systems more robust and fault tolerant

Confidential

Lead Software Engineer

Responsibilities:

• Determined the data model and architecture of the Oracle database in terms of tables, columns and dependency between various tables
• Used SQLLoader to populate the oracle db with the data from csv files
• Wrote PL/SQL stored procedures to manipulate the data in the db according to the needs of the front end

Technical environment: IBM mainframe, UNIX, Oracle 10g, ASP.NET

Confidential

Lead Software Engineer

Responsibilities:

• Fetched the data from SQL server using sqlalchemy
• Built a python class where the objects were batch jobs depending on their severity
• Used python modules like numpy, Pandas, datetime to perform extensive data analysis
• Using sqlalchemy pushed the results back to a table in SQL server
• The data in the table was then used to make reports for the dashboard

Technical environment: SQL server 2008, Python 2.7, SSRS

Research Assistant

Confidential, NY

Responsibilities:

• Interview industry professionals to identify challenges in collaboration
• Document and consolidate the findings from the interviews using Excel

Oracle DBA/developer Intern

Confidential, Bethlehem, PA

Responsibilities:

• Created and managed schemas and users
• Performed deployment for new releases of homegrown application
• Maintained and managed space as per requirement for table space and segment
• Wrote PL/SQL stored procedures for ad hoc data manipulation
• Performed database back-ups by using export and import utility
• Inspected STATSPACK reports and AWR reports for tuning of Oracle

Junior SQL Developer

Confidential

Responsibilities:

• Developed data mappings which specified the business transformation rules to be applied to the data
• Developed data dictionary which stored information about data such as meaning, relationships to other data, origin, usage, and format
• Implemented database objects like procedures, functions and triggers to achieve consistent implementation of logic