SUMMAR

• 10 years of experience in the field of Business Analysis, Data Analysis, Quality Assurance, Development and Project Management.
• Experienced in the complete software development which encompasses requirements gathering, development, and testing and project management.
• Experienced in State Government projects like confidential,  confidential, Health Care, Reporting, Data Warehouse and Salesforce Projects
• Experienced in Data Warehouse concepts. Set up new objects in Data Warehouse in current project in Greenplum Datawarehouse environment and Oracle Datawarehouse.
• Efficient in requirements gathering, requirements definition and analysis, preparing Requirements Traceability Matrix (RTM) and Gap Analysis
• Versatile in Data Migration and ETL concepts.

TECHNICAL SKILLS

Programming Languages: Apex (Salesforce)

Web and User Interface Technologies: HTML, VisualForce(Salesforce)

Software Frameworks and Toolkits: Salesforce, Microsoft Access, Microsoft Office

Database Technologies: Microsoft SQL Server, SOQL (Salesforce), SOSL (Salesforce), SQL Developer, PG Admin

Concepts: Relational Database Design• Extract,Transform,and Load (ETL)

Modeling tools: MS - Visio, Rational Rose, ERwin

Project Management Tools: MS-Project

Methodologies: SDLC, Object Oriented Analysis and Design (OOAD), Rational Unified Process (RUP), Unified Modeling Language (UML), Joint Application Development (JAD)

PROFESSIONAL EXPERIENCE

Confidential, Cranston, Rhode Island

Business Analyst II

Responsibilities:

• Worked as a business analyst on a project to modernize the Rhode Island Division of Motor Vehicles computer system.
• Wrote the high level requirements documents for NMVTIS interface.
• Worked on structured testing for AAMVA interfaces like VLS, CDLIS and PDPS.
• Gathered requirements for interfaces which interact with other state departments like State Police, confidential Resources, Department of Transportation
• Worked as a business analyst on a project to modernize the Rhode Island Division of Motor Vehicles computer system.
• Wrote the high level requirements documents for NMVTIS interface.
• Tested the POLK, NACI interface during testing phase.
• Wrote the high level requirements for the accidents interface which directly integrates with  confidential to gather the accident reports.
• Wrote the high level requirements for undercover transactions.
• Wrote the high level requirements for the DMV application transaction framework ( i.e searching for customer, updating a customer record etc).
• Worked with the solution architect and developers to develop the application in .NET framework.
• Worked on interfaces which used soap, xml calls.
• Wrote the high level requirements for the administration module of DMV application like Fee Setup, Supporting Document Setup, Output Document Setup.
• Worked on different kinds of plates issuance like temporary dealer plates, registration plates, vanity plates and etc.
• Participated in the SCRUM based software development methodology.
• Conducted JAD sessions and gathered the key requirements from DMV business users.
• Documented the requirements and developed the high level design documents
• Worked extensively with multi tier framework and understood the key concepts in software architecture.
• Communicated the requirements to the development and testing team.
• Prepared test cases, participated in User Acceptance Testing, Developed test data for the client side UAT testers.
• Used SQL Server Management Studio, SQL Integration Services and SQL Reporting Services in various phases of the project.

Confidential, Southboro, MA

Principal Business Systems Analyst

Responsibilities:

• Worked as an application lead on a project to implement knowledge base in SFDC and replace their existing Primus Knowledge Base application
• Lead a team of 2 offshore developers and 2 testers through the life cycle of the project
• Lead the conversion efforts on the project and migrated the knowledge base articles from Primus to SFDC.
• Worked on the integration module and interacted with 3rd party applications which use knowledge
• Implemented the knowledge in the service cloud of Salesforce and Case Management
• Implemented Communities in Salesforce so that customers can login and review their case status
• Implemented Single Sign On from third party applications to Salesforce.
• Developed workflows, approval steps, validation rules for authoring knowledge articles
• Helped Process/Enablement team to conduct Training sessions with business users.
• Prepared the Production Deployment Playbook which was used by various teams during production deployment.
• Participated in 4 weeks of production stabilization and post go live support.
• Triaged the cases/bugs which came in after production deployment.

Confidential

Senior Business Systems Analyst

Responsibilities:

