PROFESSIONAL SUMMARY:

• A technologist having more than 13 years of experience in development and maintenance projects in variety of industries like manufacturing, hospitality and property mgmt.
• Excellent assertive communicator: leverage technical, business and financial acumen to communicate effectively.
• Mentored various teams in terms of requirement gathering, architecting solutions and technical glitches.
• Project and portfolio management, People leadership, Solution planning and system architecture

SKILLS:

• Expertise in leading and managing multiple parallel projects both in Agile and Waterfall methodologies.
• Possesses extensive hands on software development /deployment experience till date in delivering critical projects with variety of tech skills.
• Experienced in architecting new solution for business requirement.
• Expertise in managing large teams spread across multiple geographies ensuring high - quality deliverable within required timeline and cost constraint. Proven mentoring skill towards team excellence and individual resource performance.
• Expert in identifying areas of critical business process improvements and automation.

TECHNOLOGIES:

DW & BI Report: GCP - Big Query, Spanner, Bigtable, Cloud SQL, Pubsub, Looker report, PowerBI, SSRS, SSIS, BIRT Actuate, Jasper/Talend ETL & Informatica PowerCenter

RDBMS: Oracle 12C, SQL Server, MySQL & PostgreSQL

PL/Framework.: Python, JQuery, Shell Scripting, Perl Script, Java Script, Oracle Mod-PLSQL, PL/SQL, JSON

PPM / AGILE Tools.: CA Clarity PPM, JIRA, Trello, Confluence, EasyRedmine & Redmine

Software: PyCharm, Jupiter, Toad, Eclipse, VSCode and DBeaver

CI/CD: Jenkin, Git & SVN

INTERMEDIATE: Snowflake Cloud DW, Info-work ETL, Hive and HBase

FUNDAMENTAL: AWS, Azure, Oracle Cloud and Autonomous DatabaseGraph Database

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Analyzed the business requirement and discussed about kind of the insights can be produced using PowerBI.
• Setup the DEV environment @ cloud with Azure SQL Server service as Datawarehouse and SSIS as ETL.
• Created the data model for the reporting by analyzing the customer data and the current application database.
• Screened profiles and setting up the offsite team who can deliver this solution.

Confidential, Las Vegas, NV

Software: Jira, Confluence, TRELLO, Toad, SVN, Git, Jenkin, VSCode, Talend ETL, Redmine, Easyredmine and FileZilla

Skills: SQL/PLSQL, JavaScript, AJAX, JQUERY, Restful API, GCP, BigQuery, Looker, Python, SSIS and Jasper report

Tech Lead and Senior Software Developer

Responsibilities:

• Managed a global team across multiple regions of 10 onsite and 30 offsite folks across multiple projects geared towards product delivery excellence with the portfolio size > $10 Million / Yr.
• Prepared scrum metrics like burndown charts, velocity charts, estimation accuracy %, resource loading etc. for getting a quantifiable status of the portfolio for better decision making. Facilitated sprint planning, daily standups, sprint reviews, sprint retrospectives and release planning.
• Implemented JIRA for prioritizing the task assignment for our projects. Integrated agile boards and readily available reports helped for better planning, roadmap and decisions. Introduced Confluence for data governance project activity for centralized documentation.
• Experienced in database native json features like json table, json array, json value, json query, json exists.
• Delivered automated unit test scripts in PLSQL to test our delivered code for better regression testing coverage.
• Setup training and peer-mentoring program for the existing and new hires for the team; reduced technical debt by 30% and reduced onboarding time for new hires by 80%.
• Screened resumes and interviewed resources for the team for both onsite and offsite team augmentation.
• Executed proposal for migrating OBIEE reports to Jasper by saving the licensing cost of amount ~ 90K per year. Implemented multilanguage feature of the legacy application. Optimized and secured application with best practices.
• Worked with product owners for effective product management using story mapping techniques.
• Experienced in Google cloud / Looker project for advanced analytics initiative. Prepared the team with new skills so that they can help in this new project. Ingested data by pipelines using dataflow and orchestrated using airflow in GCP to ingest data from data lake to BigQuery by referencing on-premise database.
• Performed pre-sales POCs for snowflake DW product for one of prospect client by hosting it in Google Cloud.
• Modeled flat wide tables with nested columns in BigQuery dataset to generate insights.
• Successfully completed workshops by infoworks and looker. Expertise in view, explore and look ML models on looker tool. Delivered looker dashboard components such as look, model, view with dimension, dimension groups, tiers, drilldown reports and interacting with Looker restAPIs for custom visualization.
• Maintained a well updated knowledge repository of functional understanding and development best practices to avoid single point of failure.
• Provided solution to client to meet their budget needs with innovative open source IT solution and managed the project with onsite/offsite team. Designed API to run reports in jasper server from legacy application.
• Engineered POCs showcasing jasper reporting capabilities of customized reports and dashboards which was a opensource solution to meet budget needs.
• Developed Restful API interface using python between 2 legacy application for incident and timesheet management.
• Architected PostgreSQL DB objects like UDFs and linked servers for data integration for data archival solution.
• Expertise in performance tuning and trained the team to avoid the similar situation.

Confidential, Holtsville, NY

Tech Lead & Subject Matter Expert

Skills: MS SQL Server 2005, Oracle 10g, PLSQL, actuate, Oracle Apex, Toad, actuate, FileZilla, shell scripting, BMC Footprints

Responsibilities:

• Single point of contact as “Subject matter expert” for Actuate reporting and Getpaid (Collection tool from SunGard Technology) application support and enhancement project (RUN/BUILD team)
• Proactively consolidated the improvement areas and planned to create a project with senior management to make production system healthy. Took care of product feature deployment and change management process.
• Created software architecture and detailed technical design for the assigned projects.
• Extensively used Informatica client tools; Source Analyzer, Warehouse designer, Mapping designer
• Developed different mappings by using transformations like Aggregator, Lookup, Expression, Joiner, Router etc.
• Provided project health reports and strategize to improve the reporting needs with management update.
• Attained 100% SLA expectation, reduced ~30% cost for supporting the application.
• Automated repeated activities and implemented PMP best practices to make production health better and improved support calls / issues substantially by 40%. Supported Unit tests and SIT by fixing any bugs using HP Quality Center.

Confidential, Denver, CO

DW and BI Developer

Skills: MS SQL Server 2005, SSIS, SSAS, SSRS, MS Access 2003, Toad, MS SharePoint Portal, BMC Footprints

Responsibilities:

• Designed solution for revenue managers for their unique analytics need to pricing the apartment units.
• Created SSIS packages and scheduled it to upload data from a particular spreadsheets and XML files to the SQL Server table periodically.
• Established SSAS cubes for team reporting need.
• Developed macros using VBA to format the reports. These reports were uploaded to SharePoint and emailed to specific recipients periodically.
• Expertise in MS Office suite for any quick reporting needs.
• Peer Reviewed the code, demoed the final visualization and validated the data with the stakeholders.
• Setup periodic calls with SMEs to provide status update and risks.