EXPERIENCE SUMMARY

• Over 11.5 years of result driven and proven track record in the analysis, design, development, implementation and management of full life cycle commercial applications in Confidential
• Worked as Project Lead, Change management consultant, Technical project manager, Technical Lead, Support Manager, Netezza Data architect & Modeler.
• Involved in utilizing programming and logical skills in software development of Multi - tier applications, Client Server Applications, Enterprise Applications using Unix and technologies like Informatica, Data stage, Micro Strategy, Business objects and Unix platform.
• Extensive knowledge and work experience in C, C++, Pro*C, Oracle 9i/10g, PL/SQL, SQL Server, HTML, XML, Netezza, Teradata, MS SQL Server 2008,SSIS,SSRS,SSAS and UNIX
• Proficient with using Erwin Data modeler.
• Experience in writing and implementation of Batch Scripts, Report Generation, and scheduling process using Shell Programming, Autosys, Tidal
• Experience in Requirement gathering from Business Users, Customer interaction, design, development, configuration, Testing, and installation of business application and product using core technologies C++, C and Oracle on Linux.
• Good Knowledge of design patterns, templates and reports customization in Business Objects.
• Experience in the Object Oriented Analysis and Design, strong in Data Structures.
• Knowledge of source control tools such as VSS, CVS, SVN.
• Conversant in Inmon and Kimball Methodology
• Conversant with all aspects of Netezza loading NZLOAD and NZSQL, Netezza architecture, database design and Netezza Performance Tuning skills.
• Demonstrate knowledge of plans, join processing, Netezza optimization techniques, Netezza specific best practices and solid understanding of Distribution, Zone maps, MVIEWS and be able to use them appropriately.
• Complete understanding of software development lifecycle (SDLC).
• Highly skilled at building teams, designing, developing software products and deploying it to the customers satisfaction.
• Good organizational and time management.
• Deep exposure in data warehouse MPP appliance processing.
• Industry focus includes Banking, Telecommunication, Retail, Financial and Life sciences.
• Demonstrated success many times under aggressive project schedules and deadlines. Flexible result-oriented and adapt to the environment quickly to meet the goals of the product and the organization.
• Facilitating the Agile meetings: Release Planning, Sprint Planning, Daily Stand Up, Story Review, Sprint Review, Sprint Demo and Sprint Retrospective.

TECHNICAL SUMMARY:

Programming Languages: C++, C, SQL, PL/SQL.

Operating System: UNIX, Linux, Solaris, AIX, Macintosh, Windows 95/98/NT/XP

Scripting Language: Perl, Shell, JavaScript, JASON

Databases: Oracle 8i, Oracle9i,DB2,Netezza 4.6,Netezza Twinfin, Teradata, IBM CDC

Development Methodologies: OOPS, OOAD, Rational Unified Process, n-Tier Client Server

Design Tool & Language: Rational Rose Enterprise Edition (OOA/OOD), UML

Version Control System: Perforce, CVS, VSS, SVN,JIRA/Confluence/Fisheye/Crucible

ETL tools: Data Stage, Informatica, Talend

Reporting tools: Business Objects 5.6,6.5,XI Micro strategy 9.2

Web server: IIS Web Server, Apache Web Server

Database tools: Toad, WinSQL, Oracle SQL Developer, AQT, Teradata sql assistant, Aginity Workbench for pure data system for analytics

Hadoop Stack: HDFS, Pig, Hive, Impala , Oozie, sqoop

PROFESSIONAL EXPERIENCE:

Confidential

Data ware house Consultant

Responsibilities:

• Provide principal-level technical expertise which includes overseeing the design, development, implementation and maintenance of the Risk Data Architecture to ensure and align with Enterprise Architecture.
• Serves as in-house expert and is responsible for the overall plans to initiate and pursue continuous data quality improvements.
• Performance optimization of Netezza Appliance.
• Ensures that operational and analytical data warehouses are able to support all business requirements for business reporting across the organization.
• Architect and optimize existing Micro strategy infrastructure with a focus on usability, performance, reusability, long-term flexibility, and standardization.
• Displayed demonstrated abilities in communicating the overall customer data architecture to both technical and business constituencies.
• Deep understanding of information delivery architecture including the creation of abstraction layers, SQL query paths and optimization, report level calculations and end user reporting architecture.
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads.
• Designed and executed Error and Exception handling processes and used Informatica Debugger for failures.
• Extensively worked on Informatica tools like - Designer, Workflow Manager and Repository manager.
• Modeling end to end analysis using Meta center tool for Metadata data flow analysis.
• Modelled Hive tables and designed Oozie workflows to sqoop data using pig as the mean to process and transfer the data into Hadoop clusters.
• Data lake implementation for exposure of conformed dimensions from EDW with data in Hadoop for exploratory BI .This helped data scientists and Risk analyst for predicting and modeling Global credit and Risk exposure.
• Approve crucibles and making sure best practices are followed.

