SUMMARY

• 10 years of IT experience in Data warehouse and Business Intelligence systems.
• Experience in various phases of IT projects such as data analysis, design, development, testing and supporting database and data warehouse systems on OLAP and OLTP environments.
• Extensive experience in ETL tools like Informatica Powercenter including Big Data Edition (BDE), Oracle Data Integrator (ODI), Golden Gate.
• Design and Development of Dashboards using Tableau for various organizational metrics and indicators using industry standards.
• Database design, data modelling of data marts, data warehouse systems on ER Data Modeling, Dimensional Modeling (Star Schema, Snowflake Schema) using tools like Erwin, Aqua Data modeler, Microsoft Visio, Toad.
• Experience in Big data technology and cloudera Hadoop architecture including Partitions
• Worked extensively in HDFS datasets, Apache Hive using query language HiveQL and Beeswax Hue.
• Experience in Data Integration, Data migration, Master Data Management (MDM) projects.
• Have good development and Performance tuning experience on Oracle Database 11g/10g/9i, Sybase ASE 15.0 and Sybase IQ, Teradata 14.0, IBM Netezza, IBM DB2,XML schema definitions
• Excellent experience in scripting languages like Unix Shell scripting, Teradata Bteq scripting and knowledge in Python scripting.
• Proficient in Normalization/Denormalization techniques in Relational/Dimensional database environments.
• Played role in Project Management, Project Schedule, Project Tracking and Team Management.
• Proficient in managing teams involved in development of user centric products and data migration across various platforms and database upgrades.
• Executed organization design and structure, hiring, training, performance management, professional development.
• Rich experience in programming languages like Pl/Sql, T - SQL, PostgreSQL, HiveQL, SSIS, Pro*C.
• Knowledge in Research, Financial modelling, Statistical analysis, Operations research, Project management.
• Implementation of Database Management Systems and Data warehouse systems for Banking, Financial and Health care clients.
• Experience in DBA and Admin related activities using Unix, Oracle Enterprise Manager, Hue.
• Proficient in all project methodology including Agile/scrum.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i, MS Sql Server, Teradata 14.0, Sybase ASE 15.0, Sybase IQ, IBM Netezza, IBM DB2

ETL Tools: Informatica Powercenter 9.5.1/9.6.1/8 , Informatica Developer, Informatica Analyst, Oracle data Integrator, Golden Gate, SQL* Loader

Reporting Tools: Tableau 8.2

Programming Languages: UNIX Shell Scripting, Hadoop Hive SQL, Teradata BTEQ, SSIS, SQL, PL/SQL, T-SQL, C, Pro*C, PostgreSQL

Database Tools: Toad 10.1.1.8, Teradata SQL Assistant, Pl/Sql Developer, Sql Developer, Aqua data studio, DBArtisan, Netezza Aginity, Hadoop Hue, SQL*Plus, SQL * Loader, MS SQL Server, Oracle Enterprise Manager, Database/ Performance/Query tuning (TKProf, SQL Trace), Squirrel SQL Client, FileZilla, Putty, Toad for SQL Server

Scripting Languages: Unix Shell Scripting, Teradata Bteq scripting

Data Modeling Tools: Erwin 8.1, ER Studio Data Architect 8.5, Toad Data Modeler 3.4, MS Visio 2010, Aqua Data ER Modeler

GU Front-end Tools: Oracle APEX

Version Control Tools: MS Visual SourceSafe (VSS), SVN, CVS, Accurev, Perforce, Confluence

Web Designing: HTML, XML

Operating systems: Unix, Windows

Job Schedulers: Autosys, Appworx, Oracle Enterprise Manager, Informatica Scheduler

QA/Testing Tools: Bugzilla, Test Case Manager, Teamtrack, JIRA, Quality Center, ResultSpace, Rally

Project Management: HR, Risk, Scope, Estimation, Organization design and structure, Hiring, Training, Performance management

Certifications/Training:

• Oracle PL/SQL Developer Certified Associate (OCA) awarded by Oracle University.
• AMFI Mutual Fund certification awarded by Indian National Stock Exchange.
• Certified Finance Professional certification awarded by Oracle Financial Services.
• Oracle APEX training conducted by Oracle University.
• Informatica Data Quality, Tableau training from Confidential Academy

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

ETL/BI Architect

Responsibilities:

• Leads database and ETL design processes, development and release management.
• Data analysis by matching requirements with reports and creating business requirement and technical specification documents.
• Database design and Data modeling of DataMart systems on Sql Server, Netezza, Oracle using Erwin and Microsoft Visio and data warehouse systems on Oracle,Sql Server and Hadoop.
• Involved in development and Performance tuning of Informatica ETLs, Unix Shell Scripting and HiveQL.
• Developed Tableau dashboards for various organizational metrics and indicators including Risk related business processes which includes Portfolio Analysis of money transfer processes, Bank declines, Approvals and marketing campaigns.
• Migration of data from various data sources to Hadoop warehouse system using Informatica from different OLTP databases including XML schema definitions.
• Developed automated frameworks for Audits and support alert system.
• Assessed the impact of change requests on the enterprise architecture from data and information perspective and worked on enhancement requests and deployment processes.
• Created Informatica dynamic mappings/mapplets using Mapping Architect for Visio.
• Proficient in creating strategic documentation of all types in a timely fashion
• Fluent/expert in Visio and Program/Project strategic artifacts.

Environment: Informatica Powercenter 9.5.1/9.6.1 BDE, Tableau 8.2, Cloudera Hadoop Hive QL, SSIS, Informatica Developer 9.6.1, Netezza Postgre SQL, UNIX Shell Scripting, Toad data Modeler 3.4, IBM Netezza, T-SQL, MS Sql Server, Oracle 10g, Microsoft Visio 2010

Confidential, San Francisco, CA

ETL/BI Tech Lead

Responsibilities:

• Responsible for the Functional & data Architecture, integration and middleware architectures, decision support architectures
• Leads the design of database, data models, ETL processes, data warehouse applications and business intelligence solutions through the use of best practices and tools
• Performing data analysis, matching requirements with reports, creating technical specification documents.
• Lead the reporting solutions for organizational metrics for decisioning system using Tableau Dashboards
• Working with business analysts on discrete technology-related business problems, formulates options including assessing their relative merits and risks, determines the best solution.
• Provides overarching guidance and leadership on all technical and data stewardship lifecycle aspects of the sourcing of data through to the refreshing of enterprise databases with appropriate quality, modeling, change controls, and cycle time disciplines.
• Develops strategies for data acquisitions, archive recovery, and implementation of a database.
• Assessing the impact of change requests on the enterprise architecture from a data and information perspective
• Developing/testing/tuning Informatica mappings, technical design documents, mapping document, plsql procedures.
• Experience developing governance for ETL audit, balance and control
• Developing and testing UNIX Shell Scripts.
• Co-ordination while code deployment to production and non-production environment.

Environment: Oracle 11g, Informatica 9, Oracle 11g SQL, Tableau, Pl/sql, UNIX, Toad data Modeler 3.4, TOAD 10.1.1.8, Informatica Debugger, XML, Microsoft Visio 2010, Filezilla, XML, Putty, Microsoft SQL Server, Unix shell Scripting, Toad for SQL server

Confidential, San Francisco, CA

ETL/BI Tech Lead

Responsibilities:

• Leads the design of database, data models, ETL processes, data warehouse applications and business intelligence solutions through the use of best practices and tools
• Performing data analysis, matching requirements with reports, creating technical specification documents.
• Status discussion with various stakeholders.
• Performing data analysis, matching requirements with reports using Tableau, creating technical specification documents.
• Interacting with business users end analysts in order to formulate data model as per requirements using ERwin data modeler.
• Working closely with the DBAs to implement data model and translate it to physical database design
• Data validation for data flowing from upstream systems.
• Developing/testing/tuning Informatica mappings, technical design documents, mapping document, plsql procedures.
• Developing and testing UNIX Shell Scripts.
• Review ETL design and Informatica mappings, Unit test plan documents.
• Co-ordination while code deployment to production and non-production environment.
• Defect fixing and trouble shooting.

