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

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

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

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.

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.