| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Watchung, NJ | PHONE NUMBER AVAILABLE | EMAIL AVAILABLE | LINKEDIN LINK AVAILABLESENIOR SYSTEM BUSINESS ANALYSTStrategic and collaborative leader with experience gathering user requirements, designing and developing innovative solutions, analyzing data, documentation of functional and technical requirements, facilitating UAT and demo sessions to enhance user ability and ensure proper workflows for executive-level internal and external clients. Recognized with extensive experience as a SQL Developer in the maintenance of relational databases, data integration, coding, and creating reports. Core competencies include:Requirements Gathering | Business Process/System Analysis and Data Modeling | Data Analysis | Business and Technical Documentation | Functional Design | Software Development Life Cycle (SDLC) | Legacy System Re-engineering | Agile | Waterfall | JAD| Production Support | Cross-Functional Team LeaderTECHNICAL SKILLSJIRA, SQL Server, Transact-SQL, SSRS, TFS, Power BI, UML, Word, Excel, Visio, Balsamiq, PowerPoint, MS Access, Data Warehouse, Visual Source Safe, SSAS, SSIS, ClearCase, CVS, Rational, ORACLE, Visual Basic 5.0/6.0, C#, VB.NET, XML, XSL, Crystal Reports, VBScript, HTMLEXPERIENCELasComp Institute of IT February 2020 February 2021Continuing Education: 70-768 Developing SQL Data Models (Microsoft certification ID: 990230729) 70-767 Implementing a SQL Data Warehouse 70-778 Analyzing and Visualizing Data by Using Microsoft Power BIREALOGY HOLDINGS CORP. August 2006 October 2019Senior System Analyst / Business Analyst
Subject-matter expert for billing related processes, BI reports/dashboards for dash applications. Translated business requirements into business and functional specifications, user stories and acceptance criteria. Managed Product backlog on behalf of Product Owner. Led or participated in cross-functional teams to proactively address support issues. Proficiency in Real Estate analysis. Led the dash International Franchise Management System re-engineering project which included Reverse Engineering of the legacy system, Gap analysis based on existing legal franchise agreements, defined various Billing models for all international agreements for the new system, created User Interface (UI) screen mock-ups for Franchise Agreement Management/ Billing Terms Set Up/ Billing Invoicing/Administration/BI Reporting modules. Created business, functional specifications and user stories for UI screens, monthly income reports calculation, various monthly charges calculation, income reports and invoices generation, reports and BI dashboards.
Managed reports conversion (over 500) for the dash UI application and PowerPoint portal. Analyzed legacy reports, created mock-ups, user stories, and acceptance criteria. Provided technical team with common report standards.
Partnered with stakeholders to understand and documented definitions and calculations for major KPIs that used across Real Estate industry. Converted requirements into functional and technical specifications. Created multiple KPI related reports and dashboards to help senior management determine the performance and health of the company.
Involved in most project phases for re-engineering dash Domestic Franchise Management System including requirements gathering, preparing solutions, development, data migration, conducting UAT and demo sessions with the users. Analyzed and defined all Billing models for Realogy domestic franchises. Created functional and technical specifications for each Billing model calculation
Identified root cause on reported issues for various Realogy systems/reports/dashboards and provided with the solutions. Created multiple SQL objects for SSRS/Power BI reports, ad-hoc requests, and back end processes. Created SSRS reports and Power BI dashboards Implemented back-end process that captured SOX related data from CRM application, and created SOX User Privilege Access control reports for more than 20 applications. Collaborated with different teams to collect evidence of effective internal control for SOX compliance audits.CENDANT CORP. October 1998 August 2006Technical Lead
Developed all charge calculation related processes, and reconciliation processes between multiple systems. Recognized for providing excellent production support for existing applications. Led CREST system integration with multiple back office vendors project.
Participated in Data Warehousing project including data modeling, defining business rules, data mapping for different types of sources, creating various reports.
Delivered Incentive and Rebate system for multiple Brands/Programs/types of firms.
Conducted analysis, created functional and technical specifications, developed several modules for major broker applications and back end processes, created multiple Crystal reports.
ADDITIONAL RELEVANT EXPERIENCEREDI-MAIL DIRECT MARKETING, INC.
Senior Programmer / Analyst
RCCS
Programmer / AnalystSTATE SUBWAY DESIGN COMPANY (MTA)
Programmer / Analyst
EDUCATIONBachelor of Computer Science (BS)
National Engineering University of Transportation (NTU), UkraineCERTIFICATIONSMicrosoft certification: Developing SQL Data ModelsMicrosoft Certified Professional in VBPROFESSIONAL DEVELOPMENTLasComp Institute of IT: Implementing a SQL Data Warehouse
LasComp Institute of IT: Developing SQL Data ModelsLasComp Institute of IT: Analyzing and Visualizing Data by Using Microsoft Power BILearning Tree: Agile Fundamentals TrainingLearning Tree: Certified ScrumMaster Certification TrainingLearning Tree: Agile Product Owner TrainingLearning Tree International: Writing Powerful SQL Queries for SQL ServerLearning Tree International: Implementing a SQL Data Warehouse TrainingCALC/CANTERBURY: System Administration for Microsoft SQL Server 7CALC/CANTERBURY: Implementing DB Design in SQL Server 7 |
