SUMMARY:

• May times hired for any role and worked as needed (flexible).
• Manager’s words Krupal is excellent at Agile, Research & customer relation.
• Fast track professional with successful and diverse background as Project Manager, Azure DevOps Administrator, Project Lead, Oracle Discoverer Administrator, Developer, Data / Business Systems Analyst, Programmer.
• Data warehouse, Data dictionary, Cherwell CMDB (Configuration Management Database), data mapping.
• Experience in Black Box, White Box, Functionality, System, Integration, Smoke, Boundary, Regression Testing etc.
• Excellent experience and knowledge of software development life cycle (SDLC), Waterfall, Hybrid (Agile + Waterfall), CICD (CI/CD), CMM, ITIL, ITSM.
• Knowledge of finance, economics and general business management etc.
• Record of achievement for delivering innovative Business solutions on time.
• Enthusiastic to learn and work new technology.
• Excellent verbal, written communication, and problem - solving skill.
• Was Member of PMI (Project Management Institute) & knowledge of PMP.

SOFTWARE SKILLS:

Tools: Azure DevOps, Balsamiq, MS Project, SQL*Plus, OEM (Oracle Enterprise Manager), Clear case, Harvest Workbench, MS Office (Word, Excel, Access), Rational Rose (UML), MS Visio, TOAD, SQL Navigator, Oracle Discoverer, Adobe Acrobat & others.

Database Applications: Oracle 10g/9i/8i/8 (SQL, PL/SQL), SQL Server (TSQL), MS Access, Progress

Server Utilities: SQL*Loader

Operating Systems: UNIX (HP, AIX, Sun Solaris), UNIX shell scripting, Linux, Windows, Mac OS

ERP: SAP R/3 (ABAP/4, MM, Finance), Oracle 11i

Cloud: Microsoft Azure DevOps

Project Management: Agile Project Management, Agile Application Development, Agile Methodologies

Languages: (Long ago - JAVA, C, C++, VC++, UML, SDL, ABAP/4, VB)

Web Development: (Long ago - ASP, HTML, DHTML, XML, VB script, Java script)

PROFESSIONAL EXPERIENCE:

Confidential, Tallahassee, FL

Agile Project Manager

Responsibilities:

• Follow Agile Manifesto principle#5 - Build projects around motivated individuals. Give them the environment and support they need.
• Ability to link business consequences to a project's progress, goals, functionality, cost/benefit and recommend appropriate courses of action.
• Serves as a liaison between the business community and the IT organizations (all 5 organizations) to provide technical solutions.
• Helps in creating a build pipeline and a release pipeline using Microsoft Azure DevOps (as an Azure DevOps Administrator) to achieve cloud based automation.
• Helps in writing a document how to create a build and release pipeline using Microsoft Azure DevOps resulting in easy training to other team members.
• Liaison between all cross-functional team members (including managers, enterprise architecture, technical team, QA, Release team).
• Created Personal Access Tokens, Agent Pools for DEV, QA and PRD environment for development and DBA team using MS Azure DevOps.
• Keep Release team & development team informed on plan, decision, timeline; have meetings regularly with teams to drive the migration and to help get resources they may need.
• Leading the development and refinement of project requirements, estimates, plans, schedules and implementations.
• Use the .Net forum meeting to communicate about plans.
• Other duties as assigned as required to complete the project & go for CD (Continuous Deployment).

Project Manager / Project Lead

Confidential

Responsibilities:

• Responsible for writing notes, agenda, action items discussed in each meeting about tools, process improvement, framework and different ideas.
• Manage, motivate and lead project teams to meet project objectives.
• Ability to link business consequences to a project's progress, goals, functionality, cost/benefit and recommend appropriate courses of action.
• Make a spreadsheet using Excel for collecting all tools’ names (use & want to use within departments’ different organizations), main function, purpose, license detail and many other columns as needed resulting in better communication.
• Bring idea of adding and added Microsoft Azure DevOps’ Extensions’ name, main function, purpose, which organization used, free or not in the Excel file.
• Final list has 57 software tools & extensions (out of imagination).

Technical Research Analyst

Confidential

Responsibilities:

• Research information to discuss Visioning thoughts and direction - New technologies coming up - Advances and technologies being used in different industries - Trends on application development practices.
• Actively participate in the group discussion of Artificial Intelligence (AI), Progressive WebApp (Blazor), NCLC (No Code Low Code).
• Responsible for NCLC - bring detail about Low Code platforms and gave suggestion which technology to go for. (Used Low Code platform in year 2002 but found huge change).

Application Development Tools Custodian / Support

Confidential

Responsibilities:

• User acceptance testing will be expected before completing production migration.
• Actively participate as an Azure DevOps Administrator as Automated build / release pipeline is the 1st priority of this project.
• Work as part of an implementation team and support as an application development tools custodian.

Project Technical Lead

Confidential

Responsibilities:

• Excellent source to target data mapping resulting in fast and smooth project deliverables.
• Shares knowledge with peers and other project teams.
• Identifies, tracks and resolves project issues and risks.
• Liaison between all cross-functional team members (including managers, technical team, QA, Release team).
• Conduct JAD sessions resulting in fast development and excellent managers’ satisfaction.
• Demonstrated ability delivering highly complex projects on time, on budget and with expected scope at a high level of quality.

Azure DevOps Administrator

Confidential

Responsibilities:

• Responsible for adding new users, users’ role (reader, contributor, administrator), project team members and create projects in Azure DevOps (prior Visual Studio Team Services - VSTS).
• Responsible for auditing users / projects in Azure DevOps every 6 months / yearly to ensure up to date (separated employees no longer in the system - delete user from Azure DevOps) & old projects should move to Attic project.
• Assist developers with Azure DevOps when needed & troubleshoot any issues.
• Write documents about Azure DevOps clean up (users, projects) procedure, Azure DevOps detail etc.
• Coordinates with B&A (Budget & Accounting) for MSDN licenses for new developers.
• Manage 5 organizations as an Azure DevOps Administrator - ISP (Information Services Program), CSE (Child Support Enforcement), GTA (General Tax Administration), EXE (Executive Support Program) and PTO (Property Tax Organization).
• Download free Extensions from Marketplace for different organizations with/without developers’ or managers’ request.
• Initiate meeting among developers and me to move unused code to Attic project resulting in saving of developers’ and managers’ time.
• Figure out all the DevOps accounts do not have Azure AD (Azure Active Directory) permission by contacting Azure Administrator.
• Assign correct email address (network email - office 365 email) to new accounts by selecting of “work account” instead of “personal account”.
• Convert all the DevOps accounts over to use Confidential single sign on instead of using “personal account”.
• Train colleagues and Enterprise Architect to have a back up in the future of Azure DevOps administrator.
• Actively participate in getting CI (Continuous Integration) which is the main goal of Azure DevOps.

Project Manager / Research Analyst

Confidential

Responsibilities:

• To decide the best automated code review tool for .NET development. Team comprised of the representatives of 5 organizations (GTA, CSP, ISP, PTO, EXE) who use .NET and enterprise architects.
• Research automated code review tools online by reading its features and make comparison chart to decide the tool.
• Collect information from developers, architects during the meeting and finally compare with price to make final decision.
• Collect information at the start of each month by email, websites, autogenerated emails and put them in Excel spreadsheet.
• Interact with different departments / groups and then send updated Excel spreadsheet to Budget manager & Financial Management group.

Technical Assistant to Manager / Business Process Consultant

Confidential

Responsibilities:

• Business process improvement recommendation.
• Work as a substitute project manager when project manager is on a vacation.
• Assist Core Process manager with scheduling, creating agenda for facilitating and keeping record of bi-weekly .Net Forum discussion meeting.
• Follow up on action items and tasks related to the .Net Forum meetings.
• Assist Core Process manager in determining training topics that need to be presented to web application developers, secure presenters and coordinate with resources to ensure data needs and materials are ready and distributed.
• Coordinate revision and baselining of development standards/guidelines: ABAP, .Net and others as required.
• Audit software development process related activities to ensure staff is in compliance with standards and guidelines.
• Librarian of the Core Process SharePoint sites.
• Technical contact for other Core Process tools to include Azure DevOps, Balsamiq, and others.
• Responsible for researching new tools and options based on Core Process staff needs working with an assigned team.
• Responsible for providing timely updates to team members and managers for assigned tasks.
• Assist Core Process with process documentation as required.

Software: Azure DevOps, Balsamiq, MS Excel, MS Word, Windows 10, Cherwell (desktop application not through URL)

Confidential, Tallahassee, FL

Portfolio Manager / Equity Analyst / Self Investor

Responsibilities:

• Analyze corporation reports by reading financial statements.
• Interact with clients for status of the account resulting in excellent client satisfaction.
• Develop, monitor and implement portfolio strategies.
• Evaluate portfolio risk to reward.
• Broad understanding of global investment markets and an ability to discuss technical topics in concise terms.
• Forecast fundamental performance for various company stocks.
• Focus on macro and micro economics.
• Act independently and change portfolio strategies as required.
• Successful performance track record.

Software: MS Excel, MS Power Point, MS Word, Windows 7

Confidential, Tallahassee, FL

Sr. Business Analyst / Data Analyst

Responsibilities:

• Reviewed data migration spread sheet (written by vendor) and gave feedback and resolved issues using data dictionary of legacy system, SQL server and MS Excel.
• Attended meetings of UAT (User Acceptance Test) questions review, UAT training seminar, sprint demo of the software, data migration summit etc.
• Performed UAT in different phases like 1, 2, 3 platinum etc. using BRV questions and old tickets resulting in better software quality.
• Performed UAT using Monster’s job seeker registration, employer registration and social solution’s case management including touch points.
• Reviewed BRV (Business Requirement Validation) document.
• Created BRV questions using documents, tickets (created during UAT 1st phase) resulting in more test criteria.
• Met cross functional groups like SMEs (Subject Matter Experts), vendor team, managers, data analysts, DBA to ensure project in a right direction.
• Reviewed data dictionary and mapped it with tables to send to a vendor using RDBMS (Relational Database Management System) concepts.
• Performed UAT and raised ticket resulting better software quality.
• Attended sprint demo of a website, data migration summit, FLE (Front Line Expert) familiarization summit and gave suggestions, feedback and resolved issues.
• Reviewed ETO (Efforts to Outcome) (vendor - Software Solutions) documents, and raised questions using spreadsheet and collected questions from team resulting in better documents.
• Attended ETO software demo, gave suggestions resulting improved software quality of ETO.

Software: SQL Server 2012 (TSQL), MS Word, MS Excel, Windows 7

Confidential

Portfolio Manager / Equity Analyst / Self Investor

Responsibilities:

• Analyze stocks quantitatively and qualitatively.
• Develop, monitor and implement portfolio strategies.
• Evaluate portfolio risk.
• Broad understanding of global investment markets and an ability to discuss technical topics in concise terms.
• Forecast fundamental performance for various countries.
• Focus on macro and micro economics.
• Act independently within established investment policy guidelines.
• Successful performance track record.

Software: MS Excel, MS Power Point, MS Word, Windows 7

Confidential, Chandler, AZ

Sr. Business Analyst

Responsibilities:

• Wrote DSD (Design Specification Document) using SOW (Statement of Work) created by Key Engineer (Project Manager) using MS Word and MS Excel.
• Created Clear Quest request for project initiation using Rational Rose which will be assigned to Project Manager.
• Interacted with different group of people like external customer, project manager, developer, QA etc.
• Verified and validated inbound and outbound files by reviewing them using standard file formats or proprietary file formats using UltraEdit.
• Arranged JAD (Joint Application Development) / JAR (Joint Application Requirements) sessions by arranging conference calls and net meetings resulting in excellent understanding of requirements.

