Skill / Experience Summary

• 12 years of work experience in IT Systems as Solution Architect, Data Architect, Technical Project Manager, Data Warehouse Consultant, Data Modeller, Data Analyst, Developer and Tester.
• Expertise in design, enhancement and development of Enterprise Data Warehouse, Data Marts, Data Archives and ETL techniques in different environments like Teradata 14, Oracle 9i with multiple Terabytes of data and various levels of complexity.
• Extensive experience in Data warehouse with strong understanding of Kimball and Inmon Methodologies, Slowly changing Dimensions SCD1, SCD2, SCD3 , Fact and Dimension Tables, OLAP, OLTP systems.
• Expertise in creating create flexible, reusable and scalable Logical, Physical Models and Dimensional Data Models using Erwin and ER Studio.
• Extensive functional Knowledge of Revenue, Product Sales, Compensation and Commissioning process for Telecom Products.
• Well experienced in ETL processes like Data Extraction, Transformation, Loading, Data Cleansing, Data Integration, Data Migration, Data Quality tracking and Data Profiling.
• Experienced in identifying performance bottlenecks and tuning ETL processes, mappings, SQL's as required.
• Expertise in Relational database development using PL/SQL, SQL and BTEQ in various relational databases like Teradata, Oracle, SQL Server 2005/2008, PostGreSQL and advanced SQL Skills in including writing stored procedures, Triggers, Indexes, Views, Synonyms and SQL's using derived tables, Unions and multi table inner and outer joins and creating Database links.
• Expertise in Teradata V14 V12 architectures, extensively worked on TTU's like BTEQ, MultiLoad, FastLoad, FastExport, TPUMP, SQL Assistant to design and develop dataflow paths for loading transforming and maintaining data warehouse.
• Expertise in Informatica Power Center 9x/8x. Extensively worked on Informatica Power Center Designer, Workflow Manager, Workflow Monitor and Change Data Capture CDC Tools.
• Proficiency in implementing complex Business rules by creating complex mappings, reusable components like Reusable transformations, Mapplets, Worklets and reusable control tasks to work with reusable business logic, transformations like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Highly comfortable with SDLC processes, Data Warehouse Concepts, Orthogonal Software Delivery, Agile Software Delivery, Configuration and Release Management processes.
• Expertise in Project Requirement Collection and Analysis, Project Planning, Project Execution and Monitoring, Risk Assessment and Mitigation, Project Sustenance, Production Support and Change Management.
• Expertise in managing project schedule, Resources, Scope, Schedule, Cost, Quality, Risk and Communication.
• Strong experience working in onsite - offshore and multi-vendor agile environments in various Techo- managerial roles. Proficient in running complex projects/programs from inception to deployment.
• Well experienced in CDMA Telecom Standards, Product Development, Concepts and Protocols used in Wireless and Test Measurement Systems.
• Expertise in Software Development with C on Linux platforms using STL and Boost Libraries and Unix shell scripts and possess very good debugging and problem solving skills.
• Experienced in database design for various IVR and payroll management Systems.
• Knowledge of Quality Management Systems, TL9000, CMM/PCMM, Six Sigma. Worked in leadership and prime-ship positions in various Functional Areas.
• Excellent communication, presentation and interpersonal skills and High Process Orientation.
• Excellent Team player and Quick learner with positive attitude and self -motivation.

Technology:

Career Profile:

Confidential

Frontier Data Warehouse Developer

Responsibilities:

• Participate in determining all data warehouse application which will be impacted and needs to be changed.
• Conceptualize, design and implement Shadow Data Warehouse environment for conversion.
• Incorporate new data received after acquisition in data warehouse.
• Ensure current applications have the capability to process the new data.
• Enable users access the new data and generate business required reports.
• Translate functional concepts into technical designs and define, document and execute test cases to effectively validate the new components of the data warehouse being developed, enhanced or otherwise maintained.
• Develop Solution design and code using ETL methodology, Teradata, Oracle, MS SQL Server databases, Informatica, and Autosys batch job scheduler.
• Design, Implement and maintain physical database data models required for new proposed enterprise data warehouse applications.
• Create requirement documentation, design documents and End-2-End test documents. Expertise in design, enhancement and development of Enterprise Data Warehouse, Data Marts, Data Archives and ETL techniques in different environments like Teradata 14, Oracle 9i with multiple Terabytes of data and various levels of complexity.
• Conducted business and functional analysis, creating requirements documents, process flows, data exchange diagrams, and time estimates
• Develop detailed work plans, schedules, project estimates, resource plans and status reports.
• Consult with stakeholders, business technologies and others to understand objectives and prioritize business goals and information needs related to the project.

