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. Supervised junior data architects, delegating tasks for logical data modeling and design.
2. Analyzed business requirements to define project scope and manage resources effectively.
3. Streamlined the enterprise application inventory, eliminating redundancies and enhancing data integrity.
4. Implemented a Corporate Data Dictionary Meta-Data Repository for effective data governance.
5. Provided comprehensive logical and physical data modeling services for various application development teams.
6. Facilitated design sessions to gather business requirements, ensuring alignment with project goals.
7. Guided technical teams in defining data transformation rules for seamless data integration across platforms.

Experience

2-5 Years

Level

Junior

Education

M.S. Data Science

Description :

1. Designed and implemented architectural deliverables to optimize system designs and enhance user requirements assessment.
2. Evaluated the technical and operational feasibility of proposed solutions.
3. Developed prototypes and collaborated with database and IT teams during the development lifecycle.
4. Ensured data application architecture aligned with enterprise standards and disaster recovery protocols.
5. Provided technical expertise and contributed to team initiatives as both a leader and collaborator.
6. Formulated strategic roadmaps and architectural recommendations to enhance data solutions.
7. Maintained and documented current and future state architectures to ensure alignment with business goals.

Experience

2-5 Years

Level

Junior

Education

M.S. Data Science

Description :

1. Implemented industry best practices in data management by defining data policies, standards, and architecture, coaching team members to adhere to these guidelines.
2. Reviewed and updated data models consistently to ensure compliance with standards and facilitate system integration efforts.
3. Developed a Data Warehouse that improved reporting efficiency by 30%, enhancing decision-making capabilities across departments.
4. Architected a scalable data architecture that reduced data retrieval time by 40%, significantly improving operational workflows.
5. Facilitated change control meetings with business stakeholders to assess proposed changes and their implications.
6. Collaborated with teams to reconcile discrepancies in logical and physical data models, enhancing data integrity.
7. Designed and implemented a comprehensive user segmentation system for dashboarding core KPIs across various metrics.

Experience

5-7 Years

Level

Executive

Education

M.S. in DS

Description :

1. Conducted performance tuning and optimization of data solutions to ensure scalability and reliability.
2. Monitored data systems, identifying bottlenecks, and implementing improvements to enhance processing efficiency.
3. Designed data models, schemas, and database structures for effective data storage and retrieval.
4. Developed and executed Extract, Transform, Load (ETL) processes to integrate data across systems.
5. Utilized cloud platforms including AWS and Azure for scalable data storage and analytics.
6. Leveraged big data technologies like Hadoop and Spark for processing large datasets efficiently.
7. Ensured compliance with data governance principles and regulatory requirements.

Experience

5-7 Years

Level

Executive

Education

M.S. in Data Science

Description :

1. Established and secured enterprise-wide data analytics structures to support decision-making.
2. Drafted conceptual and logical data models tailored to client needs, enhancing project alignment and efficiency.
3. Spearheaded cloud migration initiatives, improving scalability, security, and cost-effectiveness in data management.
4. Leveraged SaaS and PaaS solutions to optimize system investments and streamline operations.
5. Integrated cloud architecture into facility planning, minimizing on-site equipment requirements.
6. Enhanced database performance through query optimization and architectural redesign.
7. Gathered and refined project requirements, leading design efforts and overseeing implementation phases.

Experience

5-7 Years

Level

Executive

Education

M.S. Data Science

Description :

1. Provided professional services and support in dynamic environments, ensuring seamless data solution delivery.
2. Demonstrated effective communication and collaboration skills while leading cross-functional teams.
3. Applied time management techniques to meet tight project deadlines and deliver high-quality results.
4. Utilized leadership capabilities to drive projects from concept to completion, ensuring alignment with business objectives.
5. Showcased creativity and initiative in addressing complex data challenges, leading to innovative solutions.
6. Enhanced stakeholder engagement through regular updates and presentations on project progress and outcomes.
7. Strengthened analytical skills by conducting data assessments to optimize architecture and improve performance.

Experience

7-10 Years

Level

Management

Education

M.S. Data Analytics