SUMMARY

• Over 10+ years of IT experience in the field of Business/Data Analysis, Process Improvement and Data Integration
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration, and Metadata Management Services
• Strong understanding of Data Modeling concepts, Star & Snow - Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Models
• Ability to collaborate with peers, in both business and technical areas, to deliver optimal business process solutions in line with corporate priorities
• Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design, and Testing
• Experience in developing accurate business process requirements for Insurance, Banks, and State Government projects
• Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL
• Good Data Warehousing concepts including Metadata and Data Marts
• Experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME's), Development and QA teams
• Extensive experience in project management best practices, processes, & methodologies, including Rational Unified Process (RUP) and SDLC
• Excellent communicator focused on customer service
• Ability to understand current business processes and implement efficient business processes
• Expertise in defining scope of projects based on business requirements, including documentation of constraints, assumptions, business impacts & project risks.
• Relationship Management Process Design and Improvement Database Design
• Strong background in support documentation
• Involved in the process design documentation of the Data Warehouse Dimensional Upgrades
• Analysis and review of software and business requirement documents
• Experience in conducting requirement gathering sessions, feasibility studies, and organizing the software requirements in a structured manner
• Experience in gathering business and technical requirements that would best suit the needs of the technical architectural development process
• Team lead skills encompassing user interviews, coordination with Tech Lead, DBAs, Developers, and QA/QC Analysts during the design phase
• Skilled at interviewing Subject Matter Experts by asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people
• Work Experience in People soft Tool
• Application testing experience with working knowledge of automated testing tools like Mercury Quick Test Professional and Load Runner

TECHNICAL SKILLS

• Windows XP
• Rational Rose
• MS Visio
• Rational Requisite Pro
• UML
• MS Project
• Oracle 9i
• MS Office
• UML
• MS Word
• SQL
• Clear Quest
• Test Director
• Oracle 11i
• Oracle R12
• MfgPro
• JD Edwards and PRMS
• PeopleSoft

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. Business/Data Analyst

Responsibilities:

• Create Business Requirement and Functional Requirement for data integration from JDA System to XPC system for Multi -Brands
• •Generate Daily report for Style Attribute for Multi- Brand and Run the analysis if all the required fields are populated if not Analysis it why it’s missing, and if it’s Missing in Both XPC and JDA or its data entry error.
• Create Weekly Data Quality Reports for Multi Brands which includes Data Extraction, Business Rules Generation, Compiling and Building Report and Trouble Shooting if any Issues.
• Maintaining the Business Document with new season and new Style Attributes and it comes.
• Creating Data Dictionary with the Attributes details and definitions.
• Working on price files and creation mapping documents
• Worked on document test cases, perform testing, and document test findings
• Database level Update for any change to Domain values used in SQL Rules, Update the tables
• Working on New - Attributes addition and creation mapping documents
• Understand data, data relationships, and identity data gaps across multiple Brands.
• Worked on scale business intelligence and data warehousing systems
• Worked on Agile Development methodologies
• Experience on JDA, XPC systems
• Experience in data analysis, strong SQL, Excel and Access
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.

Confidential, New York City

Sr. Business/Data Analyst

Responsibilities:

• Work with functional leads and Finance to identify opportunities for cost reductions and avoidance using PeopleSoft Applications
• Create and deploy targeted category strategies supported by robust analysis and research
• Design, deploy and monitor indirect procurement metrics
• Analysis and working on spend data and piece data
• Working on big Data, Data warehouse, reports and historical data.
• Creating data bases, reporting and contract documentation
• Working on price files and creation mapping documents
• Relationship Management Process Design and Improvement Database Design.
• Involved in the process design documentation of the Data Warehouse Dimensional Upgrades
• Design, deploy and monitor indirect procurement metrics
• Experience in data analysis, strong SQL, Excel and Access
• Create and deploy targeted category strategies supported by robust analysis and research
• Worked on construct meaningful and persuasive business cases and productively influence multiple functions and senior management.

Confidential, Portage, MI

Sr. Business Data Analyst

Responsibilities:

• Work with a diverse IT community to identify project data requirements and detailed data requirements need to source data for the project.
• Secure source data from 15+ disparate sources, identifying and communicating data gaps or inconsistencies.
• Testing to verify data accuracy in staging area from sources and in delivered extracts to downstream application team.
• Ensure clear communication between all involved IT Teams.
• Strong communication and relationship skills for working with global teams remotely.
• Strong business intelligence and data warehousing understanding.
• Worked on elicit detailed data requirements from other IT Teams.
• Involved in the process design documentation of the Data Warehouse Dimensional Upgrades
• Worked on translate project data requirements into detailed extract specifications in order to source the data needed to provide the requested data.
• Understand data, data relationships, and identity data gaps across multiple sources.
• Worked on document test cases, perform testing, and document test findings.
• Maintain clear communication channels with IT and business stakeholders.
• Understand and navigate complex interpersonal and political issues.
• Experience navigating complex interpersonal and business relationships
• Experience working remotely with multiple global teams
• Worked on scale business intelligence and data warehousing systems
• Worked on Agile Development methodologies
• Worked on Order and Sales data
• Experience on Oracle EBS, MfgPro, JDE, and PRM ERP systems

Confidential, Buffalo, NY

Sr. Data Analyst

Responsibilities:

• Identified sources and performed data profiling on the identified sources
• Performed Source to Target data analysis and data mapping
• Participated in meetings with Technical and Business SME's and provided solutions in various aspects
• Participated in Data Validation discussions with Data Architects
• Performed smoke testing on developer release code
• Assisted Developers with development effort and integration needs
• Assisted QA with business validation, knowledge transfer, and QA result validation. Wrote (inbound and outbound) mapping for all the vendors
• Performed validation process for all the inbound and outbound mapping documents using sample claim file received from all vendors
• Wrote business rules in source to target data mapping document to make it easy and clear for developers and testers
• Created SQL scripts to find data quality issues and to identify keys, data anomalies, and data validation issues
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding

Confidential, NJ

Sr. Business/Data Analyst

Responsibilities:

• Performed data profiling in the source systems that are required for Data Marts
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding
• Worked with internal architects and assisted in the development of current and target state enterprise data architectures
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines
• Performed data analysis and data profiling using complex SQL on various sources systems
• Created SQL scripts to find data quality issues and to identify keys, data anomalies, and data validation issues
• Involved in defining the source to target data mappings, business rules, and data definitions
• Responsible for defining the key identifiers for each mapping/interface
• Responsible for defining the functional requirement documents for each source to target interface
• Documented, clarified, and communicated change requests with the requestor and coordinated with the development and testing team
• Reverse engineered all the Source Databases using Erwin
• Documented data quality and traceability documents for each source interface
• Involved in data warehouse design
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding
• Worked with internal architects in the development of current and target state data architectures
• Used data analysis techniques to validate business rules and identified low quality missing data in the existing Amgen enterprise data warehouse (EDW)

Environment: Oracle 10g/11g, MS Access 2007, MS Excel 2007, MS Word 2007, MS Outlook 2007, Erwin, Crystal Reports, PowerPoint 2007, SharePoint

Confidential, Phoenix, AZ

Sr. Data Analyst

Responsibilities:

• Gathered requirements, analyzed, and wrote the design documents
• Provided End-user Training and documentation for customer reporting services
• Attended JAD sessions and created reports for Budgeting, Finance and Project Management departments of Pima County
• Participated in the Analysis, Design and Development Phases of report development, performance tuning and production rollout for every report of Information Technology Department
• Performed data analysis and data profiling using complex SQL on various sources systems
• Wrote SQL queries on the databases, wrote test validation scripts and performed system testing
• Wrote SQL scripts to test the mappings and developed traceability matrix of business requirements mapped to test scripts to ensure any change control in requirements leads to test case update
• Involved in extensive Data validation by writing several complex SQL queries and involved in back-end testing and worked with data quality issues
• Worked with the developers during coding and while doing the remediation of the software
• Worked with the users to do the User Acceptance Testing (UAT)
• Documented all data mapping and transformation processes in the functional design documents based on the business requirements
• Created technical specifications documents based on the functional design document for the ETL coding to build the data mart
• Created data trace map and data quality mapping documents.
• Performed data profiling and data quality
• Designed and implemented report layouts according to reporting standards of the department.
• Owned the assigned reports, worked on them and updated the Report Development Scheduler for status on each report
• Worked on daily basis with lead Data Warehouse developers to evaluate impact on current implementation, redesign of all ETL logic
• Adhered to the reporting standards laid down by Pima County ITD
• Took initiative to drive the report development process
• Worked on exporting reports in multiple formats including MS Word, Excel, CSV and PDF
• Responsible for making the report available for scheduling or viewing on demand
• Worked with Technical Experts to Improve Report Performance and performed System testing

Environment: Oracle 11g, SQL Server 2008, Windows XP, Microsoft Project 2000, Informatica, HTML, Business Objects, Erwin, MS Excel, SharePoint 2010, PowerPoint, MS Visio and MS Outlook

Confidential, Columbus OH

Sr. Data Analyst

Responsibilities:

• Worked according to the software development life cycle
• Gathered requirements from remotely based business users and defined and elaborated the requirements by holding meetings with the users (who are also Fifth-third employees)
• Analyzed the historical documentation, supporting documentation, screen prints, e-mail conversations, presented business and wrote the business requirements document and got it electronically signed off from the stake holder
• Wrote the test cases and technical requirements and got them electronically signed off.
• Created new reports based on requirements
• Utilized simple methods like PowerPoint presentations while conducting walkthroughs with the stakeholders
• Conducted GAP analysis so as to analyze the variance between the system capabilities and business requirements
• Interacted with teams in AFS, ACBS and Infolease to extract the information for the reports
• Involved in defining the source to target data mappings, business rules, business and data definitions
• Created Report-Models for ad-hoc reporting and analysis
• Extensively designed data mapping and filtering, consolidation, cleansing, integration, ETL, and customization of data mart
• Provided 24 x 7 problem management support to the development team
• Documented various Data Quality mapping document
• Performed small enhancements (data cleansing/data quality)
• Performed data analysis on the existing data warehouse
• Worked on daily basis with the main frame team and lead data warehouse developers to evaluate impact on current implementation
• Communicated with the third party vendor to do the programming
• Upgraded the present application by adding new functionalities and adding new reports
• Wrote regression test cases, did smoke testing with users
• Coordinated (with business users, data base administrator, mainframe team and testing team) in mirror to production testing
• Conducted User Acceptance testing (UAT) and worked with users and vendor who build the system

Environment: MS Office 2007, MS Visio 2003, Windows XP, AFS, MS Excel, SharePoint, PowerPoint, MS Project, UML, SQL Server, Erwin, Business Objects, MS Outlook