Environment: Teradata, Netezza TwinFin Appliance, Unix, Micro strategy 9.2, Linux,  SSIS, SSRS, SSAS, T-SQL, SVN, Informatica, HDFS, Pig, Hive, Impala, Oozie

Confidential

Change management Consultant

• Help client to come up with plan of action and implement change in controlled fashion involving sox and PCI complaint systems.
• Train development team to present the requirements and implement proposed design.
• Lead and guided team of 7 offshore tech leads and developers for Massive Informatica Change as across EDW landscape.
• Acted as liaison between DEV and Work with QA team and come up with mechanism track defects.
• Implemented Joiner, Rank, Lookup, Update Strategy, and Router transformations in mapping.
• Used Mapplets extensively to design common mapping components.
• Involved in Design, development, unit testing and integration testing of new Informatica jobs.
• Builds new/enhance dashboards and reports in Tableau.
• Created process maps for the efficient planning and execution of SKU expansion implementation
• Review Business requirements and advice technical feasibility.
• Work with Product owners, Directors and provide consolidated status across portfolio to VP.
• Help Application owners and guide to follow the roadmap and enlighten them with the business advantage and scalability.
• As a Scrum master was responsible for the daily meetings and work assignments for the entire team.
• Organize the product backlog, being well able to apply the MoSCoW prioritization and map the result with a business value per story point.
• Implementing informatica Best Practices.
• Preparation of High level design document.

Environment: AS400, Informatica, Netezza, Tableau, Teradata, Unix, Windows XP, SQL Server 2008 Enterprise Edition, SSAS,MDX, OLAP, SSIS, T-SQL, SSRS Linux.

Confidential, NJ

EDW Consultant

• Help with Retail EDW Data loads.
• Creating and modifying Schema Objects and Public Objects to enable reporting on new and changed data elements.
• Effective use of optimizer settings in Netezza to bring in Optimum performance.
• Modelling data adhering to Netezza specific best practices.
• Review Business requirements and advice technical feasibility.
• Provide operational support for business reports enable to gain in performance benefits of Netezza Appliance.
• Actively involved in the analysis, design and development of ETL jobs.
• Implemented Joiner, Rank, Lookup, Update Strategy, and Router transformations in mapping
• Created Transformations and Mappings using Designer Tool of Informatica.
• Workload Management and capacity planning for Netezza system.
• Have solid understanding of Distribution, Zone maps, MVIEWS and be able to use them appropriately.
• Created Dashboards using widgets like Micro charts, Time Series Slider, Heat map and Gauge.
• Used intelligent cube reports in dashboard as datasets to achieve performance.
• Performance tuning of Netezza Sql queries and improve performance of the queries.
• Bulk insert data into Netezza using nzload interface.
• Effective use of optimizer settings in Netezza to bring in Optimum performance.
• Preparation of High level design document.

Environment: Unix, Windows, Sql server, Micro Strategy, Informatica, Netezza, Teradata.

Confidential

Support Manager

• Help with Astra Zeneca EDW for interaction, Data loads.
• Monitor ETL workflows to load data into NZ from oracle environments.
• Provide operational support for business reports enable to gain in performance benefits of Netezza Appliance.
• Workload Management and capacity planning for Netezza system.
• Coordinated program level risk management and resolution support with Program Managers and other stakeholders.
• Created complex mappings using Connected/Unconnected Lookup, Sorter, Aggregator, dynamic Lookup and Router transformations for populating target table in efficient manner.
• Worked with reusable components such as transformation, Mapplets, lookups etc and reusable objects sources and targets (shared folder) for ETL process.
• Extensively used Mapping Variables, Mapping Parameters, and Parameter.
• Performed SDLC adherence scoring and reporting for projects/initiatives using scorecards and templates.
• Conducted In-flight Project Reviews and suggested improvements.
• Works closely with stakeholders and IT vendors to ensure software solutions meet business requirements.
• Assess the impact of system or business process changes
• Preparation of High level design document.
• Handled production support for Netezza Appliance.
• Able to prioritize, organize, plan and report on all production support matters.
• Ability to analyze historical data to spot trends and problem areas in the applications and report defects and enhancements for product improvement.
• Excellent problem solving and analytical skills.
• Extensive experience with documentation (workflows, issue resolution, reporting)

Environment: Unix, Windows, Informatica 8.0, Twin fin, service now, Teradata.

Confidential

Consultant