Software: MS Word, MS Excel, Windows XP, Rational ClearQuest, UltraEdit

Confidential, Tucson, AZ

Sr. Technical Data Analyst

Responsibilities:

• Building the data warehouse from SAP R/3 tables using Informatica for different reports.
• Wrote technical specification (Source to Target mapping) file using Transformation Rules and database tables (using TOAD 9.1 - connected with Oracle database).

Software: Oracle 10g, TOAD 9.1, Documentum, MS Word, MS Excel, Informatica, Cognos, Oracle Discoverer

Confidential, Phoenix, AZ

Sr. Business Analyst / Data Movement Analyst

Responsibilities:

• Wrote ETL (Extract Transform Load) requirements specifications using Data Warehouse model (Oracle 10g) and meeting with SMEs (Subject Matter Experts).
• Created process flow charts using MS Visio.
• Suggested solution to resolve different kinds of issues and better documentation.
• Got training on HIPAA (Health Insurance Portability and Accountability Act) privacy Awareness and security resulting in worked in HIPAA compliance environment.
• Responsible for reviewing SOW (Statement of Work) resulting in better understanding of a project and budget.
• Documented customer requirements and conducted gap analysis by creating questions answers document.
• Met director of CPP (Center for Project Performance) to give detail status of project.

Software: MS Access 2003, Telelogic DOORS 8.1, MS Visio 2003, MS Word, MS Excel, Windows XPSourcceForge 4.3, Oracle 10g

Confidential, Chandler, AZ

Sr. Business Analyst

Responsibilities:

• Wrote requirements for files extract using DFD (Data Functional Design) document using MS Word.
• Attended conference calls and net meetings for different kinds of documents review like DFD (Data Functional Design), CDH requirements, design etc.
• Created flow charts using MS Visio.
• Developed tables (files) relationship charts using MS Visio to show detail RDBMS concepts.
• Suggested solution to resolve different kinds of issues.
• Wrote SQL (filter, join etc.) statements using RDBMS concepts as part of requirements.
• Interacted with different group of people like data analyst, business people, architect, project manager and off shore team in India etc.
• Reviewed and discussed S-T (Source to Target) mapping file with architect and data analyst resulting in excellent requirement document.
• Arranged JAD (Joint Application Development) / JAR (Joint Application Requirements) sessions by arranging conference calls and net meetings resulting in excellent requirement gathering.
• Used Rational ClearQuest as defect tracking tool.

Software: MS Visio 2003, MS Word, MS Excel, Windows XP, Rational ClearQuest

Confidential, Jacksonville, FL

Sr. Business Systems Analyst

Responsibilities:

• Created and modified impact analysis, technical specification, and data mapping documents for each CR (Change Request).
• Modified move log which were created by developers and passed it to operations team.
• Created job dependency chart using MS Visio by checking job dependency using Linux using PowerBroker, Autosys (product from Computer Associates) for different boxes.
• Extracted necessary files from Linux to PC using WinSCP3 FTP.
• Created and run JIL (Job Information Language) file on Linux using Autosys command to change job dependency, to create a job, box and schedule.
• Resolved spool space (for teradata database) issue by modifying job dependency timing.
• Resolved issues and gave solutions to developer like spool space in teradata database, swapping column values.
• Tested CRs (Change Requests) in test, UAT and production environment once developer modified the script using Oracle 9i, SQL Navigator, Rapid SQL, Linux, Autosys, and Power Broker.
• Wrote unit test plan using mapping document and database (Oracle 9i) tables.
• Reviewed xfr files of Ab Initio modified by developers.
• Converted functional requirements, business requirements into technical requirements resulting in excellent development.
• Created relationship chart among tables using Erwin by reverse engineer concept.
• Reviewed BRD (Business Requirements Document) and created technical specification, data mapping, and script and discussed the solution with developers.
• Created CMR (Change Management Request) using Peregrine service center.
• Reviewed Gantt Chart to see WBS (Work Breakdown Structure) for multiple projects deadline using MS Project.
• Modified PL/SQL code of stored procedures according to change in different kind of requirements like add column and add data to new column.
• Developed and executed create table script using SQL Navigator.
• Created index for better performance.
• Done PPV (Post Production Verification or Validation) or PIV (Post Implementation Validation) once change goes to UAT and production.
• Created DCR (Data Change Request) to insert, update or delete data one time in a table once it is in UAT or Production.
• Attended CAB (Change Advisory Board) meeting to get approval for production.
• Created and executed test cases / test scripts using MS Excel, Oracle, and SQL Navigator.