• Worked on a project to migrate the Data Domain (a company acquired by Confidential) CRM systems into Confidential CRM systems.
• Worked on Confidential Oracle 11i CRM system to test the creation of service requests, contracts and install base instances.
• Worked on the reporting module which encompassed the contacts, install base, accounts, service requests/cases, knowledge base and product dimensions.
• Worked as the primary business analyst in the Confidential BRS project reporting team which is responsible to support the Business Intelligence activities like report creation and data analysis for the BRS project.
• Supported in the creation of 19 workbooks encompassing 200+ reports in Tableau.
• Gathered business requirements for the reports and analyzed the gaps in the data warehouse.
• After requirement analysis, Created a business use case to move data from Salesforce environment into the Confidential global data warehouse to support report creation.
• Tested the data from Salesforce before it is moved to the Data Warehouse.
• Understood the reporting limitations of knowledge base articles in Salesforce and developed a business case to overcome this limitation in the data warehouse.
• Supported the data architect in the development of the dimension models for the reports. Assisted him in understanding the business requirements so that the models can be created accurately.
• Supported the Informatica resource to develop the mappings between the Salesforce source system and Oracle Data Warehouse.
• Tested the data in the extract, staging and the final data mart.
• Supported the Informatica resource to move the data from Oracle data warehouse to Greenplum Data warehouse (which runs on Hadoop Technology)
• After requirement analysis, created a business use case to move the product taxonomy data into the enterprise data warehouse.
• Worked with the Greenplum Architecture team to customize the sandbox which was commissioned to the project
• Worked with the business users tohelp them understand the data model and develop their reports using Tableau. Assisted in developing 16 workbooks and ~200 reports
• Worked on requirements to integrate Bugzilla, a defect tracking tool, with the Confidential Customer support portal
• Worked with the testing center of excellence to help them develop their testcases, end to end scenarios to perform the testing
• Developed the playbook to identify the tasks necessary for go-live.
• Used SQL Developer to test the data in the Oracle Data warehouse.
• Used PG Admin to test the data in the Greenplum Data warehouse.
• Used Data Loader, SFDC Developer Console to review the data in SFDC system
• Extracted Knowledge Base, User data from SFDC to Data Warehouse.
• Developed the logic which was used by Informatica resource to perform the load of knowledge base articles into the data warehouse in a persistent way.
• Developed the logic which was used in suspense processing and suspense reprocessing in the data warehouse.

Confidential, Cranston, Rhode Island

Business Analyst II

Responsibilities:

• Worked as a business analyst on a project to modernize the Rhode Island Division of Motor Vehicles computer system.
• Wrote the high level requirements documents for NMVTIS interface.
• Tested the POLK, NACI interface during testing phase.
• Wrote the high level requirements for the accidents interface which directly integrates with confidential to gather the accident reports.
• Wrote the high level requirements for undercover transactions.
• Wrote the high level requirements for the DMV application transaction framework (i.e searching for customer, updating a customer record etc).
• Worked with the solution architect and developers to develop the application in .NET framework.
• Worked on interfaces which used soap, xml calls.
• Wrote the high level requirements for the administration module of DMV application like Fee Setup, Supporting Document Setup, Output Document Setup.
• Worked on different kinds of plates issuance like temporary dealer plates, registration plates, vanity plates and etc.
• Participated in the SCRUM based software development methodology.
• Conducted JAD sessions and gathered the key requirements from DMV business users.
• Documented the requirements and developed the high level design documents
• Worked extensively with multi tier framework and understood the key concepts in software architecture.
• Communicated the requirements to the development and testing team.
• Prepared test cases, participated in User Acceptance Testing, Developed test data for the client side UAT testers.
• Used SQL Server Management Studio, SQL Integration Services and SQL Reporting Services in various phases of the project.
• Participated in the data migration from legacy system to the current system. Developed the source to target mapping for some key modules
• Played a key role in preparing the training material and in the end user training. Conducted workshops for the end users.
• Coordinated with third party vendors to gather the requirements for the web services. These web services were used for information exchange between the systems like online registration renewal, online temporary dealer plate registration etc.
• Gathered valuable experience in Data Processing, Printing batch processes.
• Worked with multiple teams like Development, Testing, Project Management Office, Migration and Client Side Management team.
• Define Access control process and policies for various users who need to access the new system.
• Performed Gap Analysis, Impact Analysis and workaround assessment during various stages of the project.
• Worked closely with QA department to triage and resolve open issue during testing phases as well as assist in development of test plans for test.

Confidential

Developer

Responsibilities:

• Worked on a project to monitor the damage of containers during transportation.
• Project was sponsored by Oklahoma Department of Transportation and NSF
• Developed an application which detects intrusion in TCP/IP networks
• Used RFID zigbee sensors to monitor the damage of containers during transportation
• Performed recurrence analysis to visualize pattern underlying the measured signals.
• Used BaseSAS, SAS Enterprise Guide and SAS Enterprise Miner.