PROFESSIONAL SUMMARY:

• 8 years of experience as a Web/Application Developer and coding with analytical programming using Python, C++ and involving RDMS experience in various Industry verticals like Healthcare, Retail, Finance, and Banking.
• Experienced in developing web - based applications using Python, XML, HTML, CSS, JavaScript and jQuery.
• Good experience of software development in Python language and IDEs -sublime text, Spyder, Pycharm, Eclipse, etc.
• Experience in various modules like rest framework, mock, Numpy etc.
• Good knowledge on NoSQL databases like Cassandra, MongoDB.
• Experienced in developing Web Services with Python programming language.
• Worked no Amazon Web Services (AWS) Cloud services such as EC2, EBS, S3, VPC, Cloud Watch, and Elastic Load Balancer.
• Experience in using Design Patterns such as MVC, Singleton and frameworks such as Django.
• Experience in using Version Control Systems like GIT, SVN and CVS. Good experience in Linux Bash scripting and following PEP Guidelines in Python.
• Architecture using Django, Flask, Jinja, Pyramid Python web application frameworks.
• Extensively worked on Hudson/Jenkins, Build Forge for continuous integration and for End to End automation for all build and deployments.
• Python programming on handling warnings, Exception handling, concrete exceptions, binary data services.
• Experience in various modules like rest framework, mock, Numpy etc.; Good experience in Shell Scripting, SQL Server, UNIX and Linux.
• Developed web applications and RESTful web services and APIs using Python Flask, Django and PHP.
• Web pages on the internet are generated by servers running LINUX.
• Experience in using Git, GitHub and deploying them.
• Added several options to the application to choose the algorithm for data and address generation.
• Using Subversion control tool to coordinate team-development.
• Responsible for debugging and troubleshooting the web application.
• Experienced in using various version control systems like GitHub enterprise.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, Relational Database models, Data integrity.
• Excellent in developing SSIS packages to Extract, Transform, Load (ETL) data into Data Warehouse from source databases such as Flat File, Excel, CSV.
• Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services 2012/2008/2005 (SSRS).
• Complete Knowledge on SDLC models, Agile (Scrum, Kanban).

TECHNICAL SKILLS:

• MS SQL Server 2012/2008 R 2/2008/2005/2000/7.0
• Python 2.7
• MS SQL Server Integration Service (SSIS)
• MS SQL Reporting Services (SSRS)
• MS SQL Analysis Services(SSAS)
• Microsoft Access 2000/8.0
• Microsoft Excel
• Outlook
• MS SQL Profiler
• SQL Query Analyzer
• Database engine tuning advisor
• JIRA
• C#
• Toad
• Erwin Data Modeler 7.2/4.2/4.1
• Crystal Reports 8.5
• T-SQL
• Business Object XI R2
• BO Designer
• Info view
• UNIX
• Windows 2003/2000 Advanced Server/Professional
• Windows NT 4.0 Server/Workstation.

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Python Developer

Responsibilities:

• Involved in Developing a Restful service using Python Django framework.
• Designing Celery and multithreading for scheduling the tasks and multiple activities.
• Develop Interactive front end to visualize data from backend and represent in graphical manner to better understanding for user.
• Experienced in hand-coding HTML5, CSS3, JavaScript, and other UI technologies.
• Experience with JavaScript Frameworks Ext JS, AngularJS, and jQuery.
• Experienced in web applications development using Flask and Django in Python.
• Experience on AWS cloud services like EC2, S3, ECS, RDS, Dynamo, Elastic Load Balancer(ELB), and EBS for installing, Configuring and troubleshooting on various Amazon images for server migration from physical into Cloud..
• Design, build and manage the ELK (Elastic Search, LogstashKibana) cluster for centralized logging and search functionalities for the App.
• Written and Maintained Automated Salt scripts for Elastic search, Kibana and Beats.
• Parsed the unstructured data into semi-structured format by writing complex algorithms in pyspark.
• Developed Merge jobs in Python to extract and load data into MySQL database.
• Successfully migrated the Django database from SQLite to MySQL to PostgreSQL with complete data integrity.
• Experience in report writing using SQL Server Reporting Services (SSRS) and in creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access.
• Creating S3 buckets and also managing policies for S3 buckets and Utilized S3 bucket for storage and backup on AWS Ensure data integrity, performing extensive quality control checks of GIS data and non-spatial database.
• Front-end web development using HTML/CSS, JQuery, Bootstrap as well as back-end development using Golang and SQL.
• Used Test driven approach for developing the application and Implemented the unit tests using Python Unit test framework.
• Reviewed and implemented instrument pricing and modelling methodologies in collaboration with technical engineers. Analyzed and documented how instrument prices move as underlying market data sources change.
• Involved in the Complete Software development life cycle (SDLC) to develop the application.

