SUMMARY

• Over 10 years of experience in IT industry with various Client - Server, Web based and Customer facing applications, which includes 5 years of as Data Management Analyst
• Government experience and proven track record of applying appropriate practical technology/mix of technologies that meet business needs while minimizing risks
• Exceptional problem-solver with keen ability to resolve technology issues, provide for system enhancements, analyze/define business processes for improvement, define, design, develop, and implement highly successful automated solutions, as well as find solutions where others have failed
• SkilledTableaufront-end BI developer integrated with multiple back-end databases and other various data source.
• Participated in Code Reviews, System Testing and UAT followed by production verification, post production testing and support
• Lead with the development and maintenance of the Enterprise Metadata Repository as the platform for centralized, cross-referenced data models, data dictionaries, data maps, STTM (Source to Target Mapping) NPI and other data artifacts across the organization.
• Motivated achiever with demonstrable ability to recommend enhancements to business process
• Designed, Implemented TC microservices using JAX-RS API REST webservices and spring boot.
• Experience in validating Laboratory Information Management System (LIMS), Adverse Event Reporting System (AERS), and Chromatography Data System (CDS).
• Experienced with event-driven and scheduled AWS Lambda functions trigger various AWS resources.
• Hands on experience in python. created Lambda functions.
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools
• Ability to use different analytical applications to identify relationships between different pieces of data and to draw appropriate conclusions. Well versed with software development life cycle, Business analysis, UML Diagrams, OSI Model and Networking protocols. Experience in SQL, UAT, ERP, Excel, Tableau, C, ASP.NET and BI tools.
• Understanding of the SDLC (Waterfall, Agile methodology) and of all phases of SDLC and Strong working knowledge of Testing.
• Extensively used Scrum/Agile Methodology in the process of the project management based on SDLC.
• Proficient in design and development of various dashboards, reports utilizingTableau Visualizations such as bar graphs, scatter plots, pie-charts, maps, funnel charts, lollypop charts, donuts, bubbles, etc.
• Experience working in Three-Tier architecture, Ajax, Web Services (SOAP, WSDL, UDDI). Gathered requirements for Client-Side Validation, and Server-Side Validation. Tested through SOAP UI, API Documentation in MS Excel.
• Strong knowledge of Agile PLM, scrum processes and experience in redesign of product development process as per the business requirement.
• Worked on deployment tools such as Azure Machine Learning Studio and AWS Lambda.
• Facilitate and/or support customers in UAT planning and execution.
• Experienced in all phases of administration starting at the user interface and all the way back to the database. Imported /exported files using Excel, MS Word
• Strong interpersonal, written, and verbal communicator who can deliver effective presentations, consults on technology projects, and maintain collaborative relationships
• Assist with configuration management in the review of plans formulated and actions taken to ensure adherence to management policies and practices.
• Designed and implemented Flowcharts, Swim charts, and department hierarchy images using the latest version of Excel, Visio, and PowerPoint to show the interconnectivity between Data management and other departments and how data accuracy or errors effect the company's communication between departments, vendors, merchants, and stores.
• Prepare factual, clear, concise and appropriately coordinated written communications with stakeholders.
• Strong knowledge of Complex SQL across multiple Relational Databases (e.g. Oracle, MS SQL, DB2).
• Good Knowledge on Business intelligence, OLAP, Dimensional modeling, Star and Snowflake schema, extraction, transformation and loading (ETL) process.
• Provide quality acquisition and program documentation assistance to the Program Managers.
• Demonstrated problem solving and analytical skills with strong oral, written and presentation skills.

TECHNICAL SKILLS

Test Automation Tools: HP Quick Test Pro (QTP), HP UFT

Test Management Tools: HP ALM, HP Quality Center, JIRA

Operating Systems: Windows, UNIX/Linux

Scripting Languages: VBScript, XML

Tools: MS Word, MS Excel, MS Outlook, PowerPoint

Languages: Java, C++, C, HTML, XML, VB, SQL, PL/SQL, JavaScript, C#, .Net, Python

Databases: Oracle, MS-SQL Server, My SQL, MS Access

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst

Responsibilities:

• Manage the planning and development of design and procedures for metrics reports
• Lead with the development and maintenance of the Enterprise Metadata Repository as the platform for centralized, cross-referenced data models, data dictionaries, data maps, NPI and other data artifacts across the organization.
• Develop business architecture using requirement such as scope, processes, alternatives, and risks
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Produced RESTful webservices developed on top of Spring Boot.
• Strong knowledge of JIRA, Confluence
• Used SQL for Querying the Oracledatabase.
• Clarifying and writingbusinessrequirements for a fast-pacedagiledevelopmentmodel using JIRA stories
• Participated in UAT problem solving sessions with essential team members
• Analyze client business requirement and processes through document analysis, interviews, workshops, and workflow analysis
• Responsible for creating user stories in JIRA (Agile methodology) and MS TFS from the high-level business requirements delivered by the SMEs
• Assisted Regression Testing, Interface Testing (SOAPUI) and Black box Testing. Created Test Cases, Test Plans, Test strategies, Test Scenarios and conducted Manual Tests in HP Quality Center.
• Investigate and conduct studies on the forecasts, demand, and capital of products
• Communicate clients business requirement by constructing easy-to-understand data and process models
• Understanding requirements across modules of Dynamics CRM, AWS access management and API’s
• Engage client to gather software requirement/business rules, and ensure alignment with developments teams
• Worked on Gap Analysis of various source systems sitting and coming from multi systems. Responsible for BI Data Quality.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Initiated detailed discussions/functional walkthroughs with stakeholders. Produced system documents, functional requirements, ETL mapping and modeling deliverables Worked with root cause of data inaccuracies and improved the quality of data by using Data Flux
• Modified and Edited the XML to validate the SOAP UI Services.
• Maintained the administration tool to control user access to Agile-PLM client services
• Partnered with cross-functional teams to elicit information to capture key business drivers for client implementation
• Successfully used Agile/Scrum Method for gathering requirements and facilitated user stores workshop.
• Used lambda step functions (python) to Process/Transform incoming data files from multiple onprem data sources.
• Performed UAT, system testing and data validation, identified and reported variances in daily system activity. Supported the development of the testing approach and plan. Executing the test plan, fixing and keeping track of the defects.
• Developed and created a more effective product inventory system to accelerate customer portal registration
• Review customer shipment data for discrepancies against order/shipment data in SAP
• Collect Assists in generating Business As Usual (BAU) reports. Supports ad-hoc presentation/analysis development and responds to information requests from management
• Develop and update the desktop procedures and Prepare Standard Operating Procedures for all the processes that occur on monthly/quarterly basis to avoid key person dependency and business is not interrupted and functions as usual.
• Perform Business Analysis and create functional and technical requirements to define report layouts and identify data sources such as internal databases
• Provided project correspondence to clients to get their approval on proposed development changes
• Familiar with Cloud Services such as AWS EC2, S3 to assist with big data tools, solve the data storage issue, and work on deployment solutions.
• Prepare and Validatedatasets using excel andTableaufunctionalities to ensure optimization anddataintegrity.
• Created Fact and Dimension tables to meet the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling
• Very good experience in performing different types of testing like Integration testing, User Acceptance testing (UAT), Functional testing, End-to-End testing, Usability testing, client/Server testing, Positive and Negative testing, Regression testing, Smoke testing, System testing, Graphic User Interface (GUI), Security testing, and Performance testing
• Assist in the development of a compliance and risk management model that protects the organization while enabling business growth
• Work with Service Desk team to determine what tools are needed to support the business process as well as alerts and reports needed to provide visibility to issues
• Analyze complex queries from SQL to build business objects

Confidential, Rockville, MD

System Analyst

Responsibilities:

• Conduct stakeholder sessions to complete and document detailed business requirement documentation
• Overseeing Agile development methodology to schedule and distribute work efficiently.
• Work with business stakeholders and other SMEs to assess current capabilities, understand high-level business requirements and apply technical background/understanding in the development of System Requirements Specification (SRS) documents
• Extensive experience facilitating the creation and documentation of High-Level Design / Functional Specifications
• Clarifying and writingbusinessrequirements for a fast-pacedagiledevelopmentmodel using JIRA stories
• Involved in extensive DATA validation using SQL queries and back-end testing
• Successfully applied Agile development methodology to project from concept to release using adevelopmentcycle to rapidly meet changing requirements and time-based needs within client parameters
• Experience in testing Client-Server and Web-Based Application using SOAPUI.
• Conduct analysis of business process changes for potential system impacts
• Performed in-depth data validation from various suppliers across clients vendor
• Developing Sourcing and Vendor management within PLM software to handle third party selection, first piece qualification, order fulfillment and financial settlements
• Involved in data mapping and data lineage activities from current state to what is expected for Confidential target state and worked with data modelers for the logical data model & physical data model built for the Centralized Data Store (CDS).
• Provide support for production issues which includes problem identification, definition and implementation of short-term work around and coordination of long term software solution with development team
• Ability to develop complicated SQL script for Data validation testing by running SQL script, procedures.
• Used Python for scripting language.
• Used SQL for Querying the Oracledatabase
• Served as the primary contact for the client service teams for different projects
• Research and resolved data discrepancies with troubleshooting teams
• Communicated effectively with project management regarding issues and needs for projects

Confidential, Elkridge, MD

Analyst

Responsibilities:

• Analyze the specified problem, examine for solutions using data analysis practices and provide recommended solution Involved in gathering business requirements from client end users, understand user criteria.
• Developed Microsoft access-based report now used daily by doctors to retrieve patient information
• Assisted in preparing the Validation Report using the Advance Reporting tool incorporated in the DSM LIMS package
• Wrote and obtainedbusinessapproval of requirements. Used ScrumAgiledevelopmentprocess.
• Assisted in preparing the Validation Report using the Advance Reporting tool incorporated in the DSM LIMS package
• Designed reports in Access, Excel using advanced functions not limited to VLOOKUP, pivot tables, formulas
• Organized meetings with business process owners to approve functional and integration Test Cases and performed gap analysis.
• Worked on Requirement Analysis, Data Analysis and Gap Analysis of various source systems sitting and coming from multi systems. Responsible for BI Data Quality.
• Involved in documenting Functional Design Specifications for various SAP objects and work through its life cycle with FSD/OIT teams Created Volume Testing, Failover Testing Strategy & Plans for Applications, Middleware and Databases.
• Ability to interact with all levels of personnel from technical to high level executive management.
• Involved in tracking project activity, providing accurate status reports and finding/fixing issues as they arise.
• Conducted operational testing of Labware LIMS software and involved in writing of Operational Qualification of various LIMS modules"
• Involved in preparing Workflow/Process diagrams as applicable to the functionality for complex systems in the organization.
• Provide accurate status to management on production related activities on a timely basis.
• Managed HP ALM Domains & Projects, set user properties, managed groups permissions etc.
• Review validation documents and troubleshoot LIMS issues
• Strong understanding and experience in working on different architectures - Client Server, Web based and GUI based systems, and applications.
• Involved In creating Business requirements specification (BRS) and maps them.