• Designing and coding the existing application to work on Netezza 4.6.
• Preparation of High level design document.
• Identified and implemented operational architecture changes in the warehouse for performance improvement.
• Conduct complete and comprehensive requirement gathering sessions, JAD sessions, one-on-one and group interviews for the development of both business, functional and system requirement documents. 
• Estimation and preparing the plan for implementation.
• Working with the client for the integration of the various assets of Confidential software across globe.
• Research on failures to make permanent fix and implementing permanent fixes through CR.
• Performance Tuning in existing ETL Aggregate and Cube tables used in Business Intelligence environment.
• Unit testing, Bug fixing, Client Implementation and Interaction.
• Documenting the work done and ensuring that the requirements in the SOW are met.

Environment: Unix, Abinito, NPS 10400 series, Twinfin.

Confidential

IT Analyst

• As a lead developer guided team members for project development.
• Assisted the team in converting Sqls written in sql and pl/sql to suit to Netezza environment.
• Created data model using ERWIN data modeler for Mortgage loan processing.
• Database design was done for payments and ledger creations.
• Database interaction was developed in NZSQL.
• Planning and designing the backend process.

Environment: Unix, Shell scripting, Oracle 9i, Netezza 4.6.

Confidential

Technical lead

• Migration from DB2 to Netezza for better performance.
• Business objects reports development, independent unit testing and code reviews.
• Modelling of BO Universe design which exploits Netezza zone maps feature.
• Unit and Integration testing & Assistance in system testing.
• Release Management Activities.
• Designed reusable components such as transformation, Mapplets, lookups etc and reusable objects sources and targets (shared folder) for ETL process.
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads.
• Designed and executed Error and Exception handling processes and used Informatica Debugger for failures.
• Extensively worked on Informatica tools like - Designer, Workflow Manager and Repository manager.
• Created complex mappings and also tuned for better performance.
• Review and Final Inspection of all the work products before delivery for the completeness, correctness and adherence to standards.
• Created migration scripts to populate default data in newly created Database table.
• Analyzing feature sheets and preparing requirements
• Designing of various modules and design documents and implementing the design
• Preparing of test plans as per requirements
• Preparing and executing test cases to ensure that all requirements and functional specifications are tested and fulfilled.
• Documenting user manuals, configuration and deployment guides.

Environment: Mid-Range Computers, RS240 Server, Informatica 8.1, Netezza, SSIS,SSRS,SSAS, Teradata.

Security Administrator

Confidential

• Helping the onsite DBA team for performance related issues.
• Running STATS pack & Query tuning.
• Creating users and handling security related issues.
• Assigning roles and granting privileges.
• Administering all database objects, including tables, clusters, indexes, Views, sequences, packages and procedures.
• Performed the capacity planning required to create and maintain the Data bases.
• Controls migrations of programs, database changes, reference data changes and menu changes through the development life cycle.
• Developing stored procedures and triggers.

Environment: Windows Workstation, Unix, Oracle 9i,Toad, unix, Teradata

Offshore Track Lead

Confidential

• Preparation of Technical Design Specifications for Interfaces.
• Developing Custom Components, Pages and other online objects as per the requirements under Interfaces.
• Developing SQR reports based on the requirements.
• Unit and Integration testing
• Assistance in system testing
• Release Management Activities
• Review and Final Inspection of all the work products before delivery for the completeness, correctness and adherence to standards.
• Coordinating with onsite for clarifications, status update, issues/concerns
• Coordinating with CCD and project team for connectivity and system H/W & S/W Installation related issues.
• As a Configuration Controller Anchor, responsible for creating and merging project branch in Clear Case.

Environment: Windows Workstation, PeopleSoft HRMS 8.8, People Tools 8.45, SQR, and Oracle 9i

Software Engineer

Confidential

• Preparation of Technical Design Specifications for Interfaces.
• Developing of DTS Packages and Stored Procedures for the ETL load process.
• Unit and Integration testing & Assistance in system testing
• Release Management Activities.
• As a Defect Prevention anchor, Responsible for creating awareness among team members to avoid frequently made defects.
• Review and Final Inspection of all the work products before delivery for the completeness, correctness and adherence to standards.
• Coordinating with onsite for clarifications, status update, issues/concerns
• Coordinating with CCD and project team for connectivity and system H/W & S/W Installation related issues.

Environment: Windows Workstation, Data Stage, Erwin Data modeler, SSIS,DTS, SQL server

Software Engineer

Confidential

• Analyzed and resolved second and/or third level problems for all network components; implementing, maintaining, and administering LAN and/or WAN systems.
• Proactively responded to incidents and service requests to fulfill service requirements within Service Level Agreements Operational Level Agreements, and managing activities using a variety of tools and reporting systems.
• Recommended system upgrades, patches, and new applications and equipment.
• Responsible for incident classification, resolution and closure.
• Developed and maintained a database for known user problems and solutions.
• Participated in UAT to ensure user satisfaction.
• Responsible for implementing the workstation security tool to maintain standardization of the Business client on all platforms.