Python/ui Developer Resume
Bloomington, IL
SUMMARY
- Around 11 years of experience as a Python, UI & ETL Developer and a proficient coder in multiple languages and environments includingPython, REST API, AWS, C, R, C++,andSQL.
- Mastered the ability to design and deploy rich Graphic visualizations with Drill - down and Drop-down menu options using Tableau.
- Experience in developing web-based applications usingPython 3, Django 1.10/9,2.2, Angular.
- Good experience of software development inPython(libraries used: Beautiful Soup, NumPy, SciPy, Matplotlib,Pandas data frame, network, urllib2, MySQL dB for database connectivity) andIDEs - sublime text, Spyder, PyCharm, RPC frameworks.
- Extensive experience in system analysis, design, development, and implementation of web-based and client/server applications usingHTML, Angular JS, Bootstrap, React JS, Node JS, CSS, JavaScript, XML, Python, Django, Spark, Scala.
- Good experience in developing web applications implementing MVT/MVCarchitecture using Django, Flask,and web application frameworks.
- Used Django and Node.js to connect to databases and createRestful APIsfor accessing and altering data.
- Excellent knowledge ofOOPS, Multi-Threading,andCollectionsconcepts inPython. Used Pandas library for Statistical Analysis.
- Experience in usingPythonmodules likeNumPy, Bigdata, Machine learning, Pyspark Matplotlib, .net, Pandas, SciPy, Xpath, Pytest,etc., for generating complex graphical data, creation of histograms, etc.
- Worked onKubernetes APIendpoint’s in exposedEKSmanaged console plane.
- Experience in Database Administration, development, design, maintenance, and production support of relational databases, business applications, new server setup,MySQLServer installation, upgrade, migration.
- Extensive experience in Text Analytics, developing different StatisticalMachine Learning, Data Miningsolutions to various business problems, and generating datavisualizations usingPython.
- A highly immersive Data Science program involvingData Manipulation & Visualization, Web Scraping,Machine Learning, Pythonprogramming, SQL, GIT, Unix Commands, NoSQL, MongoDB, Hadoop.
- Extensive experience in creatingTables, Views, Indexes, Stored Procedures, Cursors, Triggers,and T-SQL queries.
- ExecutedMySQLdatabase queries from python usingPython-MySQLconnector andMySQLdB package to retrieve information.
- Experienced in developing Web Services withPythonprogramming language and good knowledge of Web Services with protocolsSOAP, REST.
- Experienced in working with various Python Integrated Development Environments likeNet Beans, PyCharm, PyScripter, Spyder, PyStudio, PyDev,andSublime Text.
- Designed, configured, and deployed Amazon Web Services for a multitude of applications utilizing theAWSstack (IncludingEC2, Route53, S3, RDS, Cloud Formation, Cloud Watch, SQS, IAM), focusing on high-availability, fault tolerance, and auto-scaling
- Extensive Experience in Business Intelligence (BI) Tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS).
- Expertise in working with different databases likeMicrosoft SQL Server,Oracle, MySQL, Cassandra,PostgreSQL,and Good knowledge in usingNoSQLdatabasesMongoDB.
- Design and maintain databases usingPythonand developed Python-based API (Restful Web Service) usingFlask, SQL Alchemy,andPostgreSQL.
TECHNICAL SKILLS
Python Libraries: NumPy, SciPy, Matplotlib, Pandas data frame, urllib2, Django.
Web Technologies: HTML, CSS, DHTML, XML, JavaScript
Primary Languages: Python, Java, C, C#, C++, Angular.JS, React.js, node.JS
Frameworks: Bootstrap, Django, Node.JS, Flask
Database: Sqlite3, MSSQL, MySQL, Mongo DB, Oracle11g,NoSQL,Scala
BI Tools: Tableau 10.x,9.x, 8.3/8.2/8.1/8.0/7.0 , SAS, SSRS, Salesforce, Crystal Reports 9.0/8.5, OLAP, Power BI
ETL Tools: Informatica Power Center, DataStage, BOXI
IDE Tools: PyCharm, Eclipse, MS Visual Studio.
Deployment tools: MS Azure, Amazon Web Services (EC2, S3, EBS, ELB, SES).
Automation Tools: Python, Shell Scripting, Bash.
Cloud Technologies: AWS, S3.
Methodologies: Agile, Scrum, Waterfall.
Operating Systems: MS Windows, Linux/Unix.
PROFESSIONAL EXPERIENCE
Confidential, Bloomington, IL
Python/UI Developer
Responsibilities:
- Involved in all the stages of the software development life cycle like design, development, implementation, and testing.
- Prepared scripts to ensure proper data access, manipulation, and reporting functions withRprogramming languages.
- Developed views and templates with Python and Django's view controller and templating language to create a user-friendly website interface.
- UsedPandas, NumPy, Seaborn, SciPy, Matplotlib, Scikit-learn, NLTK in Python for developing various machine learning algorithms, and utilized machine learning algorithms such as linear regression, multivariate regression, naive Bayes, Random Forests, K-means, &KNN for data analysis.
- PerformedData Cleaning, features scaling, features engineering using pandas, and NumPy packages in python.
- Responsible for design & development ofSpark SQL ScriptsusingPythonbased on Functional Specifications to load data to snowflake. Implemented the workflows using Pythonto automate tasks.
- Skilled in using collections inPythonfor manipulating and looping through different user-defined objects.
- Developed API services inPython, NodeJSwhile leveraging AMQP and RabbitMQ for distributed architectures.
- CreatedTableaudashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts, etc. using show me functionality.
- ConnectedTableauto various databases and performed live data connections, query auto-updates on data refresh.
- Developed Merge jobs in Python to extract and load data intoMySQLdatabase and Worked on theMYSQLdata lineage process to map source totarget DB, table, and column mappings usingPython.
- Installing and automation of application using configuration management toolsPuppetandChefand Creating and configuring virtual development environments withChefandVirtual Box.
- Used R and python for ExploratoryData Analysis, A/B testing, ANOVA test,and Hypothesis test to compare and identify the effectiveness of Creative Campaigns.
- Managed datasets using Panda data frames andMySQL, queriedMYSQLdatabase queries fromPythonusingPython-MySQLconnector MySQLDB. package to retrieve information.
- Worked onPython OpenStackAPIs and usedNumPyfor Numerical analysis and had developed Wrapper in Python for instantiating multi-threaded application.
Environment: Python 3.8, Django 1.10,1.11, MySQL, Shell Scripting, REST, HTML5, CSS3, Bootstrap, Java, JavaScript, jQuery, JSON, AJAX, Matplotlib, PyTest, SVN.
Confidential, Greensboro, NC
Informatica Developer
Responsibilities:
- Requirement gathering from customer.
- Understanding the business rules & developing the logic for same.
- Coordinating the requirement to the offshore team.
- Developing the mappings, sessions and workflows.
- Developed Informatica Mappings using Designer, analyzed the mappings using debugging.
- Successfully ran the mappings using Workflow in different environments.
- Used Informatica PowerCenter to connect to different data source. Also ingested XML using WSDL files.
- Fixed issues in non-compliant WSDL files for easy ingestion into Informatica.
- Automated the process of testing with parallel data load using SQLLoader.
- Wrote complex SQL queries to validate the Informatica code and target data out from Transformation process.
- Developed the process of sending automatic summary details (e-mails) about the load to business and product owners.
- Guiding dependent team with proper data and suggesting quick fixes to them.
- Created procedures and triggers in SQL to identify the errors and pinpoint the same in XML.
- The go-to report was developed to check all the issues occurred during the load.
- Testing/documenting of the developed Mappings.
- Analyzing the data issues reported by the user.
Environment: Informatica, PL/SQL, Oracle.
Confidential, Irving, Texas
BOXI/BOBJ Developer
Responsibilities:
- Requirement gathering from customer.
- Development of BOBJ reports.
- Integrating HTML code into BOBJ reports for easy access and creating ToolTip for users on report.
- Developing data sources/repo based on different reports.
- Mentoring client-side representative with BOBJ development work.
- Testing/documenting of the developed reports.
- Coordinating the requirement to the offshore team.
- Analyzing the issues reported by the user.
- Training the client about Ad-hoc reporting & providing functional knowledge about the tool.
Environment: HTML5, CSS3, PL/SQL, Business Objects X, XI.
Confidential
OBIEE/Informatica Developer
Responsibilities:
- Technology stack used for development is BOXI3.0 webi for Reporting, Informatica for ETL and oracle database and Java as front end tool used
- Enhancement of the code, as per user requirement.
- Modifying existing mapping/ Mapplet.
- Use of slowly changing dimension type 1 and type 2.
- Creation/Modification of various transformations like SQ transformation, Expression, Lookup, Aggregator, Update Strategy, Sequence Generator, Joiner, Filter, Router etc.
- Use PL/SQL for verification of data.
- Use of Reusable transformations, mapplets, reusable sessions to avoid duplicate code, reduce development time and minimum storage utilization.
- Migration of code from EXT to SIT. Preparation of SIT Release notes and test cases.
- SIT Testing, preparation of SIT test cases.
- Preparing UAT release notes. Maintaining UAT release notes and release objects on Subversion.
- UAT testing.
- Getting User approval for production release.
- UAT support and maintenance.
- Preparing Design document, based on the requirement.
- Development of the reports based on requirement.
- Preparing Test cases for different scenarios.
- Performing unit testing of all components of code.
- Production Support after deployment of the code in Production.
Environment: OBIEE, Business Objects XI (BOXI), Informatica, Oracle 10i/11g, PL/SQL
Confidential
OBIEE/Informatica Developer
Responsibilities:
- Creating /Editing OBIEE dashboard, pages and report.
- Granting permission to user to access reports or dashboards. Applying security.
- Testing individual modules of the software against the Unit test cases.
- Classification and reporting the bugs to the Project Lead.
- Migrating the developed objects from Development to Production Environment.
- Setting up SVN configuration and update SVN related document on server.
- Migration of application from one production box to another Production Box.
- Created SQL loader Scripts to load data into the temporary staging tables.
- Preparation of technical specification document for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables in Data Marts and defining ETLstandards.
Environment: OBIEE, PL/SQL, Oracle 10g, Informatica.
