SUMMARY:

• Highly skilled IT Professional with around 12 years of experience working for major Enterprise Agile, Waterfall & ITUP projects, with an extensive and wide range of IT leadership, planning, skills, abilities, and experience working as Sr Technical Business Analyst.
• Managed and trained junior systems analyst to accomplish Agile and Waterfall projects.
• Experienced in working on enterprise e - commerce websites & Sales applications built on Java, .Net, CQ 5, SMX and WebSphere Commerce platforms.
• Skilled in conducting Joint Application Design (JAD) and Rapid Application Development (RAD) sessions, brainstorming sessions, requirement reviews, system walkthroughs and customer interviews for various business processes. Conducted meetings to clarify business requirements, middleware & database impacts.
• Prepared PowerPoint documents and presented the release functionality to Business clients.
• Successfully completed the functional and the technical design for .Net based Confidential web project.
• Worked on projects to document the technical solutions for third party vendor integration with the .Net website.
• Designed the technical solution to update the online order placement functionality for the .Net based e-commerce website.
• Extensive experience in documenting the Requirements, Specifications, Testing requirement documents and Production support documents.
• Experienced in project initiation, conceptual design, logical design, requirements definition, database design/modeling, system/programming specifications and documentation, quality assurance/system testing, and implementation.
• Solid experience in Designing and creating Mock-ups, Screens, Wireframes and prototypes.
• Solid release and deployment experience within production environments.
• Proven experience leading overnight bridge calls.
• Comfortable with an ambiguous environment.
• Proven ability to prioritize work, multi-task across multiple assignments and be self-sufficient.
• Excellent cross-group collaboration, outstanding communication skills and ability to work a flexible schedule and potentially weekends.
• Involved in conducting Demos, Presentations, Meetings and interaction with clients through good Interpersonal and oral communication skills.
• Experienced working in the various phases of the SDLC-, Design, Implementation and Testing in Agile, ITUP & waterfall projects. Worked with both B2C and B2B functional groups.
• Planned, facilitated, and participated in working sessions with cross functional teams.
• Experienced detailed dissection of the business processes.
• Collaborated with data architects and developers to translate requirements into technical specifications.
• Conducted peer reviews to solicit feedback on materials created.
• Willing to learn, understand and use the new technology/tool and to document as well mentor others in the team.
• Good Confidential attention to detail, time management, work prioritization, multi-tasking, estimate tasks and on-time deliverables.
• Ensured the stakeholder buy-in and signoff throughout the project lifecycle.

KEY ABILITIES:

SaaS, Unix, Linux, Siebel CRM, Salesforce, Sales UI Design, CaaS, Data Mapping, Tableau, Agile, Java, SQL, PL/SQL, Scrum, User Stories, Epic Stories, Backlog Refinement, Release Planning, Sprint Planning, Story Grooming, Sprint Demos, Sprint Retrospective, Product Backlog, Epic Stories, Daily Scrum, Lean, Kanban, Requisite Pro, Rally, Business, Functional & Technical Use Cases, Stake holder Analysis, change management (CRs), process re - engineering, Route Cause Analysis, Functional requirements (FSD), Business requirements (BRD) & technical requirements (TRD/TSD), MOSCOW, scenario planning, statistics, business rules analysis, logical and physical models etc.

TECHNICAL SKILLS:

Languages: Java, SQL, PL/SQL, Python, BPEL, UML, C#, Fortran, COBOL

Framework: ASP.Net, ADO.Net, Servelets, JSP

Architecture: BSS / OSS, REST & Service-Oriented

Analysis: Data Analysis, Data Driven Structured Analysis (Process Modelling, Data Repository, Process logic modelling), Statistical Analysis, Predictive Analysis, Data Wrangling, Data Visualization, Data Extraction, Data Modeling, Decision Analysis, Linear Regression Analysis, Multi-Regression Analysis, Data Classification, A/B Testing, Problem Solving with Analytics, Time Series Forecasting, Segmentation and Clustering, etc.

Management: Scrum Master, Leadership, Scrum Product Owner, Six Sigma Greenbelt, Design for Six Sigma.

Tools: & Utilities: SSRS, SSIS, SSMS, MS Sharepoint, Microsoft Visio, ETL Tools, Microsoft BI ToolsJIRA, Requisite Pro, Rally, Version One, Prism, MS Word, MS Excel, Blueprint, Soup UI, Ignite, JDeveloper, Eclipse, and SPSS, SAP BO, IBM Cognos, Microstrategy, Power BI, Hyperion, Informatica

Web Technologies: XML, HTML, XSLT, XSD & XPATH, CSS, SaaS (Cloud Computing), FIX, MMI

Databases: RDBMS - Oracle 9i/10g, Microsoft SQL Server 2008 / 2012, ISAM Samson, RPX, TSD, CPD & CHUB

SDLC: Agile (Certified in Scrum, Familiar with Lean, Kanban, Continuous Deployment, TDD/BDD, SAFe, Lean Startup), ITUP (IBM Tivoli Unified Process), Waterfall

