SUMMARY:

• 13+ Years of total IT experience in managing/leading data warehousing projects, Hadoop environment, Cloudera Manager, Application and Data Architecture, Data Modeling, Data Analysis, Data Profiling, Data Lineage, Data Governance and Quality, design, development & implementation of business applications across industries such as banking, insurance and manufacturing
• Experienced data architect on relational and dimensional model design and methodology from multiple perspectives and hands - on experience in designing ETL techniques on multiple database platforms
• Experience on database modeling tools like Erwin
• Good knowledge in BI domain, Data Warehousing, using MS SQL Server 2012/2008, MS SQL SSIS, DataStage, Ab Initio, Hyperion Interactive Reporting, ERWIN 9.7 Data modeling, Quality Stage, Informatica data quality 8.5 tool, Information Analyzer, Information Governance Catalog, Fasttrack, Collibra, Impala, Hive, Python
• Worked throughout the SDLC and actively involved in development of project scope, S2T mapping, Data Dictionary, Business Glossary, and ongoing quality control framework.

  Worked as a liaison between the business and IT data warehousing team. Good at performing Gap Analysis between “As Is” system and “To Be” system

• Analysis skills to understand the needs of business users and stakeholders and transform those into functional/technical requirements. Able to analyze mainframe copybook, COBOL programs, Unix/Shell scripts
• Knowledge of processes followed in Data Migration project, End to End Data Warehouse Development Project and Data Warehouse Enhancement Project, Hadoop Cloudera environment
• Worked on databases like SQL Server, DB2, Oracle and performance tuned stored procedure
• Worked with teams to examine business problems by accurately analyzing the needs of clients and helping them achieve improved quality and value for their customers

TECHNICAL SKILLS:

Databases & Tools & Framework: Oracle 8i, SQL Server 2012/2008, DB2, SSIS, SSAS, Datastage 7.5.2, 8.1, 9.1, Hyperion Interactive Reporting tool, Informatica Data Quality tool, Ab Initio tool, MS Visio, RequisitePro, Rational Rose, Erwin 9.7, Hadoop Cloudera, Hive, Impala, Python, NOSQL Db, Information Analyzer, IBM Infosphere Information Governance Catalog

Other Utilities: MS Office Suite, Quality Center, Rational ClearQuest, StarTeam, VSS, Tidal

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte NC

Responsibilities:

• As Data Modeler and Architect gathered business requirements by driving user-group meetings and working with various global, cross-functional teams for modeling
• Worked on Information Analyzer, Information Governance Catalog, FastTrack, Impala, Hive, Python
• Defined new policies and guidelines for each team within organization. Implemented data integrity and provided consistency across the enterprise that must be met by each team within the organization.
• Created solutions for critical business elements across teams to measure the quality and accuracy as per business rules.
• Worked throughout the SDLC and actively involved in development of project scope; collection and documentation of business requirements, preparation of related process documentation.
• Conducted Business Requirement Document walkthrough session with Development team and QA team

Confidential, Charlotte, NC

Responsibilities:

• As Data Modeler/Data Architect/ETL Analyst gathered business requirements by driving user-group meetings and working with various global, cross-functional teams.
• Performed source system analysis and data profiling on source system. Performed data lineage to create source and target mapping.
• Worked throughout the SDLC and actively involved in development of project scope; collection and documentation of business requirements, preparation of related process documentation, source to target mapping.
• Worked on oracle database, PL SQL, SQL server database and Ab Initio tool
• Conducted Business Requirement Document walkthrough session with Development team and QA team

Confidential

Responsibilities:

• As Data Modeler, Data Analyst established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationship.
• Prepared process flowcharts for documenting the requirement specifications.
• Performed source system and data profiling on source system. Performed data lineage to create source and target mapping.
• Created physical data model with DDL that best suits the requirement from the logical data model using forward engineering.
• Created and maintained the Data Model repository as per company standards.
• Worked on Teradata database, PL SQL and SQL server database, IDQ Informatica data quality
• Conducted UAT for verifying continuous functioning of day today activities of business

Confidential, Wilmington DE

Responsibilities:

• As Data Modeler, ETL Analyst worked with all stake holders to understand the existing Data warehouse process and challenges.
• Researched and analyzed the various steps in the claims processing lifecycle in MNLR database
• Conducted Design discussions and meetings to come out with the appropriate Data Mart at the lowest level of grain for each of the Dimensions involved.
• Worked atconceptual/logical/physical data model level using Erwin according to requirements.
• Responsible for interviewing business users, document technical requirements, provide leadership in creating the overall system architecture, identify the various elements and classify their dependencies.
• Design and Develop the data warehouse data load strategy using Ab Initio tool
• Design the data mart to support the reporting requirements
• Conducted Business Requirement Document walkthrough session with Development team and QA team
• Conducted UAT for verifying continuous functioning of day today activities of business

Confidential, Philadelphia, PA

Responsibilities:

• Worked as Data Modeler, Data Analyst Lead for IBOR project which consisted of modules like ACCLAIM, GADB, CLB, FML
• Worked on Consumer Data migration project from SQL server 2008 to SQL server 2012
• Installing SQL server and configuring Cluster and availability groups.
• Prepared process flowcharts for documenting the requirement specifications. Involved in creation of Conceptual data model
• Worked on the high level design and met with the modeler to have the TD objects modeled. Prepared the design documents for the project that includes mapping documents, Data Lineage-Visio documents. Worked on Erwin tool and IDQ Informatica Data Quality
• Used array of languages such as SQL, PL/SQL, UNIX and Stored Procedures depending on the specific requirement of the project
• Prepared process flowcharts for documenting the requirement specifications.
• Developed User specification documents. Also, gathered business requirements by driving user-group meetings and working with various global and virtual teams
• Performed data analysis by using SQL queries using SQL server database tool
• Developed Jobs Using Datastage PX 8.1, Schedule, these jobs will be interacting with Oracle for Extracting data using query

Confidential

Responsibilities:

• Managed end to end data warehousing development project and involved in all phases of Software Development Life Cycle (SDLC)
• Developed Jobs Using Datastage PX 8.1, Schedule these jobs using Tidal scheduling tool, these jobs will be interacting with Oracle for Extracting data using query
• Provided support on understanding requirement to the End to End Integration / Regression Test Team
• Involved in creating Functional Requirement Specification (FRS) document and User Requirement Specification (URS)document for system application development
• Involved in supporting various teams such as Development, QA and Technical Support teams and worked as ETL Lead
• Worked as a DataStage administrator which included activities like Install/upgrade server, client or patches, Reporting (daily, weekly, and monthly) on health and performance of the ETL environment and jobs, analyzed existing Infrastructure and DataStage jobs, ensuring best practices are being followed, and
• Developed SAP LSMW (using Recording, Standard Program, and BAPI) as per Functional Specification Provided and involved in Coordination with client and team
• Developed the plans/jobs Using Informatica Data Quality 8.5.0
• Involved in development of deliverables which included Informatica Data Quality jobs
• Involved in documenting the plans/jobs created in Informatica Data Quality 8.5.0 and also documenting the processes followed in the projects
• Performed DataStage administration activities like Performs DataStage installation and applied maintenance patches, supported teams for DataStage needs and guidance
• Also, involved in developing jobs in parallel and server canvas in Datastage and developing sequences of jobs and worked on MQ plug-in stage in Datastage