Description :

1. Developed and implemented data models and architecture to support business intelligence initiatives.
2. Analyzed and optimized ETL processes to ensure efficient data flow and integrity.
3. Collaborated with stakeholders to define data requirements and design solutions that meet business needs.
4. Created and maintained documentation for data architecture, data flows, and data governance policies.
5. Utilized SQL and other tools to extract, transform, and load data from various sources.
6. Provided technical guidance and support for data-related projects and initiatives.
7. Monitored and improved data quality through regular audits and validation processes.

Experience

5-7 Years

Level

Executive

Education

MSc DS

Description :

1. Implemented a comprehensive data architecture for a new system integrating BOR, Data Warehouse, and Data Mart.
2. Developed implementation strategies for multiple data sources, enhancing data flow efficiency.
3. Conducted discovery sessions to gather requirements and performed data profiling on key source systems.
4. Designed logical and physical data models for the Producer book of records and data mart.
5. Created a Vendor Information System to streamline claims processing for external vendors.
6. Engineered solutions to handle 10 Terabytes of data with projected annual growth of 10%.
7. Established data standards and naming conventions, ensuring model consistency and integrity.

Experience

7-10 Years

Level

Consultant

Education

MSc DS

Description :

1. Designed and implemented enterprise data management strategies to enhance data accessibility.
2. Served as the primary liaison for data management on strategic initiatives, ensuring alignment with business goals.
3. Developed logical and physical data models, including XSD and JSON schemas for SOA and RESTful services.
4. Delivered comprehensive data cleansing solutions, enhancing data integrity for applications and integrations.
5. Established a common data vocabulary, improving communication and integration across applications.
6. Created a centralized data architecture homepage on Confluence, significantly improving team collaboration.
7. Conducted evaluations and recommendations for data profiling and modeling tools to optimize data processes.

Experience

2-5 Years

Level

Junior

Education

MSc DS

Description :

1. Developed logical and physical data models for enterprise data warehouse projects, enhancing data accessibility.
2. Conducted data profiling and mapping for Teradata, Oracle, and SQL Server, ensuring data quality.
3. Utilized CA ERwin Data Modeler to create comprehensive data models, streamlining data architecture.
4. Authored data mapping documents to facilitate data integration from multiple sources into the warehouse.
5. Mentored junior data modelers on best practices in data modeling and tool usage, fostering team growth.
6. Facilitated schema design reviews and technical discussions, ensuring alignment with business requirements.
7. Generated Teradata DDL scripts from physical models, optimizing database creation processes.

Experience

5-7 Years

Level

Executive

Education

MSc DS

Description :

1. Analyzed data sources and business rules to create new Logical and Physical Data models.
2. Identified dimensions and facts for data warehousing projects, enhancing data accessibility.
3. Utilized Reverse Engineering to assess and optimize table structures for performance.
4. Updated existing logical data models to align with evolving business requirements.
5. Designed high-level conceptual and detailed physical database models for various applications.
6. Normalized relational models to 3rd normal form, ensuring data integrity and efficiency.
7. Created mapping spreadsheets for ETL processes, detailing source-to-target data mappings.

Experience

5-7 Years

Level

Executive

Education

MSc Data Science

Description :

1. Consulted on data architecture and analysis, enhancing data-driven decision-making.
2. Utilized data modeling tools like Erwin to design solutions for high-profile projects.
3. Analyzed data requirements and created a database solution to replace legacy systems.
4. Designed comprehensive data architecture using enterprise data models.
5. Integrated application data models with the enterprise data model for consistency.
6. Developed enterprise data designs for OLTP systems, data warehouses, and marts.
7. Managed project data elements in metadata dictionaries and repositories.

Experience

7-10 Years

Level

Consultant

Education

MSc DS

Description :

1. Led the design and implementation of MDM and EDW solutions, enhancing data accessibility for retail analytics.
2. Architected ERWIN data models, translating business requirements into physical and logical models for HR systems.
3. Collaborated with stakeholders to gather requirements and provide expert consultation on data design.
4. Developed robust data migration strategies, ensuring seamless upgrades and data integrity.
5. Directed the data modeling and ETL team in creating prototypes and detailed designs for large-scale systems.
6. Designed messaging applications using IBM WebSphere MQ, improving data flow for HR and portal systems.
7. Established corporate data modeling standards, enhancing consistency across data architecture projects.