Tools: Python 2.7, Py Query, Angular.js, Shell Scripting, JSON, Rest, Apache Web Server, CSV, XML, CSS, Django, SQL, UNIX, Windows, PostgreSQL, and python libraries such as Numpy, etc.

Confidential, Minneapolis, MN

Python Developer

Responsibilities:

• Enhanced the application by using HTML and Java script for design and development.
• Used data structures like directories, tuples, object oriented class based inheritance features for making complex algorithms of networks.
• Created PHP/MySQL back-end for data entry from Flash and worked in tandem with the Flash developer to obtain the correct data through query string
• Wrote advanced HTML 5, JavaScript and CSS to deliver cutting-edge user interfaces and components.
• Developed views and templates with Python and Django's view controller and templating language to create a user-friendly website interface.
• Refactor Python/Django modules to deliver certain format of data.
• Implemented a module to connect and view the status of an Apache Cassandra instance using python.
• Experience in writing Python Scripts, which integrated with Amazon API to control instance Operations.
• Managed datasets using Panda data frames and MySQL, queried MYSQL database queries from python using Python-MySQL connector and MySQL dB package to retrieve information.
• Integration with CICD (Continuous integration and continuous Deployment) Process for all micro services and serve them to external innovations.
• Used Bootstrap front-end framework for faster and easier web development with MySQL database, Node.js as the backend.
• Developing custom HTML elements using angular js 2.0 directives.
• Worked with React JS to build bootstrap components for UI web objects. Linked with API data to view render virtual DOM dynamically.
• Representation of the system in hierarchy form by defining the components, subcomponents using Python and developed set of library functions over the system based on the user needs.
• Generated graphical reports using python package Numpy and matplotlib.
• Used Python and Django creating graphics, XML processing, data exchange and business logic implementation
• Extensively used Selectors in JQuery for updating content on DOM nodes.
• Wrote code to fetch data from Web services using JQUERY AJAX via JSON response and updating the HTML pages.
• Used Eclipse IDE for designing, coding and developing applications.

Tools: Python, Django Framework, Azure APIs, Shell Scripting, Spark, CSV, ReactJS, Google APIs, SOAP, REST, Hadoop, RBAC,ACL, Pandas, NVMe, Docker, Postman, node.js, MySQL, Selenium, Scala, Flash, AWS, Windows, Unix.

Confidential, Carnegie, PA

Python Developer

.Responsibilities:

• Designed front end and backend of the application utilizing Python on Django Web Framework.
• For the dashboard utilized the Python web development framework Turbo Gear.
• For the development of the user interface of the website used HTML, CSS, Java Script and AJAX
• Experience in developing views and templates with Python and Django's view controller and templating language to create a user-friendly website interface.
• To update a portion of a webpage used JavaScript and JSON.
• Extracting the Data from Elastic search using elastic search module in Python and visualize the data in HTML or Bootstrap and also generating charts which is more specific and accurate using Matplotlib.
• Used Kibana plugin to visualize for elastic search.
• Expertise in developing consumer based features and applications with Python, Django, HTML, Behavior Driven Development (BDD) and pair based programming.
• Controlled modules that allow applications to be built on top of the web, irc or the command line using Giotto.
• Modify the existing Python/Django modules to deliver certain format of data.
• Have work knowledge on JIRA (Agile) for the bug tracking of the project.
• Worked on a lightweight Web framework emphasizing flexibility and rapid development with the help of pythons.
• Written Python scripts to parse JSON documents and load the data in database.
• The data manipulations on the client side is done by using JQuery.
• Made reusable Widgets using concepts familiar from GUI programming with Reahl.
• For the development of the web applications utilized CSS and Bootstrap.
• To share the information across the applications used pickle /unpickle in python.
• Utilized Python libraries like Numpy and matplotlib for generating graphical reports.
• Experienced with GIT version control and deployed the project to Confidential .
• Build SQL queries for performing various CRUD operations like create, update, read and delete.

