Enterprise Data Architect Resume Lansing, IL - Hire IT People

SUMMARY:

Customer focused and insights driven data architect with diverse experience in traditional relational databases, analytical tools, statistical & data mining techniques and tools.
Analytical & Predictive modeling Skills
Data mining and Statistical analysis & tools
Enterprise data governance and management
Confidential technologies and databases
Extract, Transform, Load (ETL)
Enterprise data architecture
Data modeling (Entity Relationship)
Database administration
Project Management
Strong Collaborative skills
Mentoring and Executive presentation skills
Certified Oracle DBA

TECHNICAL SKILLS:

SAS 9.4, R, Python
Hadoop, Pig, Hive
SPSS modeler, SPSS Statistics
Cognos Insight
Weka
Matlab
Oracle 11g/10g/9i/8i SQL & PL/SQL
Oracle Spatial ( Confidential )
ESRI ArcMap/ArcCatalog
SQL Diagnostics, Tuning, PL/SQL Enhancements
ER - Win, Confidential InfoSphere Data Architect
TOAD & Data modeler
Oracle DBA
Informatica PowerCenter

PROFESSIONAL EXPERIENCE:

Confidential, Lansing, IL

Enterprise Data Architect

Responsibilities:

Designed and managed enterprise database comprising of commonly used entities, spatial data items and data service tables.
Engineered new techniques to integrate asset systems and their spatial data elements into the enterprise database.
Demonstrated proof of concepts on advanced spatial needs such as routing, enterprise editing environment. Received IT Manager's Award for Innovation on using Oracle Spatial and mapping technologies. Persuaded developers use of common enterprise elements to enhance consistency across applications .
Streamlined legacy data processes to improve efficiency .
Mentored developers to use Oracle Spatial and mapping technologies .
Collaborated with Confidential Customers, Confidential Planners, Statewide resources on data management, sharing, governance and quality.
Ensured enterprise data standards and best practices are followed .

Tools: Oracle 11g/10g, SQL and PL/SQL, TOAD 10, ER-WIN 4.1.4, Modelmart, TOAD Data modeler, SHP2SDO utility, SQL*Loader, Oracle Spatial SQL and PL/SQL, TransCAD 5.0, Maptitude, ESRI ArcSDE & ArcMAP, Confidential InfoSphere Data Architect and Business Glossary.

Confidential, Lansing, Confidential

Technical Lead

Responsibilities:

Participated in customer requirement gathering sessions and played a key role in designing application.
Prepared high level technical design and test plans.
Identified and resolved several performance bottlenecks.
Ensured CMM-Level 3 compliance.
Received Compuware's certificate of achievement for outstanding service

Confidential, Lansing, IL

Senior/Lead Developer

Responsibilities:

Architecture and designed complex system functionalities to meet child support system requirements. Developed strategies for ensuring quality assurance on deliverables .
Delegated, mentored developers on requirements, coding and testing. Develop string and integrated test plans.
Received DHS Director's Certificate of appreciation for work

Confidential, Lansing, IL

Oracle DBA & Developer

Responsibilities:

Designed and constructed ETL programs using PL/SQL programs for CSES Data warehouse.
Managed oracle database administration, performance tuning, backup and restore processes.
Designed complex batch programs based on the child support requirements.

Tools: Oracle 9i/8i, Forms 6i, PL/SQL, Reports 6i, Procedure Builder 6.0, SQL *Plus 8.1, TOAD 7.1, Oracle Designer 6i, B-Liner 2.0, Visio 5.0b, Compare It 2.8, Remedy User 4.0, Telnet 1.0, AutoSys 7.1 and SQL Impact.

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

Managed multiple oracle databases as 24*7 Production support DBA.
Performed backup, database administration duties and trouble shooting.
Received manager's commendation letter

Confidential, Lansing, IL

Analytics Consultant

Responsibilities:

Performed market segmentation analysis and recommended targeted radio advertisements to promote Express SOS online facility.
Identified patterns of fraud by mining for improper transactions, discrepancies, anomalies and other known patterns. Findings helped the department to monitor, detect and control fraud .
Utilized SAS 9.4, SPSS Statistics for data preparation, segmentation and analysis.

Confidential, Grand Rapids, IL

Analytics Consultant

Responsibilities:

Led small project team to develop multiple predictive models to forecast customer churn for next period based on insurance data set with over 500 variables.
Utilized Confidential SPSS Modeler, SPSS Statistics for data preparation, building models and analysis .

We provide IT Staff Augmentation Services!

Enterprise Data Architect Resume

Lansing, IL

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship