SUMMARY

• Over 7+ years of experience as aDataAnalystin technology companies focusing onData Maintenance,DataAnalysis and Exchange derivatives using SQL, PL/SQL.
• Experience working for financial and Technology sector clients for theirDataWarehouse tools and applications.
• Experience inDatadesigning, capturing, consolidating, and maintaining key metrics.
• Strong Experience in writing functional requirements.
• Strong experience in MDM, Metadata, HITBOX/HBX, Strong IR, Credit and FX knowledge with Exchange derivatives.
• Extensive Knowledge of using (Tableau) during my project Help Building, Designing and Web Analytics.
• Utilized MS Visio, MS Project, Power Point, MS Project, and Rational Rose.
• Project management experience across delegating, budgeting, managing change requests, preparing and presenting weekly status reports and KPI reports to executive management.
• Advanced knowledge of SQL, PL/SQL queries and for SQL fordatavalidation.
• DataValidation and Back End Testing of databases to check the integrity ofdatausing SQL Queries.
• Hands on proficiency and experience with Windows; MS Project, PowerPoint, Excel, Word, Access, Outlook, Visio, Photoshop, Illustrator, Outlook, and Microsoft Office SharePoint Server (MOSS) to create effective inter - organizational, client, management communications and presentations.
• Excellent with MS Office Suite including: Access, Excel, Word, PowerPoint, Outlook, Project,Data Maintenance and Visio.
• Experience in automating and scheduling the Informatica jobs using UNIX shell scripting configuring Korn-jobs for Informatica sessions.
• Extensive experienceDatamanipulation & database experience followingDataMaintenance protocols.
• Extensive experience in working with MS Excel. Created various charts, graphs, pivot tables, and ad-hoc reports in excel.
• Contributed to design, analyzed and conducted back-end testing using SQL scripts on a database developed fromDataMining.
• Extensive ETL testing experience using Informatica (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager).
• Having good Experience in working on and using Adobe Acrobat, Dreamweaver used to develop websites
• Expertise in documenting Business Requirements, Functional Specifications, Use Cases, and User stories.
• Good understanding Software Development Life Cycle methodologies- RUP, Agile (SAFe), SCRUM, and Waterfall
• Experience in Database design and maintenance.
• Experience with project management.
• Highly Motivated Team Player with experience in working with large organizational environment.
• Ability to work with several partners/colleagues and deliver the results in time and/or resource constrained environments.
• Excellent oral and written communication skills.

TECHNICAL SKILLS

UML Modeling Tools: MS Visio, IBM Rational Rose

Analytics: Omniture, HITBOX/HBX, MDM, Metadata, Google Analytics,DataAnalytics, Web Trends, and Click Stream

SDLC/Methodologies: RUP, Waterfall, AGILE (SAFE)

Project Management: Microsoft Project, JIRA

RDBMS: MS SQL Server, Oracle10g, MySQL, PL/SQL SQL Plus, SQL Plus, TOAD, and SQL Developer

Utilities: MS PowerPoint, Excel, PL/SQL SQL Plus, Share point,DataMaintenance, MS Outlook, IBM Lotus Notes, MS Office

Datawarehousing: Informatica …

Operating Systems: Windows X, Linux, Mac OS X

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential, Seattle, WA

Responsibilities:

• Designed and published visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making.
• Ensured that Business,DataGovernance and Integration team leads are deeply involved in critical design issues and decisions.
• Developeddatastewardship program establishing metadata registry responsibilities
• Implemented metadata standards,datagovernance and stewardship, masterdatamanagement, ETL, ODS,datawarehouse,datamarts, reporting, dashboard, analytics and predictive modelling.
• Facilitate retrospectives, stakeholder meetings, and software demonstrations.
• Gathering the information about manual sources that are not captured in point of delivery (POD) Mappings.
• Work with users to identify the most appropriate source of record and profile thedatarequired for sales and service.
• Document the complete process flow to describe program development, logic, testing and implementation, application integration, coding.
• Involved in defining the business/transformation rules applied for ICPdata.
• Worked with internal architects and, assisting in the development of current and target statedata architectures.
• Worked with project team representatives to ensure that logical and physicaldatamodels were developed in line with corporate standards and guidelines.
• Involved in defining the source to targetdatamappings, business rules, and business anddata definitions.
• Applied MasterDataManagement standards indataconversion, mapping and migration.
• Responsible for defining the functional requirement documents for each source to target interface.
• Act as a liaison between client and the development team for change requests.
• Developed the financing reporting requirements by analyzing the existing business objects reports.
• Interact with computer systems end - users and project business sponsors to determine, document, and obtain signoff on business requirements.
• Utilized Informatica toolset (InformaticaDataExplorer, and InformaticaDataQuality) to analyze legacydatafordataprofiling.
• Generate weekly and monthly asset inventory reports.
• Created dashboards for ad-hoc reporting and analysis.
• Coordinate with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.
• Remain knowledgeable in all areas of business operations in order to identify systems needs and requirements.