Tools: Python, Django, Oracle, Django, Flask framework, CSS, XML, HTML, JavaScript, Numpy, Jenkins and Jupyter Notebook, MS SQL Server 2012.

Confidential, Northport, NY

Data Warehouse Developer

Responsibilities:

• Experienced in developing Web Services with Python programming language.
• Python programming on handling warnings, Exception handling, concrete exceptions, binary data services.
• Experience in various modules like rest framework, mock, Numpy etc.
• Good experience in Shell Scripting, SQL Server, UNIX and Linux.
• Designed SSIS ETL packages to validate, extract, load from different file formats and a data source.
• Used sequence containers, loop containers, Script task, execute SQL task and various data flow tasks.
• Performed data migration from source databases to data warehouse with incremental load using SSIS.
• Creating Database Backup strategy (Full backup, Differential backup and Transaction log back up) and disaster recovery procedures.
• Implementing SQL server high availability tools like Replication, Log shipping, and database mirroring.
• Wrote complex SQL queries involving multiple tables using Joins, sub-queries, temporary tables.
• Created new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2012.
• Created Stored Procedures, User Defined Functions to facilitate data load.
• Responsible for identifying sources, creating staging database, data warehouse dimensional modeling (Facts and Dimensions).
• Generated reports of types drill down, drill through, adhoc, matrix, and parameterized reports using SSRS.
• Developed many Tabular Reports, Matrix Reports, Sub Reports, dynamic grouping, drill down Reports and Charts using SQL Server Reporting Services (SSRS 2008).
• Used Team Foundation Server to create interactive reports with an ability to drill down into details.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.
• Configured Email Alerts for unsuccessful completion of Scheduled Jobs.
• Gathered Business requirements for Integration points and mapped them with Functional requirements.

Tools: MS SQL Server 2012, Windows 2000/NT/XP, SSIS, SSRS, OLAP, OLTP, T-SQL, C#, Query Analyzer, MS Office 2003, Oracle 9i/10g, Erwin 4.0, Team Foundation Server (TFS). Python, Django, UNIX, HTML, XML, CSS, PHP.

Confidential, New York, NY

Sr. SQL Developer/ SSRS developer/ SSIS developer

Responsibilities:

• Entire Front end and back end modules of the project are developed using Python with Django Framework.
• Designed and developed the data management systems using SQL databases.
• Written Python Scripts to parse the XML documents and load the data in database.
• Utilized the existing Python and Django modules and rewritten to deliver data in required formats.
• Created new schema, new tables, field definitions and mappings, stored procedures, views, indexes following the Normalization standards to maintain data consistency.
• Created SSIS Packages by using transformations (i.e. Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate) and also used Custom components such as Audit on Pre-Execute, Audit On Post-Execute, Custom Email Task.
• Tested, Cleaned and Standardized Data to meet the business standards using Fuzzy and Exact lookups.
• Configured the loading of data into slowly changing dimensions.
• Responsible for creating the reports based on the requirements using SSRS 2008.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS).
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Created different type of reports which include: Cross-tab, Conditional, Sub report, Drill-down and Parameterized dynamic reports and deployed and scheduled Reports in Report Manager using SSRS to generate all daily, weekly, monthly and quarterly Reports.
• Deployed and upload the SSRS reports to SharePoint Server for the end users and Involved in Enhancements and modifications.

Tools: MS SQL Server 2012/2008 R2, T-SQL, SSIS, SSRS, Oracle 11g, ODBC, Crystal Reports 2008Microsoft Excel, Python, Django, UNIX, HTML, XML, CSS, JavaScript, MySQL.