SUMMARY

• 7 years of Industry experience as a Business/Systems Analyst with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• Diverse experience in Automotive and Finance industry.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Extensive experience in Dimensional Data Modeling using Star/Snowflake schema, Fact and Dimensions tables, and Physical & Logical data modeling.
• Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
• Extensive testing on the performance of queries and stored procedures using Execution Plan and SQL Profiler to trace slow running queries and server activity.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
• Experienced in developing reporting application using ETL (Informatica) and Cognos Business Intelligence Suite with multiple data sources like Oracle, MS SQL and DB2 database.
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence
• Extensive experience working in back end tester by writing SQL Queries and PL/SQL scripts on large data warehouse systems involving Terabytes worth of data.
• Extensive experience working in back end tester by writing SQL Queries and PL/SQL scripts on large data warehouse systems involving Terabytes worth of data.
• Worked extensively with the database designers for data validation, data mapping, data modeling and data flow

TECHNICAL SKILLS

• Rational Rose Enterprise Suite
• Rational Requisite Pro
• MS Visio
• Test Director
• Test Manager
• Rational Clear Quest
• Cobol
• Agile
• MS Office
• MS Project
• MS Publisher
• ETL
• Performance Studio
• EDI
• Mercury Win Runner
• Load Runner
• UAT
• DB2
• SQL
• PL/SQL
• Crystal Reports
• Micro strategy
• Visual Basic
• Access
• Excel
• MS - SQL Server
• SQL* Plus
• XML
• UNIX (Solaris/Linux)
• MS-DOS
• Windows 95/ 98/ 00/NT/XP.

PROFESSIONAL EXPERIENCE

Confidential, Hilliard, OH

Business Systems Analyst

Responsibilities:

• Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions.
• Gathered user and business requirements through open-ended discussions, brainstorming sessions and role-playing.
• Provided all types of automotive servicing and repair. Am in the process of relocating.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration using Informatica.
• Worked closely with Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Designed Data warehouse including star schema design, DW capacity planning, performance and tuning.
• Documented the user requirements Analyzed and prioritized them and converted them as system requirements that must be included while developing the software.
• Identifying solutions and improving SQL Server queries to the optimal state for fast access and data retrieval.
• Involved in development and implementation of comprehensive database using Data Modeling, Process Modeling, Use cases and Test cases.
• Analyzed data and created class diagrams and ER diagrams for designing databases.
• Suggested web security using encryption and authentication technologies for reporting and complaint filing procedures.
• Provide business intelligence analysis to decision-makers using an interactive OLAP tool.
• Maintained documentation related to difficulties, complexities and anomalies that may arise during the ETL process.
• Involved in Data Analysis for the data warehouse and data mart system for the process of report generation of the data.
• Build and maintain complex SQL queries for data analysis, extraction and develop new processes to facilitate import process as well as normalization.
• Created and managed project plan, statement of work, resource allocation plan, defined schedules and monitored project progress.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Responsible for the collection of functional requirements, non functional requirements, data mapping, and light data modeling.
• Define data and technical architectures and technical requirements for the data warehouse.
• Checked and verified the data that flows into Salesforce.com application with the help of SQL queries.

Environment: Microsoft Office Suite, DB2, Windows NT/XP, Oracle, ETL, SQL, SQL Server, XML, Agile/Scrum, TestDirector, LoadRunner

Confidential, Torrance, CA

Business/Systems Analyst

Responsibilities:

• Drafted the project scope and vision and presented the same to the management committee.
• Initiated and created business specific certification databases to ensure all personnel are in compliance with the set requirements.
• Identifying gaps and inefficiencies in the existing process and systems and gathering the user wish-list.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Improved automation of existing processes of SQL using procedures and SSIS packages.
• Interacted with the Data Modelers and Data Warehouse teams to understand the designing of the new data warehouse.
• Gathered business requirements by Business intelligence (BI) tools, which involved engaging in data modeling and research alternatives for the Mutual Funds.
• Identified the Data Sources, ETL methods, OLAP designing and Reports required for the Business Intelligence Project.
• Participated in the Data Modeling to generate target database layout use for the data marts.
• Prepared complex compliance reports and tests using in-house software applications while meeting deadlines and maintaining quality standards
• Used SQL to query the existing data warehouse. Required data was exported to an excel sheet which was then provided to the Business Intelligence team for their analysis purposes.
• Traced requirements by Business intelligence (BI) tools, to high-level design, test cases and product requirements and Created the End-User Documentation.
• Worked in the ETL Procedures and processes. Reconciled disparate master data from distributed systems and synchronized this reliable data with analytical and operational systems using master data management (MDM) solution Siperian MDM Hub.
• Using Blue Sky to envision the future state where subject matter experts from different areas and the senior management along with industry experts debate on critical gaps/inefficiencies and developed a consensus about the future vision.
• Building a high level business case based on the above findings and suggest a transformation roadmap to the future.

Environment: Microsoft Office Suite, Windows NT/XP, Oracle, ETL, SQL, SQL Server, Agile/Scrum, TestDirector, LoadRunner

Confidential, Auburn Hills, MI

Business/Systems Analyst

Responsibilities:

• Solid Experience in developing Scope/Vision Documentation and Project Plan, as well as tracking Project Process, and manage resources to ensure successful delivery
• Performed data profiling and data modeling, and approved all final designs.
• Worked in mainframe environment and used SQL to query various reporting databases.
• Used SQL to query the existing data warehouse. Required data was exported to an excel sheet which was then provided to the Business Intelligence team for their analysis purposes.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Worked on data modeling and produced data mapping and data definition documentation by interacting with ETL programmers and ensured the implementation of the business requirements.
• Efficient in MS Project for planning and status reporting.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Implemented business modeling, data modeling, and object modeling using MS Visio to develop the business architecture for the application. Created reports using formulas such as Vlookup, goal seek and pivot tables.
• Deep understanding of Structured System Development Methodologies
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Designing and customizing data models for Data warehouse supporting data from multiple sources
• Collaborated with External Auditors and documented SOX compliance requirements
• Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects of both ETL jobs and Reporting jobs.
• Worked in Data Analysis, Data Reconciliation and Data Mapping for ETL process
• Ensured that the Reference data repository was setup in case of emergency or unavailability of data.

Environment: Windows, MS Access, MS Office(MS Word, MS Excel, MS PowerPoint, MS Visio), ETL, .NET, Oracle, JCL, Crystal reports, RUP, UML, SQL, SWOT analysis, Clear Quest, GAP Analysis, Win Runner

Confidential, New York, NY

Business Analyst

Responsibilities:

• Created with the project manager the project definition.
• Interpreted, evaluated, translated, analyzed and interrelated researched data, and developed integrated business analysis.
• Lead meetings, collected and understood process based requirements gathering, and can arranged end-user meetings based on objective facts.
• Summarized all of the research gathered and defining the scope of the solution, including what is not in scope.
• Responsible for cost estimation and timelines for various Business Intelligence reports.
• Parsing high-level design specification to simple ETL coding and mapping standards.
• Performed extensive data modeling to differentiate between the OLTP and Data Warehouse data models
• Enhanced end-user access to a wide variety of data using Data warehouse techniques.
• Design, develop and went live after migrating several MS Access & SQL Server databases for corporate developers, resolving typical database issues.
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema and Snowflake schema.
• Work with the project manager and development team to create real cost estimates.
• Designed and developed Use Cases, Activity Diagrams, and Sequence Diagrams using UML.
• Established a business Analysis methodology around the RUP (Rational Unified Process).

Environment: UNIX, MS Power Point, MS Excel, Rational Rose, XML, Load Runner, Crystal reports, SQL.