SUMMARY

• Master of Science, Industrial Technology, Bachelors of Engineering in Information science.
• 3+ years of experience in requirements gathering, business case creation, process flow diagram development, agile and waterfall process implementation.
• Performed Business Analyst tasks by handling needs of the stakeholder and met customer expectations.
• Business Intelligence - Power BI for reporting and PowerPivot report based on customer need.
• Strong SQL skills.
• Experience in developing detailed test cases and check list to ensure the software quality.
• Extensive experience as a Business System Analyst for Business Analysis with hands-on project management skills in User Requirement Gathering and Transforming Business Requirements into Software Requirement Specification (SRS) using MS Office Suite.
• Experience working in Microsoft Dynamics AX.
• Experience in software configuration management system git and cvs.
• Experience in developing detailed test cases and check list to ensure the software quality.
• Experience in easy programming change in AX 2012 AOT.
• Knowledge on tableau.

TECHNICAL SKILLS

Languages: Java 1.7, HTML, SQL, UML

Tools: JIRA, Power BI, Tableau, SharePoint, MS Word, MS Excel, Service Now, Visio, Visual Studio, ServiceNow

Databases: Oracle, MYSQL, SQL

ERP: Microsoft Dynamics AX 2012

Operating System: UNIX, Windows 7/Vista/XP/ME/98, Cent OS

PROFESSIONAL EXPERIENCE

Confidential

IT Business Analyst

Responsibilities:

• Analyze the requirements and map them with ERP systems (Microsoft Dynamics AX) without much code customization.
• Worked on modules-production Control, inventory and warehouse, product information management,
• Create reports for business and data analysis using Power BI tool, SQL and Excel PowerPivot.
• Attend Kaizen manufacturing meetings and involved in changing process with the team to benefit business.
• Develop crucial functional requirement specifications, created detailed use cases, process flow diagrams and dashboards to support functional specifications in the form of epics, user stories and documenting the same over different iterations and sprints, in addition to issue tracking, as-is analysis, workflow analysis, & troubleshooting
• Worked with ITA, and Dev teams for successful implementation of the user stories.
• Coordinate with both business and developers to ensure business, data needs and views are properly represented throughout the project lifecycle and coordinate communication regarding implementations.
• Act as liaison between business owners, developers and QA team to ensure enterprise data needs were met and worked closely with-it Project Managers to report project progress. Validated data mappings, data discovery with development team.
• Work closely with systems analysts to ensure functional specifications are properly accounting for business needs. Facilitated meetings, as necessary, to review captured business needs and obtain approvals.
• Conduct reporting requirements from the data ware house and analyzed the tables and columns to be added in the data ware house from the sql server.
• Data warehouse project- Documentation, Analysis, facilitating meetings, involved in EDW data mapping, collected all data required to build logical data model, test relations between fact and dimension tables, writing complex SQL queries to make sure that the data is fetched right. End to end testing- Assisted in Smoke, functional, performance, SIT, and regression testing, User Training and KT.
• Modules worked in AX ERP: Inventory and warehouse management, Production control, Product Information management, Procurement and sourcing, Master Planning.

Technologies: ERP-Microsoft Dynamics AX, Power BI, MS Word, MS Excel, Service Now, SharePoint, SQL, PowerPivot reports, X++, AOT, Visio, Visual Studio

Confidential

Business Analyst

Responsibilities:

• Analyze data spread sheets to map the systems Claims, Members, Benefit, Provider, Billing, Payment, Contract, Capitation modules with SCAN Health Plan enterprise data ware house.
• Performed multiple source system analysis to identify the source data that needs to be moved into the target tables.
• Created data flow diagrams, data mapping from Source to stage and Stage to Target mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.
• Worked on EDI transactions (270,271, 276,277, 834, 835 and 837). Performed front end to backend mapping and analyzed the start to end of transaction.
• Developed data requirements for data dictionary and data discovery document. Used SQL queries for data discovery.
• Acted as liaison between business owners, developers and QA team to ensure enterprise data needs were met and worked closely with-IT Project Managers to report project progress. Validated data mappings, data discovery with development team.
• Worked closely with systems analysts to ensure functional specifications are properly accounting for business needs. Facilitated meetings, as necessary, to review captured business needs and obtain approvals.
• Develop business use cases, business and data requirements, and related documentation in support of Enterprise Data Management.
• Provider inquiry about the status of Remittance Vouchers (RVs). This involved checking the MMIS provider subsystem and checked the setup of their Remit Media
• Responsible for review of business capabilities and requirements to define data needs and enterprise data management. Includes data analysis of business and user needs and documentation of data and mapping requirements.
• Coordinates with both business and IT partners to ensure business, data needs and views are properly represented throughout the project lifecycle and coordinate communication regarding implementations.
• Experience in Web Focus and SSRS reporting.
• Created test cases and test scenarios based on HL7 interoperability specifications like workflow, performance, Load and networking.
• Prepared Mapping document, data flow diagram, Process flow diagram using MS Visio.
• Involved in gap analysis in changing old MMIS and testing new MMIS.
• Conducted reporting requirements from the data ware house and analyzed the tables and columns to be added in the oracle data ware house from the sql server through transformation engine.
• Worked on Agile Methodologies to implement the project.

Technologies: Windows server, MS-SQL Server, Oracle SQL Developer, SDLC, UI/SOAP or XML, MS Office, JAVA, SPRING framework, Business Intelligence Tool-Tableau for reporting.

Confidential - Colorado, Denver

Intern

Responsibilities:

• Worked with Data Architect to plan, define and document the business, data model and system requirement, implemented Agile Methodology.
• Involved in SCRUM meetings and implemented project in regular Sprint releases.
• Involved in creating new schemas.
• Oracle SQL for handling the database management systems.
• Worked few stories on jQuery (UI) like creating a menu option, scorepad, modal dialog window. Used ajax call to fetch those ribs.
• Core java concepts used on the java part. Worked mostly on process controller import and export process.
• Used WinSCP to secure file transfer between a local and a remote computer. Also used for file synchronization.
• Used putty to login and check logs.
• Aware of ANT deployment and was also involved in deployment.
• Was involve in many challenging tasks like eliminating duplicate records and putting in check and export the ones with a new export config name.

Technologies: ANT, GIT, MS Visio, JAVA, SQL, Business Intelligence, Data Modeling, MS Word, MS Visio, Rational Rose, UML, jQuery

Confidential

Responsibilities:

• Analysis of all the requirements and read documents and books written by Scientific Officer Dr. R. Bhakthavatsalam.
• Design and develop a documentation/blueprint of the process.
• Training on how to use Cent OS and configure them in multiple systems.
• Writing complex SQL queries and retrieve data to test the performance of the protocols.
• Involved in programming and help developers understand the data structure and answer questions on the blueprint.
• Evaluate the final system and complete end to end testing.

Technologies: Cent OS, SQL, X++, MANETs 802.11

Confidential

Business Analyst

Responsibilities:

• Gathered requirements for users to develop a web based application for manufacturing industry.
• Arranged scrum meetings and managed several projects at once.
• Writing sql queries for report purpose for the users.
• Data validation.
• Test the enhancement requests and create a test case and test plan for the users.

Environment: Java, JRE1.6, Agile, JSP, Servlet, Webservices, JavaScript, Oracle v10g, XML, Eclipse 3.x, CVS, Tomcat AS v6.x, JDBC, Struts 2.x, UML, SQL, HTML, Linux, Maven, Log4j, Perl, JUnit.