SUMMARY:

• 2+ years of experience as a Business Analyst and Data Analyst.
• Good understanding of all phases of Software Development Life Cycle (SDLC) methodology (such as requirement, analysis, design, data modeling, business process modeling, implementation and deployment).
• Worked with different methodologies such as RUP and Agile. Worked with Agile scrum methodologies.
• Extensive experience in conducting Joint Application Development (JAD) sessions for project definition involving analyzing requirements, creating prototypes, user interface, database schema and system design.
• Experience object - oriented programming (OOP) concepts using Python.
• Proficient in Understanding User Stories, Requirement Elicitation, Requirement Documentation, Validation, Modeling and Analysis.
• Proficient in writing Use Case Specifications Functional Requirement Specifications (FRS), Technical Requirements Specifications (TRS), BRD, and Requirements Traceability Matrices (RTM).
• Competent in creating Unified Modeling Language (UML) such as Use Case Diagrams, Activity Diagrams, and Sequence Diagrams. Proficient in using Business Analysis tools such as MS Visio, Word, Excel, Visual Paradigm, etc.
• Fair knowledge in testing and project management tools such as Quality Center, Test Director, Cognos and Jira.
• Experience in working with various departmental teams, developing interactive relationships with business and IT colleagues, having a thorough understanding of needs, and perspectives of both the business users and the technical team.
• Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), Tableau and POWER BI. Expertise in Installation, configuration, upgrading and a d mi n i st r a ti o n o f T a b l e a u D e sk to p / S e r v e r .
• Experience in using Custom SQL for tableau and in writing queries for generating tableau reports, formatting report layout and expressions.
• Thorough understanding of Python basic concepts like Lists, Strings, Indexing, Slicing, Tuples and Dictionaries.
• Tracked record of successfully performing requirement analysis, feasibility analysis, framework/library development, deployments and maintenance using diverse technologies.
• Expertise in Requirements Gathering through direct user interviews and workshops.
• Using project management tools like MS-Project for status reporting and planning.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

PROFESSIONAL EXPERIENCE:

Confidential, Boston

Business Analyst / Data Analyst

• Documented meeting minutes from JAD sessions and obtained sign-offs from JAD participants.
• Worked closely with business and development teams to analyze and develop the best solution design and approach as a hands-on Business Analyst.
• Successfully completed the project by releasing the applications into productions and created various user manuals, training guides and review documents to ensure complete understanding from the business end users and the clients.
• Created class diagram, sequence diagram, and collaboration diagram using MS Visio.
• Assisted with application testing and troubleshooting. Wrote user acceptance test plans and facilitate user acceptance testing activities.
• Provided daily production support for data loading activities from various source suppliers’ data warehouse into a target SQL Server database using Informatica.
• Developed monitoring and notification tools using Python.
• Development of dashboard in Tableau for data visualization to expedite the data analysis process and report automation.
• Design interactive dashboards in Tableau Desktop and published them to Tableau Server.
• Created use case diagrams using MS Visio to show interaction between the actors and the use cases as well as to demonstrate the relationship between the use cases.
• Translated dashboard business logic into rough SQL code guidelines for developers.
• Interfaced with developers to identify and resolve technical issues and bugs in the software to validate end-user requirements.
• Assisted developers to conceive logic for complex SQL query to generate views for reports and dashboards.
• Maintained a Traceability Matrix to ensure that all functional requirements are addressed at the use case level as well as the test case level.

Confidential

Data Analyst

• Develop SQL based modeling methodology identifying member patterns for inclusion in proactive health intervention initiatives and improve health outcomes and member medical costs. Similar modeling methodology utilized to identify pharmaceutical and provider trends to indicate activities consistent with suspect prescribing and practice patterns.
• Create SQL parameter-based reports within SSRS report developer environment. SQL to create stored procedures, create and alter tables and databases.
• Supporting data analysis services through traditional OLAP, cube and operational data store environments and creating n SSRS reports for business use.
• Developed Wrapper in Python for instantiating multi-threaded application.
• Developed various algorithms for generating several data patterns.
• Developing and testing Excel macros using VBA for reports and transferring data using DTS package.
• Used JIRA for bug tracking and issue tracking.
• Designed and developed a horizontally scalable APIs using Python Flask.
• Effectively communicated with the external vendors to resolve queries.
• Worke d w i t h proj e c t t e a m r e p r e s e n t a t i ve s t o e n s ur e t ha t l og i c a l a n d p hys i c a l ER/ Stu d i o d a t a mode l s w e r e d e v e l op e d in line with corporate standards and guidelines.
• Exposed to using different tools like TOAD, OEM for developing and maintaining the SQL Server database.