Sql Developer Resume Profile
Skills
Analyze business technical processes |
Business Process Reengineering Business Performance Improvement |
Documentation experience in IT specifications, business rules flow |
SDLC including requirements, data interfaces, QA deployment |
Solving bus. Tech. problems independently, creating innovative solutions |
Experience working in teams to produce deliverables and meet pre-determined timelines |
Unified Modeling Language |
Six Sigma certification and experience with SIPOC and DMAIC/DMADV tools |
Substantive affordable housing experience |
Bachelors Degree |
Employment History:
Confidential
Sr. Business System Analyst
Responsibilities:
- Ability to troubleshoot and solve technical problems independently.
- Ability to proactively design analytical Innovative solutions to business problems.
- Follow plan driven SDLC methodology, lead requirements gathering meetings with stakeholders and technical team.
- Create the business process models, Technical processes, data model, design wireframes, functional requirements documentation for the technical team to be able to develop the solution and or application.
- Worked with Dell customers to identify and create integration requirements with their procurement applications and Dell's Premier pages.
- Conducted rigorous GAP analysis on ecommerce Sales capabilities to determine areas of interest.
- Conducted Rigorous Process Analysis suing Six Sigma DMAIC/DMADV tools SIPOC , Benchmarking analysis studying competitors and other innovative ecommerce Companies and other Business assessments such as SWOT and MOST analysis.
- Spearheaded JAD sessions to Gather requirements from SME's regarding the business needs and high level business requirements.
- Utilized Microsoft Share Point Tools in Administration and Support of team activities, collaboration and document management.
- Analyzed, Developed and Documented Business Requirement Documents BRD , System Requirement Specification Documents SRS and other related artifacts.
- Extensive background on Business Process Reengineering , Business Performance Improvement
- Developed Functional Requirements and Business rules necessary to aid Order fulfillment process architecture and seamless integration with company ERP system.
- Developed Graphic prototypes using Mockup Screens to better relay GUI requirements to the Technical team.
- Documented the business requirements and web specifications, business rules and workflow and information architecture for CMS and other applications.
- Assisted in developing Web Methods in XML to allow external customers interface seamlessly with Dell Sales Database.
- Assisted the application architects using My SQL toolkit in developing the system Architecture with attention on proper Data Mapping to internal database systems.
- Wrote documents, data transformation rules and maintaining data dictionary, data migration and data interface requirements documents.
- Work with QA to ensure product delivered meets requirements signed off by the sponsor. Manage change requests after deployment to production.
- Engaged in validating application mobility using Data Mapping to show exactly where data is stored and retrieved.
- Interfaced with ERP architects and developers to develop the required customization settings necessary to achieve goal.
- Used MS Visio and Enterprise Architect to create UML diagrams, process flowcharts and work flow diagrams.
- Created and Managed Risk Registers, Requirement Traceability Matrix and Test Cases.
Environment: Dell Premier, AGILE SCRUM RUP Tools Requisite Pro, Rational Rose , XML, Load Runner, Win Runner, MS-Project, MS Visio, Java, MS Excel, MS Access, MS Words, Windows XP, SQL Server management Studio Express.
Confidential
Sr. Business Systems Analyst
Responsibilities:
- Conducted detailed Process Analysis and Decision Tree Analysis and assisted in Business Process Re-engineering procedures including identifying bottle necks and failure points, and developing alternative paths for process flow.
- Acting as a liaison between stakeholders from different Lines of Business such as Bankruptcy, Foreclosure, Claims, REO, Invoice Processing and Quotes, Collections, Affordable Housing, Debt Settlement Agencies, Loss Mitigation, DCD, DFR, Cash Management, Transfer Agencies, Customer Care/HR/Call Center etc , Merger and Acquisitions and Chase IT groups.
- Conducted Gap analysis, SWOT analysis, Decision Point Analysis, Communication Analysis, Business Rules Analysis, Document Analysis and other related analysis such as Scope creep assessments and Goal Orientation Assessments.
- Gathered, analyzed, documented high level business requirements and produced corresponding technical requirement artifacts such as Business Requirement Documents BRD , System Requirement Documents SRD , Test Cases, Requirement Traceability Matrix and all the affiliate artifacts like UML diagrams Use Case, Activity, and Sequence Diagrams .
- Planned and supervised target meetings with SME's such as Financial Advisors , JAD sessions with all Project stakeholders including Tech Leads , direct interview sessions, conference calls and produced detailed artifacts such as Surveys/Questionnaires and minutes of meetings covering issues discussed.
- Coordinated with PM to discuss and create template for Project Technologies, Methodologies, Budget, Time factor, Risks and other factors.
- Follow plan driven SDLC methodology, lead requirements gathering meetings with stakeholders and technical team.
- Ability to proactively design analytical Innovative solutions to business problems.
- Ability to troubleshoot and solve technical problems independently.
- Create the business process models, Technical processes, data model, design wireframes, functional requirements documentation for the technical team to be able to develop the solution and or application.
- Assisted the Project Manager in developing, tracking and managing the project triple constraint schedule, cost, resources and scope using MS Project.
- Effectively managed project risks by creating and managing a Risk Register which identifies, prioritizes and measures risk, risk drivers and expected loss.
- Identified opportunities for improvement in operational performance. Introduced and deployed process improvement with control and optimization strategies
- Effectively managed change by deploying change management techniques such as Change Assessment and Impact Analysis.
- Assisted design and validation processes by performing explanatory Data Mapping and supervised Data Migration protocols.
- Assisted UI/UX team in translating client graphical requirements to reality by creating Mockup Screens.
- Applied simple Six Sigma DMAIC/DMADV tools SIPOC such as root cause analysis and mistake proofing in redefining processes to maintain happy path user experience and eliminate variation and defect.
- Documented the business requirements and web specifications, business rules and workflow and information architecture for CMS and other applications.
- Wrote documents, data transformation rules and maintaining data dictionary, data migration and data interface requirements documents.
- Work with QA to ensure product delivered meets requirements signed off by the sponsor. Manage change requests after deployment to production.
- Facilitated the Designed and development of Business Rule Engines to support SOA architecture and web services.
- Worked closely with System Architect to implement Service Oriented Architecture SOA , Client side Validations, Server side Validations, Web Method definitions and data modeling.
- Identified and documented Business Rules, created detailed Use Cases, and Conducted User Acceptance Testing.
Environment: Water Fall, AGILE SCRUM Methodology, RUP Tools Requisite Pro, Rational Rose , Oracle, SQL Server, MS Word, MS Access, MS Excel and MS Project, HP Quality Centre.
Confidential
Business System Analyst
Responsibilities:
- Ability to troubleshoot and solve technical problems independently.
- Ability to proactively design analytical Innovative solutions to business problems.
- Create the business process models, Technical processes, data model, design wireframes, functional requirements documentation for the technical team to be able to develop the solution and or application.
- Gathered Requirements from JAD sessions involving SME's Architects and Designers , Technical Team, Software designers and Customer Focus groups and used Requisite Pro to manage the requirements.
- Assisted Marketing Research Teams in Marketing Engineering and Analytics by creating, distributing, pooling and analyzing customer responses to Questionnaires designed to extract the true VOC voice of customers from the market.
- Helped develop User Stories for SDLC phases were Extreme Programming was to be utilized.
- Performed rigorous GAP Analysis by studying the last released application version including the last released versions from the competition using SWOT analysis, MOST analysis and Cost Benefit Analysis.
- Extensive background on Business Process Reengineering , Business Performance Improvement
- Participated in rigorous analysis of requirements pooled from customer surveys using Marketing Analytical tools like Crystal Ball, Marketing Engineering for Excel to arrive at factual decisions about requirements.
- Managed Traceability Matrix to trace Business Requirements, Functional Requirements, Use Cases and Test Cases.
- Used MS Visio and Enterprise Architect to create flowcharts and work flow diagrams.
- Created detailed UML diagrams using Star UML, Enterprise Architect.
- Identified Opportunities for improved System User experience by continuously Analyzing Happy Paths Normal Flow of system Functionalities.
- Wrote documents, data transformation rules and maintaining data dictionary, data migration and data interface requirements documents.
- Documented the business requirements and web specifications, business rules and workflow and information architecture for CMS and other applications.
- Work with QA to ensure product delivered meets requirements signed off by the sponsor. Manage change requests after deployment to production.
- Assisted the QA team in developing Quality Test Plans, Test Scenarios and Test Cases prior to release
- Participated in all Black Box Testing including Regression tests and Integration tests for application ad-ons.
Environment: Extreme Programming, SCRUM, RUP Tools Requisite Pro, Rational Rose , XML
Load Runner, Win Runner, MS-Project, MS Visio, Java, MS Excel, MS Access, MS Words, Windows XP, UNIX, Documentum, Crystal Reports XI, MS SQL server 2005, SQL Server management Studio Express
Confidential
Business System Analyst
Responsibilities:
- Create the business process models, Technical processes, data model, design wireframes, functional requirements documentation for the technical team to be able to develop the solution and or application.
- Follow plan driven SDLC methodology, lead requirements gathering meetings with stakeholders and technical team.
- Assisted Project Manager in preparing high level project plan using MS project that included major milestone tasks along with time and cost information.
- Conducted GAP analysis and SWOT analysis that defined current systems and procedures, risks and recommendations for system interface with business mission and vision.
- Interfaced with SME's to understand, prepare and produce requirement artifacts such as Business Requirement Documents BRD and System Requirement Documents SRD for ongoing projects.
- Conducted highly effective companywide Town Hall meetings to aid participatory grass root innovation and JAD sessions for requirement gathering.
- Assisted Business owners in conducting Business Process Re-engineering with the operations management and HR management as part of the company's continuous improvement philosophy.
- Developed Prototypes of new information processing application and as well as GUI prototypes using mockup screens.
- Identified and prioritized business and systems issues by applying analytical tools such as Impact Analysis, Root-Cause Analysis.
- Utilized UML based methods using MS Visio and Rational Rose to develop Use Case Diagrams, Activity Diagrams and assisted in developing Sequence Diagrams and Communication diagrams for the architects and developers.
- Documented the business requirements and web specifications, business rules and workflow and data transformation rules and maintaining data dictionary, data migration and data interface requirements.
- Work with QA to ensure product delivered meets requirements signed off by the sponsor. Manage change requests after deployment to production.
- Interfaced with Offshore Architects and Developers during design and development phases of the system.
- Supervised Final User Acceptance Application Testing UAT before application releases.
Environment: Waterfall methodology, Oracle, SQL, SQL Server, MS-Office, MS-Visio, MS-Access, MS-Project, MS Office Suite MS Word, Excel, PowerPoint, Access , XML.
Confidential
SQL Data/ Report Analyst
Responsibilities:
- Computed VAR Value at risk of portfolios containing equities, fixed income, currency and commodities by using variance/covariance method, historical simulation, and Monte Carlo simulation. Performed scenario analysis and stress testing.
- Assisted in Data Warehouse Development, Support, Architecture, Data Analytics, Migration and project management.
- Produced Reports summarizing Portfolio Credit performance for use by management in making informed decisions.
- Monitored and identified adverse credit quality trends and profiled different segments of the portfolio.
- Coordinated with technology and business groups to review and validate project scope, objectives, project deliverables and critical target dates in updating home equity data to meet strict government requirements.
- Accessed and extracted loan-level data from multiple internal and external sources using programs and languages such as SQL and SAS Statistical Analysis System .
- Provided application support and guidance to business unit senior management to ensure application data was uploaded in an accurate and timely manner.
- Assisted manager with deck and presentations by Extracting, Organizing and Analyzing high volume data on numerous spreadsheets in sync to produce friendly user interface UI dashboards for Business Analytics including portfolio graphs, pie charts and tables.
- Supported Data developers in performing Data Migration activities and protocols for new projects that required database mapping and backup.
- Coordinated Data Mapping concerning Foreign exchange and Payments integration, FX integration to enable corporate customers to request, review and book FX contracts and associate to payments for Cross Border Payments. Solution allows Zenith bank to process payments transaction straight through thus eliminate operator intervention resulting in cost savings.
Confidential
SQL Developer
Responsibilities:
- Provided assistance to development teams in the design, development, testing, tuning and implementation of database applications.
- Developed Data Models Operational, Dimensional and Data marts to map data from mid tier to Database.
- Developed Extract, Transform, Load ETL routines for backend databases using PL/SQL / OWB and Oracle / Teradata Data.
- Developed Database DB Objects Tables, Views or Materialized Views, Crystal Reports Stored Procedures triggers .
- Engaged in Migration of Oracle data warehousing modules to Teradata PL/SQL and Fast Load
- Involved in Data Integration from various Oracle DWs into AEDW Active Enterprise Data Warehouse Teradata Environment.
- Generated ad-hoc Data Extracts and Reports from data warehouses based on business needs using queries.
- Analyzed Data in case of data privacy/data mismatch incidents raised by end users or clients.
- Involved in Data security management/Encryption initiatives.
- Assisted technical team with Bug fixes/Issue resolution working directly with Oracle support team.
- Supported and generated Daily Data Migration using transportable table spaces to different production environments.
- Health and integrity monitoring using Microsoft OEM of Databases.
- Backup and Recovery of Database.