SUMMARY:

• Over 11 years of experience in Information Technology, with exposure to Data Modeling & Data Analysis.
• Along with system integration, Implementation and in project managements. Seeking to be an effective and efficient Information Data Architect, an aim to working with complex & heterogeneous systems. Where I can utilize my skills for the benefit of the organization and gain valuable experience.
• Understanding the business requirements, use cases and data elements from Business Analysts / Business and create an effective data model along with the technical transformation specification by incorporating the business logic.
• Have experience in detailed requirement gathering (DRG) in client workshops by using the questionnaires, fish bone methodology and direct interviews.
• Also have experience in preparing Use Case & Functional Requirement Document (FRD) artifacts for the model / development support.
• Experience in Designing Conceptual, Logical and Physical Data Model along with the Data Dictionary Document.
• Have experience in cross functional data model review along with the shadow support.
• Also Review, Update and Approve the data model by team and peers.
• Having Experience in following the Data Model and Client Standards, also mentor the team to follow the standards to the whenever is necessary.
• Effectively handle multiple deliveries with the help of the Manager and team, segregation and allocation of the work will be handled in priority matrix to avoid last minute deliverables.
• Handled the Change Request in an effectively and achieve the quality in our deliverables.
• Experience in crating the Relational Model & Dimensional Model.
• Create Global XML layout mapping specification including the source and the target information along with the Derived Logic (Pseudo code) for the developer.
• Create the ETL technical specifications using the proprietary tool named DTS.
• Maintain the versions of Data Models and keep track the changes made in the Data Model.
• Working with Senior Architects for reviewing and validating the model before publishing the models.
• Handling normalization and de - normalization process to ensure that the loading and retrieval happens based on the estimates.
• Maintaining the naming standard for documents and following the company standards and processes for all the deliverables.
• Using the Query tool to generate desired report.
• Experience in Reverse Engineering from Oracle Database to DB Wrench v3.0.1.
• Experience in creating skill matrix, iteration planning and traceability

TECHNICAL SKILLS:

Operating Systems: MS Windows 2000/03/XP, Vista, and MS Windows 7

Data Modeling Tools: DB Wrench v3.0.1, CA Erwin Data Modeling Suit R9.5, My SQL Workbench ER Designer R6.

Database: DB2, MS SQL Server 2000, Sybase IQ, Greenplum and Oracle 8

Reporting Tools: Crystal Reports, Business Objects

ETL Tools: Informatica 9.x and Pentaho

Use Case Visual Use Case: Xml ModelAltova Xml Spy

Project Management Tools: JIRA

Data Mapping tools: Altova Mapforce, Data Transformation Spec (Inhouse tool)

PROFESSIONAL EXPERIENCE:

Confidential, Redwood City, CA

Sr. Software Engineer / Data Modeling

Responsibilities:

• Need to understand the requirement provided by the product team and make sure to implement the data elements in the existing model.
• Create the High level design document before implementing; make sure the enhancement doesn’t impact the existing model.
• Create DDL for the table and table partition creations.
• Rollout the Data Dictionary for the ETL Developers and the product developers.
• Make sure the data model sync with the Hive schema and the ad-server schema.
• Support the system operation team during deployment.
• Manage the confluence page and share across the team for the physical and the logical implementation of the supply side model.
• Maintain the version management through GIT.
• Coordinate with the quality team and make sure to overcome the existing bugs published in Jira.

Environment: My SQL server v5.6, Confluence, Centos 6, Jira and Basecamp

Confidential, NYC, NY

Technical Lead / Data Modeling

Responsibilities:

• Need to understand the target data elements, identify the GAPS in the source atomic layer and make sure to capture the GAP in Data mart.
• Create the Conceptual, Logical and Physical model and track the changes.
• Raise the request for Table Space creation.
• Create DDL for the table and table partition creations.
• Rollout the Data Dictionary for the ETL Developers.
• Do the validation based on the business rules and the mapping document.
• Create the reconciliation report and share with the onshore architect.