Confidential, Tallahassee, FL

Sr. Business Systems Analyst / Oracle Discoverer Administrator / Developer

Responsibilities:

• Interaction between senior business people and technical team.
• Actively involved in process of reviewing documents written by vendor (HCL - Hindustan Computers Limited) company and gave corrections and excellent suggestions to achieve best SDLC (Software Development Life Cycle).
• Trained customers in the area (Oracle 10g, TOAD) which they need training resulting in excellent customer satisfaction.
• Verified and validated data using SQL query and OSMIS application to test changes done by programmer.
• Tested incremental refresh procedures by inserting data through beta or development application and verified in beta or development ad hoc database.
• Verified and validated data between Oracle procedure and data stage by Oracle SQL and text file from data stage procedure.
• Worked as an interface between customers and developers.
• Performed JAD / JAR (Joint Application Development / Joint Application Requirements) sessions for RAD (Rapid Application Development).
• Got relationships of tables using MS Visio by connecting to the Oracle database to understand system better.
• Analyzed and verified the reports’ data developed by developer using Discoverer Viewer.
• Checked data discrepancy between beta, production and ad hoc (data warehouse) database.
• Provided day-to-day operational support of production systems for problem identification and resolution.
• Prepared and executed comprehensive application test plans and other documentation.
• Provided input to technical standards and systems and participate in continuous process refinement and improvement.
• Inspired customer confidence through professional presence and self-confidence
• Gave proper privileges to Discoverer users using Discoverer Administrator as EUL (End User Layer) user.
• Created joins, brought tables and views to different business areas using Discoverer Administrator in Ad hoc (data warehouse) requested by users of Discoverer Plus for data warehouse reports.
• Generated reports using Oracle Discoverer Plus (web version and desktop version) for customers (from different departments of government).
• Trained co-employees in Oracle Discoverer Administrator, Plus & Viewer.
• Resolved different kind of WO (Work Order), CR (Change Request) according to priority using Oracle SQL, PL/SQL, TOAD, Oracle Discoverer etc. resulting in customer (OSPS) satisfaction.
• Added views, tables to Discoverer from Oracle database using Discoverer Administrator.
• Changed and cleaned up data according to requirements using TOAD.
• Created index on procedure to execute procedure faster.
• Resolved issues of Oracle Discoverer reported by end users.
• Loaded data from data file to Oracle table using SQL Loader, TextPad to combine some of the features of peoples first (legacy system) to OSMIS.
• Resolved different kind of issues related to Oracle Discoverer like exporting to Excel etc.

Software: Oracle 10g (10.1.0.2.0 ), SQL, PL/SQL, SQL* Plus, SQL* Loader, Oracle Business Intelligence Discoverer (Viewer 9.0 (9.0.4.43.15 ), Oracle Discoverer Administrator 10g (9.0.4.00.00 ) (desktop version), Plus (9.0.4.00.00 ) (desktop version)), TOAD 8.0.0.47, Win XP Professional, MS Outlook, MS Visio 2003, MS Office (MS Word, MS Excel), Track it, TextPad 4.7.3