SUMMARY

• Accomplished and result - driven IT professional with 4+ years of experience as Business Analyst and SQL Server Developer
• Business requirement gathering from various sponsors and stakeholders by understanding business goals and priorities through research, formal-informal sessions, JAD sessions with teams, stakeholders and end users
• Drafting business requirements and functional requirements in the form of BRDs, FRDs With great technical detail to support actual implementation of project. Hands-on experience with MS Visio and Use Case diagrams for creating data flow/process flow diagrams such as flowcharts, activity charts, sequence diagrams as per UML.
• In depth of knowledge of software development life cycle (SDLC), Waterfall, Agile/Scrum methodologies and Rational Unified Process (RUP), as well as data warehouse concepts such as OLTP, OLAP, ETL, Star and Snowflake Schema, data mapping, facts, and dimensions.
• Proficiency in designing and reviewing, Expertise in implementing Test Plans, Test cases, Functional testing, Regression Testing and Integration Testing, UAT, as well as maintaining Requirement Traceability Matrix.
• Strong experience in working with PL/SQL, Strong SQL Server programming skills with experience in working with functions, packages and triggers. Proficient in data entry, data auditing, creating data reports & monitoring data for accuracy.
• Team player with excellent interpersonal and communication skills. Technically competent and goal oriented with problem solving skills. Excellent team management and leadership skills. Additionally, great presentation skills regarding communication with both business and technical teams.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Business Analyst

Responsibilities:

• Worked closely with Product Owner and Stakeholders in an Agile SCRUM environment to improve, prioritize, and support the development, testing and release of functionality
• Worked closely with development team to verify that business needs are fulfilled, and deliverables are produced within specified budget, quality, and time
• Documented BRD/FRS and explained the functional and non-functional requirements to developers
• Developed and implemented test plans and test reports, which included writing and running test cases ensuring all the functionalities are properly tested, Faciliated SIT and CIT by providing test data and test cases and Performed User Acceptance Testing (UAT) with client
• Analyzed bugs, defects using JIRA, interacted with team members in fixing errors
• Created User Stories, Test Cases utilizing Target Process Agile methodology tool.
• Involved in reviewing Test Procedures, defining Test cases, reviewing and maintaining Test scripts, analyzing bugs, interacting with team members in fixing errors and User Acceptance Testing (UAT).
• Involved in developing and executing SQL queries to verify the proper insertion, deletion and updates into the Oracle supporting tables and cubes.
• Coordinated with QA team for Test plan and conducted meetings in between developing team and stakeholders.
• Partnered with QA Manager and Developer Lead to tackle software defects in a timely manner and keep the documentation up to date
• Thoroughly Studied Test reports submitted by the QA team.

Confidential, NY

Business Analyst

Responsibilities:

• Worked extensively with Wealth Management Financial Advisors to acknowledge the business requirements by prototyping, meetings, workshops, and interviews
• Coordinate with a multitude of different departments to maintain dashboard usage and data from varying reports of ever-changing data
• Communicated with business sponsors to elicit business/functional requirements and generated use cases. Used UML diagrams to write Wealth Management system models, covering conceptual ideas.
• Used MS Excel and SQL Server to implement data mapping, data validation, data reconciliation and data enrichment
• Assisted Financial Advisors to conduct comprehensive reviews including asset allocation, risk management, preservation of wealth, accumulation, and wealth transfer strategies
• Worked closely with development team to verify that business needs are fulfilled, and deliverables are produced within specified budget, quality, and time
• Documented BRD/FRS and explained the functional and nonfunctional requirements to developers
• Developed and implemented test plans and test reports, which included writing and running test cases ensuring all the functionalities are properly tested

Confidential, NY

SQL Server Developer/ETL Developer

Responsibilities:

• Created Star schema dimension modeling for the data mart using Visio and created dimension and fact tables based on the business requirement.
• Designed SSIS packages to Extract data from different sources like SQL server 2012, MS Excel, MS Access, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS
• Wrote complex SQL queries and stored procedure to create reports using SSRS 2008 from the relational database
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations.
• Data analysis and Designed the logical and physical model architecture for database.
• Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables
• Developed and maintained system documentation, diagrams and flowcharts.
• Worked with project manager and technical leads for resolution of technical issues.

Confidential, Staten Island NY

MS SQL Server Developer/SSRS

Responsibilities:

• Worked on the complete life cycle of the project from design to implementation
• Translated user requirements into functional and technical requirements in coordination with the Sr. Business Analyst. Analyzed the business requirement and functional specifications provided by the data specialist
• Responsible for designing and maintaining a wide variety of daily, weekly, and monthly financial and analytical reports used by different departments within the company.
• Responsible for making sure reports are scheduled and delivered in a timely manner
• Designed reports using proper text formatting, report headers and footers, and page size to allow for printable reports.
• Produced operational reports in SSRS 2012 i.e., drill-down, drill-through, dashboard and matrix reports.
• Created ad Hoc and parameterized various reports using SQL server 2008R2 & SQL Server reporting Services 2010 with data from SQL Server and MS Access as data sources
• Created dynamic Reports from the cube using SSRS and stored procedures.