Over 8 years of variable track record of managing complex IT projects, as a Sr. Oracle SQL , Data analysis and Tableau Developer with experience in Analysis, Design, and Implementation of Business Applications. Experienced in designing and development of Tableau visualizations and creating business requirement documents. Extensive experience in Performance tuning of reports and resolving issues within Tableau Server and Reports. Experience in Data Migration across various databases. Well-versed in different stages of the Software Development Life Cycle (SDLC). Practiced in clarifying business requirements, performing gap analysis, designing process and system improvements to increase productivity and reduce costs. Strong interpersonal skills facilitating discussions and negotiations with stakeholders.
Project Managment : Agile, Waterfall, Management of Cross-Functional Teams
Process Mapping
Data Analysis
Technical Analysis
T-SQL coding
Code reviews
Enterprise application integration
Software Tools: Eclipse, PyCharm, MS Office, Radar - Bug Tracking Tool, Espresso - Bug Tracking Tool, Various Apple in-house tools
Education
IITMGwalior, India, Expected in 2011 – –Bachelor of Engineering:Computer Science And Programming - GPA:
SSVM School, Expected in 2004 – –High School Diploma: - GPA:
Work History
Bmo - Data Analyst Virtual, MT, 01/2019 - Current
Coordinated statistical data analysis, design, and information flow.
Developed database objects, including tables, views and materialized views using SQL.
Synthesized current business intelligence data to produce reports and polished presentations, highlighting findings and recommending changes.
Researched and resolved issues regarding integrity of data flow into Oracle and Mongo databases.
Transformed project data requirements into project data models.
Built library of models and reusable knowledge-base assets to produce consistent and streamlined business intelligence results.
Created various Excel documents to assist with pulling metrics data and presenting them to give concise understanding of best placement for needed resources.
Documented business workflows for stakeholder review.
Corrected any data entry error to prevent later issues such as duplication or data degradation.
Investigated and addressed "Contract Life Cycle Management" system issues to enhance usability and improve functionality.
Performed system analysis, documentation, testing, implementation and user support for platform transitions.
Recommended data standardization and usage for protection of data integrity.
Designed and developed schema data models.
Trained employees on Tableau, SQL for improved data management, monitoring effectiveness and suggesting improvements.
Evaluated consistency and importance of different business intelligence data against needs to determine optimal courses of action.
Identified and documented detailed business rules and use cases based on requirements analysis.
Identified and documented project constraints, assumptions, business impacts, risks and scope exclusions.
Participated in requirements meetings and data mapping sessions to understand business needs.
Compiled, evaluated and reviewed engineered data integrated to "Contract Life Cycle Management" system.
Bmo - Data Analyst Virtual, OR, 02/2017 - 12/2018
Coordinated statistical data analysis, design, and information flow.
Developed database objects, including tables, views and materialized views using SQL.
Synthesized current business intelligence data to produce reports and polished presentations, highlighting findings and recommending changes.
Researched and resolved issues regarding integrity of data flow into Oracle and Mongo databases.
Transformed project data requirements into project data models.
Built library of models and reusable knowledge-base assets to produce consistent and streamlined business intelligence results.
Created various Excel documents to assist with pulling metrics data and presenting them to give concise understanding of best placement for needed resources.
Documented business workflows for stakeholder review.
Corrected any data entry error to prevent later issues such as duplication or data degradation.
Investigated and addressed "Contract Life Cycle Management" system issues to enhance usability and improve functionality.
Performed system analysis, documentation, testing, implementation and user support for platform transitions.
Recommended data standardization and usage for protection of data integrity.
Designed and developed schema data models.
Trained employees on Tableau, SQL for improved data management, monitoring effectiveness and suggesting improvements.
Evaluated consistency and importance of different business intelligence data against needs to determine optimal courses of action.
Identified and documented detailed business rules and use cases based on requirements analysis.
Identified and documented project constraints, assumptions, business impacts, risks and scope exclusions.
Participated in requirements meetings and data mapping sessions to understand business needs.
Compiled, evaluated and reviewed engineered data integrated to "Contract Life Cycle Management" system.
Wells Fargo Bank - PLSQL Developer Bannockburn, IL, 03/2012 - 02/2017
Improved application performance by determining root cause of issues and resolving.
Generated, debugged and enhanced existing reports with introduction of new system features.
Developed custom database objects, stored procedures and delivered application support.
Implemented system enhancements to propose, design and develop solutions to fulfill requests and address problem reports.
Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements.
Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
Incorporated extensive familiarity with Contract Life Cycle Management for data management and backup and recovery accountability.
Supported multiple concurrent projects enabling delivery efficiencies and technical resolution.
Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
Developed, implemented and optimized stored procedures and functions using T-SQL.
Documented and analyzed business reports for prompt communication, follow-up and ongoing support.
Built useful reporting deliverables to properly document analysis results and provide performance improvement feedback.
Devised high-quality database solutions ranging in size and complexity, increasing productivity and improving data sharing.
Created optimal technical solutions to user needs through research and in-depth system analysis.
Prepared memory management for database systems.
Reviewed and interpreted business report requirements to address user needs.
Analyzed existing SQL queries to identify opportunities for improvements.
Produced high-standard database solutions to meet stability, reliability and performance metrics.
Drove data analysis, resolving complex business issues and proposing long-term system solutions.
Designed and implemented TSQL queries for reporting and complex solution development.
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
