SUMMARY

• Over all 23 years of IT experience with 8 yrs of in the field of Business/Data analysis, MDM, ETL Development and Data Modeling.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
• Good experience in Data Modeling with expertise in creating Star & Snow - Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.
• 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 as per the Software Development Life Cycle.
• Experienced in developing accurate business process requirements for Banks, Insurance and State government projects.
• Experience in understanding Stored Procedures, Stored Functions, Database Triggers and Packages using PL/SQL.
• Good Data Warehousing concepts including Meta data 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 process.
• Expertise in defining scope of projects based on gathered Business Requirements including documentation of constraints, assumptions, business impacts & project risks.
• Strong background in support documentation.
• Analysis and review of Software and Business Requirement Documents.
• Conducting requirement gathering sessions, feasibility studies and organizing the software requirements in a structured way.
• 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, DBA's, Developers, QA/QC Analysts during the design phase.
• Interviewing Subject Matter Experts, asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people.
• Having application testing experience with working knowledge of automatic testing tools like Mercury Quick test Professional and Load Runner.

TECHNICAL SKILLS

Databases: SQL Server 2008, Oracle 11g/10g/9i/8/8i/7.x, Access 97-2007

Others: R, Microsoft Office suite (Word, Excel, PowerPoint), Microsoft Project 2007, Visio, T-SQL, PL/SQL, Java, Java script, XML, Tableau, Erwin, ETL Tools, Talend

PROFESSIONAL EXPERIENCE

Confidential - Merrimack, NH

Sr. Data Analyst

Responsibilities:

• Manipulating, cleansing & processing data using Excel, Access and SQL.
• Responsible for loading, extracting and validation of client data.
• Liaising with end-users and 3rd party suppliers.
• Analyzing raw data, drawing conclusions & developing recommendations
• Writing T-SQL scripts to manipulate data for data loads and extracts. Developing data analytical databases from complex financial source data.
• Worked in ETL Process: tables from source to target using standard SDLC templates
• Performing daily system checks.
• Involved in migrating of data from source systems to MDM system using ETL
• Involved in designing and developing business rules in Data Quality Tool.
• Data entry, data auditing, creating data reports & monitoring all data for accuracy.
• Designing, developing and implementing new functionality.
• Monitoring the automated loading processes.
• Advising on the suitability of methodologies and suggesting improvements.
• Carrying out specified data processing and statistical techniques. Supplying qualitative and quantitative data to colleagues & clients.

Confidential, Indianapolis, IA

Sr.Business Systems Analyst

Responsibilities:

• Interacting with Business Process Leaders and authoring Test Scripts and Test Plans for upcoming releases
• Ensuring that the Test Scripts are reusable and traceable to original business requirement
• Order management and Inventory Management integration from Siebel into Oracle instance across multiple Operating Units
• Creating Integration Test Plans and leading CRP testing
• Validating Data migration plan and ensuring that it aligns with Testing timelines
• Working with technical teams to make sure they understand the requirement and are able to build prototypes that will adhere to the test scripts.
• Overseeing creation and review of defects entered in QC and developing an execution plan for defect closure
• Classifying and reporting defect status based on Severity, Complexity and other business defined parameters.
• Involved in helping product owners set up foundational and master data like Orgs, Divisions, Positions, Roles, Entitlements and Warranty Templates, Project Plans, Users and external support systems.
• Reporting requirements gathering for US, Europe users on up/downtime, measurement & reading metrics, cost analysis of the machines in the region using BO reporting tool.

Confidential, Orlando, Fl

Sr.Analyst

Responsibilities:

• Reviewed and analyzed daily reports in order to make recommendation to management for continuous improvement
• Lead and participated in ongoing communications with leadership team to develop effective vendor hosted, predictive, preview and unmanned campaign strategies.
• Troubleshooting technical issues and coordinate efforts as necessary with IT.
• Consolidated and automated all reports and ensure accuracy in all data reported to senior executives.
• Improved financial status by analyzing results and variances; identified trends; recommended actions based on analysis.
• Increased productivity by developing automated applications; eliminating duplications; coordinating information requirements.
• Provided information to management by assembling and summarizing data; preparing reports; making presentation of findings.
• Demonstrated an awareness of personal strengths and areas for improvement and acts independently to improve and increase skills and knowledge.
• Managed small projects, business processes or parts of larger ones.
• Directly worked with non-management staff.

Confidential, St Louis, MO

Data Analyst

Responsibilities:

• Utilize Oracle Business Intelligence as well as standard data warehouse tools and techniques to mine for needed data.
• Create and deliver routine reports on topics including KPI's, Operational Performance, Asset Gathering, Trading, and Guidance on a weekly and monthly basis.
• Provide insights into business opportunities based on data and statistical analysis.
• Utilize Siebel CRM software to support data analysis.
• Review, recommend, and modify business requirements concerning database and system applications.
• Take a project from initial inception and description, find the data components, craft an analysis with the data, and be able to recap that story for Management; Use PowerPoint, Excel and similar tools to help summarize and recap.

Confidential, St Louis, MO

CRM System Analyst

Responsibilities:

• Involved in gathering business requirements from the end users and management
• Analyzed Requirements and created Use Cases, Use Case Diagrams, Sequence Diagrams using Rose.
• Used Rational RequisitePro for Managing and Configuring the Requirement Analysis effort.
• Extracted the business requirements for E-commerce from various sessions with business leads and maintained them using Requisite Pro, tracing them all the way to the system artifacts.
• Planned, coordinated, and monitored project levels of performance and activities to ensure project completion in time.
• Prioritized requirements to be developed according to Agile methodology.
• Performed extensive requirement analysis and gap analysis.
• Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements and then documented them in a format that can be reviewed and understood by both business people and technical people.
• Used sessions, workforce for running and loading the data from source to target data warehouse.
• Followed established formats and procedures, created new formats, as well as researched, created, edited technical and business data documents.
• Extensively used SQL for accessing and manipulating database systems
• Participated in Design walk-through with SME's to baseline the business architecture.
• Worked closely with QA and Developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.
• Effectively implemented defect management process using ClearQuest.
• Maintained a close and strong working relationship with teammates and management staff to achieve expected results for the project.
• Involved in writing Manual Test Cases and Test Scripts for checking the application.
• Assisted the database modelers in preparing the logical and physical data models and ascertained that requirements have been met.
• Developed Functional Specifications and Testing Requirements using Test Director to conform to user needs.
• Was involved in UAT testing.
• Prepared user training manuals and successfully conducted user training sessions.