SUMMARY

• Sr. Data Analyst and Sr. Business Analyst wif 8+ of experience in providing business solutions, liaising cross functional teams for business requirements gathering, software data modeling/design and Project Management. Proficient in handling hybrid roles and complex ETL tools for accomplishing multiple high budget projects. Successful track record in providing data modeling and design services to industry leaders like Apple, Microsoft and Adidas.
• Highly experienced in synthesizing data requirements reports, implementing OLAP, Data Warehouse & Business intelligence solutions.
• Strong domain experience in financial reporting analysis, Due Diligence and retail industry.
• Expertise in refining data mapping, conducting gap analysis and identifying opportunities for increasing teh business productivity.
• Expertise in implementing Data Migration, Data Integration, Source to Target mappings and Master Data Management and database optimization techniques.
• Experience in handling business intelligence tools like SAP Business Objects, Microsoft CRS, MSBI and Informatica Power Center (9.x/8.1).
• Working Proficiency in Agile project management, Scrum methodology, iterative sprint management, Waterfall SDLC frame work, Creating Process mapping, Use Cases, Sequence diagrams and Activity diagrams.
• Demonstrated expertise wif repository creation, and data and information system life cycle methodologies.
• Skilled in Tracking, Documenting, Capturing, Managing and Communicating teh Requirements using Requirement Traceability Matrix (RTM). Experience wif business requirements analysis, entity relationship planning, database design, reporting structures.
• Past track record in generating user stories and business cases for supporting teh Project Management team.
• Generated teh financial dashboards, billing reports and cluster reports by using MS CRS data modeling tool for supporting strategic planning and refining customer service.
• Liaised wif stake holders, worked wif peers over technical areas, to deliver optimal business process solutions, in line wif corporate priorities.
• Good experience in Developing and Extending OLAP Cubes, Dimensions and data source view and designing, creating, processing of cube using SQL Server Analysis Services (SSAS).
• Highly experienced in developing financial report using crystal reports, SAP Business Objects and MS CRS, and there by performing an in - depth analytical analysis to support consulting and management teams.
• Received teh “Most Valuable Player of teh year” 2011&2013, and “Customer Delight Champion of teh Quarter” for Q2 in ; received teh “Champion of teh Quarter” for Q4” in ;
• Secured a $1.2M USD revenue-generating project from Microsoft to Infosys.

TECHNICAL SKILLS

BI Reporting tools: SAP Business Objects, Microsoft CRS, MS BI

Data Modeling and Mapping: Informatica 9.x/8.1, Microsoft CRS, Microsoft CAT Man, Microsoft PAC Man, MS Visio

Database Management: MS SQL, Oracle, SQL

BW tools: Tibco BW, Tibco Administrator

Project Management: MS Project, Spreadsheet

Methodologies: Agile - Scrum, Waterfall

SAP Technologies: SAP NetWeaver XI, SAP BASIS, SAP BO

Packages: MS Office ( Word, Excel and PowerPoint )

Operating Systems: Unix and Windows

Processes and Practices: Use Cases, User Stories, Activity Diagrams

Functional Skills: Business Analysis Financial Reporting analysis Report Analytics Change Management Strategic Planning and Execution Data Modeling and Data design Data Integrations Project Management Agile and Scrum Software release planning Source to target mapping.

PROFESSIONAL EXPERIENCE

Confidential, Raleigh NC

Sr. Data Analyst

Responsibilities:

• Developed various SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints and created dynamic and Static Stored Procedures and Queries to develop Decision Engine.
• Optimized teh performance of queries wif modification in T-SQL queries, created sub queries, established joins and created indexes wherever necessary.
• Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Managed teh system utilization by using teh query optimizer and checking teh execution plan.
• Deployed analysis projects using SSAS based on data volume, as well as developed of KPI’s which halped teh Business users for easy understanding.
• Mined large datasets in SQL/SAS to draw patterns/inferences.
• Design and Developed multiple Enterprise reports (Drill down, Drill through reports) using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Developed MDX expressions for cube calculations and KPIs.

Confidential

Sr. Data Analyst/ Business Analyst

Responsibilities:

• Supported internal project managers in defining teh data requirement, implementing and reviewing teh functional specification to determine best data design approach and translate business requirements into data models.
• Develop a detailed understanding of teh business and its functions, operations and processes for making teh business modern and implement teh latest trends in technology to improve data flow.
• Led cross-functional teams as key contributor towards strategic and tactical activities, project execution planning, and requirements management.
• Ensured that Business, Data Governance and Integration team leads are deeply involved in critical design issues and decisions
• Responsible for defining teh functional requirement documents for each source to target interface.
• Document, clarify, and communicate requests for change requests wif teh requestor and coordinate wif teh development and testing team.
• Involved in configuration management in teh process of creating and maintaining an up-to-date record of all teh components of teh development efforts in coding and designing schemas
• Developed teh financing reporting requirements by analyzing teh existing business objects reports
• Interact wif computer systems end-users and project business sponsors to determine, document, and obtain signoff on business requirements.
• Utilized Informatica toolset (Informatica Data Explorer, and Informatica Data Quality) to analyze legacy data for data profiling.
• Developed data stewardship program establishing metadata registry responsibilities
• Implemented metadata standards, data governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modeling
• Gathering teh information about manual sources that are not captured in point of delivery(POD) Mappings.
• Collaborates across business units wif stakeholders, providing thought leadership, and driving day-to-day implementation of our analytics strategy.

