Built and automated KPI reports, data monitoring, forecast reports and product quality reports using SQL, Python to reduce reports preparation time.Collected external data sources and stored the data into MySQL.Performed forward engineering in Erwin tool to generate schemas and implement them in DB.
ERWIN R9 7 FULL WINDOWS
Operating Systems: MS Office Suite MS Word, MS PowerPoint, MS Excel, MS Access UNIX, DOS, Microsoft Windows 8.1/7/vista/7. Programming Languages: C, C++, Python, SQL, T-SQL, PL/SQL, MATLAB,R programing.ĭatabase Systems: SQL Server 2012/2008/2005, NoSQL, MS Access, Oracle 11g/10g/9i, Teradata, MYSQL.ĮTL and Reporting Tools: SSIS, SSRS, informatica 8.6/7.1/6.2, IBM Infosphere, Data Stage, Crystal reports, Tableau, x Celsius, QlikView.ĭata Modeling Tools: Power Designer 16.5, Erwin9.3, 9.5,9.7, ER/Studio, UML 2.x, Erwin, MY SQL Workbench. Exceptional communication and presentation skills and established track record of client interaction.Have a good exposure in overall SDLC including Requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies and Microsoft SQL Server database management.Experienced working with agile and waterfall methodologies.Strong hands on experience implementing dash boarding, data visualizations and analytics using Tableau Desktop and Sever.Provided Strong Support to the reporting team using data virtualization tools like Tableau, Power BI, etc.Excellent knowledge in creating databases, tables, stored procedures, DDL/DML triggers, views, user-defined data types, effective functions, cursors and indexes using T-SQL.Experienced in Data loading using PL\SQL Scripts and SQL Server Integration Services packages (SSIS).Good knowledge in Database programming PLSQL&SQL, SQL Server 2012/2008/2005 ORACLE 12c/11g/10g/9i, DB2, TERADATA 14.0, NoSQL Database tuning and query optimization.Experienced in SSIS, SSRS in solving business problems and managing reports in organization.Have knowledge with ETL Tools like INFORMATICA and IBM infosphere.Expertise in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources.Strong knowledge in using Erwin r9.7, r9.5, ER-Studio & Power Designer 16.5 for developing conceptual logical/physical, relational and multi-dimensional modeling, Data Transformation (ETL) and reporting.Extensive experience in Relational and Dimensional data modeling for creating logical and physical design of database and ER diagrams using data modeling tools like ERWIN and ER studio.
ERWIN R9 7 FULL SOFTWARE