We provide IT Staff Augmentation Services!

Technical Analyst/architect - Application Development And Reporting Resume

Fresno, CA

SUMMARY:

  • Technical Product Owner/Senior Systems Analyst with 12+ years of experience in Business Intelligence Product Integration, implementation, support and development. Acquired and proven diverse experience as Project management in BI, GIS, Application Development, SharePoint Implementation, Legacy, .NET & BI Applications Integrations and Custom Software Development. Excellent leadership and agile management skills in leading a team of Developers, QA, BA, and Operational analyst. Led team with examples with product ownership, technical analysis and requirement gathering, analyzing, documenting, designing, developing and implementing customized solutions. Provisioning and providing quick solutions using best market practice approaches technology and methodologies.
  • Presently working with as Technical Product Owner / Sr. Systems Analyst in Fresno, CA with Confidential for the project of School Administration and Human Resource Management Systems enhancements, reengineering and BI reporting/visualization.
  • Comprehensive experience in Finance and HRMS (3 years in Payroll, Time & Expense, Onboarding and Personnel Requisition), Property & Casualty Insurance (6 years), Banking domain (1 year), Products Inventory & Book - of-Business (1 year), and Hospitality Industry (1 year) with Business Application Development, Enhancements, and Support
  • Extensive experience with application analysis of Insurance customer online application for Home and Fire (Dwelling) clients in Policy life cycle, Quotes, Underwriting and Issued policies and claims. Umbrella coverage and liability, Disaster zone, and Fire insurance policies and their Do-Not-Renew flagging, Discounts, and Claims applications
  • Proven experience in database architecture review, recommendation, development and maintenance for scalability, sustainability, and adaptability of application requirements
  • Initiated and Developed the database health check automation, auto backup & recovery and disaster recovery procedures for multiple clients
  • Expertise and hands-on experience in all the phases of Software Development Life Cycle, including requirements gathering, data analysis, technical design, development, testing execution, implementation, performance analysis, UAT signoffs and post-production support
  • Techno-Functional lead in transforming business requirements to technical requirements, documentation like design documents, high/Low-level test approach, strategy, and planning
  • Prolific confidence, positive attitude, strong aptitude, inter-personnel skills, expert technical writer, experienced in concurrent project management, go-getter and lead by example believer
  • Extensive experience in client presentations, proposal drafting and submissions
  • Complete knowledge of registration, scheduling and billing processes for Revenue Cycle and Organization planning flow
  • Proven ability to research, architect, analyze and translate complex business and technical information to stakeholders, SMEs, and developers at all levels of the organization. Involved in Defining, Gathering, Documenting, and Managing requirements to identify the real business need of the client company
  • Developed use case diagrams, sequence diagrams, state diagrams and activity diagrams, business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML).
  • Experience in producing documents like Business Requirements Documents (BRD), Functional Requirement Documents (FRD), Software Requirement Specifications (SRS), Creating Request for Proposals (RFP), creating Requirements Traceability Matrix (RTM)
  • Hands-on experience in service management and ITIL module implementation over the multiple departments and developing centralized solution and reporting
  • Experience in creating Prototypes and Wireframes and documenting them using MS Visio and Enterprise Architect
  • Involved in all phases of Testing life cycles including integration testing, User Acceptance Testing (UAT) Functional testing/Black Box Testing, Regression testing, GUI testing, and performance testing
  • Expertise with SQL, BI/DW, ETL, DB2, Oracle, BI Reporting Technologies
  • Demonstrated ability to adapt to new environments, learn new skills and participate/lead teams.
  • Creative and aggressive self-starter and a versatile team player with excellent problem-solving capability for collecting clear and detailed Business Requirements and Functional Specifications.

TECHNICAL SKILLS:

Project Management / Requirement Tools: MS Visio 2016, SharePoint 2016, Rational Rose, Oracle BRM, and Rational Requisite Pro, JIRA & Confluence.

Methodology: RUP, RAD, AGILE, Waterfall, SCRUM, UML

Modeling and Planning Tools: Rational Rose, MS Visio, Unified Modeling Tools, Primavera, PlanView, and MS Project

ETL: Informatica Power Center 8.6/7.x on UNIX platform, SSIS

OLAP/DSS Tools: Business Objects 6.5 / XI 3.1, Apache Hadoop, Web-I, Cognos 8.1, SAS, MS SSAS, MS SSRS, QlikView,PowerQuery, PowerPivot, PowerView, Power BI, Looker, Logi Analytics, Tableau

Database Modeling: Erwin3.5.2/4.2

Databases: Teradata 6.8/8.2/12, Oracle10g, SQLServer7.0, DB2-9.x, MS Access97/2000

