Occupation:Data Mining Specialist |
Location:Canal Winchester, OH |
Education Level:Master |
Will Relocate:YES |
Description
PROFESSIONAL SUMMARY * Data Analyst with over 8 years of experience working with financial and retail domain. * Proven ability in working with enterprise level large data warehouses, RDBMS systems, and ETL and modeling tools/techniques. * Excellent in data mining for fulfilling customer segmentation business requests and periodic report generation. * Worked with different source systems like Teradata, Oracle 10g and Microsoft SQL Server. Thorough knowledge and understanding of Dimensional Data Modeling, Star schema, Snow-Flake schema, creation of Fact and Dimension Tables, OLAP, OLTP and other Data-Warehousing concepts. * Created SAS code to be used by the team members to export and import data in and out of SAS and Teradata * Well versed with data movement and data conditioning within cross platforms. * Created clear audit trails showing how populations were selected and validation of criteria. * Adept at reducing the development cost and providing the traceability of Projects * Extracted data from existing data stores, Developing and executing departmental reports for performance and response purposes by using oracle SQL, SAS, procedures, packages, functions, database triggers * Excellent analytical skills for understanding the business requirements, business rules, business process and detailed design of the application * Extensive experience in System Development Life Cycle (SDLC) involved in all stages of development including elicitation, analysis, specification, design, implementation, testing and deployment of applications. * Extensive experience using MS-Word, MS-Excel, MS-PowerPoint, MS-Visio and Requisite Pro * Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments. * Experience in Developing Performance Dashboards, Score cards, Metrics, What if analysis, Prompts, Drills, Search (using Add-ons), Reports/Dashboards for all the functional areas including Finance, Change Management, Order Management, Pricing, Purchasing, HR, Demand Planning, Discrete Manufacturing, Quality, Inventory Warehouse Management, Supply Chain, and Transportation, Sales/Marketing Variable Objects with formulas.