SUMMARY:

• More than 8 years of experience in multiple roles such as Senior Business Analyst, Business Systems Analyst, Data Analyst, and also a module lead in a Service Delivery Project in diverse verticals such as Banking, Finance, Retail, Mortgage, and Healthcare
• Experience creating Business Requirements Document BRD , Functional Specifications Document FSD , Non-functional Requirements Document and Use Case Specifications
• Experience in writing SQL queries to generate reports from Oracle database and SQL Server database, writing stored procedures and functions to maintain the data quality in the database
• Exemplary verbal and communication skills that is necessary to elicit requirements through shadowing, Repository lookups, interviews and JAD sessions with Stakeholders, Business Owners, Business Users, SMEs and specific stakeholders relevant to the project
• Extensive experience in creating As-Is and To-Be process models, conducting Gap Analysis to understand pain points and analyzing the risACks involved through SWOT and gap analysis
• Skilled in identifying data requirements, creating data flow diagrams, business process flows, data mapping, data analysis, Process mapping and BPM
• Skilled in data modeling Conceptual, Physical and Logical and creating Entity-Relationship diagrams.
• Designed data models and conducted normalization and de-normalization of data to fit OLTP and OLAP frameworks respectively
• Extensively used SQL Server database to extract data using advanced SQL queries and analytical functions
• Significant knowledge and experience in using ETL tools such as Informatica
• Knowledge of DDL, DML, DCL, and DQ in RDBMS
• Experience on managing data held in RDBMS by writing, testing and implementing SQL queries
• Significant experience in reviewing Test Procedures and creating Test Cases, Test Scripts and Test plans
• Extensive knowledge in content management systems such as SharePoint and its workflow architecture
• Experience working in different SDLC cycles including waterfall model and agile methodology
• Experience in gathering requirements from business stakeholders by conducting interviews, defining the business processes and working on process improvement
• Certified R Programmer and have extensive statistical knowledge on regressions, ANOVA, cluster analysis, decision trees, cross tabulation, chi-square tests
• Adept at conflict management, work delegation, and negotiation
• Excellent communication, organizational and networkingskills
• Experience leading and working with off-shore teams
• Experience mentoring and monitoring junior Business Analysts

SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Sr Business/DataAnalyst

• Involved in gathering business requirements by conducting a series of meetings and brain storming sessions with the business users
• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality
• Created Use Cases, Business Requirements Documents BRD , Functional Specifications Document FSD
• Created Business Process Flow diagrams
• Involved in identifying the process flow, the work flow and data flows of the core systems
• Worked extensively on user requirements gathering and gap analysis
• Created Conceptual, Logical Modeling and Physical Database design for OLTP and OLAP systems
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities
• Monitored the Data quality of the daily processes and ensure integrity of data was maintained to ensure effective functioning of the department
• Developed Business Process Modeling and Process Flow Diagrams
• Conducted logical data model walkthroughs and validation
• Worked with DBA's to create a best fit physical data model from the logical data model
• Implemented Referential Integrity using primary key and foreign key relationships
• Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using Erwin data modeling tool
• Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models
• Created Design Fact Dimensions Tables, Conceptual, Physical and Logical Data
• Involved in designing the integrated Data Warehouse for the company to store the data from the OLTP systems
• Involved in implementing and testing of the developed application data standards
• Data Warehouse - Designed and programmed ETL and aggregation of data in target database, working with staging, de-normalized and start schemas and dimensional reporting

Environment: SQL Server 2012, Oracle 11g, Erwin, PL/SQL, MS Word, MS Excel, MS PowerPoint, MS Outlook

Confidential

Sr Business Systems Analyst

