SEARCH

Data warehouse Specialist Resume Example

Resume Score: 80%

Love this resume?Build Your Own Now
DATA WAREHOUSE SPECIALIST
Professional Summary
Qualified professional with a Master of Computer Science. Having 11 years of professional experience with complete SDLC in Software development and AMS projects using ETL INFORMATICA and web-based applications using Microsoft Technologies.
Core Qualifications
  • Database: SQL Server and Oracle11g
  • ETL & Reporting Tools: INFORMATICA, SSIS, Tableau, SSRS.
  • Languages: Classic ASP, ASP.Net.1.1, 2.0, 3.5 and 4.0, C#, VB.Net, Web Service, WCF.
  • Scripting Languages: R, Java Script, XML, XSD, LINQ, PowerShell Script.
  • Tools: SPLUNK and Tidal scheduler.
  • Methodology: Agile and Waterfall.
Experience
Data warehouse SpecialistMay 2016 to Mar 2017
Zimmer Biomet － Warsaw, Indiana
  • Data Integration Hub or DIH provides an effective mechanism to share data at Zimmer Biomet.
  • In a DIH, source application is called a "Publisher", while consumers of data are called "Subscribers".
  • DIH minimizes technical considerations when data is pulled from multiple sources to a single subset of data.
  • DIH also separates the distribution of data from the publishing system allowing the source to send once and DIH to handle distribution of data to multiple subscribers at different frequencies.
  • Responsibility.
  • Design, develop and implement enterprise data warehouse and DatMart models, logical data model.
  • Involved in implementing end to end ETL and development life cycle.
  • Analyse requirements, program and configure warehouses of database information and provide support to warehouse users.
  • Review data mart/warehouse deliverables and suggest and co-create standards and guidelines.
  • Perform data quality and profiling activities, advice on data quality issues and provide analysis on data collection.
  • Develop mappings; define workflows and tasks, monitor sessions, export and import mappings and workflows in Dev, QA and Production environment.
  • Translating the requirement into design document like HLD and Integration Mapping and Transformation requirement.
  • Involved in designing the dimensional model like STAR schema and Snowflake schema.
  • Review mapping, Transformation, session and workflow as per requirement and unit testing for all the ETL components.
  • Technologies: INFORMATICA Power Centre 9.6.1, ORACLE11g, XML, XSD, DB2, informatica power exchange.
Project LeadApr 2015 to May 2016
Boston Scientific Corporation － St Paul, Minnesota
  • As a part of Quality App support, various applications are being supported and in plan for migration.
  • There are multiple set of applications which are used by End clients for self-direct users.
  • These applications System track BSC products and all related data.
  • Also reports are generated in month end for compliance purpose as per FDA requirements.
  • TRaC II application used for tracking of their medical devices for all over the word and data flow from upstream to TRaC II and from TRaC II to downstream using ETL tool and generate reports.
  • leading innovator of medical solutions that improve the health of patients around the world.
  • TCS will take transition of Application Services for 56 Applications in-scope for Package A.
  • Applications Services refers to: Application Maintenance Integration Services Production Support ETL Development Responsibility.
  • Understanding workflow rules, system requirements.
  • Designing logical & Physical system flows.
  • Development in ASP.Net, C#, JavaScript and Unit testing.
  • Creating DoU, HLD, LLD and Monitoring document based on the KT session with clients.
  • Migration from web services to WCF services.
  • Develop mappings; define workflows and tasks, monitor sessions, export and import mappings and workflows in Dev to QA and Production environment.
  • Translating the requirement into design document like HLD and Integration Mapping and Transformation requirement.
  • Involved in designing the dimensional model like STAR schema and Snowflake schema.
  • Review mapping, Transformation, session and workflow as per requirement and unit testing for all the ETL components.
  • Technologies: DotNet 4.0, Web Services, SQL, C#, WCF, MS-TFS, Visual Studio 2010, XML INFORMATICA Power Center 9.6.1 and ORACLE11g.