DBTools: Teradata SQL Assistant, TOAD 9.7, SQL* plus

GIS Tools experience and exposure: AddressBroker 3.3, Geostan, ESRI ArcMap, ArcGIS Server 10, ArcSDE, MapPoint 11, Excel Map.

BA support utilities: DRAT, Clarity, Rally, JIRA, BMC-Remedy v6.3, HP Service Manager v8.1/v9.3, MS Office 2013 Suite, TestComplete for UAT automation

PROFESSIONAL EXPERIENCE:

Confidential, Fresno, CA

Technical Analyst/Architect - Application Development and Reporting

Responsibilities:

  • Analyze existing HRMS (3 years in Payroll, Time & Expense, Onboarding and Personnel Requisition) legacy applications, support and address issues of legacy systems users
  • Gather, document, refine and own the PRD, FRD, TRD and Technical Presentations
  • Review and revamp the reports from legacy system to Logi reports.
  • Create STTM, Calculation, Business Logic implementation and review Store Procs outputs.
  • Architect, Design, and Develop portal based solution School Management and Administration software
  • Lead JIRA implementation and reporting
  • Converting Flex and Cristal Reports to Portal Logi based reports and dashboards
  • Manage Epic, Backlogs, Tasks, Issues, Bugs, User stories for team and act as Spring Master
  • Attend technical and business stakeholder sessions

Confidential, Tampa, FL

Senior SQL Developer/BI reporting

Responsibilities:

  • Initiating report review and performance tuning initiatives
  • Collaborating with internal DWH/BI customers and departments to centralize the reporting solutions, applications and architecture
  • Documentation of requirements and solution designs
  • Teradata SQL Query maintenance and JIRA reporting

Confidential, Alpharetta, GA

Solution Architect and Technical Project Manager - BI

Responsibilities:

  • Leading discovery session with potential clients to address their challenges
  • Application analysis and Architecture exploration for clients
  • Documentation of requirements and solution designs
  • Effort estimation and Proposal writing
  • Perform platform setup, Design Solution, and Develop or Lead Development activities
  • Validate the provided solution and deploy in production
  • Production support and closing activities

Confidential, Alpharetta, GA

Solution Architect (BI) - Development and Technical Project Manager/Mentor

Responsibilities:

  • Developed a BI Solution for Confidential to be integrated with their existing application for their clients across globe
  • Perform detailed analysis of current data structure, data distribution and storage for the scalability and preparation of future data flow in BI applications
  • Setup and developed Azure cloud-based solution to in corporate Azure SQL 2016, Power BI and Azure Automation for data refresh
  • Built entire stack Data Dictionary, Data Models, Data Warehouse, DWH ETLs, Power BI data model, Power BI reports and dashboards

Confidential, Alpharetta, GA

Data Analyst/BA - Payroll and HRMS Application

Responsibilities:

  • Architect a Custom packaged solution for ADS to replace and enhance the existing payroll module
  • Perform detailed analysis and documentation of current and legacy application and systems, heir data flow, and storage for the application scalability and preparation of future modules to be developed
  • Led the exercise of designed the solution and managed offshore team for individual HRM module development like Payroll, HR, Onboarding, Recruitment and Benefits
  • Overseeing QA, delivery, integration and production release

Confidential, Alpharetta, GA

Solution Architect - BI and PM

Responsibilities:

  • Analyze the existing data sources and reporting structure of AOG application
  • Redefine the data integration platform to Azure Cloud and migrate the LogiAnalytics reports
  • Perform QA, UAT and manage delivery from offshore
  • Developed usage trends and asset longevity reports for predictive analytics team

Confidential, Alpharetta, GA

Business Systems Analyst and Project Manager

Responsibilities:

  • Refine and update PPIA Application Phase 1 business and functional requirements
  • Define and document business and functional requirements for Phase 2 application and UI wireframe
  • Perform detailed documentation of to-be application, their modules, screen navigation, and UI experience
  • Performed UAT, coordinated delivery, and change management
  • Managed offshore team for marketing and quoting module

Confidential, Alpharetta, GA

Solution Architect (Business Intelligence and Analytics) and PM