Environment: Oracle 11g, Informatica 9, Oracle 11g SQL, Tableau, Pl/sql, UNIX, Data Mart, Windows XP, Toad data Modeler 3.4, TOAD 10.1.1.8, Microsoft Visio 2010, Filezilla, XML, Putty, Microsoft SQL Server, Unix shell Scripting, Toad for SQL server

Confidential, Lansdale, PA

Senior ETL Developer

Responsibilities:

• Develops architecture strategies, documents and maintains Architecture Roadmap for the Data Warehouse
• Responsible for working on medium to high architectural impact projects, creating Conceptual Architecture and High Level Design documentation and recommending Best Practices.
• Creates logical, physical and dimensional data models using Erwin
• Experience with ETL design and developing architecture for Data Marts
• Proficient in creating strategic documentation of all types in a timely fashion, fluent/expert in Visio and Program/Project strategic artifacts
• Responsible for reviewing and approving low architectural impact designs and directing implementation of the architecture
• Conducts complex technology and data assessments for data warehouse architecture and participates in ongoing releases, directing implementation of the architecture
• Acts as a lead in component architecture and provides in-depth technical and systems consultation to ongoing releases and technical management to ensure alignment with the Architecture.
• Acts as expert technical resource to Data Analysts and development staff in the development, testing, and implementation process.
• Data validation for data flowing from upstream systems.
• Developing/testing/tuning Informatica mappings, Bteq scripts, plsql code
• Developing and testing UNIX Shell Scripts.
• Review ETL design and code prior to delivery.
• Co-ordination while code deployment to production and non-production environment.
• Defect fixing and trouble shooting.

Environment: Oracle 11g,Teradata 14.0, Informatica 9, Oracle 11g SQL, Bteq Teradata Sql, Model N, Pl/sql, UNIX, Data Mart, Windows XP, Toad data Modeler 3.4, XML, TOAD 10.1.1.8, Microsoft Visio 2010, MS Office, Filezilla, XML, Aqua data studio, Teradata SQL Assistant, Bteq Scripting.

Confidential, Boston, MA

Senior ETL developer

Responsibilities:

• Working closely with the management to formulate and track project plan.
• Discussion with various stakeholders at offshore and client teams
• Followed Sapient approach Agile methodology to track the project status and deliverables
• Estimating and planning resources based on Sapient approach
• Database designing/Modeling for AA application using Erwin, Aqua Data Studio
• Performing Technical Analysis and creating functional requirement document
• Analyzing the requirement and formulating solutions.
• Verifying data quality after extracting and loading data from external feed using integration service by Informatica.
• Data validation for data flowing from upstream systems.
• Review Informatica ETL design and code prior to delivery.
• Analyzing the existing T-SQL programs and replicate the logic in PL/SQL.
• Developing/testing/tuning T-SQL, PL/SQL code.
• Developing and testing UNIX Shell Scripts.
• SQL and PL/SQL Performance Tuning - analyzing query plans & query tuning for SQL scripts by using tools such as Explain Plan, TKProf, SQL Trace utilities.
• Leading a team for 3 members at onsite and 15 resources at offshore.
• Co-ordination while code deployment to QA and production environment.
• Defect fixing and trouble shooting.

Environment: Oracle, Sybase ASE, Sybase IQ, Informatica 8.6, Oracle 11g, UNIX shell scripting, Oracle Pl/Sql, Sybase T-SQL, Oracle PL/SQL, Golden Gate, Autosys, Toad data Modeler 3.4, SQL* Loader, TOAD 10.1.1.8, XML, Microsoft Visio 2010, Data Mart, Putty, Clearcase, DBArtisan.

Confidential, Boston, MA

Senior ETL developer

Responsibilities:

• Followed Sapient Approach (SA) Agile methodology to track project status and iterations
• Status discussion with offshore and client teams
• Database designing/Modeling for legal entity database using Erwin, Aqua Data Studio
• Performing Technical Analysis and creating Technical Design Document.
• Analyzing the requirement and formulating solutions.
• Extracting and Loading data from external feed using integration service by Informatica.
• Data migration to migrate data from databases like Oracle, Sybase ASE to Oracle and Sybase IQ environments for generating reports and for auditing purposes
• Data validation for data flowing from upstream systems.
• Review Informatica ETL design and code prior to delivery.
• Analyzing the existing T-SQL programs and replicate the logic in PL/SQL.
• Developing/testing/tuning T-SQL, PL/SQL code.
• Developing and testing UNIX Shell Scripts.
• SQL and PL/SQL Performance Tuning - analyzing query plans & query tuning for SQL scripts by using tools such as Explain Plan, TKProf, SQL Trace utilities.
• Leading a team for 3 members at client location and 14 resources at offshore.
• Co-ordination while code deployment to QA and production environment.
• Defect fixing and trouble shooting.

Environment: Oracle, Sybase ASE 15.0.3, Sybase IQ, Informatica, Sybase T-SQL, Oracle PL/SQL, Golden Gate, Oracle 11g, Aqua data studio, Accurev, Java, UNIX, Toad data Modeler 3.4, SQL* Loader, TOAD 10.1.1.8, JIRA, Data Mart, Unix shell scripting, .NET Framework, XML, Microsoft Visio 2010, Aqua data modeler, DBArtisan, Putty

Confidential, Boston, MA

Senior ETL Developer

Responsibilities:

• Analyzing the requirement and assigning it to team members.
• Performing Technical Analysis and creating Technical Design (TD) Document.
• Interacting with business users end analysts in order to formulate data model as per requirements using ERwin data modeler.
• Review Informatica ETL design and code prior to delivery.
• Developing and Testing T-SQL programs.
• Developing/testing/tuning PL/SQL code.
• Developing and testing UNIX Shell Scripts.
• Database Designing/Modeling.
• Designing/Developing Informatica ETL Flow.
• SQL and PL/SQL Performance Tuning - analyzing query plans & query tuning for SQL scripts by using tools such as Explain Plan, TKProf, SQL Trace utilities.
• Review the design and code prior to delivery.
• Co-ordination while code deployment to QA and production environment.
• Defect fixing and trouble shooting.

Environment: Oracle, Sybase ASE 15.0.3, Sybase IQ, Informatica, PL/SQL, Sybase ASE, Sybase IQ, T-SQL, Data Mart, Unix shell scripting, Accurev, Aqua Data Studio, DBArtisan, Erwin, Aqua Data Modeler, Putty, Golden Gate, JIRA, Toad, Java, XML

Confidential

Senior ETL Developer

Responsibilities:

• Developed complex “PRICING” functionality module involving advanced features of oracle 10g
• Performed as a Track lead for various teams like VaR Reporting, Performance, Data Warehousing team
• Prepared Story (high level of tasks) Dashboard lists, High Level planning and LLP tasks
• Performed as a DBA of the project and involved in maintenance of multiple databases
• Performed as a Technical SME and held responsibility of Deliverables sent to clients
• Involved in internal & Client code reviews and followed strictly the Sapient SA3 quality process
• Analyzing the requirement and assigning it to team members.
• SQL and PL/SQL Performance Tuning - analyzing query plans & query tuning for SQL scripts by using tools such as Explain Plan, TKProf, SQL Trace utilities.
• Defect fixing and trouble shooting.
• Database designing/Modeling for few modules.
• Help other teams in the business domain

Environment: Oracle 10g, Microsoft SQL Server, Oracle PL/SQL, Informatica, Sybase T-SQL, SSIS, Data Modeling, Toad Data Modeler, Oracle Enterprise Manager, Unix Shell Scripting, Visual Studio Safe, Microsoft Visual Studio, Data Mart, Bugzilla, TKProf, Performance tuning, ERwin

Confidential

ETL developer

Responsibilities:

• Working closely with the management to formulate and track project plan.
• Status discussion with various stakeholders.
• Performing Technical Analysis and creating Technical Design (TD) Document.
• Performing Data Analysis.
• Analyzing the requirement and formulating solutions.
• Extracting and Loading data from various source systems using integration service by Informatica.
• Designing ETL flow for the Data Mart.
• Data validation for data flowing from upstream systems.
• Developing/testing/tuning PL/SQL code.
• Developing and testing UNIX Shell Scripts.
• SQL and PL/SQL Performance Tuning - analyzing query plans & query tuning for SQL scripts by using tools such as Explain Plan, TKProf, SQL Trace utilities.
• Review ETL design and code prior to delivery.
• Defect fixing and trouble shooting

Environment: Oracle 10g, Oracle PL/SQL, Informatica, Java, Oracle XML technologies, SQL *Loader, Oracle data Integrator, Unix shell scripting, CVS, Putty, Toad data modeler, Data Mart

Confidential

Senior Database Developer

Responsibilities:

• Leading a three member team.
• Involved in requirement gathering, Analysis, Design, Development and testing of screening, workbook modules in the application
• Developed Oracle packages, procedures and functions which involves advanced features of oracle 10g including xml file parsing and loading in the database
• SQL and PL/SQL Performance Tuning - analyzing query plans & query tuning for SQL scripts by using tools such as Explain Plan, TKProf, SQL Trace utilities.
• Involved in peer review and adhering to quality process
• Prepared delivery logs for development that has been requested and deliver them

Environment: Oracle 10g, Oracle PL/SQL, .NET, PL/SQL Developer, Putty, Bugzilla, Oracle XML technology, Toad, Erwin data modeler

Confidential

Senior Database Developer

Responsibilities:

• Involved in requirement gathering, Analysis, Design, Development and testing of various sector tests scenarios
• Developed Oracle packages, procedures and functions
• Developing and testing the PL/SQL code.
• SQL and PL/SQL Performance Tuning - analyzing query plans & query tuning for SQL scripts by using tools such as Explain Plan, TKProf, SQL Trace utilities.
• Involved in peer review and adhering to quality process
• Prepared delivery logs for development that has been requested and deliver them
• Involved in Performance tuning of oracle 10g SQL queries

Environment: Oracle 10g, Oracle PL/SQL, .NET, PL/SQL Developer, Putty, Bugzilla, Oracle XML technology, Toad, Erwin data modeler

Confidential

Senior Database Developer

Responsibilities:

• Involved in Analysis, Design, Development and testing of sector tests module
• Co-ordinating with client at onsite to gather requirements
• Developed Oracle packages, procedures and functions using advanced features of oracle 10g including collections, table functions.
• Involved in peer review and adhering to quality process
• Prepared delivery logs for development that has been requested and deliver them
• Involved in Performance tuning of oracle 10g SQL queries

Environment: Oracle 10g, Oracle PL/SQL, .NET, PL/SQL Developer, Putty, Bugzilla, Oracle XML technology, Toad, Erwin data modeler

Confidential

Database Developer

Responsibilities:

• Analyzed, developed, tested and Peer reviews of various inbound and outbound batch process built on Batch framework
• Played a key role in the team by being a part of requirements gathering, understanding Client System, requirement Analysis, use case preparation, development, unit testing and system integrated Testing
• Involved in development of Pro*c programs, stored procedures and Packages in Oracle/Plsql for mapping fields from legacy systems to paradigm database

Environment: Oracle 9i, Unix, Pro*C, Oracle, Pl/SQL, Unix shell scripting

Confidential

Database Developer

Responsibilities:

• Involved in requirements gathering, design and development of modules using Pl/sql, Pro*C,Unix
• Created application specification, use case documents
• Preparation of unit test scripts, assembly test logs for the components
• Identifying the Problem & providing solutions as to data repair or program bug fix
• Other enhancements projects worked includes Checking credit liability of customers through view option of the booking module and Service tax & education cess calculation for various fees charged for a customer & printing of the same in customer statements.

Environment: Oracle 9i, Unix, Pro*C, Oracle, Pl/SQL, Unix shell scripting