SUMMARY:

• A Technical and management professional with 5+ Years of experience concentration in business analysis, business intelligence and data analytics and a keen knowledge of numerous technical applications and programming languages, and a background in team leadership. A motivated problem solver with an aptitude for innovation and solution development. Communicative and personable, a technology evangelist who clearly and persuasively describes the benefits of various technologies. Will benefit the organization by combining technical, managerial, academic training and leadership skills to drive productivity and savings.

TECHNICAL SKILLS:

Languages: VB.Net, C#.NET, ASP.Net, HTML, CSS, JavaScript, AJAX.

Analysis / Reporting Tools: Tableau, IBM Cognos Analytics, SSRS, IBM Rational RequisitePro, Google Analytics, Advanced Excel (Vlookup, pivot tables, macros, regression, data modelling).

Database Platforms/Cloud: MS SQL Server, Oracle SQL Developer, MS Access, Oracle 11g, SQL Server 2014 Management Studio, My SQL/Workbench, Teradata, Amazon Web Services.

Methodologies / Frameworks: Agile and Waterfall Methodologies. TOGAF and Zachman Framework.

Tools and Software: MS Visual Studio, ProVision, MS Visio, MS Project Professional, MS Office Suite Professional.

PROFESSIONAL EXPERIENCE:

Confidential, TX

Business Analyst

Responsibilities:

• Developed As - Is and To-Be flowcharts and wrote business requirements and technical requirements. Managed development team by working with them to review business needs and monitor progress based on project schedule.
• Designed CRM data reports to accurately track sales operations work flow, processes and documented monthly performance.
• Accelerated several manual business processes by working with developers and business users to determine best solutions.
• Designed and wrote use cases and test cases including functional specifications.
• Designed and created complicated SQL queries for production support data analysis.
• Led collaboration for the integration and communication among applications, databases and technology platforms on a Business level.

Confidential, OH

Business Analyst

Responsibilities:

• Gathering design, development requirements from product owners by creating use case diagrams, high level process flows and analyzing them to provide end-to-end solution design for application development.
• Worked with diverse stakeholders, business customers and project managers to define and translate business requirements into PRDs (Product Requirement Documents) for the development teams. Involved in identifying functional and Non-Functional requirements and create the Functional System Design document (FSD).
• Provide strategic consultation by translating business requirements into prolific solutions conducting Impact analysis, GAP Analysis and JAD Sessions, participating in sprint planning and daily scrum stand up meetings.
• Prepared Logical Process and Data Models that contained set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document Business Data Requirements including grooming of project backlog stories.
• Performed code reviews and design reviews to ensure quality of deliverables and functional requirements are achieved by including troubleshooting, debugging and testing of application software.
• Analyzed statistical reports on the company’s web traffic using MS Excel and generated business reports, visualizations using Tableau and IBM Cognos Analytics, generating Tableau Dashboards, mitigating defects by 15% by developing metrics to determine inefficiencies and areas for improvement across systems.
• Implemented a cost-benefit analysis report to address financial and economic viability of the application system.
• Involved in UAT and logged test results per the test plans using Quality Center.

Confidential

Business Analyst / Developer

Responsibilities:

• Participate in requirement analysis of the projects along with business Owners.
• Prepared traceability matrices to ensure that business requirements are met by defining technical specifications.
• Designed and developed complete front-end applications including user interface by using C#.NET and VB.NET Web forms by utilizing HTML, CSS and JavaScript which also included implementation of validation controls and form controls.
• Constructed web pages encapsulating the business logic to provide separation of data and presentation layers which included entity framework in design and implementation of both the layers for the applications using AngularJS, HTML Controls, JavaScript, JQuery, Bootstrap and CSS.
• Created basic table reports using SSRS and developed configuration pages for a website that included multiple language and time zone support using technologies like Google Maps, Google Charts, JavaScript and JQuery to display data.
• Database development using relational database management systems like Microsoft SQL Server, MySQL and Oracle by creating queries, views, trigger and stored procedures that are used throughout the applications in the database.
• Developed Process Flow Diagrams /Activity Diagrams, Test Cases, Use Cases and performed Functionality testing, Regression testing and involved in UAT for web applications in the business units within the organization.

Confidential

Program Analyst / Business Analyst / Web Applications Quality Analyst

Responsibilities:

• Translated business strategy and requirements to Functional & Technical Specifications including database design & development of enterprise level applications.
• Redesigned and remodeled various tools to minimize task redundancy, optimize time & improvise operational efficiency.
• Designed and engineered an application called ‘XShare’ for knowledge sharing, aimed at creating and scheduling knowledge sharing events for training purposes.
• Developed a Publishing Outlet Management Systems application which helped publishers and outlets to track their products and sales.
• Responsible for creating test plans, test cases and test cards based on user cases in business requirements to cover both functional and non-functional requirements.
• Utilized WAPT to test web applications and web related interfaces including performance testing to verify the response time of the server and throughput under load conditions and Security testing to prevent access of unauthorized data and theft of data.
• Managed test cases, defects and reports in Quality Center. Continuously streamline and improve the Testing Life Cycle to ensure test planning, execution, and reporting coordination.
• Devised test data by executing SQL queries and joins, including database schema for web applications.
• Testing, verifying the fixes for issues found, including enhancements requested by line of business in production.
• Used statistical analysis to identify insights and conclusions from complex data that included software documentation to prevent loss of data.
• Developed and conducted usability tests, implementing enhancements to improve user experience.
• Collaborated with developers on test case design and utilized QTP testing methods during system software releases to ensure successful project launches. Managed requirements gathering, analysis and design for website enhancements and application development.