Deena Patel

txq6zo@r.postjobfree.com

* *** **** ****** 586-***-**** (H)

Bloomington, IL 61705-9204 586-***-**** (C)

OBJECTIVE: Seeking a challenging career as Data Architect / Database Administrator / Data Administrator / Data Modeler / Data Warehousing / Business Intelligence Analyst.

SUMMARY:

Eleven years of DBMS experience using RDBMS DB2, UDB, ORACLE, ETL, IMS, SQL, JCL, TSO, ACF, MSP, CLIST, and ISPF on IBM Mainframes. Excellent with WebSphere, ERWIN/ ER Studio and Power Designer. Sound technical knowledge in computer architecture, systems software, and programming tools. Self-directed and motivated with strong teamwork, communication, analytical, problem solving, and organizational skills. Able to train and motivate co-workers and customers. Have demonstrated expertise in analysis, problem resolution, and goal achievement as seen in progressive career positions and in performance reviews. Adept at time management and project management. US Citizen.

ACCOMPLISHMENTS:

Received several corporate recognition awards from customers, peers, and management.

TECHNICAL SKILLS:

Databases: DB2 / UDB 6, 7, & 8, IMS, Oracle, SQL Server, and Access.

Tools: TSO, ACF, MSP, ISPF, CLIST, ETL/DSS, FileAid, OLAP, ERWIN/ ER Studio, WebSphere Studio Asset Analyzer, Cognos, and Power Designer.

Languages: SQL, QMF, COBOL II, HTML, XML, and JCL.

Web Development: Microsoft Expression Studio 2, Macromedia Dreamweaver 8, Adobe Photoshop CS2, Visual Web Developer 2008 Express.

Operating Systems: MVS/ESA, OS/390, Windows-9x, 2000, NT, XP, Vista, UNIX.

Hardware: IBM compatible PC, Sun Solaris, and IBM 3270 Mainframe.

PROFESSIONAL EXPERIENCE:

GRACEFUL CREATIONS, LLC Jun ’08 – Present

Proprietor of Computing Services Company

• Responsible for marketing, customer service, procuring business, and maintaining on-going relationship with client base for future business development

• Responsible for designing overall architecture based on design patterns.

• Developed web forms, user control, custom control for web applications using .NET, ASP.NET, and validated these pages using ASP.NET validation controls under Visual Studio. NET environment.

• Wrote SQL stored procedures, views, triggers and functions for viewing and manipulating data in SQL Server.

• Created flow charts for all business processes using MS Visio.

• Client management and release activities.

• Used HTML controls and Java Script for client side validation on the web pages.

ENVIRONMENT: ASP.NET 2.0, .NET 2.0, SQL Server, Windows XP/2008 server, Microsoft Expression Studio 2, Macromedia Dreamweaver 8, Adobe Photoshop CS2, Visual Web Developer 2008 Express.

CHRYSLER LLC, Auburn Hills, MI Nov ’98 – Jun ’08

DB2 / Data Architect / Data Modeler / Data Administrator / Warehousing / Business Analyst

• As a Data Architect/ Database Administrator / Data Administrator/ Data Modeler/ Business Analyst, I was the sole support for the Application Group in a wide variety of business applications and IT teams clarifying data requirements, participating in analysis sessions, performing data analysis, data profiling, data mapping, reverse data engineering, and data modeling.

• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio, Power Designer.

• Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes. Created reports and depending upon the requirement, published Data model in model mart, created naming convention files, co-coordinated with DBAs to apply the data model changes.

• Worked with customers to develop business rules in planning and developing requirements. Defined and documented business data requirements and standards and translated those data requirements into logical and physical database models. Responsible for the System Impact & Data Standard. Built and managed data dictionary capturing the company’s data requirements & system impact analysis. Lead and managed requirements and analysis activities. Supported various projects for administrative business systems.

• Analyzed existing table structures and mapped transactional data to the reporting tables. As part of Application Support Team, I managed table spaces and tables, ensured data standards, created and maintained records.

• Communicated with application developers to ensure that user requirements were appropriately reflected in data models.

• Analyzed large quantities of data and performed a wide variety of calculations and projections.

• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.

• Developed Metadata Integration Strategy for the Enterprise Data Standards Initiative, including software evaluation, information integration, and management method development. Organized all existing data models, data flows, and data dictionaries into a MetaData Repository. Metadata included operational databases and analytical data warehouses / business intelligence.

• Created physical models of all databases, and logical models of strategic customer and product databases. Designed a Corporate Conceptual Model as an architecture migration target and developed procedures to map this model to the database models to facilitate information location.

• Analyzed reports, data, and systems when existing reports do not function properly. Corrected these reports and/or data. Recommended solutions to keep the data correct in real-time.

• Worked with Database Administrators (DBA) to build conceptual and physical database models & create DDL for application team.

• Performed several Database Administration functions such as: monitoring, performance tuning, data backup & recovery, troubleshooting, utilities, statistics, etc.

• Developed JCL and scripts to automate routine processes.

• Effectively applied in-depth technical knowledge to the design and development of new and efficient systems.

• Acted as main contact for vendor regarding technical and user issues for the design, development, and maintenance of the new Oracle based client-server software system.

• Created documentation for the system. Mapped Oracle main database tables used in the web site reports.

• Automated reporting functions by posting reports on the intranet web site.

ENVIRONMENT: IBM 3270 Mainframe, OS/390, DB2, UDB 8, ORACLE 9 and 10g.2, J2EE, IMS, PL/SQL, QMF, FileAid, Clist, Windows XP, MS Office, TSO, ETL/DSS, OLAP, XML, MSP, ISPF, COBOL, Cognos, Power Designer, ERWIN, ER Studio, WebSphere Studio Asset Analyzer, and JCL.

DOW CHEMICALS, Midland, MI Mar ’98 – Nov ’98

Security Programmer / Analyst

Year 2000 Conversion project for Latin American Plants

• As a Security Programmer / Analyst, I was involved in the analysis, design, coding, and testing of Y2K project for the key automated functions of Dow Chemical’s Mexico and Brazil plants.

• Worked on impact analysis and conversion plans.

• Managed a small group of programmers and helped them with higher order security related issues.

ENVIRONMENT: IBM 3270 Mainframe, UNIX, DB2, ERWIN, ER Studio, MVS, JCL, TSO, ISPF, and VS COBOL II.

REFERENCES: Available upon request.

PERSONAL: US Citizen, multi-lingual.

Contact this candidate