Web Servers/Application Servers: Apache Tomcat 5.x/6.x, Oracle WebLogic 10g/11g, IBM WebSphere 5.x/6.x

Middleware: Oracle Fusion Middleware 10g/11g (Oracle SOA Suite, Oracle Weblogic, OSB), Oracle EBS, TIBCO, HSO, RSP, ESP, Ignite.

GIS: ArcGIS Desktop, AutoCAD, Eridas Imagine 2011, E-cognition, ArcGIS Server 10, ArcSDE 10

Operating Systems: Windows 8, Unix, Linux

CAREER DEVELOPMENT:

Confidential

Lead Business Systems Analyst

Responsibilities:

• Managed System Analysts team for accomplishing Enterprise IT VOIP/ASR Projects.
• Presented E2E demo on Siebel CRM, Neustar, and VIPR and Salesforce applications.
• Created functional and technical requirements for Siebel CRM, Salesforce, VIPR and Prime applications.
• Built Cross functional flow diagram, Sequence Diagram and Activity Diagram for VIPR and Salesforce E2E flow.
• Created Process Flow diagram in Visio for TAP/Salesforce/Bandwidth.com integration.
• Prepared traceability matrix for VIPR and Prime requirements.
• Completed Orders and Forms matrix to find the relationship between forms and orders.
• Submitted firm orders, pre-orders and service requests successfully from Neustar, TPGW, VIPR and Salesforce.
• Created firm orders related to Access Service Requests.
• Prepared sequence diagrams and activity diagrams on Salesforce, Prime UI, Prime Gateway, PSGW, TPGW, OCGW & BPS.
• Presented E2E demo on Salesforce and Prime flow.
• Performed database analysis in RDMT database to identify missing NC/NCI/SEC NCI codes in production.
• Resolved production issues based on tickets rose in JIRA and QC defects in HP Quality center.
• Prepared document inventory for Prime and VIPR.
• Implemented process improvement tasks in Microsoft Sharepoint.
• Created Tableau Visualizations in Dashboards using Tableau desktop.
• Created data visualization reports with Bar Charts, Scatter Plots, Line Plots, Tableau Stories, maps etc.
• Extracted data from database into Views using SQL queries and presented the analysis to the client.
• Involved in creating database objects like tables, views, procedures, triggers and functions using Confidential -SQL to provide definition, structure and to maintain data efficiently.
• Created filters, parameters and calculated fields for preparing dashboards and worksheets in Tableau.
• Built, published customized interactive reports and dashboards, report scheduling using Tableau server.
• Built different kind of reports using Tableau like parameterized reports, Ad hoc reports, Drilldown reports and Drill through report.
• Used Tableau to generate Enterprise level reports related tablix, matrix and list data.
• Used Tableau to develop enterprise level ETL processes that include process logging, data validation and data integrity checks.
• Experience is desirable in data analytics, data mining, trending and forecasting as well as familiarity with Data Modeling and Data Warehouse design principles and implementation.
• Published reports on to SharePoint instance and created Web Parts in SharePoint to show various reports generated from Tableau and Excel in one page.

Confidential, Middletown, NJ

Lead Business Systems Analyst

Responsibilities:

• Lead Jr System Analysts for accomplishing agile Projects.
• Managed and trained junior systems analyst to accomplish Agile and Waterfall projects.
• Extensively worked on Core Java, read the code from basic Java, object Oriented concepts like inheritance, polymorphism, Encapsulation, Abstraction, Data hiding, etc.,
• Worked on creating Web APIs which are based on SOAP, REST and JSON. REST is used in one of our IPAD application (Sales Express) which is Client-Server based architecture that can cache the data received from database without calling every time when data is needed that has increased the application performance. Designed the application interface document for this REST based application.
• Designed several SOAP and JSON based application interface documents for Web apps like ADOPT, SSDF. Apart from this worked on other applications like PricerD, IMS2 etc.,
• Interacted with onshore and offshore dev team daily for reviewing the user stories.
• Worked on activities like writing or understanding pseudo code or actual Java code, running SQL queries in SQL Developer to understand the logical relationship between design and pricing tables.
• Used java script for data validations in forms.
• Designed UX for various projects & cross functional E2E flows using Microsoft Visio.
• Identified the tables, packages & web services impacted for every project to calculate function points for project estimation.
• Worked on several Agile, Waterfall and ITUP projects used tools like CA Technologies Rally, IBM Requisite Pro, IBM TDP, to write technical user stories, High-level Design Documents, System design documents, application interface documents, & application design documents etc.
• Reviewed Epics, business requirements, architecture documents, E2E flows, etc.
• Effectively participated in backlog refinement meetings, daily scrum meetings, sprint planning, sprint retrospective etc.,
• Worked throughout SDLC process starting from Kick off till deployment including testing support to resolve defects in QC & JIRA during System Testing, UAT, & UCT. Worked in Agile Test Driven or Behavior Driven Development framework on several projects.
• Prepared User Stories, BRD, HLD & SRS documents for the Agile & ITUP projects listed above.
• Reviewed JRD, ISA, AID & Application Design Documents for ITUP projects.
• Wrote Impact Statements to get the Dev and ST estimations for new projects both Agile & waterfall.
• Reviewed ST and E2E test cases, & prepared PowerPoint documents & presented release functionality to business clients. Attended application design document reviews for agile projects.
• Worked as technical analyst & Scrum Master for various projects with offshore team in India.
• Prepared Application Interface Documents for various agile projects.
• Worked with E2E testers to help them in resolving defects.
• Supported major enterprise wide releases for all the above listed agile projects.
• Worked on weekly maintenance work for ADOPT sales application.
• Wrote technical change request documents for few projects.

