| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate PRIYANKAPAIDA PHONE NUMBER AVAILABLE EMAIL AVAILABLEPROFESSIONAL SUMMARY: . Over 7+ years of industry experience in IT industry, Excellent working experience as Programming with Object oriented technologies, Analysis, Database Administration. . Knowledge of salesforce application. Also done the salesforce admin certification. . Experience in development and configuration of Accela (Govt licensing software). . Developed different EMSE Scripts and Batch Scripts in Accela. . Strong Accela Civic Platform Design & Architectural, configuration, scripting and migration skills. . Strong analytical/problem solving skills. . Developed Oracle Reports using Oracle Report Builder, SAP Crystal Reports, SSRS which is integrated with Accela for Generating Reports. . Experience in Developing the Design Documents for different project using tools such as Microsoft Visio and presenting them to the Client. . Collected the requirements from Business Analyst and come up with design on how to implement them. . Prepared Development Design Documents (DDS) to describe the development process. . Responsibilities include extensive client interaction to understand expectation, requirements, formulating solutions, designing the architecture and developing the application besides managing teams. . Excellent experience participating in the deployment of applications across multiple sites and platforms. . Possesses good experience supporting tactical and strategic goals of the IT Production Support Team. . Skilled in database business analysis, design/integration and development/implementation. . Highly adaptable in quickly changing technical environments with very strong organizational and analytical skills . Good experience resolving system issues and collaborated with IT team members. . Self starter and can work individually as well as can be a good team player. . Possesses good oral and written communications skills. . Preparation, Review and execution of Manual test cases for Functional, Non-Functional, GUI and regression and recording them in ALM. . Arrange and participate in daily scrum meetings, retrospective and backlog refinement meetings. . Generation of test metrics and using them for QA process improvement. . Strong Knowledge in various Software Development Methodologies like Object Oriented Analysis and Design (OOAD), Agile Software Development, Scrum Methodology.TECHNICAL SKILLS:|Programming Languages |C, C++, Java, PL/SQL. ||Products |Accela 9.1.0, 8.3, 9.3.11 etc., ||SQL Databases |MySQL, Oracle, SQL Server. ||Web Development |HTML, CSS, JavaScript, jQuery, XML, JSON. ||Technologies | ||Tools |Eclipse, Oracle SQL Developer, Microsoft SQL || |Server Management Studio ||Web server |Apache. ||Reporting Tools |Ad hoc reporting, Oracle Report Builder, SAP || |Crystal Reports, Power BI, SSRS ||Operating Systems |Windows 98/XP/7/8/10, Mac OS X, Unix, Red-Hat || |Linux. ||Development methodologies |Scrum methodology, Waterfall methodology, Agile|| |methodology |PROFESSIONAL EXPERIENCE:State of Michigan, Lansing MI Jan 2020 - PresentRole: Accela Developer/Report WriterProject Description: worked on Cards, Payments division and benefitsSection. Based on the cards spend, benefits should be calculated. The goalof the project is to implement payment module for agency wide Licensing andInspection system. Payments section of the module is migrated tomicroservices.Responsibilities: . Design solutions that align with the firm's data management principles, policies, standards and best practices. . Worked on Configuration and scripting of different record types in Accela Automation (AA). . Worked with the testing team to resolve defects in the system and performed unit testing. . Worked on Configuration and scripting in Accela Automation (AA). . Translate requirements and generate and develop a roadmap utilizing the best technologies for the project with comprehensive and obtainable milestones. . Develop and deploy dashboards, visualizations and autonomous and dynamic reporting interfaces to be distributed to stakeholders via the BI reporting platform, web portal, mobile, tablet devices, widgets and email. . Optimize report distribution, execution and the scalability of all reporting solutions so they are autonomous and dynamic. . Work with the Data Management team to provide input on logical and physical database design, data modeling and/or mapping. . Generate large and complex data extracts and queries for the Analytical Leads for data analysis by utilizing various database schema such as Microsoft SQL Server, Oracle. . Develop deep knowledge of the business needs of the various stakeholders within Hilton Worldwide (including Hotel Analysts, eCommerce team and Revenue Management). . Work with various Team Members, internal departments and third-party agencies on report business requirements, documentation, timelines, testing, and technical delivery. . Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.. . Created Dax Queries to generated computed columns in Power BI. . Generated computed tables in Power BI by using Dax. . Involved in creating new stored procedures and optimizing existing queries and stored procedures. . Created Azure Blob Storage for Import/Export data to/from .CSV File. . Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports. . Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps. . Explore data in a Variety of ways and across multiple visualizations using Power BI. . Used Power BI Gateways to keep the dashboards and reports up to date. . Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services. . Published reports and dashboards using Power BI.BNY Mellon, Jersey City, NJ May 2019- Jan 2020Role: Power BI Developer/Report WriterProject Description: Workbench application is a central database; it willstore and retrieve different types of customer's data. This applicationleverages several technologies to provide services. It will enable BNYM toreduce applications and operational overhead while providing a singleauthoritative source for customer's data that will be leveraged by nearlyevery LOB and digital horizon use case.Responsibilities: . Involved in Software Development lifecycle of the project. . Work with the functional team to analyze, design, develop, deploy, and support Power BI Reporting to meet business and technical requirements. . Strong analytical, problem solving and synthesis skills; intellectual curiosity and industry knowledge. . Strong SQL skills, including performance analysis. . Strong communication skills with various audiences (written, verbal and listening). . Demonstrated experience delivering effective visualizations to business users. . Strong understanding of relational databases, SQL optimization skills, and OLAP tools. . Strong analytic, problem solving, communication, and collaboration skills. . Strong SQL language development skills and Data Modeling concepts. . Solve technical and data related problems to meet the needs of the business. . Prepare and maintain documentation for reports, metrics, and processes. . Provide feedback on the effort, risks, and resources necessary on potential project initiatives. . Examine the needs and concerns of Analytical Leads to determine opportunities or problem areas and provide feedback in the development of policies, procedures, methods and/or standards. . Develop and maintain constructive and cooperative working relationships with corporate Team Members and various departments within Hilton. . Attend internal and external meetings and address topics of analysis and reportingFire Department of New York City, Brooklyn, NY Jan 2017- May 2019Role: Accela Developer/Report WriterProject Description: FIRES (Fire Inspection Revenue and EnforcementSystem): Fires is a new BFP inspection, revenue and enforcement actiontracking application which will be developed and deployed in Phase III ofCBIDAS. New application will replace the existing FPIMS system. The FIRESproject is a multi-year enterprise initiative to automate the inspection,enforcement action, and revenue work processes for the Bureau of FirePrevention, the Legal Enforcement Unit, and the Revenue Management Unit ofthe FDNY. This entails installing and configuring the Accela product suiteas the core solution to incorporate Fire Prevention, Legal Tracking andRevenue Management into the FIRES, while building all necessary interfacesand replacing legacy systems.Responsibilities: . Involved in Software Development lifecycle of the project. . Used Agile Methodology for developing the project, where developed module is presented to the client every iteration. . Integrated Accela EDMS with Oracle UCM 11g Enterprise Product for storing and managing the documents present in Accela Application. This is done by developing Axis 2 Web services with MTOM support and transferring the document to Oracle UCM using Oracle RIDC (Remote Intra Doc Client) API. . Integrating Accela with third party web services like Pitney Bowes system for validating and formatting the address to mailing address format. Custom EMSE Java Scripts are written for Interaction between Accela and Rest Services developed in Interfaces using Java. Made use of Spring Rest Template to consume services developed by Pitney Bowes. . Developing Batch Jobs using Spring Batch to transfer the data between Oracle 12c Database and Accela using Accela's in built EMSE and SSO Web services. . Integrated FDNY In House ARCGIS Software with Accela to optimize the routes for Inspectors. This results in effective usage of Inspectors Time and Effort. . Developed different Rest API End Points using spring boot framework. . Integrated all the Batch Jobs using Apache Camel 2.2. Different Routes are configured for each batch job, each route will start the job to transfer the Data (available in Different formats) to Accela System. . Developed Custom EMSE Scripts to Process the JSON Data Sent from the different Batch Jobs using EMSE Web Services Provided by Accela. . Developed Page Flow Scripts that are executed in the Accela Citizen Access Public Portal. These scripts are used to pre-load the data to fields from the information already entered by the user in Citizen Portal. . Integrated the Inspection Module of the Accela with the ArcGIS so that an optimized route is assigned to the Inspectors going on field for inspections. This is a batch job which gathers all the inspection related data (Address, Inspector Calendar) and re assigns the inspections in an optimized way every night. . Developing and Scheduling Internal Batch Job Scripts so that they run regularly and process the data and send the appropriate reports or correspondence to the users regularly. . Developed and Deployed Oracle Reports using oracle Report Builder and integrated with Accela so that different Reports are generated as a part of Correspondence/ Internal Review. . Developed Reports using SAP Crystal Reports, SSRS and integrated with Accela and Exported formats includes Word, Excel, PDF and Crystal Report viewer etc., . Developed custom Interface to fill the already build Custom PDF Forms using IText 7.0 using the data in Accela. . Designing the Work Flow for Different Record Types using Work Flow Designer. Configured different work flow tasks and Assigned work flow statuses to each task. This Design is driven by the Business rules. . Designing Forms that Occur in Accela Citizen Portal and Accela Back Office. . Developed Custom Interface API to Extract the Data from Pdf forms and convert them to JSON Data to be Processed by the Accela Application. . Made use of Fork Join Pool to fill the different forms in Parallel using multithreading to improve the processing time. As a result of this all the different forms are populated in different thread and hence improving the processing time. . Used Hibernate as the JPA framework to perform all the data base related operations. Made use of Audit Listeners in Hibernate Framework to update the columns like created date and modified date automatically to the tables whenever changes are made to the Persistence Object. . Apache Shiro is used to Secure all the Rest End Points that are used to invoke different Batch Jobs. . Extensively Made Use of Spring annotations for developing The Application. . Used Enterprise Integration Pattern like Wire Tap in Apache Camel for different Rest Services Invocation. . Developed Restful Web Services using Spring Web Framework. . Developed JUnit Test Case for each unit present in the application. Mockito framework is used for mocking the data base interactions. . Jacoco maven plugin is used for generating the test coverage report. . Jenkins is integrated with SonarQube for Continuous integration and code clean up. . Logging for Interfaces using log4j2 and SL4J. . Also involved in Debugging Accela Issues by checking BIZ Server logs and creating the ticket with Accela. . Used Maven to build the application and deployed it on WebLogic Server 12.2.1 present in Windows Server 2012 O.S. . Updated the application with new features of Angular 4. . Worked on some of the new features of Angular 4 like new if else syntax, ng-templates, form validators. . Designed and developed the application using Angular 2 framework along with HTML5, CSS3, Type Script, Java Script, Bootstrap, Node.js, NPM, Mongo DB. . Moved existing AngularJS controllers and services to Angular 2 components for more responsive and less dependency. . Enhanced legacy application by building new components in Angular 2 and typescript. . Developed single page applications using Angular 2, Typescript, web pack and grunt. . Hands on Experience on Angular 2 technology for one complete project in rebasing the UI of the application using the techniques in Angular 2Environment: JDK 8, Accela 9.1.0, Spring 4.3, Spring IOC, Hibernate 5.2,JSON, Eclipse Neon, JavaScript, EMSE Script (Accela), Oracle 12c, Junit 4,SonarQube 7.0, Jenkins 2.8, Jacoco 0.7, WebLogic 12.2.1, Spring Batch3.0.8, Oracle UCM 11g, SAP Crystal Report 16v.Fire Department of New York City, Brooklyn, NY Sep 2015 - Dec 2016Role: Accela Developer/Report WriterProject Description: FIRES (Fire Inspection Revenue and EnforcementSystem): Fires is a new BFP inspection, revenue and enforcement actiontracking application which will be developed and deployed in Phase III ofCBIDAS. New application will replace the existing FPIMS system. The FIRESproject is a multi-year enterprise initiative to automate the inspection,enforcement action, and revenue work processes for the Bureau of FirePrevention, the Legal Enforcement Unit, and the Revenue Management Unit ofthe FDNY. This entails installing and configuring the Accela product suiteas the core solution to incorporate Fire Prevention, Legal Tracking andRevenue Management into the FIRES, while building all necessary interfacesand replacing legacy systems.Responsibilities: . Worked with stakeholders and management team in gathering various requirements for the project. . Involved in Design Discussions of the Project. . Developed custom EMSE Scripts to automate some of the processes. . Developed queries on Accela Data base to generate ad-hoc reports for the users to analyze. . Oracle 12c is used as database for Accela. . Made some changes to Work Flow as the part of change management process. Added some automation steps using EMSE Scripts on Work Flow Changes. . Developed Custom EMSE Scripts to Process the JSON Data Sent from the different Batch Jobs using EMSE Web Services Provided by Accela. . By using Multithreading, we prevent the application submitted from ACA by different people of the same application etc., . Worked on Configuration and scripting of different record types in Accela Automation (AA). . Worked with the testing team to resolve defects in the system and performed unit testing. . Worked on Configuration and scripting in Accela Automation (AA). . Developed EMSE Scripts and tied the scripts to different events like change in work flow status, Application Submission, conversion of temp record to real record id. . Developed Page Flow Scripts that are executed in the Accela Citizen Access Public Portal. These scripts are used to pre-load the data to fields from the information already entered by the user in Citizen Portal. . Customized the Accela Citizen Portal from Admin page according to the business needs from the Client by using HTML, CSS, JavaScript & jQuery. . Configured the look and order of the citizen access pages. . Developed Scripts in Expression Builder to do the Validations/ Auto Populate the Data according to the Business Rules. . Experienced in setting up application security roles and FIDS. . Developing and Scheduling Internal Batch Job Scripts so that they run regularly and process the data and send the appropriate reports or correspondence to the users regularly. . Developed and Deployed Oracle Reports using oracle Report Builder and integrated with Accela so that different Reports are generated as a part of Correspondence/ Internal Review. . Developed Database migration scripts to build the new environment like production using data mapping tool. . Preparing Detail Design Specification Documents. . Wrote Junit test cases and was involved in full end to end software testing. . Worked on Knowledge Transfer. . Was also involved in production support for solving issues and bug fixes. . Worked on Release Management and Migrations in all environments (Production, QA, and Test). . Worked with the testing team to resolve defects in the system and performed unit, white box testing. . Developed and consumed SOAP web services used to interact with other intermediate systems. . Working in a Hybrid Agile environment. . Work closely with Performance team and provide inputs to and participate in performance analysis. . Conducting Data driven testing, cross browser testing and parallel test execution. . Administrated HP Quality Center for the project in Providing User Access and Defined Work Flow in Quality Center for the Project. . Preparation of Performance Test Plan for various releases. . Provide support for User Acceptance Testing and execution of test cases. . Preparation of Data conversion and interface test plans and test cases. . Execution of Data Conversion and Interface test cases. . Create and participate root cause analysis reports and reviews. . Experience in providing support for Production Systems. . Experience in Developing the Design Documents for different project using tools such as Microsoft Visio and presenting them to the Client. . Maintaining the Current system, checking the health of BIZ Server and IIS Server regularly so that the users don't experience any shutdown or delay. . Conducting Advanced Statistical Analysis to determine trends, patterns, consumer behavior and significant data relationships . Carrying out in-depth analysis (time-series analysis, etc.), Identifying trends and patterns and communicating complex results using visualizations, presentations, etc. to technical and non- technical audiences which helps the company take strategic decisions. . Building complex data sets from multiple data sources and transforming Legacy data (using SQL Procedures) for Conversion (ETL) . Redesigned existing methodologies as per trends detected from data which in turn improved data collection and storage.Environment: Accela, EMSE Java script, Oracle, Web Services, HP QualityCenter.Trilogic Software Solutions Jan 2013 - July 2014Role: Java/J2EE DeveloperProject: Mutual Fund History AnalysisTrologic Software Solution is a Financial Services Organization. TheProject mainly deals with developing a web application so that theFinancial Advisors could track the Historical Trend of each Mutual Fund.As a Part of Developing the Project, Google Charts is used as a JavaScript Frame Work to represent the json data coming from Backend asCharts. Spring Framework is used as the primary framework for developingthe Backend Restful Services. Spring JDBC is used to access the Data fromDatabase.Responsibilities: . Involved in Design Discussions of the Project. . Developed UML diagrams using Microsoft Visio to represent the Architecture of the Project. . Developed Rest End Points using Spring 3.0. . Implemented Various Design Patterns like DAO, MVC for developing the Project. . Used jQuery 1.6 for Making Ajax Calls to API and Extracting the Json Data. . Spring JDBC is used to Run the SQL Queries and Read the Data from MySQL Database. . Google Charts is used as Java Script Frame work for Converting the Json and Representing them as Charts. . Log4j is used the Logging Framework in the Application. . Deployed the Application in Tomcat 7.0. . Used SVN for version control. . Developed the Application using Eclipse ID. . Managed CRM module and created PL/SQL components for data analysis, conversion, and ETL . Assembled quality data pipelines which are used to aggregate and transfer data which is in turn used in decision making.Environment: Java EE 7, POJO, SOAP, SQL, SVN, Visio and Eclipse IDE.EducationMaster in Science/Computer Science New York institute of technologyCoursework: Advance Operating Systems; Advance Databases; ComputerNetworks; Network Programming with Java; Operating System Security;Computer Network; Algorithm Concepts; Computer System Architecture etc.Bachelor of Technology, Information Technology JNTU HyderabadCoursework: Operating Systems (Linux & Windows); Databases;Algorithms; Programming Principles; Java etc.Trainings & Certifications: 1) Salesforce Administration 2) Accela training + Certification |
