SUMMARY

• Solutions - oriented professional with a dedicated 14+ year career establishing development, testing and implementation organizations, policies and standards to enable continued growth across complex environments.
• Good knowledge of Hadoop ecosystems, HDFS, Big Data, ETL, RDBMS.
• Experienced on working with Big Data and Hadoop File System (HDFS).
• Hands on experience in working with Ecosystems like Hive, Pig, Map Reduce, Oozie.
• Knowledge of Hadoop and Hive and Hive’s analytical functions.
• Efficient in building hive, pig and map-reduce scripts.
• Worked on all phases of data warehouse development lifecycle, ETL design and implementation, and support of new and existing applications.
• Strength in enhancing collaboration and synergy between business, development, testing and support organizations to improve time-to-market, reduce costs and enhance the rollout of quality products.
• Skilled in designing process and automation frameworks for software development, testing, defect detection and prevention, status report, and
• Release management within Agile development environments. Proven ability to forge solid relationships with global teams, business, leadership and customers to define requirements, design solutions, resolve issues and ensure the release of innovative software
• Extensively used ETL methodology for supporting Data Extraction, transformations and loading processing, using ODI, SSIS, PLSQL
• Highly skilled in Planning, Designing, developing and deploying Data Warehouses / Data Marts.
• Involved in creating mappings, active transformations and also reusable transformations.
• Experienced in analyzing business requirements and translating requirements into functional and technical design specifications.
• Experience in working with different data sources like Flat files, XML files and Databases.
• Hands on experience in migrating the Data warehouse from oracle to Oracle /SQL Server /My SQL / Postgres /Transbase
• Immensely used various active transformations like Filter Transformation, Router Transformation, Lookup Transformation, Update Strategy Transformation, Joiner Transformation and Aggregator Transformation.
• Excellent technical and analytical skills with clear understanding of ETL design and project architecture based on reporting requirements.
• Experience in data cleansing and data mining.
• Capturing data from existing databases that provide SQL interfaces using Sqoop.
• Implemented Proof of concepts on Hadoop stack and different big data analytic tools, migration from different databases( i.e. Oracle, Mysql) to Hadoop.
• Loaded the dataset into Hive for ETL (Extract, Transfer and Load) operation.
• Excellent problem solving skills, high analytical skills, good communication and interpersonal skills.

TECHNICAL SKILLS

Hardware: HP UX, IBM 4381, 3090, AS/400, SUN, IBM Compatible

Operating System: UNIX (Solaris 2.7), Windows 95/NT/2000, OS/2 2.11, OS/400, LINUX 8Linux Advanced Server

Languages: Perl, SQL, PL/SQL, Visual Basic 6, C/C++, Pro*C, JavaScript, HTMLVBScript, COBOL II, Java, Python

Warehousing: Micro Strategy, Oracle Express Builder, Cognos

Databases / Tools: SQL Server, Oracle 11g /10g /9i, Oracle ExpressDB2/400, DB2/2, MS Access 97, Power Designer 6.1, ERWIN, MS VisioDesigner 2000 R 6i Oracle Enterprise Manager, Transformation Server for the AS/400, Transformation Server for MS Windows NT, SQL Tuning

Applications: Oracle Financials, SAP Finance, PeopleSoft HRMS, MS Transaction Server 2.0MS Index Server, MS Developer Studio97

PROFESSIONAL EXPERIENCE

Confidential

Data Architect

Responsibilities:

• Pivotal role in analyzing functional requirements from disparate groups and developing a common Billing platform, focused on reducing maintenance costs while improving productivity. Lead role during the sign-off on key design, code and test walkthroughs within the system
• Partnered with IT team to set-up new platform environment to enable the testing and validation of all products under different Operating System.
• Define, implement and refine engineering processes
• Domain expertise
• Led efforts of Product Technology group, comprised of 8-10 persons across the enterprise, in evaluating emerging technologies and customer requirements, defining strategies for in corporation into product offerings, and presenting business plan and recommendations to leadership for approval.
• Credited with effectively integrating disparate teams into a unified group sharing common goals. Identified training needs and managed career paths to ensure optimal satisfaction and retention.
• Major technology decisions in collaboration with Solution Architects
• Implemented Hadoop stack and different big data analytic tools, migration from different databases ( i.e. SQL Server, Mysql) to Hadoop.
• Loaded the dataset into Hive for ETL (Extract, Transfer and Load) operation
• Performed Data Cleaning and Data Mining on RDBMS and during load to Hadoop Eco Systems
• Conducted architecture overview presentations to senior management, assisted in securing project approval.
• Work with technology and business groups for Hadoop migration strategy
• Validate and assess current planned phases for Hadoop/Big Data migration
• Build technology stack for Hadoop migration considering current architecture
• Build Hadoop migration strategy, roadmap and technology fitment
• Validate and Recommend on Hadoop Infrastructure and data center planning considering data growth
• Execute and advice on the optimal solution implementation
• Creating Performance Steps for the RDBMS at System and Application level.
• Developing strategies for Data Archiving, Migration, and Partitioning.
• Managed Multiple Instances of DB (SQL Server 2008/2005) with a > 1TB database size for multiple clients.
• Managing all DB Releases
• Maintained and Administered Release calendar.
• Deployment of Product.

Confidential

Principle Engineer

Responsibilities:

• Specified and defined nature of major project deliverables. Actively sought out and received support and collaboration from other Data Management and reporting groups throughout the organization.
• Evaluated competing Data Mart approaches, and chose a feeder Data Mart so it would integrate easily with the planned enterprise-wide Data Warehouse being developed later.
• Participated in tool selection criteria definition. Defined and diagrammed significant elements of the proposed database architecture, including the Transactional systems, Interim Data Staging database, Extract Transform and Load (ETL) routines, and On Line Analytical Processing (OLAP) database.
• Created prototype data models, and outlined Operational Data Store (ODS) needs, and estimated impact on project.
• In addition, established documentation requirements and itemized list of project guidelines necessary for each phase of project. Defined project team member roles, and assigned resources to detailed tasks. Devised inter-team communications guidelines and project workflow approach. Finally, recommended specific subject areas in which to seek help from resources with specialized skill sets (e.g. ETL network capacity planning), for devising accurate estimates.
• Managing Weekly Builds
• Preparing DB release strategy
• Performance Tuning the databases to their most optimum level
• Physical and Logical Database Design, Capacity Planning and Sizing of Oracle Databases

Confidential

Programmer Analyst

Responsibilities:

• Define logical and physical relational data models for all new and modified processes, from start to finish.
• Designed new classes, properties, methods, and patterns of class interaction (design patterns).
• Tuned complex stored procedures in SQL, including encryption / decryption algorithms for various applications.
• Designed the data model and architecture of Vendor Assignment & L - Sign, keeping in mind the existing design, current requirements and future requirements, including logical and physical designs.
• Designed Database that consisted of over 200 tables after careful consideration of normalization, referential integrity and database constraints.
• Designed, wrote specifications and helped development team in coding functions, stored procedures and triggers.
• Wrote Packages, Stored Procedures and Triggers, to allow multiple applications to reuse application logic and code that checks and cleans up errors.
• Wrote Packages, Stored Procedures and Triggers, to allow multiple applications to reuse application logic and code that checks and cleans up errors.
• Worked with schema objects.
• Worked with Multiple Instances of DB (Oracle & SQL Server 2005/2000) with a > 1TB database size for multiple clients.
• Database administration, database tuning, database recovery, database backup and database security of Oracle 9i /10g databases and MS SQL SERVER
• Implemented RAC, ASM and Clusterware on 9i and 10g
• Migrated Oracle 8i to 9i and 10g on UNIX & LINUX Platform.
• Worked on DATA GUARD Techniques.
• Identification of SQLs that are candidates for Performance Enhancement, and Tuning them, using STATSPACK, EXPLAIN PLAN, SQL TRACE, tkprof and Hints.
• Exporting & Importing data into the databases, using Oracle utilities, such as exp/ imp, SQL*Loader, External Tables and JDBC drivers installed with-in the database
• Design and Development of External Interfaces using UTL FILE package and Managing Job Queues using DBMS JOB package and Advanced Queuing
• Worked with schema objects.

Confidential

Sr. Software Engineer

Responsibilities:

• Define logical and physical relational data models for all new and modified processes, from start to finish.
• Designed new classes, properties, methods, and patterns of class interaction (design patterns).
• Design, estimate, scheduled and developed new uitliites.
• All system activities which involves policies, administration, monitoring, performance, process change etc.

Confidential

Responsibilities:

• Designed, developed, and implemented several processes that served as foundation for department includes MIS reporting, requirements for central call center control desk and internal assessment tools.
• Directed all operational and business development activities for startup credit card telesales testing department, including staff development, program management, sales generation and MIS reporting.
• Created processes and guidelines as part of start-up development.
• Interacted with multi-operating areas to implement fraud reporting procedures.
• Created logical and physical relational data models for all new and modified processes, from start to finish.
• Coded complex stored procedures in SQL, including encryption / decryption algorithms for credit card security.

Confidential

Sr. Software Engineer

Responsibilities:

• Was involved in Data Modeling, Design and Creation of Database.
• Worked on Stored procedures, Functions & Triggers, worked with schema objects & functions.
• Configured interactions and mappings between multiple language environments.
• Involved in the implementation of the system at the Hospital
• Worked as a Team Member
• Assisted management in strategic planning. Developed strategy for ensuring database independence across multiple applications. Established criteria for selection of an application framework,
• Developed application framework strategies for large-scale version upgrade, and created development standards for application development group.
• Instructor for a rapidly expanding technical education and training
• As an Object Modeler, used Rational Rose models to devise an Impact Analysis and Project Estimation methodology and metrics for a securities portfolio trading system project.