Confidential, Irving, TX.

Sr. Data Analyst/ Sr. Business Analyst

Responsibilities:

• Analyzed and reviewed functional specifications and requirements to determine best data design approach and translate business requirements into data models. Produced quality functional requirements specifications.
• Defined and documented logical and physical relational database design using MS Visio.
• Supported data conversion activities and coordinated teh resolution of conversion and data migration issues.
• Created and maintained Data Dictionary and PL/SQL querying on Staging, Data warehouse and Data Marts.
• Ensured Error logs and audit tables are generated and populated properly
• Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Tracking and reporting teh issues to project team and management during test cycles.
• Conducted data profiling to insure that teh available data could support business needs.
• Worked wif teh developers on resolving teh reported bugs and various technical issues.
• Managed Change Requests by following Change Request Management process for teh project.
• Involved in preparing a simple and detailed User Guide and Manual for teh application and for an intended novice user.
• Perform analyses to support business decisions.Provide feedback to management regarding quarterly results.
• Responsible for interpreting and analyzing accounts financial performance for presenting results.
• Report variances and gather business information regarding business results to management.
• Assist Implementation Managers wif customer interviews and discover customer requirements for all teh project deliverable, including workflow support, reporting and dashboard requirements.

Environment: MS Access, MS Visio, MS CRS, MS CAT Man, MSSQL, Oracle, SQL Server, Informatica 9.x/8.1.

Confidential, Irving, TX

Sr. Data Analyst

Responsibilities:

• Liaison between Walmart data management team and internal data molding team.
• Identified minor and major requirements changes and developed change management proposals.
• Conducted review meetings to identify defects in “My Money center” portal and suggested improvements to customer through project review meetings.
• Identify and assist in resolving issues, questions, and scope/requirements gaps quickly to effectively enable delivery and support of applications
• Implementation of Metadata Repository, Maintaining Data Quality, Data Cleanup procedures, Transformations, Data Standards, Data Governance program, Scripts, Stored Procedures, triggers and execution of test plans
• Analyzed and designed teh business rules for data cleansing that are required by teh staging and OLAP & OLTP database.
• Updated or worked wif test team members to halp them understand data changes and write test cases.
• Identified and documented data sources and transformation rules required to populate and maintain data warehouse content
• Implemented teh Data Cleansing using various transformations
• Designed and implemented basic SQL queries for testing and report/data validation
• Ensured teh compliance of teh extracts to teh Data Quality Center initiatives

Environment: MS Word, MS Excel, MS Access, SQL Server, MS Visio, Oracle, SAP BO, SAP Basis, Informatica 8.1.

Confidential, Austin, TX

Sr. Data Analyst/Sr. Business Analyst

Responsibilities:

• Involved in teh whole project wif developing teh entire path from business problem statement to data driven solution recommendation.
• Experience in ETL tools for Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, and IBM DB2 to MS SQL.
• Created SQL server Analysis Projects and created Multi-dimensional databases and OLAP Cubes and dimensions for teh analysis of sales in specific areas using SSAS.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
• Worked wif Physical, logical and conceptual data model.
• Implementation of full lifecycle in Data warehouses and Business Data marts wif Star Schemas, Snowflake Schemas, SCD & Dimensional Modeling.
• Perform data reconciliation between integrated systems.
• Assisted in teh oversight for compliance to teh Enterprise Data Standards, data governance and data quality

Environment: IBM TSM, SAP BO, SAP BASIS, MS Word, MS Excel, MS Project, SQL Server.

Confidential

Business Analysis Consultant.

Responsibilities:

• Developed teh billing dashboards for Microsoft delivery management team and developed teh billing reports.
• Secured a revenue generating project from Microsoft; Recognized by teh client for developing interactive dashboards to retrieve critical business data.
• Document teh complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Developed reports for supporting consultants in process improvements by performing analytical analysis for developing insights and identifying future areas of improvement.
• Created dashboards used by Microsoft information technology team for billing analysis; assisted teh delivery managers in understanding teh cluster performance reports.
• Responsible for generating teh quarterly and monthly business review reports and analysis
• Performed analyses on requirements and maintained traceability matrix.

Environment: MS Access, MS Visio, MS CRS, MS CAT Man, MS PAC Man, MSSQL, MS Server Management Studio.

Confidential

Software Developer

Responsibilities:

• Mapped teh data connection between Tibco business works and Tibco administrators.
• Formulated and organized functional requirements, developed UML diagrams and use-cases.
• Responsible for fixing teh Tibco administrator defect log and maintain teh health of production servers.
• Handled teh Tibco Cloud server Up/Down times and migration of teh project from Tibco to SAP XI.
• Responsible for approving teh developers DART and handling IPM+.

Environment: SAP NetWeaver XI, TIBCO BW, TIBCO Administrator

Confidential

Web Application Developer

Responsibilities:

• Developed new online solutions to enhance and improve an already existing application
• Created use-cases and test-plans.
• Participated in requirements gathering processes and elicitation meetings
• Participated in requirements analysis and halped in designing traceability matrices
• Helped in requirements and change requests triage
• Participated in feasibility studies for few projects
• Worked closely wif teh branding team for UI/UX work for interface design and development

Environment: HTML, JAVA.