• Elicited the requirements through shadowing the executive managers to understand the business requirements of analytical reports
• Wrote Use Cases, BRDs, FSDs, Business Process Flows and Business Rules
• Interacted with different source system architects to understand the source data and data file layouts
• Conducted interviews with the Business Owners BO to understand the To-Be Future state system functionalities
• Conducted user interviews with portfolio accounting application management group and business domain SMEs to capture user requirements, business rules, and business processes.
• Assisted the team lead in planning conducting the JAD sessions, preparing the meeting minutes and developed the BRD.
• Identified the major tasks, timelines for each tasks and assisted the project manager in preparing the project plan using MS Project.
• Identified and documented the business rules and mapped the business requirements and functional requirements.
• Defined the enhanced asset classes and various models in the BRD.
• Conducted Data Analysis to identify potential opportunities of improvement and recommended them to the Business Owners
• Created data requirements analysis and data sensitivity and risk analysis documents
• Prepared the product assessments with help of user stories collected through requirements gathering and gap analysis
• Conducted data mapping, data modeling, and data profiling using SQL, de-normalization models and created transformation logics
• Created reports using Tableau for validation of slice and dice data marts
• Assisted in Data warehouse architecture and transforming OLTP to OLAP databases
• Conducted Feasibility Analysis and Product backlog planning with the Product Manager
• Expressed the requirements through user stories, use cases, business rules, story boarding, future state mapping and process flow diagrams
• Utilized SharePoint as an administrator for document management, version control and creating team dashboards on the team site

Environment: Hybrid Agile Scrum, SQL, SQL Server 2010, JIRA, Informatica, Tableau, MS Visio, MS Access, MS Project, MS Excel, MS PowerPoint, MS Word, MS Outlook, SharePoint

Confidential

Sr Business Analyst

• Worked with business users, gather requirements and developed complex SQL queries to generate reports from Oracle database for the business team that facilitates better understanding of the customer profile
• Managed scheduled jobs using Autosys job schedules in UNIX environment
• Conducted interviews with stakeholders across the team to document the business processes with the help of Microsoft Office Visio to keep the business and technical documents up to date
• Implemented an initiative to improve the usability of media files in business documents that resulted in 90 time savings
• Addressed ah-hoc requests from business stakeholders that involved tasks ranging from data analysis and report generation to backend testing of data to adhere to the business standards
• Implemented data cleansing solutions in the database with the help of regular expressions to maintain the data quality in the database system by writing SQL queries
• Logged and tracked data management requests using the Serena Team Track tool
• Organized a code fest tech event that involved decision making in venue, food, infrastructure etc.
• Learned to generate enterprise reporting dashboards using Qlikview

Environment: Oracle 9i, PL/SQL, Toad for Oracle, Microsoft Visio, MS SharePoint, MS Office Suite Word, PowerPoint, Excel, Outlook , BMC Remedy IT Service Management, Serena Team Track, UNIX, Autosys Job Schedules, Nintex Workflows, Qlikview, MS Access.

Confidential

Business Analyst

• Involved in multiple projects for US clients including Nokia
• Collaborated with Product and Production manager on a production support project for the employee portal SharePoint site
• Coordinated a team of 13 members that managed 1500 SharePoint sites
• Developed custom workflow Auto Acknowledgement System that saved 240 person hours, eliminating the need for additional staffing
• Devised an issue resolution database by analyzing issue inflow and team performance metrics, which reduced customer complaints by 20 and increased client satisfaction to 95 a raise of 3.5 from previous year
• Initiated the creation of value additions for process improvement e.g. Monitor Portal Outage and customer satisfaction e.g. Content Approval Workflow that decreased respective lead time by 25
• Performed as a Technology Innovation Lead at account level with a headcount of 84 members to experiment on synergy outcomes
• Gathered requirements from product owners to identify business issues, categorized under different priority levels and formulated solutions to enhance the business process
• Prepared the business requirements documents and maintained them in SharePoint repository
• Mentored 5 associates in the team by giving them technical training regarding the project and associated tasks related to the project such as email and phone etiquettes
• Improved the response time of medical emergency service in the company at organization level by reforming the three stage approval process to single stage process

Environment: MS Office SharePoint Server 2007, MS SharePoint 2010, MS SharePoint designer 2010, MS Office Suite, BMC Remedy IT Service Management, MS InfoPath 2010, SharePoint integration with other office utilities