SUMMARY

• 8 years of total IT with hand on experience of Hadoop Big Data development experience.
• Around 5+ of experience in Business Intelligence administration, design, development and deployment using SAP Business Objects from version 5 to XI 4.0, extensive experience gathering techno - functional requirements.
• Hands on experience in installing, configuring and using ecosystem components like HDFS, Hbase, Hive, Sqoop, Pig
• Strong understanding of project life cycle and SDLC methodologies including Agile and RUP
• First point of contact for any R&D activities and critical problems
• Experience in development, implementation and testing of Database projects
• Got good knowledge on MySQL, Oracle, and RDBMS.
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), Mainframes, SAP BW, MS Access and client/server applications.
• Experience with data analysis, mapping source and target systems for data migration efforts and resolving issues relating to data migration and data creation.
• Developed reports from multiple data providers like Universes, Free Hand SQL, Personal data files.
• Experience on working in a version migration environment from 6i to XI R2 and XIR2 to XI 4.0.
• Experienced in interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing universe, documenting and rolling out the deliverable.
• Experience using CCM, Import wizard and LCM tools. Ability to work with team and manage quickly resolves issues in a dynamic environment.
• Polished interpersonal communicator with strong team building and conflict management skills.
• Excellent experience on Banking, Financial and insurance background.

TECHNICAL SKILLS

Big Data: HDFS, Mapreduce, HBase, Pig, Hive, Sqoop, Flume, MongoDB, Cassandra, Power pivot, Puppet, Oozie, Zookeeper

Programming/Reporting: Business Objects 5.1/6.0/XI R2/ XI 3.1/4.0 (Supervisor, Designer and Reporter)/ XI R2, XI 3.1, 4.0, Web Intelligence, Crystal Xcelsius, Crystal XI, LCM, Import Wizard, Dashboard

Database: Oracle 11g/10g/9i, MySQL, DB2, MS SQL Server 2000, Ms-Access, TOAD, Sybase, Teradata SQL Assistant, SQL Advantage, BW 7.3

Operating Systems: MS Windows 2000/NT/98/XP, Linux, UNIX

Programming: C, C++, Java, Perl, Linux shell scripts SQL, PL/SQL, C+

Software: MS Project, MS Word 97/2000, MS Excel 97/2000, MS Office, MS PowerPoint, IBM WebSphere MQ 6.0

PROFESSIONAL EXPERIENCE

Confidential, Woburn, MA

HadoopAdministrator/Developer

Responsibilities:

• Worked on map-reduce Joins in querying multiple semi-structured data as per analytic needs.
• Programmed Hadoop combiners, partitons, counters, filters.
• Coded map-reduce counters to gather runtime metrics of job progression.
• Created Hadoop distributed cache resources needed for job execution.
• Developed Hadoop debug scripts identifying causes for task execution failures.
• Configured Hadoop server components such as Name node, Data node, Secondary Name node,
• Performed cluster monitoring and maintenance activities supporting applications and infrastructure.
• Created hadoop deployment packages running Hive queries using custom map-reduce jobs.
• End-to-end performance tuning of Hadoop clusters and Hadoop Map/Reduce routines against very large data sets
• Lead Hadoop data modeling efforts, both logical and physical
• Worked on Hadoop Schema design, File uploads to Hadoop Distribute File System

Environment: Hadoop, MapReduce, HDFS, Hive, CouchDB, Flume, Oracle 11g, Java, Struts, Servlets, HTML, XML, SQL, J2EE, JUnit, Tomcat 6. Java, JDBC, JNDI, Struts, Maven, SQL language, Oracle, XML, Eclipse

Confidential, San Antonio, TX

Business Objects Developer& Administrator/ Hadoop Administrator

Responsibilities:

• Gathered requirements and developed universe for reporting solutions, working with the Power users and Community of Practice (COP) to prioritize requirements and deliver reporting solutions.
• Participated in Big Data / Big Insight POC evaluation (Hadoop and NoSQL).
• Held meetings with project managers, business analysts and end users to analyze business requirements and created outlines.
• Created design, development, test plans, detailed functional specifications documents, user interface design, and process flow charts.
• Designed reports using SAP BI Launch Pad from different source systems.
• Always checked cardinalities and integrity of the Universe and corrected any logical or SQL problems and used free hand SQL and derived tables to create universes for best performance.
• Deployed the reports on web using Opendoc functionality and SharePoint 2007.
• Created mock -up reports for initial user presentation in the process of designing TDS (Technical Design Specifications).
• Involved with a team and worked on Importing and exporting data into HDFS and Hive using Sqoop
• Experienced in analyzing data with Hive and Pig
• Installed/Configured/Maintained Apache Hadoop clusters for application development and Hadoop tools like Hive, Pig, HBase, Zookeeper and Sqoop Loading log data directly into HDFS using Flume
• Experienced in managing and reviewing Hadoop log files
• Scheduled reports on Daily, Weekly, Monthly and custom calendar dates basis
• Created users, groups, folders and categories and Setting upCustom and Access level Security for Business Objects contents and applications.
• Managing change management and production moves in a parallel development environment.
• Leading the development teams on universe design and report development on the project.
• User training and assistance to Business Objects 4.0.

Environment: SAP Business Objects 4.0/XIR3, SAP Crystal Reports 2008/XI, LCM, SAP BW BEx Queries, Oracle 9i, Teradata, SQL Server 2005, Hadoop, NoSQL, HDFS, Flume, Pig, Hive

Confidential, Hemdon, Virginia

Business Analyst / BO Developer

Responsibilities:

• Involved in gathering requirements for the DARAM (Data Access Reporting and Modeling) Project.
• Worked on Business and System Requirements Documents and created data mapping for database to communicate with the reporting tool.
• Talked to various business users and created functional and nonfunctional requirement documents for the project.
• Designed new Universe and applied prompt and filters based on requirements.
• Creating canned and Ad-hoc reports for Management Team, Pricing Manager, Sales Forecasting and product planning department using Web Intelligence.
• Provided right to various users for different reports, Created folder and categories by using the Central Management control (CMC).

Environment: Business Objects XI 3.1, 4.0, InfoView, Oracle 10g, Microsoft Visio, Crystal Xcelsius, UNIX, MS Access, MS Excel, MS Project, MS Access, BW.

Confidential, Rose Land, NJ

Business Objects Developer

Responsibilities:

• Involved in all phases of translating business requirements into technical specifications including gathering, analyzing, documenting business requirements, and functional requirements and data specifications.
• Designed, developed and tested universes in Business Objects Enterprise environment.
• Worked on Actuate Migration project to convert the existing reports designed in Actuate software; recreated the reports using Web intelligence.
• Learned Actuate software in order to draw the data path for each report.
• Created new universes using the Universe Designer.
• Detected problems such as traps and loops in Universes and resolved such problems using aliases and contexts.
• Team Lead for Web Intelligence XIR3 report development and Universe design on top of BW cubes and queries.
• Created drill down reports and developed custom hierarchies.
• Created pixel perfect reports using Crystal Report XI.
• Worked on report bursting feature for dynamic distribution of the report in different locations and e-mail addresses.
• Published Desktop Intelligence reports to the repository for enterprise wide availability.
• In Central Management Console, created users, folders, groups and granted permissions according to the company requirements.
• Worked on Business Object 4.0 for testing reports.
• Updated the database as needed and refreshed the corporate documents using XI Scheduler in an automatic way.
• Provided training and training materials to the business users and reporting and analytics team.

Environment: Business Objects XI 3.1, 4.0, InfoView, Oracle 10g, Crystal Reports, Crystal Xcelsius, Scheduler, UNIX, MS Access, MS Excel, MS Project, MS Access, BW.

Confidential, New York, NY

IT Consultant

Responsibilities:

• Utilized BO for reporting and analysis of data.
• Used Import Wizard to Upgrade from BusinessObjects XI R2 to 3.1
• Responsible for end-user query and reporting supports end-user training and report / interface development.
• Monitored, tracked reports progress against project plan.
• Worked with business users to identify additional report requirements and document client requirements.
• Performed business analysis for Electronic Content Management, Membership Management, Events Management, and Accounting Management.
• Development and Deployment of Complex Reports. Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts.
• Worked extensively with (@select, @aggregate aware, @where, and @prompt) to overcome the problems with database when integrating with BusinessObjects.
• Created Templates for standardizing the Structure of our Corporate Documents.
• Worked extensively with the major functionality of BO like Breaks, Alerter, Filters, Sorts, Query Prompt and Drill filters.
• Created the Xcelsius Dashboards for the Monthly Operations Review Meeting presented to the Executive Team of Managers.
• Owned the only universe for the project.
• Created objects for utilization by other Developers
• Lead efforts to migrate three environments from XIR2 architecture to XI 3.1 using Import Wizard.
• Installed and set up Lifecycle manager.

Environment: Business Objects XIR2/ XI3.1 (Reporter, Designer, Supervisor), Crystal Reports, Xcelsius MS Access, MS Excel, Dashboard Manager, Info View, MS Project, MS Access, MS Excel, Windows 2000 Professional, Web Intelligence XIR2, Data Integrator, Oracle10g

Confidential, New York, NY

System Administrator

Responsibilities:

• Managed three different projects for a wide range of users - developed project plans, deliverables and guidelines.
• Worked on gathering business requirements interacting with the business analyst team.
• Created analysis and design documentation following Standard Operating Procedures (SOP).
• Administered security, universe, report domains and end-user privileges for departments in BO XIR2.
• Developed reports through Dashboard manager for end user interactive analysis of sales influencers.

Environment: Oracle 10g, Business Objects XIR2 in production and BusinessObjects XI 3.0 in development, Info View, Informatica.