Experience

7-10 Years

Level

Consultant

Education

M.S. DS

Description :

1. Developed and implemented ETL processes to streamline data integration across platforms.
2. Designed complex enterprise data architectures to support business intelligence initiatives.
3. Analyzed system requirements and data volumes to create scalable database solutions.
4. Recommended optimal design criteria for data storage and retrieval, enhancing performance.
5. Created entity-relationship diagrams and data flow diagrams to visualize data structures.
6. Managed historical data conversion projects to ensure data integrity and accessibility.
7. Developed reporting frameworks for dashboards and BI tools to support decision-making.

Experience

5-7 Years

Level

Executive

Education

MSc Data Science

Description :

1. Lead data modeling and mapping initiatives to ensure data integrity and accuracy across systems.
2. Design and develop scalable data solutions that support large-scale enterprise applications.
3. Establish and maintain architectural frameworks, processes, and standards for data architecture.
4. Provide architectural guidance to development teams, ensuring alignment with best practices.
5. Define core data entities and business functions to streamline data management.
6. Collaborate on enterprise-wide data initiatives to promote a unified understanding of data assets.
7. Research and evaluate new technologies to enhance data architecture efficiency and effectiveness.

Experience

2-5 Years

Level

Junior

Education

MSc Data Science

Description :

1. Collaborated with stakeholders to gather and analyze database requirements, ensuring alignment with business goals.
2. Designed and developed conceptual and logical data models to support data architecture initiatives.
3. Utilized Data Vault methodology to create normalized logical and physical database models for enterprise applications.
4. Managed changes to data models, ensuring accuracy and consistency across all documentation.
5. Produced comprehensive data architecture documentation for complex information systems, enhancing clarity and usability.
6. Communicated data model design decisions effectively, incorporating team feedback to optimize outcomes.
7. Executed reverse engineering of data models from existing database instances, improving understanding of legacy systems.

Experience

5-7 Years

Level

Executive

Education

MSc DS

Description :

1. Analyzed source systems and conducted data profiling to enhance data quality across mortgage lifecycle stages.
2. Created logical and physical data models adhering to 3NF and enterprise data modeling standards.
3. Collaborated with enterprise architects and DBAs to design scalable enterprise-level data models.
4. Designed and implemented operational data stores (ODS) on SQL Server and DB2 for improved data access.
5. Participated in peer review forums to resolve data modeling challenges and enhance team collaboration.
6. Established enterprise modeling standards and guidelines to ensure consistency across projects.
7. Developed conceptual models for various lines of business to clarify business processes and data flows.

Experience

7-10 Years

Level

Consultant

Education

MSc DS

Description :

1. Designed and maintained logical and physical data models for enterprise applications.
2. Executed data migration strategies from legacy systems to modern databases, ensuring data integrity.
3. Created comprehensive data flow diagrams and transformation logic for data integration.
4. Collaborated with cross-functional teams to redesign and optimize database architectures.
5. Provided enterprise data solutions, enhancing data accessibility and reporting capabilities.
6. Worked closely with data analysts and developers to implement data-driven solutions.
7. Developed and executed DDL scripts for database schema changes and optimizations.

Experience

5-7 Years

Level

Executive

Education

MSc DS

Description :

1. Managed the workload of the junior data architects and made logical data modeling assignments.
2. Analyzed business requirements, define the scope, and manage project work schedule, resources, and cost estimates.
3. Managed the enterprise application inventory through processes that eliminated duplications through documented and monitored business processes.
4. Implemented the Corporate Data Dictionary (Meta-Data Repository) to house all the logical entities and attributes with business definitions, validation rules, and version control using Power Designer's Repository.
5. Provided logical and physical relational data modeling services for application development teams supporting financial, human resource, customer service, and operation systems.
6. Facilitated design sessions with the application analyst and end-users, to gather business requirements Led the design, code, test, and implementation of legacy application (mainframe and client/server) messaging interfaces for Oracle iProcurement Application via MQSeries Integrator.
7. Provided technical guidance to the team in defining the data transformation rules and data conversion routines for the integration of data on multiple platforms.

