SUMMARY

• Sr. Data Analyst with over 6+ years of diverse experience with requirements management, business analysis with strong knowledge of Finance/Banking/Retail domain.
• Expertise in Data Analysis/Business Analysis/Data Modeling and BI reporting.
• Troubleshoot existing reports and eliminate data discrepancies.
• Experienced as a Business Analyst in using the iterative software development life cycle principles of Rational Unified Process to manage, develop and test distributed client/server, internet and intranet applications on heterogeneous environments.
• Managing user epic/stories(jira) and sizing to manageable stories/tasks using story point estimates
• Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data.
• Experienced in data warehouses and data marts for business intelligence reporting and data mining along with developing and documenting process flows for business processes.
• Experience in bug tracking systems like JIRA and documenting systems like Confluence (wiki)
• Good experience in Data Warehousing using ETL tools like Informatica & Teradata and reporting tools like Business Objects for business intelligence.
• Strong knowledge in Data Warehousing concepts, Teradata utilities (BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, Teradata Administrator, SQL Assistant), UNIX scripting and Data Modeling
• Working knowledge of implementing software development projects using methodologies such as Waterfall, Rational Unified Process, Agile/Scrum.
• Experience in coding and designing using C, C++, Visual C++, Java, Visual Basic, Oracle and Web based applications like ASP, PHP, NET, Servlets, Applet Swing and JDBC.
• Run ad hoc analyses to answer specific day to day questions and support larger initiative.
• Expertise in creating SQL queries for data validation and data analysis, on RDBMS such as Oracle, MS SQL Server, and Sybase
• Extensive work with various Rational tools like RequisitePro - Requirement gathering/maintenance, Use Case document maintenance, ClearCase- version control and ClearQuest/TestDirector for bug tracking, Rational Rose for Use case diagrams, Sequence diagrams and activity diagrams.
• Efficient in MS Project/MS Excel for planning/status reporting/writing test scenarios.

TECHNICAL SKILLS

Operating System: Windows, Vista, UNIX, DOS

Languages: SQL, HTML, SAS, XML

Databases: Oracle, MS SQL server, MS Access, Netezza

Tools: MS Office, MS Project, TOAD, MS Visio, Rational Rose, Rational Requisite Pro, Clearquest, Clearcase.

Business Tools: Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case), MS Visio, MS Project, MS Access, MS Office Suite, Visual Paradigm, Erwin Data Modeler, Business Object (Crystal Reports)

Business Skills: Business Definition Requirements, Business Process Analysis, Gap Analysis, Use Case Modelling & Analysis, Business Environment and Market Research Analysis.

Methodologies: RUP, OOAD, UML & Business/Data Modeling

Packages: MS Office Suite, Dream Weaver, Adobe Photoshop.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Data Analyst

Responsibilities:

• Involved in Managing Data modeling project from Logical design and implementation of Sybase Database
• Mapped high-level to-be designs using Business Process Modeling Notation (BPMN) on MS Visio.
• Extensively involved in data modeling.
• Managed and collaborated with design, web product and development teams to understand and maintainefficientagileand traditional project management processes.
• Defined the granularity of high level requirements, broke them down into prioritized functional requirements and tracked the progress of these requirements usingJIRA.
• Documented the dimensional models of ETL system.
• Tracking\handling issues, requests and enhancements via Service Now and JIRA workflows.
• Used SQL to test various reports and ETL load jobs in development, QA and production environment.
• Created source table definitions in the DataStage Repository by studying the data sources.
• Authored progress and completion reports, which were then submitted to project management on a weekly basis.
• Design, development, implementation and roll-out of Microstrategy Business Intelligence applications
• Worked on creation of Cognos packages and performance tuning of backend SQL generated for Cognos reports for faster report output.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Provided data modeling support for numerous strategic application development projects.
• 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
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Assess data quality requirements in terms of data completeness, consistency, conformity, accuracy, referential integrity, duplication and evaluate vendors (Informatica Data Explorer Data Quality, identify and measure data quality, design and implement data profiling and data quality improvement solution to analyze, match, cleanse, and consolidate data before loading into data warehouse.
• Worked on data modelling and produced data mapping and data definition documentation
• Used Agile software development methodology in defining the problem, gathering requirements, development iterations, business modeling and communicating with the technical team for development of the system.
• Drive tactical delivery for multiple teams using Agile and governance processes.
• Ensure adherence to defined Agile processes and User Story Writing for development life cycle, good software design practices.
• Responsible for defining Functional Requirement Specifications following the Agile methodology using HP Quality Center.
• Embrace agile principles. Support iterative user experience design, involving UX research and UX design at all stages of product development
• Helped with Data Mapping between the data mart and the Source Systems.
• Developed the ETL Informatica Mappings for importing data from ODS into subsequent data marts.
• Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, data dictionary and data analysis.
• Used Microsoft Visio for Business Process Modelling and Data flow diagrams.
• Involved in Managing Data modelling project from Logical design and implementation of Sybase Database
• Extensively used TOAD to write and execute SQL queries to extract the data from the database.
• Used Informatica to extract and transform data from various DB2 database to the data
• Coordinated with onsite and offshore teams for better understanding of client needs and provided quality deliverables.
• Manually generated reconciliation reports using MS Excel and Access.
• Design and streamlined process to facilitate annual reconciliation of plan sponsors.
• Developed, reviewed, understood and validated Testing scenarios/scripts.
• Defect Tracking with Clear Quest, Configuration Management with Clear Case.

Environment: Oracle, OLTP, JIRA,Netezza, MS Project,Python,Erwin, Visio, Trillium, UNIX, and Requirements gathering. Rational RequisitePro, Rational ClearCase, Rational ClearQuest

Confidential, Sacramento, CA

Data Analyst

Responsibilities:

• Assist the business in identifying, understanding, and documenting their business needs, including the applications capable of supporting those requirements and identify procedures that are cost effective and meet business requirements.
• Developed Complex parameterized MDX, bottom count, top count, cross join, non-ascendants and log MDX queries for creating Calculations and KPI's on SSRS Reports.
• Collect and document business processes as well as business rules.Translate the business needs into system requirements; communicate with the business on a non-technical level, and with the System Analyst on a more technical level. Perform gap analysis.
• Document and deliver Functional Specification Document to the project team. Conduct User Acceptance Testing (UAT).
• Develop test scenarios and implement test plan providing key input in working with users in defining project and system requirements. Conduct project related presentations.
• Performed Role of offshore coordinator and developer, involved in many business level meeting to understand the requirements.
• Small enhancement work: Analysis, find root cause & implementation.
• Handling Incident Tickets with different priority in Global Service Desk.
• Implementing various changes in Production Environment in PL/SQL which is embedded inside UNIX environment, this acted as a source from where our sql server database is the destination.

Environment: Agile/Scrum, Microsoft Office Products (Word, Excel, PowerPoint), MS Visio, DB2,UAT, Sybase, SQL .Ms Project 2010,Release Coordination,Ticketing,MS Share point.

Confidential 

Entry Level Data Analyst

Responsibilities:

• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Designed and Developed the Business Objects Universes which suit the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• Improved SDLC through incorporation of new level of detail in requirements/design documents
• Worked with Product Owner/Intent Owner to translate requirements into user stories.
• Identified business process and developed activity diagrams for loan preapproval, loan application and loan process with the help of MS Visio.
• Excellent understanding of SQL RDBMS, ability to read and understand data flow diagrams and ERD.
• Experience in working with all kinds data formats to create reports using SQL, Excel and SAS.
• Applied Agile Methodologies for the project and used practices such as Program Backlogs, Iteration Backlogs and Daily Standup Meetings.
• Involved in Designing and implemented basic SQL queries for QA testing and report/ data validations.
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
• Assisted in the development, design and implementation of new relational or multi-dimensional databases, including the analysis of user needs.
• Created and managed project templates, use case project templates, requirement types and traceability relationships in Requisite Pro.
• Involved in performance measurement of ongoing data collection to determine if a program is implementing activities and achieving objectives.

Environment: Microsoft Office Products (Word, Excel VLOOKUP, Pivot Table, PowerPoint), SAP CRM, EQRS.