PROFESSIONAL SUMMARY:

• Technology Architect in Infosys Limited with 11 years of experience in Data warehouse & Business Intelligence. Areas of expertise include DW Architecture Design, Data Modeling, Project Management, ETL, Data Integration, and Reporting & Visualization.
• Always looking for a challenging and growth oriented position in a performance oriented company, where my contribution to the company will be valued and recognized; through which my technical and managerial skills will be enhanced which in turn will contribute to the organization's success.
• Managed to meet SLA for last three years for both support & development
• Plan and manage multimillion - dollar data warehouse migration projects aligning business goals with technology solutions to drive process improvements, competitive advantage and bottom-line gains.

TECHNICAL SKILLS:

Skills: Teradata, Greenplum, Netezza, Oracle 9i Apache Spark, Scala Informatica 7.1, Informatica 8.6 ER - Studio 7.6 and ER Studio DA 9.1 Microstrategy 9.3, Business Objects XIR2, Tableau SQL, PLSQL Unix Shell Scripting, FTP, SFTData warehousing Data Modeling Database design ETL Design Job scheduling Reporting and Visual Insight Project Management

PROFESSIONAL EXPERIENCE:

Technology Architect

Confidential ( Rye, NY )

Responsibilities:

• Infosys BI Anchor for AVON BI applications managing all BI projects &support with annual revenue of 3.1M USD
• Led a team of 50 to execute and deliver all the BI projects & Support activities
• 99% SLA adherence for both Support & Development projects
• Achieved 8% to10% YoY cost saving to client through productivity improvement
• Quarterly/Monthly forecast and planning of resources to meet the demand as per agreed managed services guidelines
• Publish weekly & monthly reports on Status, SLA, Innovations & s, Issues and Risks
• Understand the new initiatives from Client directors & executive directors and plan for the same
• Analyzing Scope and submitting/clarifying/negotiating Estimations/SOW/Work Orders for new enhancements and projects
• Providing input for planning and design
• Involved in performance engineering activities of Interfaces, ETLs, Databases
• Work with project teams to resolve complex technical issues using solution deployment and roll out methods during build, deployment and support,
• Provide guidance to project teams on quality, process and architectural frameworks to improve technical quality and productivity of the project,
• Provide recommendations on solution architecture, implementation approach and deployment options
• Coordinate with different stakeholders (Integration team, Source team, Performance team, DBA, Global IT, Regional IT, Business Users etc)

Software & Tools: Greenplum, Oracle 11g, Microstrategy 9.3, Unix

Confidential

Responsibilities:

• Understood the business requirement and proposed the best statistical model for unstructured customer feedback text analysis
• Designed the Naïve Bayes statistical model for unstructured text classification
• Built the dataset and classify the test dataset (three type of classification Problem area, Polarity & Sentiment) using Spark Scala language
• Created visual insight of classified data using Tableau reports
• Validated the model, reviewed the result of text classification through business and improved the accuracy
• Automated the whole process for monthly analysis of all customer feedback received to help customer to improve representative/customer satisfaction, product quality, increase in order

Software & Tools: Apache Spark, Scala, Tableau, Unix

Confidential

Responsibilities:

• Understood the existing data warehouses present for Avon BI applications
• Proposed Data Integration approach and strategy
• Proposed, Built and used automated solution for data migration from Oracle to Greenplum and help customer to save 130K USD with a reduced go-to-market duration
• Built data migration tool to migrate data from one Greenplum environment to other, which reduced effort and cost (20K USD per year)
• Design and code review of 400 Greenplum functions
• Led a team of 10 to meet the milestones and helped team to resolve Oracle to Greenplum compatibility issues
• Coordinated with Product Vendor, Client to mitigate any technical challenges and risks
• Implemented the data warehouse migration and provided hyper care support of the product delivered

Software & Tools: Greenplum, Oracle 11g, Microstrategy 9.3, Unix

Confidential

Responsibilities:

• Analyzing the business requirement, clarify the same from client and functional SME
• Analyzing and understanding of Teradata provided base Transport and Logistics Data Model (TLDM)
• Analyzing and understanding of Teradata provided control framework
• Preparing master list of attributes required for EDW
• Performing GAP analysis of master list of attributes with Source system and TLDM
• Customization of TLDM
• PDM build
• Customization of PDM to achieve better performance and compatible enough to use control framework
• Data Source mapping of PDM (Physical Data Model)
• Building Security layer and Semantic layer
• Data source mapping for Semantic layer
• Reviewing ETL design and data flow logic
• Coordinating with Integration team, Source team, Performance team
• Led a team of 30 to train, make them understand the data model and complete the ETL and Reporting

Software & Tools: ER Studio 7.6, ER Studio DA 9.1, Teradata 13

Technology Lead

Confidential ( Cupertino, CA )

Responsibilities:

• Tracking CPU usage daily basis, Space usage monthly basis and verifying the same
• Analyzing Teradata system resource utilization
• Identifying processes having performance bottleneck in Teradata
• Reviewing design of new/upcoming application with respect to feasibility/performance/Capacity of database
• Provide solutions, guide team, reviewing and verifying to enhance the performance of processes
• Teradata database capacity planning with respect to storage and CPU
• Reviewing dynamic workload and throttling settings of Teradata workloads
• Train and guide team in Teradata Performance management

Software & Tools: Teradata 12, SQL, PL/SQL, TOAD 9.0, Unix Shell scripting, Informatica

Confidential ( Cupertino, CA )

Responsibilities:

• Responsible for analyzing system requirement and come up with approach
• Design of framework for parallel validation (Data, Performance, Objects) for database upgrade
• Analyze the production ELT framework and implement the same in test environment
• Responsible for validation of Teradata keywords, database objects, UDFs
• Responsible for validation of ELT jobs (Core, Semantic), Informatica, BOBJ reports with respect to data as well as Teradata performance
• Validation of Teradata ODBC drivers, JDBC drivers, Teradata GSS, tdicu for compatible with other tools like informatica, BOBJ, Corda etc
• Coordinating UNICA campaign management team, SAS, SAP team to check the compatibility of new database
• Support during and after production/DR database upgrade
• Prepared reusable frameworks in unix to automate the total validation process
• It Includes automated Teradata keyword validation, Database object migration and validation, data validation, Teradata resource availability validation

Software & Tools: Teradata 6.2, Teradata 12, Informatica Powercenter 8.1, Oracle 9i, TOAD 8.0, SQL, PLSQL, Shell Scripting, FTP, SFTP

Confidential ( Texas)

Responsibilities:

• Responsible for analyzing business requirements
• Prepared High level design, Detailed Design documents
• Responsible to find out the compatible issues between Netezza and Informatica
• Review of unit test plan for the project based on SDLC
• Review of Traceability Matrix
• Reviewing Test Cases and Test Scripts after reviewing the business required document and technical specifications
• Involved in Integration Testing
• Informatica Code Migration to different environments and Production
• Defect Analysis and Defect Prevention Activities
• Performance Improvement of respective application and Knowledge Management

Software & Tools: Informatica Powercenter 7.1, Informatica Powercenter 8.1, Netezza 4.5, Oracle 9i, TOAD 8.0, SQL, PLSQL, Shell Scripting, FTP, SFTP

Programmer Analyst

Confidential ( Chicago, IL )

Responsibilities:

• Responsible for analyzing system requirements
• Prepared High level design, Detailed Design documents
• Analyzed the Data Model, Development of code in Informatica, Unix Shell scripting and PLSQL and Code walkthrough
• Developed shell scripts for automated secured file transfer ABN AMRO environment to ECRIS system
• Performed Unit Testing and Involved in Integration Testing
• Implementation and support of same.
• Defect Prevention Activities
• Performance turning of Informatica mappings and workflows
• Developed Unix scripts for automatic integrity check across extracts, which helped a lot for Integration Testing.

Software & Tools: Informatica Powercenter 7.1, Oracle 9i, TOAD 8.0, SQL, PLSQL, Shell Scripting, FTP, SFTP

Confidential

Responsibilities:

• Responsible for analyzing business requirements
• Writing and executing Test Cases and Test Scripts after reviewing the business required document and technical specifications for functional acceptance testing and regression testing
• Test report generation
• Defect Analysis and Defect Prevention Activities of Test plans

Software & Tools: NCR Teradata, Oracle 9i, TOAD 8.0, SQL, PLSQL, Shell Scripting, FTP, SFTP

Senior Software Engineer

Confidential ( Chicago, IL )

Responsibilities:

• Responsible for analyzing system requirements
• Prepared High level design, Detailed Design documents
• Developed a unit test plan for the project based on SDLC
• Create and maintain Traceability Matrix
• Writing and executing Test Cases and Test Scripts after reviewing the business required document and technical specifications
• Analyzed the Data Model and Involved in Application Development and Code walkthrough
• Developed and maintained stored procedures, functions using PL/SQL.
• Involved in Integration Testing
• Informatica Code Migration to different environments and Production
• Defect Analysis and Defect Prevention Activities
• Performance Improvement of respective application and Knowledge Management

Software & Tools: Informatica Powercenter 7.1, Oracle 9i, TOAD 8.0, SQL, PLSQL, Shell Scripting, FTP, SFTP

Software Engineer

Confidential

Responsibilities:

• Understanding of SLDC processes,
• Understanding and learning Oracle, UNIX, Mainframe
• Writing and executing Test Cases and Test Scripts for Internal project
• Understanding of project requirement and development
• Position in Confidential mprehensive examination

Software & Tools: Oracle 9i, SQL, PLSQL, Shell Scripting, Mainframe