SUMMARY: Over 6 years of IT experience, 4 years of Business Analyst experience with knowledge of testing methodologies in both Agile PM and Waterfall technologies

• Experience making reports at both high level and low level
• Experienced with Requirements gathering, data modeling, System Architecture
• In-depth knowledge of Software Development Life Cycle SDLC , having through understanding of various phases such as Requirements, Analysis/Design, Development and Testing
• Requirement Analysis and Use-Case Development, UML Modeling using Rational Rose
• Experienced in conducting Joint Application Development JAD sessions
• Experienced with Data Flow Diagrams DFD , Flowcharts
• Extensive experience with variety of BI Business Intelligence tools such as Cognos, Tableau, SAS, SAP Business objects
• Talent for quickly mastering and leveraging technology through strong analytical and problem solving skills
• Excellent Communication skills Interaction with Client , Organization and Multitasking skills
• Attended meetings with users, project leaders and development teams to communicate program changes utilized information to update test documentation and planning
• Highly organized, directed, and detail-oriented.
• Environment: MS SQL Server,Cognos 8.4 and 10, UML, Windows 7, XP, Vista , Unix, MS Office, MS Access, MS Excel, Business Objects, Gantt Charts, Swim-lane Process Flow, MS Project, MS Visio, Quality Center, Ab Initio, DB2, Teradata, BugZilla, Oracle 11g, 10g, Java, J2EE, XML, Tableau, VBA Macros, QlikView
• PROFESSIONAL EXPERIENCE
• Business/Data Analyst Confidential
• Provided data analysis, informational reports and tracked performance of online order fulfillment
• Used Tableau for data visualization such as making dashboards with high level views for senior directors and low level view for managers
• Created brand new tables, updating them with new information and additional columns in DB2
• Get reports from Inventory Management System using Mysql on Azure
• Fine tuning previous SQL queries as well those of team members
• For Tableau reports, created data source from scratch in DB2 and connect it to Tableau
• In Tableau created animated heat map of USA for showing order destinations over different fiscal years
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases
• Contributed to design of a database from relational to an OLAP model online analytical processing for analytics
• Work with Sears authorized vendors to maintain their inventory and help with logistics and supply chain issues
• Did predictive modeling for signing services using SAS enterprise miner
• Did weighted average predictive modelling for online business unit
• Making ad hoc reports for Senior director and VP of Online business units
• Created and updated tables in database on daily, weekly and monthly basis
• Convert MS SQL schema to DB2 by collecting metadata then generating DDL and scripts
• Perform data visualization using Tableau software for senior management
• Responsible to architect, design and develop ETL, transformations , performance tuning and deployment of Business Intelligence and Data Warehousing projects
• Use Pantaho data integration for ETL Extract, Transform and Load operations involving large volumes of data
• Perform logistics ,supply chain data analysis such as end to end data mapping on Master Order Data warehouse that allowed for real time update of several connected systems and reports
• Perform ad-hoc queries on regular basis for tracking performance of online order fulfillment
• Summarize large volumes of customer survey data for senior management

Business Analyst Confidential

• Extensive experience in extracting/integrating data from diverse data sources including SQL server, Oracle and applying business rules to transform data to load into data warehouse
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems
• For Tableau reports, created data source from scratch in Hadoop and connect it to Tableau
• Use oracle project portfolio analysis for data analysis to help vendors with their goals
• Implemented all kinds of Cognos report functions Vendor summaries, operators, business date, etc with both relational data and dimensional data from Development to QA and QA to production
• Responsible for extracting, transforming and loading ETL data from spread sheets, database tables, xml files and other sources using Oracle Warehouse builder and PL/SQL
• Acted as Tableau trainer for the organization, mentoring users and helping troubleshoot any Tableau related problems
• Perform project portfolio data analysis to help clients reduce no value projects
• Involved in requirement gathering and analysis in support of data warehousing efforts and data quality analysis for cleansing and develop ETL specifications

SAS Administrator/Business Analyst Confidential

• Performed SAS installation, administration, and system maintenance and managed Data Flux, Power Studio and SAS Integration Studio environments
• Ensure project is completed and delivered according to the implementation plan and schedule using Agile methodology
• Involved with creating packages within Cognos to move from Development to test and test to production environments
• Coordinated the server migration process of the Power Play Reports and the Cubes
• Diagnosed Oracle Bugs and co-ordinated with Oracle support through metalink to resolve them in timely manner
• Executed an integrity analysis to identify data quality and extracted, merged and manipulated large volumes of data
• Implemented security at different levels in Framework manager and Cognos Connection to restrict access
• Designed the role based dynamically filtering reports by using Report Studio and Cognos Workspace Advanced, tuned performance for master detail relationship big report
• Used Oracle utilities like SQL Loader to load Inventory data from Excel Spreadsheet to Oracle9i tables
• Used SAS BI Suite extensively to perform statistical analysis of complex datasets including predictive modeling and comparative statistics
• Responsible for analysis and functional specifications of As-Is and To-Be business model to conduct GAP analysis in comparison to the proposed system to enhance the functionality of the application
• Documented functional and non-functional requirements for system based on flaws seen in existing system
• Provided status updates, as needed, on existing systems within the business unit by tracking activity and maintain log of all events including new requests, upgrades, and any other changes
• Use SSRS for making dashboards and create visualization reports for senior management.

Business Analyst Confidential

• Prepared automated graphical presentation of weekly sales and margin results Using Excel pivot tables and charts and forecasts based on trend analysis for meetings
• Involved in preparing documentation, gathering and review of software requirements specs and providing mockups
• Experience in import and export of Metadata and promote incremental changes between environments from development to testing phase
• Mentoring team members on Data Warehousing concepts , best practices and principles
• Designed and developed dashboards with drill through functionality in Cognos report studio
• Participated in planning and review meetings with engineering, QC, documentation, product management, customer service leads and SME's
• Designed and implemented agile methodology and project management process for group
• Developed Test Cases to validate the requirements and documented the Traceability Matrix for Test Cases and Requirements
• Created diagrams using MS Visio. Utilized MS Project for scheduling, sub-contractor information, entering time, and tracking materials
• Conducted JAD sessions with business stakeholders to elicit business systems and business processes
• Performed analysis on huge databases using MS Access and SQL queries
• Extract and load large volumes of data using Ab Initio.

Business Analyst Confidential

• Performed leadership in handling Independent projects. Starting from Requirements and then directly working with the offshore team to first identify resources that will be working on the project, then make them understand the requirements and then have the project implemented and get it delivered
• Using Project portfolio data analysis to streamline data
• Prepare Business Requirement Document BRD
• Responsible for daily updates of tables in the data warehouse
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle
• Creating extensive questionnaires for performing GAP analysis and documented the gaps between the current capabilities and the desired requirements
• Distributed plan sets tracked all architect revisions using MS Project, Visio, and Excel
• Analyzed and identified areas of concern, work progress trends for potential problems and examined implications
• Built and maintained relationships with clients and their creditors
• Managed team of 3 junior engineers and awarded 'Best newcomer' in 2006