Experience

2-5 Years

Level

Junior

Education

MS

Description :

1. Participated in design, development and implementation of architectural deliverables, to include components of the assessment and optimization of system design and review of user requirements.
2. Contributed to the determination of technical and operational feasibility of solutions.
3. Developed prototypes of the system design and works with database, operations, technical support and other IT areas as appropriate throughout development and implementation processes.
4. Assured that the data application architecture is consistent with enterprise application standards and disaster recovery plan requirements.
5. Provided technical knowledge and capabilities as a team member and individual contributor.
6. Provided strategic thinking, solutions, and roadmaps while driving architectural recommendations.
7. Maintained current and future state architecture.

Experience

2-5 Years

Level

Junior

Education

MS

Description :

1. Participated in implementing and adopting industry best practices on data management like defining data policies, standards, guidelines, architecture and coached team members to follow the defined standards.
2. Ensured the data models were reviewed and updated consistently to ensure compliance with standards and to aid system integration efforts.
3. Led and delivered successfully Campaign Performance Analytics Dashboard saving 1.2 million annually for HP Americas Marketing Analytics Business Groups.
4. Responsible for logical and physical designs of both the ODS(relational) and EDW(dimensional models).
5. Led change control meetings with business primes and developers to discuss proposed changes and understand at what level they applied.
6. Reconciled discrepancies in current state logical and physical data models, and collaborated with other team members to model additional entities and relationships.
7. Designed and implemented extensive user segmentation and tagging system for dashboarding all core KPIs and game balance metrics by user acquisition source, geolocation, device, platform, AB test group, game progress, etc.

Experience

5-7 Years

Level

Executive

Education

MS

Description :

1. Conducted performance tuning, optimization, and troubleshooting of data solutions to ensure scalability, reliability, and high performance.
2. Monitored data systems, identifying bottlenecks, and implementing optimizations to improve data processing efficiency and response times.
3. Designed data models, schemas, and database structures that support efficient data storage, retrieval, and analysis.
4. Designed and implemented Extract, Transform, Load (ETL) processes to move data from source systems to data warehouses or data lakes.
5. Experienced with cloud platforms such as AWS, Azure, Google Cloud Platform (GCP), and their data services (Amazon Redshift, Azure SQL Database, Google BigQuery) for scalable and cost-effective data storage, processing, and analytics.
6. Experienced with big data technologies like Hadoop, Spark, Kafka, and distributed computing frameworks for processing and analyzing large volumes of data.
7. Understood of data governance principles, data quality management, metadata management, and compliance with regulatory requirements (GDPR, HIPAA).

Experience

5-7 Years

Level

Executive

Education

BSIT

Description :

1. Responsible for establishing and securing enterprise-wide data analytics structures.
2. Responsible for drafting conceptual and logical data models for high-level system planning tasks, optimizing each model to customers' needs and budgets.
3. Responsible for spearheading cloud migration initiatives for enhanced scalability, security, and cost-efficiency in managing vast amounts of enterprise data assets.
4. Responsible for employing Software-as-a-Service (SaaS) and Platform-as-a-Service ( PaaS) products to reduce initial outlay in systems purchasing.
5. Responsible for incorporating cloud architecture into new facility planning, reducing need for on-site equipment and technical support personnel.
6. Responsible for improving database performance by optimizing queries, indexing strategies, and overall architecture design.
7. Responsible for gathering, defining and refining requirements, leading project design and overseeing implementation.

Experience

5-7 Years

Level

Executive

Education

Bachelor of Science in Computer Science

Description :

1. Responsible for providing professional services and support in a dynamic work environment.
2. Responsible for demonstrating respect, friendliness and willingness to help wherever needed.
3. Responsible for applied effective time management techniques to meet tight deadlines.
4. Responsible for managing time efficiently in order to complete all tasks within deadlines.
5. Responsible for demonstrating leadership skills in managing projects from concept to completion.
6. Responsible for demonstrating a high level of initiative and creativity while tackling difficult tasks.
7. Responsible for strengthening communication skills through regular interactions with others.

Experience

7-10 Years

Level

Management

Education

Bachelor of Science in Computer Science