Yatin Patel Email & Phone Number

Royersford, Pa, Us

Royersford, Pa, Us

Philadelphia, Pa, Us

Philadelphia, Pa, Us

Danbury, Ct, Us

Senior Member of Tech and Apps team built a Data Warehouse for multiple pharmaceutical clients. I have designed and implemented a solution to process client’s data and push it out to publish layer. Lead a team on a project that involved designing and building a healthcare data warehouse solution built on Oracle12c.Familiar with data architecture including data ingestion pipeline design, Hadoop information architecture, data modeling and data mining, Experience optimizing ETL workflows.Created and maintained SQL stored procedures, external tables, functions, packages, view and other scripts supporting ETL process.Worked directly with BAs, DBAs and PMs to coordinate deliverables and other engagement activities related to the project.Worked on an exciting new initiative of Big Data Factory where we used different facets of Big Data Technologies such as Hadoop, Hive, Pig, Scala, Impala and Spark.Created Hive tables and loaded data and wrote Hive queries. Successfully loaded files to Hive and Hadoop Distributed File System(HDFS) from Oracle using SQOOP. Created multiple MapReduce jobs in Pig and Hive for data cleaning and pre-processing purpose. Used Spark for fast processing of data and defining job flows.

Sr. Data Engineer, Data Services Team As a part of DataServices team, I have worked on building data warehouse for multiple healthcare clients. I have also designed and implemented a solution to publish data into Redshift from SQL Server 2014. Experienced working with VPC which is hosted by AWS EC2 and S3.Experienced working with time intense and high impact projects for clients.Built ETL solutions to migrate data from multiple input source files into Data Warehouse. Automated daily feed and release process to minimize human intervention in day to day processing.Designed a high performance and high scalable data warehouse to process data for one of the leading healthcare clients. The data file includes membership, eligibility, providers, medical and pharmacy claims, admission and episodes, lab results.Applied various indexing techniques to optimize query performance.

Valley Forge, Pa, Us

Consultant Data Architect, Compliance TeamWorked as Data Architect Consultant with a Compliance team on a multiple large scale projects. Comfortably worked on multiple technologies projects in parallel. Application environments were Oracle 11g and SQL Server 2008 R2, HTML, XML, XSL, Tibco.Designed and successfully implemented migration path for a legacy application into SQL Server 2008R2 database. Created new SSIS packages to process the daily feed from multiple source. Worked with DBAs to resolve performance issue with a very large data warehouse application.Experienced working with onshore and offshore teams and effectively communicate the expectations and results.

Philadelphia, Pa, Us

Consultant Data Architect, Infrastructure TeamWorked as Data Architect Consultant in Infrastructure team at an e-Commerce company. Application development was mainly done in C#, ASP.Net, JavaScript and SQL server 2008 R2 (Clustered) as database engine in private cloud, VMware with shared load balancers environment. This is a very a fast pace agile development environment.Created new SSIS packages and also migrated some exiting SSIS packages with enhancements. Implemented database maintenance jobs to mitigate some of the high risks encountered during dry run. Created data migration scripts including procedures and packages to populate data from existing database into new database.Engineered the architecture of DR environment and worked with hosting company to successfully carry out all necessary tasks.Helped team carry out multiple iterations of application stress testing.Performed database tuning to improve the website performance and achieved goal of page load time of < 2 sec per page.

Delft, Zuid-Holland, Nl

Provided the integration solution, implementation and support of a third party solution. This global solution was implemented in 27 countries and 287 stores. Environments were Windows Server 2003 EE, Windows Server 2008 EE with NLB and SQL Server 2008 R2 EE (clustered) as database servers. Designed, implemented and supported an integration solution between the HQ.Net and StorePoint applications to share data across global time zones. Worked very closely with Global Project Teams including IT architects, Operational Architects to ensure the solution is compatible and a long term fit for the company.Carried out application database upgrades, database backups, database restore, database performance, backup scripts, deployment of patches and maintained data files and transaction logs. Engineered solution to capture missing sales and achieved 95% success rate.Installed and managed SQL Server 2008 reporting services, analysis services and ETL jobs.

Delft, Zuid-Holland, Nl

Performed the analysis, design, development, implementation and support of in-house systems in the areas of Warehouse Management and Customs. The applications environments were AIX, Oracle 8i/10g, Windows Server 2003, VB6.0, Java, PL/SQL, ASP.Net, XML, Shell Scripts and Oracle Web forms. Development and Solution Architect activities are as briefly listed below.Designed, developed and implemented tablespaces, schemas, tables, views, indexes, triggers, procedures, functions, packages using SQL, PL/SQL.Specialized in Requirement gathering, Analysis, Data Modeling, Physical Database Design, Data Conversion, Data Migration and Documentation.Worked in multiple time zones with user organization and multiple project teams to and delivered the results on time.Database rollouts and Data Migration between development, test, pre-production and production databases.Performed technical lead role for rolling out key warehouse management system in 7 warehouses in US and CA with 100% success rates and within timeframe. Performance tuning using TKPROF and Explain Plan, substantially improving job performance from 90minutes to 2 minutes.Assisted Developers in developing efficient SQL queries.Led the team of developers in multiple projects/activities.Provided work estimate to manager, managed work load among teams and achieved 95% project timeline.Reviewed and approved change requests analysis and code changes.

Delft, Zuid-Holland, Nl

Conducted the design, development, implementation and support of in-house systems in area of Customs and Ordering. Database were utilized for business logic, user management, access control, product catalog, order processing, Inventory, reporting and other Custom’s functionalities. The application environments were AIX, Windows Server 2003, Java, PL/SQL, ASP.Net and Oracle Forms, Oracle 8i, Shell Scripts. • Performed all tasks of Software Development Life Cycle such as Requirements gathering, Analysis, Data Modeling, Physical Database Design, Development, Testing, Data Conversion, Data Migration and Documentation.• The Customs solution gave business return of more than $45M of savings over 5 years to IKEA. • Worked with global development teams including teams in Sweden, China, Singapore and Japan. • Conducted User trainings and trainings to the other team members.• Established development standards for database development.• Resolved user inquiries regarding database issues and supported critical tasks.• Created an absolute positive image with users by delivering high quality solutions and dedications.

Export module was one of the module of ERP Package developed using Oracle Developer 6, Designer 2000 and Oracle 8i. • Gathered and analyzed the Requirements• Designed database relationship model using Oracle Designer.• Presented the module design to the review board.• Documented and presented the project status reports.• Installed and enabled three tier environments using Oracle Forms 6.0, Oracle 8i Database and Oracle Application Server.