SUMMARY

• 9 year 5 months of total IT experience in the Business Requirements Analysis, Solution Design, Data Architecture,Data Integration,Data Quality, Implementations of Data warehousing and Database business systems for Telecom, Banking and Technology industries.
• Around 3 Years of experience in BSS sytems like BSCS & CRM - Siebel.
• 8+ years of Data warehousing ETL (Extract, Transform, Load) utilizing Informatica 7 / 8/ 9 Power Center, SQL Server, Oracle, Teradata, SQL, PL/SQL, Unix Shell Scripts, Sun Solaris and Windows, including complete System Life Cycle from Analysis and Design to Implementation.
• 2+ Years experience with OLAP Tool- Business Objects XI R2 (Designer, Web Intelligence).
• 2 + years experience in Big Data Technologies, Hadoop Mapreduce, Hive, Pig,,
• Extensive database experience using Oracle 10g/9i/8i/7.x, SQL Server 12.0, Teradata, Erwin, SQL, PL/SQL, SQL*Plus, Win 3.x/95/98/2000, Win NT 4.0 and Sun Solaris 2.x.
• Experience with ETL integration efforts of various data sources into a staging area; Installation and Developed common logic using Reusable transformations and mapplets. Developed Strategies for Extraction Transformation Loading (ETL) mechanism;
• Knowledge on Bigdata technologies HADOOP Map-Reduce, Hive, HBase,Sqoop,Phoenix, R Programming.

TECHNICAL SKILLS

Telecom Products: BSCS, CRM-Siebel.

ETL Tools: Informatica, Pentaho Kettle

OLAP & Reporting: Business Objects

Data Modeling: Erwin, Visio, SQL data modeler.

RDBMS: Oracle, SQLServer, Teradata

Scripts: Unix, BTeq scripts

Languages: Java, C++, C, UNIX Shell Scripting.

OS: UNIX, Windows 98/2008 R2/NT /XP/7/8, Sun Solaris, Linux.

BI Methodologies: Kimbal, Inmon.

BigData Technolgies: Apache hadoop,Mapreduce, Hive, HBase,Pig,Phoenix, Sqoop,Oozie, Hadoop Cluster Setup.

PROFESSIONAL EXPERIENCE

Confidential

Solution Architect & Big Data Analyst

Responsibilities:

• Part of building the BI data model to support E/// events from BI/IDW Teradata CDM data model & FADS(Financial Analytical Data Source).
• Working as source data analyst for BSCS customer,Product & Finance data.
• Mapping the Confidential events against the E/// CBIO DB attributes for applications like BI/IDW,Commissions and Campaign Management.
• Reviewing the business and functional requirements from Confidential .
• Involving in the JAD meetings.
• High level designing for E/// out of box reports from different applications E///billing, order management and ECNM for drop1 release 1.
• Reviewing the Confidential customer and product model and validate product changes in CBiO to accomadate Confidential requirements.
• Gathering the reporting requiremetns from TMOB and solution design.
• User story & FSP document creation for reporting requirements.
• Report development using crystal reports & BO 4.0.
• Hadoop cluster setup for Control & Compliance system .
• Data loading using Hive/Pig programming for CDR data analysis & log analysis.

Environment: BSCS iX 4.0, BO 4.0, Oracle, Unix, Visio, Brackets UML, Golden Gate, Hadoop Hive & Pig, Erwin Data modeler.

Confidential

Sr.Data warehouse Developer

Responsibilities:

• Logical/physical modeling of DB objects in the SQL Server.
• Developing ETL design, change data capture, created SQL views.
• Follow the quality standards and guidelines for configuration management, testing, project planning and execution.
• Carrying out impact analysis for change requests.
• Establishing and monitoring issue management, change management and quality management processes.
• Loading data from Flat Files into the Staging area using Informatica PowerCenter into Sql Server.
• Using the designer designed Mappings, which populated the Data into the Target Star Schema on SqlServer Instance.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.

Environment: Windows, Informatica PowerCenter 9.1, SQL Server 2012, Octopus, Visual Stuido 2012(VSTF).