Environment: CA Erwin Suite 9.5, Oracle 11i, Data Stage and MS Windows 7

Confidential, Madison, WI

Data Analyst / Data Modeling

Responsibilities:

• Understanding the business specification documents and customer requirements.
• Did the reverse engineering from Oracle for the transaction specified tables and create the Physical Document for the conversion.
• Analyzing the existing Oracle environments and Greenplum environment and datatypes.
• Developed migration test plan to communicate the defects to developers.
• Executing both Oracle and Green plum workflow and compared the result sets.
• Do the validation based on the business rules and the mapping document.
• Create the reconciliation report and share with the onshore architect.

Environment: DB Wrench v3.0.1, Informatica 9.1, Green Plum, Oracle, and MS Windows 7

Confidential

Data Analyst / Data Modeling

Responsibilities:

• Understanding the business specification documents and customer requirements.
• Analyzing the existing KPI system.
• Developed the new logical and physical Data Model using the third party tool - My SQL Workbench v6.
• Create MS SQL scripts for DDL from the data models and coordinating with DBAs to implement the database
• Develop the Data Dictionary Document and share with the developers.

Environment: My SQL Workbench V6, Share point, SQL Server 2007 and MS Windows 7

Confidential

Lead System Analyst / Data Modeling

Responsibilities:

• Involving in Events Architecture Artifacts for MaxCv - Events project
• Reviewing business requirement documents and use cases in coordination with Business Analysts and Subject Matter Experts
• Working with Senior Data Architects, Data Modelers and Subject Matter Experts to perform data analysis and functional analysis of the data elements required in the Data Models
• Preparing the data elements description document to help the modeler to create logical model.
• Involved in creating the standard abbreviation document.
• Working with Senior Data Architects to create efficient data transformation specification document.
• Analyzing the requirements for Standard Code Table System (SCoTS) codes for all the Enterprise level data models and checking to see if requests are already present in Standard Code Table System Lite (SCoTS Lite) or can be reused with any of the available SCoTS, and if no match is found, then creating the Code Table and corresponding Code Values with business definitions in Standard Code Table System User Interface
• Working with Senior Data Architects to obtain the Standard Code Table System (SCoTS) Codes reviewed and approved
• Releasing the SCoTS codes identifier to Business and Development teams on approval
• Releasing Transformation Specification for developers along with business logic and notes for every iteration (Model Release)
• Participating in meetings with Business and Client Managers, Project Leads, and Senior Data Architects to provide project status updates and to discuss open items
• Coordinating future plans and activities

Environment: CA Erwin v7.2.5, Data Transformation Spec (In-house tool), Oracle and MS Office

Confidential

Senior Analyst

Responsibilities:

• Performed Change Request (CR) in the model that is used
• Analyzed, designed, and wrote business requirement specifications and technical specifications for new implementations
• Create the Rule level document for the ETL developers to inherit in the transformation.
• Worked with clients, Onshore Business Analysts, and developers/programmers during the development lifecycle to document business needs for decision support data
• Ensured compliance with applicable standards and processes
• Dealt with different database and flat files for the data loading and posted the changes into their respective database
• Served as a techno functional consultant and worked with business users, architects, and Subject Matter Experts

Environment: CI Loader (In house Tool), pseudo coder (in house tool), Sybase, and MS Office

Confidential

Executive Analyst

Responsibilities:

• Created ad-hoc reports using Query studio and sophisticated reports using report studio
• Created List and Cross-tab reports
• Created various types of prompts such as mandatory, optional, and cascading prompts using tool box elements (value prompt, text box prompt, select, search prompt, and prompt button)
• Created variables in condition explorer and set values for conditional formatting through conditional style and conditional text
• Created reports in desired format
• Created a global event element tracker document used in the implementation process which will be helpful for the person who starts the events
• Coordinated with the quality team to ensure that the business logics is getting captured
• Kept track of the working process which will have the before and after of the working module

Environment: Crystal Reports Developer, SQL Server 2k, Ensamble pro dialer and MS Office