Technical ArchitectJul 2014 to Jan 2015
BCP MDC Migration Assessment － LIMA, PERU
  • BCP aims to migrate Capital Market suite of applications (MDC) from .NET 1.1 to .NET 4.0 frameworks and Migrate Database Assessment of MDC suite of applications (320 Projects), Databases (18), DTS (99), INFORMATICA (79) and Batch jobs (184).
  • MDC suite of applications and define migration roadmap.
  • High level objectives to migrate MDC suite are as follows:.
  • To make the application suite compatible with current standards and new technologies.
  • Improved performance by adopting latest technology.
  • Continued support from vendors.
  • Responsibility.
  • Understand the current architecture, its inventory, dependencies and complexities.
  • High Level Architectural review to identify major and evident architectural enhancements.
  • Understand the performance and code review of the current application using Splunk and FxCop tools.
  • Identify the performance bottlenecks and improve the performance of the existing jobs.
  • Estimate & define the phases and roadmap.
  • Capture all the necessary information to define the migration roadmap and identify the various tools required for migration.
  • Identify any third party components used in the current systems and their compatibility with .NET 4.0 Framework.
  • Identify the scope of PoC and PoT.
  • Technologies: INFORMATICA, DotNet 4.0, Web Services, Oracle, SQL Server2000, WCF, MS-TFS and UNIX.
Technical LeadJan 2011 to Jul 2014
Nationwide Building Society － Swindon, UK
  • EIT and 7DAS Account Switcher.
  • This Project is based on Account portability rules on UK and European banks.
  • Any Customer wants to change his/ her account can change within 7 working days.
  • Nationwide needs to ensure it can comply with the 7 day service to maintain a competitive edge within the market, and cannot be seen to be holding up any account transfer requests.
  • Nationwide also needs to ensure that its new customers switching their current accounts benefit from the certainty of payments continuing to be made when they switch.
  • Project consisted of Development and Deployment part of Microsoft Source code and Web Services from Nationwide.
  • Also it was part of the support and assigning tasks to the project colleagues and ensuring that the tasks were done based on the timeliness set.
  • Responsibility.
  • Analysing the requirements and breaking into simple tasks.
  • Coordinating with Client and Microsoft for new builds.
  • Supporting, maintaining Microsoft applications.
  • Downloading the latest application code and performing a check out/check in operation through TFS.
  • Doing the branching, merging for every major code.
  • Creating the manual builds from TFS and getting output in drop folder at specified path.
  • Deploying the applications onto the different Dev environments.
  • Monitoring the application and servers using VMware tool.
  • Scheduling of the SSIS jobs on SQL Server 2008.
  • Troubleshooting the application, configuration related defects and solving them.
  • Coordinating among different teams like testing team relating to defects in QC.
  • Handling of regular client calls for technical discussion.
  • Provide estimations for enhancements and different tasks.
  • Troubleshooting BizTalk Admin console and IBM web sphere MQ.
  • Technologies: DotNet 3.5, Web Services, SQL, C#, WCF, SSRS, MS-TFS,Visual Studio 2008, SSIS , BizTalk Administrator.
Associate ConsultantOct 2010 to Apr 2017
TATA Consultancy Services
Senior IT ConsultantApr 2010 to Oct 2010
Fujitsu Consulting India
Senior Software EngineerJun 2007 to Apr 2010
Fiserv India Noida
NoidaJun 2007 to Mar 2010
XP2 Platform DCU - Fiserv, INDIA
Senior Software EngineerMar 2006 to Jun 2007
Birlasoft (India) Ltd. Noida
Sr. Software EngineerMar 2006 to Jun 2007
Monster - BCS Rewrite
  • XP SYSTEMS: For more than four decades, XP Systems has set the standard for credit union information systems.
  • The company's XP2 product is a comprehensive system of integrated software, hardware, and services that allows credit unions.
  • Integrate the Chex Systems-QualiFile solution in the XP2 platform.
  • QualiFile is offered through Fidelity National Information Services (FIS) and contains the Chex Systems services within the application.
  • The Qualifile solution has four tiers, each of which is subscriber based and includes: Classic, Advantage, Premier, and Custom.
  • Integrate the SBA Options in the XP2 platform.
  • The legacy Shared Branch Acquirer Look up includes the selection of the guest member's credit union from a drop list of hundreds of credit unions.
  • During the migration of this product from legacy to XP2 the look up process is being streamlined to get the data for the user more quickly.
  • To support that process, a new option will be added for Shared Branch Acquirer where a credit union can define a "favourites" list of foreign credit unions to pre-populate the new Guest Member Look Up page with a default list of credit unions.
  • Default lists can be created for each branch with a global list for all branches not otherwise defined.
  • Responsibility.
  • Understanding workflow rules, system requirements.
  • Designing logical & Physical system flows.
  • Responsible for producing a reproducible build from the files placed in the software configuration management system.
  • Involved in system/integration testing.
  • Unit testing, debugging and deployment of the system.
  • Documenting the processes as per standards.
  • Technologies: ASP.net framework 2.0, C#, TFS, Web Service, WCF, SSIS etc.
