We provide IT Staff Augmentation Services!

Data Modeler Resume

SUMMARY:

  • 10 + years of IT experience in analysis, design, implementation and administration of business intelligence solutions in development, testing and production environment, continuous Integration for various v erticals like Banking ( Citigroup, China Merchants Bank), Financial(PRA Group, 9NIU), Technology(IBM, Huawei).
  • Extensive experience in Requirement Analysis, Work flow analysis, Design, Development & Implementation, Testing & Deployment of complete software development life cycle (SDLC) in field of Data Warehouse, Data integration, Dashboard reporting .
  • Extensive experience in modeling Logical, Physical Data model (dimensional and transactional ) for, Data Warehouse, OLTP system using Oracle Data Modeler, IBM IDA,RDA, Erwin, Power designer.Strong concepts of Data Warehousing, strategies for ETL, identifying metrics, dimensions, hierarchies and design dimensional schema (Star, Snowflake) and implementing slowly changing dimension etc.
  • 8.5+ years’ of experience in Oracle 11g/10g/9i, Oracle Exadata, MS SQL Server 2005/2000, DB2, MySQL. Oracle Certified Professional for 9i and 11g Database.
  • 7 + years’ of ETL experience using Informatica Power Center 8.5/9.1/9.6 in design and develop m odular and reusable code and architecture .
  • Expert in designing and developing high performance subprograms Oracle Functions, Procedures, Packages, Cursors, Reference Cursor, Triggers, Collection in Oracle Exadata RAC environment .
  • Extensive experience and professional in PL/SQL,T - SQL,SQL, excellent in performing performance tuning for SQL, PL/SQL, ETL process . Expert in SQL, PL/SQL, T-SQL performance tuning using different approaches, expert in understanding query execution plan ,Autotrace and SQL Access Adviser .
  • 4+ years’ experience using DataStage 7.5/8.1/8.5/8.7 to design and develop ETL solution for IBM finance reporting platform.
  • 3 + year of on-site Experience leading 10 member ETL team, successfully design and implemented multiple solution and projects.
  • 4 years experience with IBM Cognos Framework manager, Report Studio .Good at Cognos report performance tuning and model design .
  • Excellent problem solving skills with a strong technical background and good interpersonal skills.
  • Excellent code review skills, code trouble shooting, code standard setup.
  • Strong Data profiling, analysis skill using SQL and SAS Dataflux .
  • Hands-on experience in Hadoop Mapreduce,HDFS, Hadoop Stream, HIVE,Spark Shell, Pyspark and Scala .
  • Enthusiastic learner and excellent problem-solver.

TECHNICAL SKILLS:

Certifications: Oracle Certified Professional for 9i Database. Oracle Certified Professional for 11g Database. Hadoop Platform and Application Framework .

Systems: AIX, HP-Unix, Zlinux, Ubuntu, Redhat Linux, Windows, MS-DOS, Hadoop

Databases: Oracle, Sqlserver, DB2, MySQL, Essbase, Access

Languages: PL/SQL, SQL, Shell Script, Hive, T-SQL, Essbase Report script, VBA, Java,HTML, P ython . Scala,Sparksql

Software: Informatica PowerCenter, Dataflux, Erwin, IBM Infosphere Datastage, Infosphere Data Architect, Rational Data Architect, Oracle Data Modeler, Toad, SQL Developer, Oracle Exadata(Hardware), SSIS, SSAS,MS Office, Tivoli, Autosys,Power designer, Ipython, Sharepoint . Mapr

PROFESSIONAL EXPERIENCE:

Confidential

Data Modeler

  • Design logical and relational data model for Citi group Information Security data warehouse and BI Dashboard, implement and manage the data model using Oracle Data Modeler, IBM Data Architect .
  • Created fact and dimensional tables (Star Schema ) for Risk and Audit Analysis .
  • Design source target mapping for ETL and reporting team in Excel and IBM Data Architect .
  • Automate existing manual reporting process, redesign the ETL process for various reporting systems .
  • Design and develop Data Masking process using Oracle generic ANYDataset, pipeline function, Oracle Data Redaction,, PL/SQL.
  • Design and develop seat entitlement for reporting using Oracle virtual private database.
  • Perform Data profiling, Data analysis for different source upstream systems .
  • Analyze the performance bottleneck, tune reporting and ETL SQL queries, processes .
  • Work with stake holders, business analyst to understand the requirement and feature of the data .
  • Document functional requirement document and design document .
  • Design modeling rules, standard, Domain and glossary for model validation . Enforce standards and best practices around data modeling efforts.
  • Analyze and performance tuning for the Cognos dashboard reports, shorten the repor loading time by 50% to 60%.
  • Coordinate with different teams to setup job dependencies in Autosys .

Confidential

Technology Lead/Tech Architect

  • Created detail ETL Standards documents for Design, Development, Release Management and Production Support.
  • Created entity relationship diagrams and multidimensional data models, reports and diagrams for bankruptcy management, payment calculation system .
  • Design and Develop Reusable Common objects/process shared across various Repositories.
  • Design Detail ETL spec for offshore development and ensured Quality ETL Deliverable .
  • Automated, Redesigned and tuned several ETL Process for optimal utilization of Time and resources.
  • Develop Job to stream data from operations to Data warehouse using Oracle Supplement log and Informatica CDC.
  • Trouble Shooting, Tune and Maintain complex ETL Mapping and workflows .
  • Re-engineered Data Standardization jobs and Processes to bring down the load times by more than 80%.
  • Design and develop and Implement detail layout of ETL testing plan procedures.
  • Provide estimations for ETL deliverable and oversee the progress for quality ETL Deliverable .
  • Created Informaitca Repository Mappings and Queries facilitating rapid analysis, trouble shooting, code verification and deployment.
  • Design and develop Meta data reports for the ETL, Business and Support teams for day to day needs.
  • Work closely with QA team to identify and resolve defects .

Confidential

Technology Lead

  • Work closely with UK lead and UK stakeholders to understand the different debt management system, identify the difference of the business definition and design the transformation for conversion of the meta-data .
  • Design data profiling process and perform data profiling using SQL and Dataflux for the account migration in different systems in UK.
  • Design the intermediate layer, ETL process, Migration plan using Oracle Data Modeler for migrating 2 millions of Accounts into the PRA Group current system.
  • Design the data validation, data reconciliation process to ensure the data quality of the migrated Accounts.
  • Design the Model and process for payment posting, promises plan evaluation system using Oracle Data modeler .
  • Work with Client lead/BA closely to identify and resolve the issues.
  • Design Unit Test Case for various UK projects, participant in each sprint in Agile Team and fulfill the commitment .

Confidential

IT Specialist

  • Urgent support for Huawei ,analyzed and identified the bottleneck of the ETL process, identified the root cause of slowness in Oracle Database and ETL Processes .
  • Modified the top 15 time taking ETL jobs and shorten the run time.
  • Guide the development team on avoiding performance issue.

Confidential

IT Specialist

  • Worked as Data Architect maintaining Meta data and design data models using IBM Infosphere Data Architect, define entity relationship, data granularity.
  • Designed and merge Data Models
  • Maintain and push model on the Data Architect Wiki site.
  • Designed test case and validated Different Source Target data (OLTP, SAP, Essbase Cube ) during SIT phase, document test cases.
  • Designed and developed ETL jobs using IDA and Data Stage for the Data Application Systems Control and Audit Process.
  • Develop Cognos report using Cognos report studio and Cognos analysis studio
  • Design and execute unit/system test case for the ETL jobs.

Confidential

IT Specialist

  • Design Staging, Metric, Dimension Layer models, define entity relationship, data granularity for measurement using IBM Data Architect .
  • Design data extract (ETL) process for different data source, DB2, Essbase, Cognos, FTP .
  • Performance tuning for the Datastage code In, DB2 SQL Query, Package/Procedures .
  • Worked as Business Analyst gathering and analyzing user requirements.
  • Prepared requirement document and ETL mapping and reporting mock-ups.
  • Validated data in Cognos analysis studio in SIT, UAT and Production .
  • Designed and develop Datastage jobs based on ETL mapping.
  • Performed unit/system test to ensure the data quality.
  • Worked in an Agile scrum team, participant in each sprint and accomplish the commitment.

Confidential

IT Specialist

  • Design Staging, Metric layer model using Rational data architect .
  • Designed and develop Datastage jobs based on ETL mapping.
  • Designed and develop Shell script to control ETL.
  • Performed unit/system test.
  • Validated data via Cognos Analysis Studio.
  • Worked in an Agile scrum team, work closely with stakeholders, senior Data Architect to get the requirement and design the data model, field mappings .

Confidential

Oralce programmer

  • Setup data warehouse environment on zLinux, including create job execution system and Database id, group and permission.
  • Analyze the copybook from Mainframe, design Staging layer model for moving the data from Mainframe, define the glossary for different data sources using Erwin .
  • Cooperated with offshore team and BA to develop Datastage ETL jobs for new data models.
  • Cooperated with mainframe teams to transfer host files and setup the file transfer via ndm.
  • Defined Tivoli schedules and jobs.
  • Tested and implemented ETL jobs in SIT, UAT, PAT and Production.
  • Developed procedures to verify the data consistency.
  • Setup data cleanup and DB backup strategies; coded the new backup program which backups data based on table partition.
  • Setup the SAS user privileges on tables through Oracle policy.
  • Monitored and maintained the production system, provided 24/7 production support and troubleshooting.

Confidential

Oralce programmer

  • Design staging layer based on the mainframe copy books and data model using Erwin.
  • Design the mapping and process for populating data into fact layers .
  • Maintained Meta Data for mainframe data ETL.
  • Cooperated with mainframe team to transfer host files and setup the file transfer via ndm.
  • Defined Tivoli schedules and jobs to set the processes of ETL.
  • Tested and implemented in SIT, UAT, PAT and Production.
  • Created Oracle packages for building the intermediate tables for reports.
  • Setup the SAS user privileges on tables through Oracle policy.
  • Modified the logic of program as per user request

Confidential

Software Engineer

  • Analyzed user requirement from different departments including health, information, Order, factory, finance, Marketing and Sales department.
  • Involved in preliminary design and detailed design for multiple client-Server systems.
  • Built application of the system using PowerBuilder, Oracle, SQL Server .
  • Tested and implemented in SIT, UAT and Production.
  • Provided production support.

Hire Now