I am an ETL/ Oracle Database Architect with over 8 years of experience in the following speciality areas: 1. Design and Architecture 2. Data Modeling and Database Design 3. Custom ETL Solutions using Procedural SQL (MS T-SQL, Oracle PL/SQL and MySQL) 4. Data Migration and Cleansing 5. Database Process Automation 6. SQL and Procedural SQL Performance Tuning 7. Advanced Database Application Development 8. Freelance Database Training My past experience includes working extensively with the various clients in the Banking and Capital markets domain in India and United States. Some of the major clients include Fidelity Investments Boston, Citigroup, Royal Bank of Scotland etc. I have been involved in all the stages of SDLC including Requirements Gathering and Analysis, Design, Build, Testing, Implementation and Post-Implementation Support. My core competency lies in strong analytical, problem solving and requirement elicitation skills. I am well versed with the projects involving high volumes of data, data analytics and assure you of value addition, timely delivery and quality deliverables. Please feel free to call/email me for more details/discussion on my past projects and experience.
Erwin Job Cost Overview
Typical total cost of oDesk Erwin projects based on completed and fixed-price jobs.
oDesk Erwin Jobs Completed Quarterly
On average, 1 Erwin projects are completed every quarter on oDesk.
Time to Complete oDesk Erwin Jobs
Time needed to complete a Erwin project on oDesk.
Average Erwin Freelancer Feedback Score
Erwin oDesk freelancers typically receive a client rating of 3.40.
Mrinmay Samaddar Agency Contractor
Ten years experience in IT Architecture positions me well for freelance Research, Strategising, Modelling and Writing on topics ranging from specific technologies to the application of Software for Business success. Located in South Africa but available to work 7h00 to 17h00 EST.
I graduated from RIT with a bachelor's degree in Information Technology (2008). My concentrations were web development and database. Since then I have been working as a web developer for various companies. Currently, I work as a web developer doing PHP, MySQL, etc for a local company. That is part time and I am always looking for work to supplement that.
Ravish HS Agency Contractor
Objective : In pursuit of true knowledge and looking for a challenging career, which provides ample opportunities to exploit my potential to the mutual benefits of myself and the company I work for Work History: Over Sixteen years of experience in Information Technology. I have worked for over 6 years in USA on H1B. I have been involved in Project management, Data Analysis, design, development, implementation and enhancement of software Projects over these years. Also, I have expertise in Data Warehousing and Business Intelligence Solutions using technologies mentioned below. I have work experience in segments like Manufacturing, Finance, Healthcare, Auto Insurance, Telemarketing, and Sports(ESPN). Databases- Oracle, SQL server, Sybase, DB2, MS/Access, Focus, Essbase Language - C, COBOL, SQR, PL/SQL, T-SQL, HTML, Java ETL Tool - Informatica, DataStage BI Tools - Brio/Hyperion Interactive Reporting , SQR/production Reports, BusinessObject, Brio Query, Brio Portal Cognos, Microstrategy, ER-Win, Visual Source Safe, PVCS GUI - PowerBuilder, Visual Basic, Gupta SQL / CENTURA OS - UNIX & Windows RESPONSIBILITY: -Leadership with development group with hands on problem identification and resolution. -Concept through requirements, planning, development and integration. -Full life cycle application development with Object oriented Software Engineering. -Specialized in Report design & Development, data analysis, PM, ETL, BI, and Data warehousing.
Senior Data Warehouse-Business Intelligence (BI) Engineer/Architect, and Database (RDMBS) Developer/Administrator, with extensive hands-on experience in agile, fast-pace, cross-functional environments. Well-versed in all areas of system development life-cycle for centralized client-server, and distributed, multi-tenant RDBMS platforms; such areas include: data analysis, architecture, modeling, development, testing, implementation, and maintenance. Engineered and implemented transactional (OTLP) and analytic (OLAP) database applications for following industries: Healthcare Practice Management/Electronic Medical Records, Life/Health Insurance, Distributed Marketing Resource Management, On-line Payment Processing, Credit Risk Management, and Corp. Banking. Specializes in scale-up and/or conversion of monolithic client-server database systems into highly robust, scalable, distributed data service platforms, utilizing following architectural practices: Service Oriented Architecture, Software-as-a-Service, and Platform-as-a-Service. Designs and deploys DB applications for dedicated and/or hybrid, Operational and Data Warehouse/Mart systems, incorporating various development stacks, with following technologies: RDBMS (PostgreSQL 9.x, MySQL 5.x, Oracle 10.x, DB2); Data Warehouse (DW)/BI/BigData (Pentaho BI Server 4.x CE, Mondrian 5.x, Hadoop Hive); ETL/DI (Pentaho, Talend, Informatcia, DataStage); Reporting (Pentaho, Jasper); Data Modeling (Erwin, Embarcadero, Toad); Programming (DB: SQL, PL/SQL, MDX, HQL, Shell Script, PHP, Python, Java, HTML, XML); NoSQL DMS (Cassandra 2.x, MongoDB 2.x, Hadoop Hbase); Operating Systems (CentOS 6.x, FreeBSD8.x, Ubuntu 12.x, Fedora Linux 7.x, Solaris 10.x, Windows Server 2003/NT); Backup & Recovery Managers (pgBarman 1.2.x, Oracle RMAN), Load-balancing & High Availability (PosgreSQL Replication Clusters, Oracle RAC, HAProxy); VCS and CI (GIT, Jenkins, Chef); Project Management (JIRA, RedMine)
-- ETL Expert with in-depth working knowledge of Informatica And Datastage -- Expert in designing DWH solutions For Telcos -- Expert in designing DWH solution in Teradata -- Expert in all phases of DWH development life cycle -- Expert in working with Star Schemas