Environment: SQL/Server, Oracle 9i, MS-Access, Excel, Informatica, ER Studio, XML, Business Objects.

Data Analyst

Confidential, Tampa, FL

Responsibilities:

• Conducted current state analysis and proposed state analysis.
• Elicited Requirements and documented Business Requirements and Functional Specifications.
• Created analytics dashboards. Captured and consolidated key metrics.
• Performeddatamigrations (exports) from PL/SQL SQL Plus to Oracle for customized Complex reports,datavalidation anddatarecovery projects.
• Develop the SQL codes as well as use ETL tools toDataCleansing,DataMapping and conversion rules and applications.
• Interacted with the Business Lead to identify the Key Performance Indicators and document them in the User Requirement Specification
• Work with stakeholders to develop artifacts needed. Review specifications with stakeholders
• Risk analysis using PL/SQL SQL Plus.
• Documented and Prioritized Business Requirements followingDataMaintenance protocols.
• Defined Functional Requirements, use cases, and user stories.
• Developed and implementedDataanalytics solutions including Omniture.
• Provided business requirements within Waterfall software development environment.
• Wrote advanced SQL queries to test the database backend.
• Used SQL queries to extractdatafrom different databases including testing and production fordata validation anddataanalysis.

Environment: MS Visio, MS-Excel,DataQuality, MS-Access, SAP, SQL, MS Excel,Data Maintenance, PL/SQL SQL Plus, Project, Agile (SAFe), MDM, Metadata, Documentum, OBIA, Erwin,DataAnalysis, Waterfall SDLC, Microsoft SQL 2005, MS PowerPoint.

Business Analyst

Confidential, Bentonville, AR

Responsibilities:

• Elicited and gathered user and business requirements through open ended discussions, brainstorming and prototyping.
• Created detailed process flow documentation based on the input from system users and understood the system architecture.
• Assisted the Project Manager in managing project resources and project timeline using MS Project and Excel.
• Designed the Functional Specification Document (FSD) based on the project scope and SDLC methodology.
• Performed requirement gathering for integration with the Enterprise Reporting System using SSRS
• Facilitate issue resolution of defects uncovered through testing. Participated in ad hoc testing of system interfaces with Program Participants.
• Developed SQL Queries to fetch complexdatafrom different tables in remote databases using joins, database links and Bulk collects.
• Conducted JAD sessions for communicating with Project directors and stakeholders
• Created and managed project templates, use case templates, requirement types and traceability matrix in UML and YED

Environment: MS Visio, MS Project, MS Excel, MS SQLSERVER 2008, Windows XP Pro/7, UML, YED, SSRS

Data Analyst

Confidential, Perryville, MO

Responsibilities:

• Assisting the business team in Business Case Modeling using SQL, PL/SQL.
• Assisting IT Functional managers inDataModeling using Entity Relationship Diagrams (ERD) for enhancing password management functionality in accordance with Confidential security policy.
• Created analytics dashboard. Captured and consolidated key metrics.
• Worked with cross - functional process team members to ensure that best practices and central applicationDataWarehouse is leveraged.
• Allocated work to CoreDataWarehouse teams for completion of application updates and enhancements
• Implemented best practices and process drivenDataAnalysis mechanism using Omniture.
• Creating PowerPoint presentations and project updates using MS Project for management review
• Enhanced MS SQL statements to support new fees and reporting requirements by using SHOWPLAN
• Enhanced database design to support new fee structures and reporting requirements.

Environment: MS Visio, MS-Excel,DataQuality, MS-Access, SQL, MS Excel, PL/SQL SQL Plus, Project, Agile (SAFe), MDM, Metadata, Documentum, OBIA, Erwin,DataAnalysis, Waterfall SDLC, Microsoft SQL 2005, MS PowerPoint.

Data Analyst

Confidential

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 Confidential 's 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 stakeholders.
• 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.
• Involved in defining the source to targetdatamappings, business rules, and business anddata definitions.
• Created dashboards for ad-hoc reporting and analysis.
• Extensively involved in filtering, consolidation, cleansing, Integration, ETL, and customization of datamart.
• Provide 24 x 7 problem management support to the development team.
• Document variousDataQuality mapping document.
• Perform small enhancements (datacleansing/dataquality).
• Worked on daily basis with the mainframe team and leaddatawarehouse 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.
• Coordinated (with business users,database administrator, mainframe team and testing team) in mirror to production testing.

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