Responsibilities:

  • Perform detailed analysis of current architecture and data structure, data distribution and storage for the scalability and preparation of future data flow in applications with use cases, functional designs, and technical designs
  • Prepares flowcharts and diagrams to illustrate sequence of steps new system enhancements must follow and to describe logical operations involved
  • Drafted, reviewed and finalized the BI Analytics Solution, Business Case, Charters and Scope
  • Reviewed, recommended and created the database development and admiration self-guide for health and recovery
  • Initiated and maintained a data admin - developers white-board forum for open discussion and knowledge share within all technical teams
  • Facilitate and monitor the authorization progress and completion reports which were then submitted to leadership on a weekly basis
  • Develop strategies with GroupREV™ architecture design group to prepare the future state roadmap
  • Lead the initiatives of development, testing and UAT for product enhancement implementation
  • Analyzing current data conditions, understand customer’s quote and booking trends to recommend most appropriate courses of action to fix the performance of data flow or functionality of the products and applications
  • Performed active roles in MVC - ASP.NET4.5/SQL Server 2008 R2/MongoDB based customized application development discovery, requirements, design, development coordination, QA, UAT, and deployment & post-production support

Confidential

Team Lead - Business Analyst - BI

Responsibilities:

  • Leading project vision & charters
  • Manage team at onshore and offshore
  • Addressing requirements of Service Managers, Directors and Executive Leadership
  • Application analysis and Architecture exploration
  • Documentation of requirements and solution designs
  • Hired and trained developer and business analyst
  • Managed and groomed ASE, SE, and SSE
  • Well appreciated and rewarded by client managers and BA
  • Effort estimation and Proposal writing
  • Perform platform setup, Design Solution, and Develop or Lead Development activities
  • Validate the provided solution and deploy in production

Confidential, Bloomington, IL

Project Manager GIS Analyst and Project coordinator

Responsibilities:

  • Performed Business Application Analysis as Business Systems Analysis requirement gathering, GAP Analysis, Continuous Process Improvements and End-users/ Stakeholders communication
  • Organized in Joint Application Development (JAD) and Rapid Application Development (RAD) sessions with business/end users, expert team and technical team
  • Developed benchmarks and procedures to maintained multiple databases for BI applications and reports for reusability, scalability, quality, availability and recovery
  • Researched BI and GIS market for new tools, training and best practices and identified and implemented for multiple business units
  • Supported existing versions and analyze to-be version of Customer facing and customized GIS enterprise application and tools
  • Led offshore BA and onshore project team throughout the requirements gathering phase to production implementation during systems development lifecycle
  • Maintained inventory and keep a track of vendor data release for projects like geocoding data, zip boundaries, municipal boundaries, state level peril data, viewable data, SQL data, GIS tools readable format data from various 3rd party vendors from all across globe
  • Uses structured analysis in the preparation of use cases, functional design, and technical requirements
  • Prepares flowcharts and diagrams to illustrate sequence of steps a new system must follow and to describe logical operations involved
  • Developed and Enhanced the Mapping Strategies and performance Q-factors, Map Caching and monitoring of Splunk logs
  • Periodical reporting and analysis of event, issue, defect, problem and performance spikes and application outage through incident/change/interaction/service request/configuration management on Service management tools
  • Performed UAT test drives and coordinated end users signoffs
  • As GIS Business Analyst, maintain area website for Legends and Metadata reports, Implementation Schedule Calendar, OOO Calendar, Guesstimated implementation schedule
  • Monitor and Maintain Change Management process for the entire component through CR creation, review, submission, implementation, and post-implementation final reviews. Also, enable and maintain ITIL practice
  • Created Moratorium request, Release exception, expedited, and emergency business case for Projects & Service and get approvals from Directors, IT Architects, CAB, and CMRB
  • Performed technical & functional checkouts and report accomplishment summaries
  • Perform as Project Coordinator and standby project manager for Tools & Data Project and initiate Planning, Documentations, Communication, Execution, and Implementation and coordinate project schedule and resource allocation
  • Drafted, reviewed and finalized the Business Case, Project Charters, and Project Scope
  • Assisted project managers with the development of Project Risk Management Plan, Project Kick-off Report, Project Status Report, Project Schedule, Change Request, Implementation and Deployment Plan, Project Test Plan, Project Transition Plan, and Project Closing Report
  • Performed requirements planning initiatives for effort estimations and created project charters for project start-up and implementation planning
  • Represented project team and service team in front of Change Advisory Board and Change Management Review Board
  • Maintain Data and Tools Project Tacking tools for each implementation and coordinate cross-functional validation, User Acceptance Testing & sign-off, and Evidence of Test creation
  • Liaison between Team Lead, Members, Onshore-Offshore Coordinators, Implementation & Change Coordinator, Infrastructure Coordinator, Business Partners and Hands-on External teams
  • Perform as implementation coordinator for weekly, monthly, quarterly and annually data and tools upgrades

Confidential, Orange, CA

Business Project Manager - Data Support

Responsibilities:

  • Gathered user and business requirements through interviews, surveys, prototyping and observing from portfolio managers and UI (User Interface)
  • Analyzed, prioritized and migrated user and business requirements as system requirements that must be included while developing the software
  • Involved in Inception Phase and prepared Logical Data Models that contains set of diagrams and BRD’s (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements
  • Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies in agile environment
  • Created Use Case, Activity, Sequence, and ER Diagrams in MS Visio, used SharePoint
  • Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
  • Scheduled meetings with Developers, System Analysts and Testers to collaborate resource allocation and project completion using MS Project.
  • Worked on content management system for publishing, editing and modifying content as well as maintenance from a central interface
  • Created Mock-up forms in MS Access for better visualization and understanding of the software solution.
  • Thorough understanding of ETL (extract, transform, and load) processing methods, SQL, and .Net.
  • Created and managed project templates, use case project templates, requirement types, and traceability relationships in Requisite Pro
  • Authored progress and completion reports which were then submitted to project management on a weekly basis.
  • Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing)
  • Developed the Business requirements and build new or updated existing source to target mappings (STTM)
  • Building of Test strategy, test plans and reviews of test conditions, cases, and SQL scripts
  • Analyzing and requesting test data for various functional test scenarios
  • Post production validation results in sharing and follow-up with end users for defect closure
  • Posting the weekly defect and status reporting with stakeholders and managements
  • Weekly meetings with business team, end users and stakeholders to discuss and prioritize production release items
  • Fortnightly/Monthly/Quarterly production defect and change request priority assessment matrix and stats reporting
  • Updating the production change log and request for database changes relevant to release items and defects fixes

Confidential, Milpitas, CA

Data Quality Manager and Techno Functional Lead

Responsibilities:

  • Worked as Techno-Functional QA Lead and Onshore POC for Confidential 's Accelerated Migration Program from Oracle to Teradata. The Project was a short-term (2 years) solution to accelerate the migration of the legacy application, business and reporting users of Oracle to Teradata by providing the same dataset with same structure
  • Worked on Data design, Architecture design and staging requirements for the data warehouse environment
  • Acted as Onshore QA Lead by making sure that testing of ETL and Architecture Standards are followed and Business and functional requirement are met as per the Function and Business requirement documents
  • Understanding and implementing the technical, functional and business requirement and passing details to QA team and addressing query from/to offshore
  • Test strategy and test artifact preparation, their review and tech lead sign-off
  • Interaction with business and addressing their queries and implementation of their change requests
  • Information Liaison between Business, Data Analyst and Build teams

Confidential

Lead Quality Analyst

Responsibilities:

  • Understand and implement Banking Risk Management BASEL-II standards implementation, Business Requirements, and Technical Specifications
  • Data Analysis of the existing source system/phases
  • Understanding Global Functional Design Documents and Test Plans
  • Test Condition, Test Case Preparation, and Test Case & Test Scenario Review
  • Complex Test DB2-SQL Scripts Building and Execution
  • Defects Identification and Follow-up till Closing, Identifying Scenarios for System Integration Testing
  • Creating the Script for the identified scenarios, execution and performance tuning of DB2 SQL Scripts
  • Defects Reporting and Resolutions

Confidential, Seattle, WA

Quality Assurance and Data Analyst

Responsibilities:

  • Extensively worked on Teradata tools and utilities (like SQL Assistant for querying through ODBC connections to Excel / Access / XML / SQL / DB2 Teradata servers, CDB Comparator for data comparison across databases, P-Mon for Performance Monitoring), IMS (customized Mainframe's green screens).
  • Analyzing current data conditions, understanding policies trends like their coverage, liability, and claims trend and recommending most appropriate courses of action to fix the data flow or functionality of the Homeowners policy underwriting suite and recover the reports, analytics and usability.
  • Assisted Principal Business Analyst in supervising the QA teams of 12 testers to make sure the all the suggested Home and Dwelling Insurance business scenarios, Functional integrity are maintained and covered and results are published to end users in the desired format.
  • Understanding the functional, business requirements and release level details of the end-user change requests
  • Data analyzing, cleansing, profiling, and staging testing through integrity checks
  • Prepare High-level BIZ Test Strategies, Test Plans, and change/work requests documentation
  • Review QA Test approach and Test Conditions and Cases
  • Review of QA results of Sanity, Smoke, Regressive testing of fields and subject area parameters of Home coverage and liability suite per the Functional mapping specification and business requirement documents
  • Dimensions and Facts testing of CUBES and Reports per functional specification
  • Suggestions to improve performance optimization of QA data retrieval queries
  • Acted as Onshore system analyst and QA-BIZ coordinator from Seattle WA, USA between the Client’s end users and the QA team for the new Data mart introduced on Home, Fire, and their Claims under personal insurance

Hire Now