PROFESSIONAL SUMMARY:

• 6 years of experience as a Web Application Development/Support of Software Applications using Python, C/C++, SQL and Java.
• Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools, ETL Process (Data Extraction, Transformation and Load) with PL/SQL Stored Procedures, Data Stage.
• Good Experience with Django, a high - level Python Web framework.
• Expert in creating Clustered and Non-Clustered Indexes to improve the performance of the SQL queries.
• Experienced in developing web-based applications using Python, Django, Java, C++, XML, CSS, HTML, DHTML, JavaScript and JQuery.
• Having experienced in Agile Methodologies, Scrum stories and sprints experience in a Python based environment, along with data analytics, data wrangling and data extracts.
• Good experience in creating Stored Procedures, User Defined functions, Triggers and writing sub-queries to simplify complex queries involving multiple tables.
• Good knowledge of Apache Tomcat, Web logic, various Design Patterns and UML.
• Good knowledge in Amazon AWS concepts and EC2 web services.
• Experience in designing and deploying data visualizations using Tableau 8.x & 9.x.
• Experience in Dimensional Modeling, Designing of star, snow flake schemas.
• Experience in interacting with various business stakeholders and able to gather the business specifications and translate into data visualizations for effective decision making.
• Experience includes technical support, troubleshooting, report design and monitoring of system usage.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Actively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Optimized SQL Queries in stored procedures to meet batch processing SLAs.

SKILL SET SUMMARY:

Operating systems: LINUX (Red hat5/6/Fedora/Suse/CentOS), AIX and Windows Family.

Programming Skills: PL/SQL, C, C++, Java, Bash, Python, HTML

Visualization Tools: Tableau Desktop 7.x, 8.x, 9.x, Tableau Server, Business Objects Xcelsius 2008.

Databases: Teradata, Oracle, DB2

Application Server: CVS server, Web server (Apache/Web Sphere/Web Logic/Tomcat), Webmail, SQUID.

PROFESSIONAL EXPERIENCE:

Confidential, VA

Python/SQL developer

Responsibilities:

• Analyzed the Business Requirement Documents and created the technical specification documents.
• Implemented business logic in Python to prevent, detect and claim the duplicate payments.
• Re-engineered various modules for implementing changes and created efficient system.
• Created Map Reduce programs in Python to reconcile the payment history and account payable files.
• Implemented code to create dynamic claim reports after auditing using PyJasper.
• Developed dynamic web pages to view the reports generated using Django Framework.
• Developed entire frontend and backend modules using Python on Django Web Framework.
• Used Django configuration to manage URLs and application parameters.
• Build all database mapping classes using Django models.
• Developed Python scripts to parse XML documents and load the data in database.
• Worked with JSON based REST Web services and Amazon Web Services.
• Used Jenkins to deploy your Django application and run unit tests.
• Developed entire frontend and backend modules using Pythonon Django Web Framework.
• Developed tools using Python, Shell scripting, XML to automate some of the menial tasks.
• Created Business Logic using Python to create Planning and Tracking functions.
• Developed the required XML Schemas and implemented the framework for parsing XML documents.
• Used JQuery and Ajax calls for transmitting JSON data objects between frontend and controllers.
• Used Github for version control.
• Build development environment with JIRA.
• Designed and configured database and back end applications and programs.
• Created Views and developed Stored Procedures, Functions and Triggers.
• Participated in Daily Stand-up meetings and provided status on work progress.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions in Teradata and DB2.
• Changed stored procedures during the platform migration from DB2 to Teradata.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing and shrinking of databases and regular monitoring.
• Created many reports which include Drill down Report, Linked Report, Log Reports and Sub Reports.
• Worked with Business Analysts and functional teams to resolve incidents in a timely manner.

Environment: Python, Django, MySQL, HTML, JavaScript XML, JIRA, Jenkins, JSON, PyJasper, PyMongo, MongoDB, Tableau, AWS EC2 and Elastic Map Reduce

Confidential, CA

ETL/Tableau Developer

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements.
• Involved in reviewing business requirements and analysing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analyse projects within Tableau.
• Worked closely with business power users to create reports/dashboards using tableau.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Involved in creating advanced Tableau functionalities such as geographic mapping, data blending, extract optimization to create advanced chart types and visualizations.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Connected Tableau server to publish dashboards and visualizations to central location for portal integration.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations; and created test cases and documented the test results.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Created Stored Procedures using nodes method to load XML file data into SQLserver tables.
• Created packages using the various control flow task such as data flow task, executeSQLtask, Execute package task, File System task.
• Created logic and indexed tables/views/ Stored Procedures based on the business requirements.
• Experienced solving issues raised by QA, UA for database, supported the different UI with back end logics, and wroteSQLcodes to summarize the data.
• Imported and exported data into MS Access databases and Debugged VBA scripts linked to said databases.
• Created database objects like tables, users, roles,storedprocedures, triggers, worked on solving issues by doing data recovery in existing database.
• Used various formatting techniques like interactive sorting, grouping to created user friendly reports.
• Created Views to enforce security and data customization, Created Non-Clustered indexes to improve query performance and query optimization, Involved in the performance tuning and optimization of T-SQLqueries.
• Developed T-SQLqueries with the help of Stored Procedures, Functions, Triggers, Cursors, Views, and Indexes.
• Optimized SQL Queries in stored procedures to meet batch processing SLA.

Environment: Tableau Desktop 8.x/9, Tableau Server, SAP BIBO 4.0, Design Studio 4.1SP3, Oracle 10g, SQL Server 2008, Informatica 8x, MS Excel, Toad 9.0, Agile Méthodology.

Confidential

SQL Developer

Responsibilities:

• Designed/developed/Modifiedtables, views, materialized view, stored procedures, packagesandfunctions.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.
• Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
• UsedSQL loaderto load the data from the files provided by the interfacing applications.
• Created newProcedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
• Createdpartitioned tablesandpartitioned indexesto improve the performance of the applications.
• WrotePL/SQL Database triggersto implement the business rules in the application.
• Createdexternal tablesto handle huge volumes of data which is not used frequently.
• Optimized lot ofSQL statementsandPL/SQL blocksby analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
• Developed various backend application programs, such asViews, Functions, Triggers, ProceduresandPackagesusingSQLandPL/SQLlanguage for the top management for decision making.
• Implemented all modules logic by usingTriggersandIntegrity Constraints.
• Good understanding of database objects and ability to triage issues.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Createdmaterialized viewsrequired for the application.

Environment: Oracle 10g, PL/SQL