Uploaded File
Padmavathy
Information Architect
C2C Jacksonville, FL
Available immediately
Exploring options
Padmavathy
48
views
Information Architect
0
Recommendations
Average rating
48
Profile views
Software Engineer Information Architecture Analytics Data Analysis Data Validation E/R Studio Enterprise Miner ETL Metadata OLAP
Remove Note
View Note
Recent Experience
Information Architect 03/16 - present
Information Architecture
Software engineer 02/06 - 03/08
Software Engineer
09/05 - 12/06
Summary


• 10 years of experience in analysis, design, development, implementation and production support in areas of Database, ETL, and analytics using ER Studio, SAS, OLAP and Report Development.
• Extensive knowledge of relational and dimensional data model, star schema and Snow Flake schema and Kimball Methodologies.
• Expertise in developing Conceptual, Logical and physical data models and maintaining it with version control
• Proficient in translating user requirements to physical data model, generate data definition language using ER Studio CASE tool.
• Experience designing Geographical Information System database tables to be compatible with map layers using SDO and SDE
• In depth knowledge of Dimension tables, Fact and summary tables, slowly Changing Dimensions, Conformed Dimensions, and Metadata.
• Experienced developing multi star schema with secondary dimension tables.
• In depth knowledge of database concepts Entity relationships, Database constraints, data types.
• Expertise in designing and developing Enterprise Information and Content Architecture Models.
• Experienced in collaborating with application teams and database administrators and design the optimal solution to fit the requirements
• Expertise in data analysis and reporting using advanced Excel features like Pivot table, charts, VLookups, macros, formula auditing and data validation.
• Proficient in using SAS Enterprise Miner and IBM SPSS for Predictive Analytics.

Top 5 Skills
SkillsProficiencyLast Used
Software Engineer
2008
Information Architecture
2019
Analytics
0
Data Analysis
0
Data Validation
0
Education and Certifications
Anna University 2005
Anna University
Preferences
Availability:Immediately
Willing to relocate?:No
Prepared to Travel:No travel (0%)
Employment Type:Any
Security Clearance:No clearance
Citizenship:H-1B Visa