SUMMARY:

• 9+ years of diverse experience in information technology with emphasis in Business Systems Analysis in property and casualty insurance (P & C), financial systems and other complex well - integrated OLTP and OLAP data warehouse systems.
• 7+ years of conducting many complete Systems Development Life Cycle (SDLC) using Waterfall, Agile (XP and SCRUM) methodology through partnership with major global solution and consultation providers including KPMG, Tata Consultancy Services' IT services, Microsoft, 3i InfoTech, and Penta soft.
• 7+ years of documenting business and functional requirement and specifications of processes related to insurance illustration, salesforce, underwriting, customer service, claim, policy billing, security of financial transactions and other financial operations.
• 7+ years of managing metadata, data mapping, reviewing and analyzing, large volume of data, documenting and presenting findings, risk assessment, recommendations, and conclusions.
• 7+ handled data mapping to integrate different systems by analyzing the gaps and set the functional and nonfunctional requirements.
• 7+ years leading, facilitating, participating actively in JAD sessions for requirements walk-through with business and technical teams to resolve business and system change request, defects and enhancement.
• 7+ years of building UML diagrams and virtualizing Use Cases, User Story, processes, operations and activity using MS-Visio, MS-Word, MS-PowerPoint and MS-Excel.
• 7+ years of effective and collaborative work with diverse teams of experts on big and complex systems implemented on different/integrated database platforms including Oracle Database, Microsoft SQL Server, MySQL and IBM DB2 through diverse specialists in management, development, network/database/system administration, quality assurance and SMEs.
• 10+ years of extensively executed SQL and T-SQL queries with solid experience on ETL and other database administration tools with advanced skills in MS-Excel including macro programing and add-in.
• 7+ years of solid experience in data virtualization and creating and managing custom reports using Power BI, Oracle Reports 10g, Crystal Report and MS Access and writing the queries for interactive dashboards on Business Intelligence tools.
• Enrolled in Data Science Specialization, a program of nine courses, at Johns Hopkins University.
• Publishing scientific paper in prominent Journal about data analysis and data decomposition using MATLAB, C.
• 10+ years of proficient use of MS Excel spread sheet, PowerPoint, MS Visio, online MS Project and DOORS.
• More than one year of experience in transportation and GIS in salesforce systems and routing optimization applications.
• 4+ years of experience of using SharePoint, CRM and Salesforce.
• 6+ years of issue tracking and management including defects, enhancement and change request handling.
• 6+ years of examining the deliverables including the verification of requirement coverage and assuring user acceptance.
• 3+ years of experience in training in IT field.
• Organizing and provide training for users and other consultants.
• Experience in programing with JEE, C, C++, JavaScript, C# and VB .net

TECHNICAL SKILLS:

SDLC Project Methodologies: Water Fall, Agile XP and SCRUM.

Issue tracking systems: JIRA, Quality Center and PentaSoft Help Desk.

Data Analysis: SAS, MATLAB, MATHMATICA, C++, Advanced features on Excel

Business Intelligence & In data virtualization: SSRS, Power BI, Oracle Reports 10g, BO, Crystal Report, Visual Studio

Financial Systems: MS Dynamic Great Plans and Oracle Orion.

Database Management systems: Oracle, Microsoft SQL Server, MySQL and IBM DB2.

Business Applications: Microsoft Office Suite - MS Word, Excel, PowerPoint, Outlook and SharePoint.

Technical Languages: SQL, Transact SQL, JEE, CSS, XML, UML, JavaScript, C#, VB .net and HTML.

Integration tools: Microsoft BizTalk Server, IBM WebSphere Application Server and Web Service.

Operating Systems and servers: Windows 2008R2/2012R2/10, UNIX, Linux and Active Directory.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Business Systems/Data Analyst

• Preparing documentation and presenting progress reports to stakeholders.
• Active communication with developers, users and all stakeholder about all pending tasks.
• Preparing Test scripts, Test plans, Test Cases, Test Scenarios, setting up Test Environment for accounting, financial, services and core systems.
• Gathering requirements, interviewing senior level company officials to gather requirements for documenting project functional specification, epic and user stories.
• Business analytics experience with on call activity, platform adherence, MCO, plans, retail and non-retail sales, pharmacy redemption, market volume, market share, KPI.
• Applying effective methods to measure the Sales Force size to enhance sales force strategies by assigning accounts and zip codes to certain territories.
• Monitoring and measuring the performance of sales and marketing strategies against targeted health care provider and patient’s needs by building multi-dimensional cross tabs, pivot table and metrics
• Enhancing the accuracy and the performance of the Quality Control operations by building templates and modules to handle repetitive tasks.
• Improving the Quality Control operations by building automated process to expand the sample of tested data and to reduce time and other resources.
• Virtualizing data and creating and managing custom reports using SSRS report, Tableau and MS-excel and access.
• Extensively executed SQL queries and T-SQL to analyze salesforce data integrated from different sources.
• Supporting and administrating many functionalities on Salesforce system SFDC and Veeva CRM, including prescriber’s certification from Diversion Control Division under Drug Enforcement Administration under at U.S. Department of Justice, certification from The Substance Abuse and Mental Health Services Administration (SAMHSA) at U.S. Department of Health and Human Services, Prescriber Concern Report (PCR) Committee Activity, dashboard and reports.
• Working on cloud databases that are accessed by dozens of branches around US.
• Support more than 200 Clinical Liaisons around US.

Confidential, Fairfax, VA

Business Systems Analyst

• Virtualizing data and creating and managing custom reports using Power BI and writing the queries for interactive dashboards.
• Requirements gathering and documentation.
• Extensively executed SQL and T-SQL queries to analyze salesforce data and to contribute in designing a marketing campaign by integrating data from different sources.
• Normalizing salesforce data and setting weights based on market potential analysis.
• Develop C# and R code to analyze huge volume of data.
• Applying different SDLC including Waterfall, Agile Scrum.
• Drafting Project Charter, Business Rules, Epic, User Stories, FRD, Use Cases, Test Cases.
• Monitoring the usage of resources and the performance of the systems and handle related issues.

Confidential, McLean, VA

Project Manager 

• Coordination and completion of individual initiatives by performing a variety of tasks including supervising developers and systems analysts, setting deadline, assigning responsibilities, and monitoring and summarizing progress of the projects.
• Establish project plans, milestones & deliverables while assuring the successful management of the project scope, resources, issues, risks, budget, communications, and procedures as imposed by the client.
• Provide trend analysis to management team to enable them to make informed decisions regarding resource management.
• Organizing and provide training for users and other consultants.
• Preparing documentation and presenting progress reports to stakeholders.
• Using SharePoint for document management.

Confidential

Senior Business Systems Analyst

Responsibilities:

• Supervise business systems analysts and developers on Data Warehouse System which is integrated with the major government systems through IBM MQ Messaging with multiple jobs scheduled on IBM Data Stage.
• Ensured the completeness and delivery of the defined functional and non-functional requirements by building multiple user stories, epics, creating test cases and using Requirement Traceability Matrix (RTM).
• Requirements gathering and documentation.
• Create, update and monitor the status of each issue reported on the issue tracking system and closed the resolved issues.
• Conducted pilot deployment of E-commerce services for final testing before going live.
• Led the systems analysis team and ensured that assigned tasks are performed timely and in adherence with Confidential -IT’s change management and incident management processes.
• On regular bases, communicated with the business stakeholders, analyzed, designed and implemented enhancements and fixes to the existing systems.
• Create, analyze, validate and Monitor the data integration rules.
• Leading Business Analyst Team to implement MS- Customer Relationship Management systems (CRM).
• Analysis any discrepancies during the integration process to identify the cause of any error or failure.
• Regularly design reports about the status of the opened, pending and resolved issue.
• Monitor the log files of system integration and respond to any unexpected outcome.
• Using MS-Visio to design data flow based on the business process.
• On daily basis, creating different SQL and T-SQL queries to analysis cases on the database
• Handled data mapping to integrate different systems by analyzing the gaps and set the functional and nonfunctional requirements.
• Communicated with BDA’s and network administrators to report any non-functional concerns related to backup, accessibility, capacity, deployment, efficiency, portability and security.
• Advanced experience in data integration with outside systems through messaging systems such as Microsoft BizTalk Server, IBM WebSphere Application Server and Web Service.

Confidential

Business Systems Analyst

Responsibilities:

• Part of a team responsible for the implementation and delivery of one of the largest life insurance systems in the region.
• Gathered requirements and interviewed senior level company officials to define the functional specification, epic and user stories.
• Follow up and facilitate the testing on UAT environment and track the status of each issue on the help desk system (issue tracking system).
• Participated in delivering an accounting system that integrated with payroll, asset management, and Salesforce and core business systems.
• Performed in-depth data analysis for large amounts of data to analyze business rules, issues, bugs, enhancement and improvements using advance features in excel and toad.
• Participated in the validation process of claims.
• Creating, analyzing, and validating detailed functional specifications of business rules.
• Coordinate and lead meetings and design sessions with SMEs and multiple stakeholders understand the business needs and to approve business processes and future plans.
• Provide SMEs and different stakeholders with consultations and advices about the latest technologies and best practices plan for major future initiatives.
• Virtualizing data and creating and managing custom reports using Oracle Reports 10g, Visual Studio, SSRS, Crystal Report and MS Access and writing the queries for interactive dashboards on Business Intelligence tools.
• Planned the database and security strategy.
• Defined the security matrix for the core business system and accounting system which connects the authorities and privileges of each user with the management structure and the job description for each.
• Managed system user accounts by creating, modifying and disabling the roles and profile of each user on the system.
• Defining the accessible areas and the authorized process role.
• Implemented the database design, monitored the security and performance of the databases and evaluated server hardware.
• Preformed various aspects of database management including installation, cloning, exporting and migration of the database.
• Deploy fixes on test and production environment.
• Implemented and installed Citrix thin-client/server computing system based on Meta-Frame server.
• Published and administered online applications by creating and manipulating the profiles of users.
• Using Citrix for desktop virtualization.