Software EngineerAug 2005 to Mar 2006
HCL Technology Ltd
TATA CONSULTENCY SERVICES
  • Lead multiple projects such development in MS Technologies and ETL, INFORMATICA CoE.
  • Extensively used ETL tool for supporting the Data Extraction, Transformation & Loading in a corporate-wide data warehouse using INFORMATICA PowerCenter 9.1x.
  • In-depth knowledge in Data warehouse design, develop and implement DataMart model, Operational Data Store.
  • Understanding of Data Validation Option (DVO) in INFORMATICA PowerCenter.
  • Understanding of INFORMATICA MDM architecture and Power Exchange.
  • Knowledge and expertise in .NET framework1.1, 2.0, 3.5 encompassing ASP.NET, Web Services, WCF, ADO.NET, C#, and Enterprise Library.
  • Understanding of MVC and Entity Framework.
  • Good understanding of database development, Stored Procedures and Functions using SQL Server.
  • Experience with data reporting tools like SSRS and Tableau.
  • Knowledge on SPLUNK and Tidal scheduler monitoring tools.
  • Understanding of Microsoft Project Plan, ITIL concepts and incidents management.
  • Understanding of BizTalk Server2006/2010 and SOA.
  • Worked on different client locations at UK (Swindon), PERU (Lima), ECUADOR (Quito) and USA.
  • Certifications and Awards.
  • PRINCE2 Practitioner.
  • ITIL v3.0 Foundation.
  • BI Data Visualization - Tableau Foundation.
  • Received PRIDE award from customer (Nationwide Building Society) Swindon, UK.
  • On the successful and bug free deliverables.
Education
M.Sc. (Master of Science), Computer ScienceKurukshretra University － Haryana, IndiaComputer Science
Bachelor of Science, Computer ScienceKurukshetra University Ambala CanttIndiaComputer Science
Skills
.NET 4.0, .NET, .NET 1.1, ASP.Net, VB.Net, ADO, Premier, Agile, aims, Microsoft applications, ASP, BizTalk, BSC, BI, competitive, hardware, configuration management, credit, Client, clients, data collection, Data Integration, DTS, Data Validation, Data Visualization, data warehouse, Databases, Database, database development, debugging, Designing, downstream, driving, edge, EIT, ETL, XML, HTML, Hub, DB2, IBM web sphere, INFORMATICA, information systems, inventory, ITIL, ITIL v, JavaScript, Java Script, Market, C#, Exchange, Microsoft Project, Publisher, SQL Server2000, word, Migration, MVC, Enterprise, Operational Data Store, ORACLE, page, PRINCE2 Practitioner, processes, producing, Quality, QA, reporting, requirement, Scheduling, servers, Script, Scripting, SQL, SQL Server, switch, Tableau, Translating, Troubleshooting, UNIX, upstream, Visual Studio, workflow
Build Your Own Now

Resume Overview

Companies Worked For:

  • Zimmer Biomet
  • Boston Scientific Corporation
  • BCP MDC Migration Assessment
  • Nationwide Building Society
  • TATA Consultancy Services
  • Fujitsu Consulting India
  • Fiserv India Noida
  • XP2 Platform DCU - Fiserv, INDIA
  • Birlasoft (India) Ltd. Noida
  • Monster - BCS Rewrite
  • HCL Technology Ltd
  • TATA CONSULTENCY SERVICES

School Attended

  • Kurukshretra University
  • Kurukshetra University Ambala Cantt

Job Titles Held:

  • Data warehouse Specialist
  • Project Lead
  • Technical Architect
  • Technical Lead
  • Associate Consultant
  • Senior IT Consultant
  • Senior Software Engineer
  • Noida
  • Sr. Software Engineer
  • Software Engineer

Degrees

  • M.Sc. (Master of Science) , Computer Science
    Bachelor of Science , Computer Science

Similar Resumes

View All
Data-warehouse-Specialist-resume-sample

Data warehouse Specialist

CACI International INC

Middletown, Ohio

Posted 2291 days ago