Confidential, Bothell, WA

Sr Business Systems Analyst

Responsibilities:

• Collaborated with business to define requirements and recommend optimized solutions.
• Interviewed stakeholders to elicit and document business needs for detailed software changes.
• Presented requirements to business leaders and facilitated discussion to build consensus on the completeness and accuracy of requirements.
• Participated in high level solution and detailed design reviews.
• Performed as the liaison between IT resources and the business team to resolve questions from IT resources regarding the requested software changes.
• Conducted system impact analysis including upstream and downstream impacts and proposed solutions.
• Prepared cross functional flows in Microsoft Visio for Confidential and Confidential Projects.
• Conducted bug triage in quality center for all the projects to assist testers during QAT & UAT.
• Reviewed night of deployment test cases and logged defects to appropriate teams for validation.
• Analyzed the system built to replace SOAP to REST based web services
• Conducted meetings to clarify business requirements, middleware & database impacts.
• Worked on release and change management along with Process Governance.
• Participated in the planning and implementation of new application or version releases and major technology upgrades.
• Served as an escalation point for all issues and questions associated with a release
• Used subject matter experts, circumstantial evidence and sound judgment to mitigate risks by adjusting releases and/or release management process requirements.
• Used post release reviews to improve and adjust documentation on the release process, roles and responsibilities, policies and procedures
• Assisted in resolving production support issues.

Confidential, Akron, OH

Web Systems Analyst

Responsibilities:

• Developed the Business Intelligence technical and functional roadmap. Partnered with the BI leadership to ensure that the roadmap aligns with the overall vision and the direction for the BI team and for the Enterprise Data Warehouse (EDW).
• Collaborated with the business to define BI / Analytics requirements and recommend the optimized solutions.
• Mapped the business problem statements to the logical model.
• Articulated changes to the current environment that will be required as a result of the required business intelligence / analytics capabilities as defined within a given project.
• Created numerous processes using MS Visual Studio (SSIS, SSAS & SSRS).
• Created reports, graphs and the data for multiple levels of process stakeholders including but not limited to management.
• Performed Extracting, Transforming and Loading (ETL) data from Excel and Flat file, using SSIS services.
• Accomplished ETL implementation using SQL Server Integration Services (SSIS) in OLTP and Data warehouse Environment.
• Participated in continuous improvement activities related to requirements management and its integration with other phases of the lifecycle.
• Interacted with the clients and the architect for gathering the functional requirements and documented them. Identified Use cases from the requirements and wrote the Use Case Specifications.
• Created the business process workflow diagrams (Activity diagrams) in Visio.
• Developed and configured the pick lists, MVG’s, Screens, Views, Links, Joins, Business Objects to meet the user interface layer requirements.
• Prepared technical reports by collecting, analyzing, and summarizing information and the trends.
• Contributed to team effort by accomplishing related results as needed.
• Wrote and compiled queries to extract data.
• Build and maintained excellent relationships and negotiated effectively with internal customers and resource teams such as developers, testers, etc.

Confidential

Project Manager

Responsibilities:

• Coordinated and directed the programs, made detailed plans to accomplish the goals and directed the integration of technical activities.
• Consulted with the customers to define and prepare the project specifications. Conferred with the management, production, and the engineering staff to discuss the program activity.
• Reviewed and captured the changes in scope, monitored contracts, tracked the deliverables & cost.
• Primary relationships with the engineering staff and with the mid-level managers & the supervisors as a whole.
• Participated as a member of the program management team (PMO).
• Had a responsibility to comply with the company standards, programs, systems, and policies.
• Strong consulting & coaching skills; effective advisor to management and engineers.
• Effectively managed expectations and resolve conflicts that balance customer and company needs.
• Managed the day-to-day client program stakeholder relationships.
• Consulted with the client to ensure that the project and the program work aligns with the client expectations and supports the achievement of the business goals.
• Lead the effective and efficient delivery of the large complex cross-functional projects.
• Balanced the business needs versus the technical constraints.
• Gained consensus on the technical and operational decisions to ensure that the appropriate business practices are used to deliver the high quality results.
• Identified, assessed, tracked and mitigated the issues and the risks Confidential multiple levels.

Confidential

GIS Systems Analyst

Responsibilities:

• Created the geo-data and web map applications to develop Confidential maps.
• Identified and escalated the geometric errors in production.
• Coordinated the activities of the quality team.
• Re-assigned the production work to vendors with the quality performance spreadsheets.
• Provided a general GIS system administrative support service within the department.