Solution Environment: Informatica Power Center 9.1/9.5, Teradata V14, Oracle, MS SQL Server 2012, Perl Scripts, BTEQ, MLoad, Fast Export, TPump, Perl Scripts, BTEQ.

Confidential

Role: Senior Data Architect

Responsibilities:

• Lead team in multi-vendor environment at client Site for Revenue, Products, Promotions Contracts, Email, Bill Toll subject areas.
• Ensure project scope is properly defined and captured in high level business requirement and then translated in functional requirements
• Mange project schedule, Quality and risks and deliver high quality product on-time within budget.
• Translate functional concepts into technical designs and define, document and execute test cases to effectively validate the new components of the data warehouse being developed, enhanced or otherwise maintained.
• Define follow standards and models for data warehouse. Engage in team reviews of design and code.
• Worked with Data Modellers to design logical and physical data model
• Implement and maintain physical database data models required for new proposed enterprise data warehouse applications.
• Develop Solution design and code using ETL methodology, Teradata, Oracle databases, Informatica, Erwin data modelling tool, and Autosys batch job scheduler.
• Come up with End-2-End Scheduling Strategy and get it implemented in Autosys.
• Create requirement documentation, design documents and End-2-End test documents.
• Translate use cases into system architecture, process and database construction
• Discuss technical issues with clients and take care of a positive solution
• Issue and release management

Solution Environment : MS Project, Visio, Informatica Power Centre 9.1/9.5, Teradata V14, BTEQ, MLoad, Fast Export, TPump, Perl Scripts, BTEQ, Oracle, Change Data Capture, Erwin.

Confidential

Responsibilities:

• Lead the team in multi-vendor environment and delivered the projects on time as per the schedule.
• Ensure project scope is properly defined and captured in high level business requirement and then translated in functional requirements
• Conducted business and functional analysis, creating requirements documents, process flows, data exchange diagrams, and time estimates
• Develop detailed work plans, schedules, project estimates, resource plans and status reports.
• Consult with stakeholders, business technologies and others to understand objectives and prioritize business goals and information needs related to the project.
• Consult with stakeholders and review project proposals to determine goals, time frame, funding limitations, procedures for accomplishing project, staffing requirements and allotment of resources
• Mange project schedule, Quality and risks and deliver high quality product on-time within budget.
• Develop Logical and Physical Data Model with team.
• Design and Review End-2-End Design and Code
• Create Informatica workflows, BTEQ and shell scripts and deploy.
• Review Tests cases and perform System Test of the Code
• Troubleshoot and guide others on a wide variety of complex problems with interdependence on other projects. Identify solutions within broad application and functional expertise. Recommend and drive the analysis of and solutions to problems. Develop new processes.
• Collaborate with development, QA, and Technical Services teams to define, plan, and deliver on client implementations
• Drive project completion across multiple groups, anticipating and removing barriers.

Solution Environment : Informatica Power Centre 9.1/9.5, Teradata V14 TTU, BTEQ, MLoad, Fast Export, TPump, Oracle 9, Perl, PL/SQL, BTEQ, Erwin, MS Project, Visio

Confidential

Responsibilities:

• Conduct project meetings and is responsible for project tracking and analysis. Prepare project status reports and keep team, management, clients and others informed of project status and related issues.
• Resource management and prioritization as per need.
• Project meetings consist of complex, cross functional teams in multiple locations across multiple time zones.
• Facilitate business and technical design sessions, data conversion planning and case model design.
• Work with Business users to enable them to complete the day to day reporting.
• Collect new business user's reporting requirements and develop optimized solutions for functional teams.
• Provide leadership to the project team in terms of required documentation, adherence to process, policy and standards, including product and business related issues.
• Sales and Compensation Processing for Business and Residential Customers in Operational Data Store and reporting Cubes.
• Product Management at Database level based on Need.
• Sales Recovery for the unmapped Sales.
• Sales Hierarchy Management for Call Centres and Vendor Agents
• Database Maintenance Activities.
• CA Deployment and Internal Request closure as per need.
• Fallout reporting for posted orders, Gross Adds, Disconnects and Net Additions.
• Segment Wise Report creation for Voice, Video and HSI products using SSIS jobs packages.

Solution Environment : SQL Server 2008, SSIS, SSRS, ASP .net, IIS, Unix Shell Scripts, Crontab, Oracle9i, Erwin, Integrated Project Management System , Knowmax