Confidential, Plano, TX

Sr.Data warehouse Developer

Responsibilities:

• Worked with Business Users to identify Key Business Rules and Measures and recommend controls to validate the information.
• Perform Data Profiling to analyze the data from correctness, completeness, accuracy, integrity, consistency dimensions
• Coordinate with Business Leaders and Project Managers to assure the solutions are complying with Business Strategies and are according to IT strategic plan.
• Architect for Data Management Framework for Confidential &T Data Warehouse Quality Data Management.
• Program, including but not limited to Metadata Management, Incident Management, Change Management, Data Quality Management, Master Data Management.
• Designed Conceptual, Logical and Physical Data Model using ERWIN Data Modeler
• Defined processes to capture Data Definitions, Metadata, Process Lineages, Data Sources, and Downstream Applications.
• Coordinated with Development Teams, Offshore team, Project Manager, Business Users to deliver key project milestones.
• Worked on Unix and Btech scripts.
• Defiening and ipleenting data quality metrics on diffirent subject areas like Customers, Orders, Payments, Call detail records, Confidential &T Uverse etc.
• Used different techonologies like Oracle, Teradata to capture the different metrics.

Environment: Teradata, Oracle, Bteq, Unix Scripting,Erwin

Confidential, SanJose,CA

Production Support

Responsibilities:

• Co-coordinating offshore team in all deliveries.
• Generate and review the audit reports.
• Involving Change Management Process, Release plans and Upgrading plans.
• Root Cause Analysis of various aborts in Golden Gate,Datamover and Informatica.
• Client Status Reporting.
• Impact analysis and deployment support.
• Dollar U scheduling and monitoring.
• Unix scripting and Teradata stored procedure implementation.

Environment: Informatica PowerCenter 8.1,Oracle Golden Gate, Data mover, Teradata, Oracle 10g, SQL,Unix Shell Scripting.

Confidential, Charlotte

Sr.Data warehouse Developer

Responsibilities:

• Interacting with onsite co-ordinator and client in understanding the requirements.
• Preparing the low level design documents.
• SQL Scripting usind Netezza and building the model microstrategy
• Developing informatica mappings/sessions/maplets/workflows.
• Preparing and executing unit test cases.
• Fixing defects raised as part of system testing.
• Deploying the informatica and database objects in different environments like SIT,UAT and PROD.
• Developing Autosys jobs for process flow control.
• Developing/Enhancement of stored procedures in oracle, teradata and netteza database.
• Unix scripting and BTeq scripting.

Environment: Informatica PowerCenter 8.1, Netezza Oracle 9i, Teradata, SQL, TOAD, Autosys, Unix Shell Scripting.

Confidential

Data warehouse Developer

Responsibilities:

• Requirement Analysis.
• Impact analysis on Du’s data warehouse system due to change requests.
• Data integration from various BSS/OSS source systems into enterprise data warehouse system using ETL tool Informatica.
• Unit testing of ETL code.
• Guide team members in learning datawarehousing and telecom domain.
• Good knowledge in data warehouse concepts and SQL.
• Oracle stored proedures implementations.
• Unix scripting.
• Developing informatica mappings / transformations / sessions /workflows.
• Good knowledge in the below areas of Business Objects XI R2
• Designing universes.
• Resolving loops in universes using concepts like aliasing and contexts.
• Creating classes and objects(dimensions, measures and detail).
• Creating objects with LOVs and cascaded LOVs.
• Developing reports (Desk-I & Web-I) .
• Knowledge on BSS applications systems like BSCS,SIEBEL-CRM,Prepaid Intelligence Network etc.

Environment: Informatica PowerCenter 7.1, Business Objects, Oracle 10G,Unix Shell Scripting.

Confidential

Order Management Developer

Responsibilities:

• Requirement Analysis.
• Impact analysis.
• Developing the code for BT’s transaction workflow management.
• Oracle stored procdure enahancements.
• Unix scripting.
• Unit testing
• Testing support.

Environment: Oracle, CSS-Order System