Skills

Employment History:

Confidential

Data Analyst/Business Analyst

Responsibilities:

• Coordinated with business leads in gathering business requirements for data migration needs, and drove management level discussions for Knowledge Transfer, Business plan, and client feedback
• Ensured that migrated data was accessible in the manner as expected for usage within sub-projects
• Coordinated efforts for functional projects to understand data usage and implications for data migration, and assisted in designing, planning and managing the data migration process
• Synchronized work effort with subject matter experts and project team to identify, define, collate, document and communicate the data migration requirements
• Involved with all the phases of Software Development Life Cycle SDLC methodologies throughout the project life cycle
• Prepared data migration plans including migration risk, milestones, quality and business sign-off details, and performed source system data analysis in order to manage source to target data mapping
• Worked with data compliance teams, Data governance team to maintain the data models,
• Metadata, Data Dictionaries define source fields and its definitions.
• Assisted with the documentation and development of best practices, processes, and standards operating procedures for effectively carrying out data migration activities, and managed assigned risks and monitor potential impacts as part of the data migration plan
• Administered with the migration and testing of static data and transaction data from one core system to another, and performed post data migration audit, reconciliation and exception reporting
• Managed cross-program data assurance for physical data items in source and target systems
• Gathered and assessed system requirements for future state systems, and created system architecture documents to document current state
• Created documentation from Knowledge Transfer session recordings, and graded trainee assessments for post Knowledge Transfer review sessions
• Conducted detailed walkthroughs with QA leads on test scenarios, test cases, and processes currently maintained at QBE
• Worked with OLAP tools such as ETL, Data warehousing and Modeling.
• Facilitated JAD sessions and design meetings with the Stakeholders, SME's and Leads of Interfaces.
• Performed Requirement Gathering Analysis by actively soliciting, analysing and negotiating customer requirements and prepared the requirements specification document for the application using MS Word.
• Proficient in Functionality Testing Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping
• Worked on Performance, Tuning and loading data for fast access of reports in Client/Database. Server balancing, business Rules Implementation, Meta Data, Data Profiling.
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• Flat file conversion from the data warehouse scenario.
• Assisted in preparing test case drafts to enable the testers to prepare final UAT Test Cases for approval, and assisted in reviewing, defining, and approving UAT Test Cases in review sessions held with the SME's and lead BA's
• Executed UAT Test Cases on site to approve functional and business requirements and specifications have been met
• Documented Standard Operating Procedures in regards to Testing, and QA analysis, and served as a liaison for communications between business, management, development, and testing teams
• Worked with all Teradata load utilities, and executed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices

Environment: HP Application Lifecycle Management Quality Center Edition 11.0, UNIX/Linux Servers, PuTTy, Ascential DataStage for Extract, Transform and Load Testing ETL , SQL Server 2008, IBM DB2, SAP Business Process Consolidation, PeopleSoft, Business Objects, CITRIX, and Interactive Intelligence

Confidential

Project/Data Analyst Merchandising Business Intelligence

Responsibilities:

• Involved in translating sales data to expected data versus Sales and promotional data, in comparison with seasonal and year over year sales forecasts
• Involved in appropriating and reporting volume and inventory data, to assist upper management in future forecasting of seasonal and promotional sale events
• Perform data analysis for the existing data warehouse and changed the internal schema for performance
• Involved with the development of a proactive methodology for effective data management by collecting, analyzing and reporting on disparate data sources
• Metadata Repository, Data Dictionary Documentation using Interface Diagrams, Flow Charts.
• Analyzed business objectives and develop data solutions to meet Target Executive Management's needs and collaborated with the Database, and Business teams to help and customize current data solutions to meet business functional and non-functional requirements
• Assisted in the development and documentation of standard data reporting processes, and coordinated with other project teams for report enhancements and modifications activities
• Worked with data compliance teams, Data governance team to maintain the data models,

Confidential

Informatica Team Lead

Responsibilities:

• Served as primary Team Lead for Informatica, in regards to Testing and Data mappings, Data monitoring, Data Migration, and provided sign-off for the entry and exit criteria's
• Performed UAT User Acceptance Testing and executed to verify requirements, look and feel of the applications, including validation tests to ensure that the developed functionality meets the specifications prior to UAT Testing
• Prepared and audited expected test results, for comparison to actual test setsin HP Quality Center
• Helped design and approved test environments, for manual, regression and post migration testing
• Designed data and source-to-target mapping work on the MIDE data warehouse
• Used HP Quality Center in routing defects, defect resolution and assigning business cases to end-business users, and used Clear Quest to track and report system defects and bug fixes
• Written modification requests for bugs in the application and helped developers to track and resolve the issues in validating the load process of ETL to ensure that target tables are populated according the data mapping
• Provided information that satisfies the transformation rules validating the Archive process to purge the data that met the defined business rules
• Validated the ETL Scripts in the Target Database Oracle for creating data cubes before migration to SQL Server, and reviewed and approved database modifications
• Worked with all Teradata load utilities, and executed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices

Confidential

Responsibilities:

• Assisted in the preparation of RedPrairie Warehouse/Workforce Management Systems WFM/WMS reports for logistics, supply chain and delivery management
• Involved in the drafting of plans to allocate the logistics of retail merchandise from Warehouse to Retail outlets based on region, and store expectations in RedPrairie WMS
• Prepared audit reports by gathering output from RedPrairie Warehouse Management Systems for assisting in sales forecasts, and stock management for sales events

Environment: Informatica 8.6, and 9.5 PowerCenter Domain, PowerCenter Client Tools Designer, Workflow Manager, Workflow Monitor and Repository Manager , Service Manager Repository, Integration SAP BW and Web Services , and Administration Console, PL/SQL, HP Quick Test Pro, HP Quality Center 9.0, HP Application Lifecycle Management 11.0, UNIX, SAP BusinessObjects, Teradata, Oracle, SQL Plus, MS Access, and Simple Object Access Protocol SOAP , and Clarity Enterprise Program Management, and RedPrairie Warehouse Management Systems for Logistics, Supply Chain, Delivery and Workforce Management

Confidential

Data Analyst/Business Requirements Analyst Enterprise Communications Architecture

Responsibilities:

• Capture and prepare draft Meeting Minutes incorporating team input to ensure timely delivery to client
• Sessions included reviews of readily available Enterprise Content Management systems for evaluation by senior IT management at Northrop Grumman Social Security Administration
• Review and edit Enterprise Communications Architecture Project documentation developed by team members including Project Deliverables and other related project documentation
• Schedule project overview meetings with clients, system leads and Subject Matter Expert's to gather requirements on redesigning current state architecture
• Gather required systems documentation, review, provide analysis, and input on re-engineering and redesigning Social Security Administrations' Notice Generation Process, alongside Architecture and Functional Components
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, WebSphere and Cognos.
• Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Design, development, implementation and roll-out of Microstrategy Business Intelligence applications
• Rational Unified Process RUP was used to implement iterative SDLC.
• Created job schedules to automate the ETL process.
• Draft, edit, control and prepare for submission to client Current State of Notice Generation Systems Deliverable, Architecture Components, and Technical and Business survey results
• Facilitate team discussion, meeting agendas, and co-ordinate with team lead to document project requirements, status of current state
• Prepare Meeting Agendas and gather discussion points from meetings for team discussion and project documentation. Assisted Business Manager as required