We provide IT Staff Augmentation Services!

Data Modeler Resume

2.00/5 (Submit Your Rating)

Frederick, MD

SUMMARY:

  • This position will serve as a Sr. expert solution, design and governance leader for Home Lending’s Enterprise Content Management Platform and portfolio of applications including Imaging and Content Management Platform (ICMP).
  • This position will also be providing key technology strategy leadership and advisory role for broader Imaging platform Leadership team.
  • This Technical leader will drive innovation and evolution of Enterprise Content Management strategy while providing leadership and support to enterprise digitization, e - Lending and 1WF Strategy.
  • Leader will have tactical, intermediate and long-term perspectives for how current designs and solutions can evolve to meet current and strategic business needs. This individual will participate in solution level consulting for projects, programs and platform optimization/evolution initiatives with other lead engineers, architects, business and technology partners; making sure that decisions made are aligned with platform strategy.
  • Lead the Technical Roadmap and Enterprise Content Management Strategy for Home and Consumer Lending while providing direct leadership support to TOG Enterprise Content Management Steering Committee, Enterprise Digitization and 1 WF efforts.
  • Collaborate with business and technology Architects, engineering and technical experts to develop strategically sound solution options for complex business problems and enable faster and efficient decision making towards an optimal solution.
  • Leading creation of best practices, guidelines and industry standards for utilizing the Enterprise Content Management strategy and solution patterns.
  • Effectively communicating technical and non-technical issues with the business and technology user groups.
  • Participate as an expert engineer and contribute towards Imaging platform’s solution design and governance process across all projects utilizing Imaging Integration capabilities.
  • Develop and conduct vendor assessments and Proof-of-Concepts (POCs) for suitable technologies and vendor products for emerging business needs.
  • Act as an expert engineer providing support towards critical Platform engineering, production and infrastructure management issues, evaluate and provide guidance towards troubleshooting, performance and design inefficiencies.
  • Mentor and guide others across imaging and other home Lending teams on Platform capabilities and technology solutions.
  • 10+ years application development and implementation experience.
  • 5+ years of experience towards design and development of medium to large scale mission critical applications and platforms.
  • 5+ years working experience with a SOA and/or ECM enabling platform.
  • 4+ years of hands on architecture, design, development, Integration experience around web applications and/or web services on a Java/J2EE platform.
  • Ability to understand business problems and articulate a corresponding solution.
  • Experience as a technical lead within SOA and/or ECM enabled applications in shared environments, guiding technology and business groups through on boarding processes.
  • Excellent communication, relationship building and partnership skills required.
  • Working and/or hands experience with ECM and Or SOA technologies is preferred.
  • Experience with IBM Websphere Application Server, WS Datapower, WS MQ, IBM FileNet P8, Tomcat is preferred.
  • Experience with business rules management systems like ILog/Jrules, Blaze, Drools is a plus.
  • Ability to understand business problems and articulate corresponding solutions.
  • Person should have good understanding about the various aspects of SDL Tridion 2013 Product and its customization points
  • Expertise in writing Tridion Event Handlers, Anguilla framework based GUI customizations, Bundle Workflow and Resolver
  • Expertise in developing Schemas, Tridion Templates & Template Building Blocks using C# & DWT .
  • Expertise in developing custom extensions for SDL Deployer module
  • Good understanding about the SDL Tridion CMS & CD schema layout
  • Expertise in modeling content based on business requirements
  • Experience in writing extensions for Tridion Experience Manager is a plus
  • .Net framework programming concepts, design patterns & coding practices. (.net Framework 3.5 and above)
  • 7+ years of basic .net programming language skills required (C# / VB.Net)
  • Expertise in WCF Web Service clients & services
  • Expertise in ASP.Net programming
  • Expertise in JavaScript & JQuery
  • Expertise in writing SQL queries for SQL Server / Oracle DB
  • Expertise in XSLT & XML
  • Expertise in IIS configuration
  • Prior experience in WIX toolset & MS Build will be a plus
  • DCTM Content Management System experience is a plus.
  • Should have used Source control systems like SVN / TFS
  • Good verbal & oral communication skills
  • Good Logical & Analytical skills
  • Team player skills
  • Person should be strong in basic .net framework programming concepts, design patterns & coding practices. (.net Framework 3.5 and above)
  • 5+ years of basic .net programming language skills required (C# / VB.Net)
  • Expertise in WCF Web Service clients & services
  • Expertise in ASP.Net programming
  • Expertise in JavaScript & JQuery
  • Expertise in writing SQL queries for SQL Server / Oracle DB
  • Expertise in XSLT & XML
  • Expertise in IIS configuration
  • Prior experience in WIX toolset & MS Build will be a plus
  • SDL / DCTM Content Management System experience is a plus.
  • Should have used Source control systems like SVN / TFS
  • Good verbal & oral communication skills
  • Good Logical & Analytical skills
  • Should be willing to learn new vendor products & tools that is required to complete the task
  • Team player skills
  • Candidate should have BPM and J2EE design and development as his/her primary skill...
  • Experience with BPM platforms like IBM BPM, Lombardi, required.
  • Design, develop, and test complex business process using BPMN 2.0 utilizing multiple integrations with other legacy systems on variety of platforms.
  • Experience with Rules Management platforms like IBM ODM, iLog, DROOLS.
  • Design, develop, and test complex business rules managed and executed by rules engine integrating with BPM platform
  • Design and develop enhancements to existing web based applications and back end components.
  • Perform unit testing and system integration validations. Verify program logic by preparing test data, tests and debug programs. Participate in overall system testing and support implementation of the application into production environment.
  • Responsible for system quality assurance and consistency with installation and security policy and standards.
  • Multi-task application development queue, production support, documentation and administrative duties.
  • Communicate effectively with the project team.
  • Comply with development standards and security policies set within the larger development organization.
  • Work with team of application developers (team members and contractors) and collaborate with a senior architect and solution designer to effectively deliver projects, enhancements and applications.
  • Production support duties during business hours and after hours and weekends as needed for application deploys, etc.
  • 8+ years experience in J2EE application development
  • 4+ years business process modeling, design, development, and implementation, BPMN language
  • Experience with BPM tools including Lombardi Teamworks, IBM BPM, TIBCO, etc
  • 3+ year’s experience with user interface modeling and design
  • 4+ years working with scripting languages like Dojo, jQuery or JavaScript
  • Detailed application development experience utilizing Object oriented design methodologies
  • 4+ years experience with Oracle and SQL language
  • Proven ability to understanding business requirements and be able to communicate with business as well as within team
  • Experience with rules engines like IBM ODM, iLog, DROOLS
  • Experienced in Web service design and development (SOA)
  • 2+ years with REST web services
  • Performance related tuning and configuration on application servers preferably WebSphere
  • 2+ years framework experience with Spring and/or Struts
  • Experience with content management system using CMIS
  • Experience in an agile work environment
  • Exceptional analytical skills focused on problem solving and process improvement in a rapidly changing environment.
  • Consistently embraces ownership and accountability situations and roles.
  • Proven ability to lead process improvement activities through disciplined project management practices.
  • Strong written and verbal communication skills
  • Must be able to work on a small distributed team and provide contributions without management oversight
  • Must be able to lead multiple efforts across variety of business groups.
  • 5+ years of Imaging and Workflow Industry Experience
  • 3+ Kofax Transformation Modules (KTM) or Kofax KTT
  • 5+ Kofax advanced classification, forms processing.
  • 3+ Kofax Capture
  • Experience with large complex technical projects.
  • Effective troubleshooting and problem resolution.
  • Adapt priorities to maintain multiple in - progress assignments.
  • Excellent interpersonal and communication (verbal and written) skills.
  • Exposure to and familiarity with mixed systems environments, mass storage and networking.
  • Some travel may be required.
  • 3+ Kofax capture custom module development
  • 3+ Web development using .NET 3.5 or above
  • 3+ years experience with MS SQL Server
  • 3+ Oracle 11g

PROFESSIONAL EXPERIENCE:

Confidential, Frederick, MD

Data Modeler

Responsibilities:

  • Design of data structures within an ODS/EDW environment (all layers)
  • Develop information architecture.
  • Understand and evaluate source system data as part of the ODS/EDW design
  • Design and Develop Conceptual, Logical & Physical models for EDW staging, data integration, and reporting.
  • Understanding of database technologies (Teradata/MS SQL Server)
  • Model reviews with project team members;
  • Metadata capture through data modeling tool
  • Maintain the repository and exchange of metadata through the various tools
  • Promote and follow Enterprise Architecture standards, guidelines, and best practices around EDW data modeling efforts
  • Translate data quality, data movement requirements/technical specifications into and across EDW layers
  • Collaborate with Architects and BI team to create data structures thatfacilitate data integration and meet reporting as well as analytical requirements.

Confidential, Frederick, MD

AbInitio Tech Lead

Responsibilities:

  • Should have Experience in Banking Domain especially in Data Integration Space
  • Lead and guide development of an Ab Initio, MS SSIS based ETL architecture.
  • Perform active leading role in shaping and enhancing overall ETL architecture using Ab Initio, MS SSIS, SQL Server & Teradata
  • Identify, recommend and implement ETL process and architecture improvements.
  • Head complex ETL requirements and design and assess requirements for completeness and accuracy.
  • Understanding of Data Modeling based on Teradata
  • Determine if requirements are actionable for ETL team.
  • Collaborate with product development teams and senior designers to develop architectural requirements to ensure client satisfaction with product.
  • Conduct impact assessment and determine size of effort based on requirements.
  • Resolve difficult design and development issues.
  • Business Requirement Analyst:
  • Evaluate and define functional requirements for DW and BI solutions
  • Manage ovelaps with other projects to decide on precedence and coordinate on necessary steps.
  • Partners with Business users and other stakeholders to communicate and capture requirements in a structured form (e.g. User Stories, Test Cases, Data Flow Diagrams, Acceptance Criteria etc.). Meets with stakeholders to discuss, define and capture requirements.
  • Closely Partner with Project Management and BI solution delivery teams to implement BI projects
  • Conduct Needs analysis to envision future iterations of implemented BI applications.The ability to conduct competitive BI research and in-depth analysis on program data, perform trend analysis etc.
  • Participate in UAT, Unit Testing, Regression Testing, Integration Testing Events
  • Effectively transition implementation knowledge to support teams. Participate in UAT, Unit Testing, Regression Testing, Integration Testing Events
  • Excellent verbal and written communication and strong leadership skills.

Confidential, Frederick, MD

Business Requirement Analyst

Responsibilities:

  • Evaluate and define functional requirements for DW and BI solutions
  • Manage ovelaps with other projects to decide on precedence and coordinate on necessary steps.
  • Partners with Business users and other stakeholders to communicate and capture requirements in a structured form (e.g. User Stories, Test Cases, Data Flow Diagrams, Acceptance Criteria etc.). Meets with stakeholders to discuss, define and capture requirements.
  • Closely Partner with Project Management and BI solution delivery teams to implement BI projects
  • Conduct Needs analysis to envision future iterations of implemented BI applications.The ability to conduct competitive BI research and in-depth analysis on program data, perform trend analysis etc.
  • Participate in UAT, Unit Testing, Regression Testing, Integration Testing Events
  • Effectively transition implementation knowledge to support teams. Participate in UAT, Unit Testing, Regression Testing, Integration Testing Events
  • Excellent verbal and written communication and strong leadership skills.

Confidential, Frederick, MD

Semantic Developer

Responsibilities:

  • Ability to understand customer requirements and translate the same into DB design
  • Hands-on experience in TeraData SQL complex queries, load utilities, writing scripts for system Performance tuning and SQL tuning.
  • Write, test and implement Teradata Fastload, Multiload and Bteq scripts, DML and DDL
  • Able to work in Teradata and its Utilities (BTEQ, Fasltoad, MultiLoad, FastExport, TPUMP, TPT)
  • Good understanding of Teradata Architecture.
  • Strong understanding of Logical and Physical Data Model, Dimensional modelling and design (Star Schema, Snowflake Schema)
  • Experience using Teradata Administrator, TASM, ViewPoint, Index Wizard, Statistics Wizard, TSET
  • Experience in Teradata Multi System Manager, Unity Ecosystem Manager, Data Mover, configuring disaster recovery, BAR and Arcmain
  • Write, test and implement UNIX scripts. Able to write code for aggregates and building efficient views.
  • Experience in SSAS and SSIS is a plus with ability to develop MDX queries
  • Experience and Background to Develop, Test and Implement solutions comprising of ETL, Data Warehouse Design, Reporting and Dashboarding and web-based interface.

Confidential, Frederick, MD

Data Analyst

Responsibilities:

  • Be able to identify relevant data sources, design and implement software / procedures to extract and process relevant data.
  • Ability to interpret results and find insights in data. Review and analyze data from multiple internal and external sources .and develop recommendations
  • Analyze complex data systems and document data elements, data flow, relationships and dependencies describing what/how/where/why data is stored and how to access the data.
  • Partners with Business Analysts, Business users and other stakeholders to communicate and capture requirements in a structured form (e.g. User Stories, Test Cases, Data Flow Diagrams, Acceptance Criteria etc.). Meets with stakeholders to discuss, define and capture requirements.
  • Experience using business analysis in order to translate business questions into data analysis problems
  • The ability to conduct competitive business intelligence research and in-depth analysis on program data, perform trend analysis etc.
  • Analyze and evaluate content and performance of queries, reports, and other data-based processes suggesting improvements which may include changes in the structure or indexing of data, as well as programming changes.
  • Conduct detailed analysis of databases and systems to identify real or potential data quality issues including accuracy, completeness, relevance, and timeliness. Develop data reconciliation and cleansing solutions.
  • Identify and present findings, process improvements that improve data quality, drive efficiency, mitigate risk, or provide new value to the organization.
  • Participate in establishing governance for data management and participate in the governance activities associated with ensuring compliance with the enterprise information/data architecture.
  • Excellent verbal and written communication and strong leadership skills.

Confidential, Frederick, MD

Project Manager

Responsibilities:

  • Responsible for delivering strategic enterprise data management, warehousing, and analytic capabilities across multiple IT and business functions.
  • Direct accountability for assigned project including overall delivery of scope within the defined delivery timeframe and in accordance to project budget.
  • Coordination, communication and dependency management at the team and initiative level, within the BI organization.
  • Lead requirements gathering workshops and document Use cases/Functional workflows/Technical specifications.
  • Partner with architects to develop technology specifications.
  • Work with the business and technical team for solution design.
  • Develops project plans, schedule and work breakdown structure for projects.Drives implementation planning and execution.
  • Define and execute contingency planning and mitigation strategies as necessary.
  • Define and maintain project scope, timeline, charter, goals, milestones and deliverables in support of business requirements.
  • Gather and document project data metrics to feedback to teams for improvement.
  • Communicates project status, progress on deliverables, and risks/issues tostakeholders and leadership in a timely manner. works with senior leadership and stakeholders for approvals
  • Work with Program Manager, ensure that projects are completed within committed delivery timeframe, defined scope, within budget and integrated with other dependent projects.
  • Manage dependencies between BI teams and between external groups in the company.
  • Discuss and prioritize project issues with the project team, and provide help/support to the project team as required.
  • Manage day-to-day operational aspects of a project and scope.
  • Facilitate, document, and organize initiative planning meetings.
  • Ensure project documents are complete, current, and stored appropriately.
  • Work closely with QA to develop test plan & test cases.

Confidential, Frederick, MD

QA Test Lead

Responsibilities:

  • Knowledge of QA methodologies, test case writing, use test tools.
  • Good experience in black box and white box testing
  • Experience managing suites of automated test cases (smoke, regression, load, etc.)
  • Experience in defect tracking tools (such as - Quality Center)
  • Experience using the latest test automation and scripting frameworks
  • Understand table dependencies which is specific to DW testing and analytic/reporting needs.
  • SDLC and QA Data warehouse Strategy knowledge.
  • Experience in SQL, scripts, and TSL
  • ETL Abinitio Tool skills/knowledge is preferred
  • Teradata experience with BTEQ scripts knowledge
  • Knowledge of technical functions such as Mainframe and SAS processes
  • Strong analytic skills. Capable of troubleshooting, problem solving and root cause analysis
  • Ability to meet tight deadlines independently and within a team environment
  • Ability to handle and resolve customer conflicts in a professional, tactful manner
  • Must be a team player and experience working and coordinating with EDW teams

Confidential, Minneapolis

QA Lead

Responsibilities:

  • Lead Confidential Systems Technology Quality Assurance workstream of the Core Platform initiative based on SWP expertise and WF business/technology program needs
  • Assist in establishing a QA team for Wells Fargo Confidential Systems Technology
  • Identify, analyze, review WF enterprise tools and standards and recommend QA tools to be used on this project
  • Implement tools
  • Consult with project team to establish QA program - document QA program
  • Lead QA team in performance/stress and QA testing, metrics documentation, analysis and trends of QA metrics
  • Coordinate/consult with other LOB/technology QA teams sharing expertise
  • SMEs in the SWP data space, data architecture, and integration capabilities to help together a Data Strategy that entails how to interact with SEI.

We'd love your feedback!