SUMMARY:

• 5 - 6 years of experience as Python developer includes Python programming.
• Application designing skills using XML, JSON for python.
• Expert in writing SQL queries and optimizing the queries in Redshift, Snowflake.
• Excellent knowledge in SQL and coding PostgreSQL Packages, Procedures.
• Good amount of experience in Snowflake Database, packages, Internal staging and external Staging.
• Secured Tableau server on AWS to protect the Tableau environment using Amazon VPC, security group, AWS IAM and AWS Direct Connect.
• Expertise in Normalization Techniques for Data Consistency and Flexible Database design.
• Worked on different python IDE’s: PyCharm, Sublime, Spyder etc.
• Experienced in writing programs which require use of Machine learning concepts in Financial services.
• Built various graphs for business decision-making using Python matplotlib library.
• Hands on experience in data quality, data organization, metadata, and data profiling and large Data set sizes.
• Ability to move data between production systems and work on cross/multiple platforms.
• Experience in analyzing the claims data, future trends and summarized results to generate recommendations for management. Hands-on experience in building web and enterprise applications in various domains like Banking/Financial Services.

TECHNICAL SKILLS:

Programming Languages: Python.

Machine Learning: TensorFlow

Web Technologies: HTML, XML, JSON.

Frameworks: Flask.

AWS: AWS (EC2/Redshift), S3, IAM, Lambda.

IDE s/ Development Tools: Ultra Edit, PyCharm

Databases: PostgreSQL, Snowflake.

Version Control: GitHub, GitHub Enterprise.

Operating Systems: Windows, Red Hat Linux.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Responsibilities:

• Act as key data lead to leverage versatile technical capabilities to drive the development, evolution, and implementation of data products, which enable self-service by data consumers
• Explore industry trends, tools, and techniques in Open Source/Big Data/Digital domain.
• MTTR Automation, AUDIT PDF Automation using python on LEGOLAND, EC2 instance to create applications for “KEY-WORD SEARCH” using TensorFlow algorithms.
• Create own virtual environment on barebones linux and TensorFlow Linux instances using Legoland for using Machine Learning algorithms.
• ICTT (IDEPENDENT COMPLIANCE TEST) for KOHLS partner every fiscal year.
• Maintains Tableau refresh on server for reports like PSP Schedule, Executive Refresh and (Exams and Audit) as a part of BAU.

Python Engineer

Confidential, Greater Chicago Area

Responsibilities:

• Responsible for the design, development and administration of analytical data processes such as converting TERADATA SQL scripts to REDSHIFT PSQL scripts, data validation checks, metadata review, included within those responsibilities are the areas of data access and delivery technologies.
• Using other corporate tools like Legoland and Databricks associated with Confidential .
• Includes expertise in data quality, data organization, metadata, and data profiling.
• Data set sizes are usually huge (more than hundreds of millions of records), storing millions of records in csv files and excel spreadsheets.
• Leveraging Driver tables to pull data in Teradata, Redshift (UD Interim and Driver).
• Mapping the true source of the fields from the table and moving the fields from S3 RAW, LOAD Ready, Extract datasets to REDSHIFT using AWS CLI and Python.
• Working with AWS services like EC2, S3, IAM and REDSHIFT.
• Working on FUSION UAT, BAU testing for both Teradata and Redshift.
• Understanding the PDS - BAU data workflow such flow from following:
• Mainframe files->Cluster->Validation ->Preproc Wrapper-> XFORM JOBS->S3->REDSHIFT LOAD.
• Working on FRB Reporting, converting and making reports using Python (Pandas, XLSXwriter etc. modules).
• Converting Kohls Library Metric scripts: Commonly used metric scripts, Driver table scripts and others etc. from Teradata SQL syntax to Redshift PSQL syntax.
• Branded Card tables and fields validation and testing from converting the Shell, SQL scripts to Python and PSQL in AWS.

Confidential

Python Engineer

Responsibilities:

• Working linux based environment.
• Written SQL queries in SQL Server, AWS's Redshift environment using SQL workbench.
• SAS functions for almost any statistical operation / model building for python frameworks like Flask, Pandas.
• Using get and post API which exposes the primary part of the code.
• As a part of migration, we are performing migration of new sets of frameworks, apps and data to AWS.
• Some API’s are already there in legacy system and migration of legacy systems to AWS.
• Worked extensively on Multithreading and Concurrency for implementing Batch and Python.
• Backend database as SQL for the development and test environment. Having data backups on Teradata databases.
• Worked on validating the code and developed SQL queries.
• Developing a web application written in python/flask in windows and deploying to a Linux server.
• Used python scripts to update content in the database.
• Manipulate CVS files like looping through rows, extracting information, handling lists etc.
• Generated Python flask forms to record data of online users for application setup, setting up user accounts, templates, static files etc.
• Testing (unit and integration), debugging and error handling.
• Using version control systems like GIT (windows).

Confidential, Allentown, WA

Python Backend Engineer

Responsibilities:

• Responsible to Deliver Proof of Concepts using AWS, understanding customer business requirement
• Involved in the implementation of open-source web application frameworks like Flask.
• Resolved bugs and other defects using Firebug and chrome developer tools and eclipse debugging tool.
• Worked closely with backend developers in understanding requirements and coordinating the development.
• Interacted with client periodically to gather the requirements and presenting demos.
• Coordinated with offshore counterparts to deliver quality code on time.
• Worked on AGILE methodology to reach the timelines.
• Managed code with GitHub.

Confidential

Software Engineer

Responsibilities:

• Work with team of developers on python applications for RISK management.
• Design, develop, deploy and maintain the website.
• Written python scripts to parse XML documents and load the data in database.
• Responsible for debugging and troubleshooting the web application.
• Developed views and templates with python and Django's view controller and template language to create a user-friendly website interface.
• Python, Django1.3, MySQL,
• Worked on configuring security for Hadoop cluster (Kerberos, Active Directory).
• Responsible to manage data coming from various sources.
• Wrote Hive queries for data analysis to meet the business requirements.
• Created Hive tables and working on them using Hive QL.
• Upgraded the Hadoop Cluster to Cloudera Manager.