SUMMARY:

Take a lead position in the Data / IT Architecture with the knowledge & experience gained over thirty five years in the IT industry to enable the organization face the ever increasing information management challenges. Data / IT Architecture, design, development, leadership, coordination, communication, listening, diagramming, presentation, facilitation and learning.

EXPERIENCE:

Confidential, Troy, MI

Data Architect / Solution Designer

Responsibilities:

• Working as a Data Architect / Solution Designer for some of the high visibility work efforts relevant for all lines of business for strategic decisions.
• Latest projects include Customer Relationship Management (CRM), Marketing, eSignature (operational and BIG data platform solution design), Business Events (click stream) analytics, and Auto Build Sheets analytics solution design on BIG data platform.
• Hands on experience in managing data from Salesforce to the Hadoop environment right from the architecture to daily data flow to Hive table creation and scripts managing the daily flow for the CRM project. The scripts include Linux shell scripts, python and Hive scripts.
• Closely worked with business partners to translate business data rules in technical language for the developers for data integration from a number of systems in to one database.
• Experience in data governance in the areas of metadata management, data design patterns, data design standards and data definition standards.
• Worked on architectural framework for data ingestion into Hadoop cluster and subsequent discovery analytics.
• Worked on ETL design and transformation rules for data movement from discrete sources to a central database for marketing.
• Worked on hundreds of projects to design the data architecture best suited for their current business requirements and is adaptable to future needs. Covered a wide range of insurance / financial sector domains including auto, life, P&C, health, bank and mutual funds. On the Systems side, worked in the areas of ITSM, IT Asset Risk Management and Datacenter Migration Efforts as data architect/designer.
• Worked for the OLTP systems using near third normal form (TNF) modeling techniques as well as the BI systems (OLAP) using the Star Schema Dimensional Data modeling technique.
• Responsible for analyzing business data requirements and model them as per the enterprise data design patterns adhering to the metadata standards such as naming conventions, class words & descriptions; in line with the reference architecture - the Insurance Application Architecture (IAA). Responsible for producing conceptual, logical and physical models.
• Responsible for source-to-target mapping and assist ETL team to code data conversion rules/logic. Responsible for creating worked examples to validate the data models with the business partners.
• Mentored new entrants. Offered consultation to peers to model complex business concepts. Conducted training with a case study approach.
• Was a member of the Data Architecture team that decided Hadoop architecture for BIG data.

Business Analyst / Requirements Modeler

Confidential

Responsibilities:

• Responsible to gather, analyze, document, present, and verify the business functional, non-functional & technical requirements, business rules and data elements using the UML style modeling artifacts such as Use Cases, Interaction Diagrams, State Charts, Data Flow Diagrams, Process Maps etc.
• Model the data requirements in a logical data model. Validate the model by creating worked examples with business scenarios.
• Generate physical data model for the selected database platform such as DB/2, Oracle, MS SQL Server, Postgres, etc. work with the DBA for performance tuning, partitioning, etc.
• Help the developers and testing team understand the model and build test cases.

Alliance coordinator

Confidential

Responsibilities:

• Coordinated a team of 30 Test Specialists.
• Responsible to understand and respond to resource requests, allocate resource to projects, monitor performance & utilization, assess training needs, and resolve issues.
• Conceptualized, pursued, designed, and led the development of a web-based tool for resources to log hours to the allocated projects.
• It is being used since past several years by over 300 consultants without a need to change the basic data structure.
• Used by the management to generate various reports and acts as a feed to the payroll system.

Computer and Systems Eng.

Confidential

Responsibilities:

• Responsible for bringing Computer Aided System Engineering (CASE) culture to the Systems department of Confidential .
• Brought the architectural standards from business goals and objectives to process and data models with impact analysis, to screen design, all with lineage up to business objectives.
• The exercise included data and application architecture starting with mission statement and objectives for the organization.
• Reverse engineered Shares system into an Entity Relationship model and Business Process model.
• Sabic Marketing systems Requirements Modeling and ERP selection (SAP/BaaN/Oracle) for the supply chain management system.
• Laboratory Management Information System (LIMS) data modeling, software selection, implementation and training.
• Set presentation standards for Powerpoint presentations. Conducted seminars and training for management staff.

Tools: used: Oracle Designer 2000. MS Office tool suite. Computer graphics softwares such as Designer, Corel Draw, Draw.

Confidential

Corporate Manager, Regional Manager, Principal Consultant

Responsibilities:

• Corporate manager for franchise operations to implement and oversee the use of standards for the software development and training operations.
• Toured all over India to guide the franchise centers on use of Structured Systems Analysis and Design Method ( Confidential ) and the use of standard training material from the Confidential.
• Overall in-charge of the Regional Center for Confidential .
• Led the effort for documenting the standards and procedures into the manuals for administration, marketing and development/training.
• Promoted the use of Confidential .
• Conducted various seminars and gave presentations on Confidential to senior management to sell the concept. Conducted Confidential training with overhead slides made in line with the Confidential (UK) standard, plus cartoons to make the subject interesting. Conducted training on effective presentations emphasizing the importance of OPTRA - Objective, Preparation, Transmission, Reception and Assessment. Responsible for use of Confidential for development.
• Trained in Confidential by the experts from Confidential (UK). Visited Confidential (UK) to explore collaboration in promotion and use of Confidential .
• Implemented application architecture standards with structured/modular programming practices and loosely coupled components that promote reuse.

Confidential

Sr. Systems Analyst

Responsibilities:

• Design and development of the Bill of Material (BoM) explosion from end product to raw materials for the Production Planning & Control (PPC) system which is considered as a mother of all the systems in a manufacturing industry.
• Guided systems analysts and developers for the development of the Financial Accounting and Vehicle Booking system.
• Developed useful tools using Lotus 123 spreadsheets for costing.

Confidential

Sr. Programmer

Responsibilities:

• Developed/modified over 70 COBOL programs in a year written in a modular fashion. Developed generic subroutines for computing difference between two dates and converting numeric amount to words. Payroll, Inventory, Shares & Debentures.
• Re-designed year-end job programs adopting the structured and modular programming pattern with a 100% Performance improvement.

Confidential

Programmer

Responsibilities:

• Production runs for a government certification examination system. the validation program included hundreds of checks for data validation and consistency.
• Offered the user advisory services for GEORGE 3 multi-programming, multitasking OS environment on Confidential 1904 S.
• Monitored the OS performance, resource utilization, job scheduling and throughput.
• Developed a two pass Assembler for Intel 8080, using FORTRAN IV as a part of the project for MS.
• The assembler was used for coding the programs that were used in the nerve impulse analysis. Developed a text editor program in C language for entering Devanagari script.
• Used arrays of pointers to create the characters in the screen memory.
• This editor was used by Desktop Publishing (DTP) company.