Senior Systems Engineer (big Data) Resume
SUMMARY:
- Design, build, manage and recommend Big Data solutions
- A collaborative engineering professional with extensive experience in designing, recommending and executing solutions for complex business problems involvinglarge scale data warehousing, real - time analytics and reporting solutions.
- Known for using the right tools and creating an intuitive architecture that helps organizations effectively analyze and process petabytes of structured, semi-structured and unstructured data.
- Played an important role in selling a multi million dollar deal to a large travel company.
- Presented and conducted workshops and mentored several junior engineers.
- Proven history of building large-scale data processing systems and serving as an expert in data warehousing solutions while working with a variety of database technologies. Experience in architecting highly scalable, distributed systems as well as designing and optimizing large, multi-terabyte to petabyte scale MPP systems. Able to integrate state-of-the-art Big Data technologies into the overall architecture.
SKILLS:
Databases and Tools: Oracle, SQL Server, Confidential, IDOL, DB2, HANA, and Teradata.
Data Analysis: Consulted with business partners and made recommendations to improve the effectiveness of Big Data systems, descriptive analytics systems, and prescriptive analytics systems. Integrated new tools and developed technology frameworks/prototypes to accelerate the data integration process and empower the deployment of predictive analytics in near realtime. Working knowledge of machine learning and/or predictive modeling.
Tools: Hive, Pig and Hadoop Streaming, MapReduce, R, Distributed R.
Data Transformation: Experience in analyzing, designing, reviewing, implementing and optimizing data transformation processes. Able to consolidate, validate and cleanse data from a vast range of sources from applications and databases to files and consume them for analysis.
Data Collection: Capable of extracting data from an existing database, Web sources or APIs. Experience designing and implementing fast and efficient data acquisition using Big Data processing techniques and tools.
PROFESSIONAL EXPERIENCE:
Confidential
Senior Systems Engineer (Big Data)
Responsibilities:
- Developed a very high prospect base in the Oil and Gas sector over the last two years by analyzing business needs, collaborating with stakeholders and working with partners.
- Successfully lead several workshops for intra company personnel, partners, customers and prospects.
- Assisted Sales team closely with technical meetings and presentations.
- Work closely with the prospect to study and gather details to gain the business and make them a customer by selling the solution.
- Gather details and get the prospect to a POC stage if necessary to prove the solution is the right one both technically and financially.
- Conduct lunch and learn sessions for potential prospects.
- Demonstrated the integration of Hadoop with Confidential and several other technologies like Spark, Hive and social media.
- Designed and developed a Big Data analytics platform solution to consume 100% of the Oil and Gas sector data for processing and doing near realtime analytics at the well site for well placement and drilling operations.
- Demonstrated the loading of a huge data set into a columnar database for reporting, dash boarding and ad-hoc analyses, which revealed ways to lower operating costs and offset the rising cost of programming.
Confidential, Chandler, AZ
Sr Oracle Applications Consultant
Responsibilities:
- Study and gather details to implement a Solution to integrate several systems to Oracle EBS R12.
- Design the interfaces required for various operating systems to talk to Oracle EBS R12.
- Responsible for developing the interfaces.
Confidential, Seatle, WA
ORACLE MDM Consultant
Responsibilities:
- Installed SIEBEL UCM for managing Customer Data Hub (CDH) on LINUX.
- Responsible for helping team members on all ORACLE related issues.
Confidential, Saginaw, MI
ORACLE Data Migration Workstream Lead - SAP Implementation
Responsibilities:
- Responsible for mapping data from Oracle to SAP for the migration project using MDM techniques from multiple data sources including manual data generation.
- Responsibilities include analyzing the data and provide solution.
- Manage the data extraction process done by Danaher team by providing solution.
- Ensure data meets the standards required by SAP adhering to MDM best practices.
- Write scripts to enrich data that were not available in ORACLE but required by SAP.
- Involved in post go live support and data validation in SAP.
Confidential, Arlington, TX
Sr Oracle Applications Developer
Responsibilities:
- Design and Develop custom reports for the company
- Manage the daily processes and reports in concurrent manager.
- Responsible to support all the users for the whole company with their requests in all the Oracle modules.
- Write custom scripts for loading data for new acquisitions and manage data
- Help in loading data in ESSBASE and reporting areas.
- Coordinate and manage an offshore team for support related issues.
- Help in the integration of new B2B customer with the company.
- Write interfaces and reports for EDI and other business related processes.
- Help in customizing the reports for the upper management and executives.
Confidential, Dallas, TX
Oracle Architect
Responsibilities:
- Study and gather details to implement an ERP Solution for the group.
- Decide in the hardware and software components and suggest a solution.
- Lead the team and help them setup a centralized data centre for the group.
- Implementation of LYCEUM and customization.
- Help in customizing the reports to the management and executives.
Confidential, Richardson, TX
Oracle Architect
Responsibilities:
- Design and develop an EDI interface system between ISTHA and other third party agencies to collect toll through an automated system.
- Manage the daily feeds and make sure the revenues billed and collected are in balance.
- Tune queries which are performing bad in the system
- Develop triggers, procedures, functions and packages.
- Develop custom PL/SQL scripts, FORMS and REPORTS.
- Wrote scripts to generate dynamic SQL.
- Used Bulk operations in scripts.
Confidential, Dallas, TX
Oracle Architect
Responsibilities:
- Write custom scripts to migrate data from a legacy system using PL/SQL.
- Development of custom PL/SQL reports after migration.
- Helped in integrating the data using Informatica.
- Tune queries and rewrite code to make them reusable and manageable.
- Created indexes as part of tuning.
- Extensively created B-Tree and Bitmap indexes.
- Generate reports for upper management to aid them in making time critical decisions.
Confidential, Washington, DC
Oracle Consultant
Responsibilities:
- Analysis, design and development of scripts.
- Oracle E-Business Suite. Wrote scripts to use API calls to interface with the legacy system and developed custom forms.
- Write custom scripts for the consolidation of 3 agencies data into the consolidated Sunflower Instance.
- Development of custom PL/SQL reports
- Wrote UNIX shell scripts for data load and other operations.
Confidential, Dallas, TX
Oracle Consultant
Responsibilities:
- Rewrite a custom financial application.
- Responsibilities include mentoring and leading a team of developers.
- Ensure that standards are maintained in the rewrite.
- Develop new packages and triggers which would be used in the .NET application.
Confidential, Idaho Falls
Oracle Consultant
Responsibilities:
- Install and configure Oracle 10g Release 2 on Red Hat EL4.
- Install and configure Oracle Application Server Release 2 on Red Hat EL4.
- Install and configure Sunflower Assets Version 4.5 on Red Hat EL4.
Confidential, Washington, DC
Oracle Consultant
Responsibilities:
- Write custom PL/SQL scripts for data validation.
- Development of custom PL/SQL reports.
Confidential, Birmingham, AL
Oracle Consultant
Responsibilities:
- Design and development of custom packages in Sunflower Application and write code to interface with Oracle Applications using PL/SQL.
- Oracle E-Business Suite. Wrote scripts to use API calls to interface with the legacy system and developed custom forms and integrate data using Informatica.
- Development of custom PL/SQL reports.
Confidential, Washington, DC
Oracle Consultant
Responsibilities:
- Write custom PL/SQL scripts for the consolidation of 2 Sunflower instances.
- Oracle E-Business Suite. Wrote scripts to use API calls to interface with the legacy system and developed custom forms.
- Development of custom PL/SQL reports.
Confidential, Dallas, TX
Oracle Consultant
Responsibilities:
- Data Maintenance, Oracle reporting and Improved performance of a bottleneck report significantly.
- Performance tuning of existing PL/SQL reports, packages and queries.
Confidential, TX
Oracle Consultant
Responsibilities:
- Developed interface programs to load data into temporary tables using PL/SQL and SQL in Oracle EBusiness Suite.
- Design and develop custom packages for an Oracle Portal 10g.
- Designed the portal database using Designer.
- Involved in the development of an interface for the credit card processing system.
- Designed web enabled reports using HTML and ASP.
- Developed custom forms, reports and packages.
- Wrote interfaces to load data from legacy systems into Oracle Applications AP, AR, PO and INV modules.
- Used Direct-path and conventional loading techniques.
- Installed and configured Oracle Collaboration Suite R2 running on dual Intel x86 Xeon 3.06 processors single box Linux AS 2.1.
Confidential, Dallas, TX
Oracle Consultant
Responsibilities:
- Developed and Implemented Custom Application.
- Data Maintenance, reporting and Improved performance of a bottleneck report.
- Adopted and trained to use modular coding techniques to simplify development process and maintenance.
- Developed Web enabled forms, reports and packages to transmit data to outside vendor in XML.
- Developed enhanced reports which helped in strategic planning and decision making for executives.
- Design, development, testing and implementation of legacy Eagle Scout system.
- ETL processing from a legacy Micro Focus system using PL/SQL, SQL Loader.
- Performance tuning of existing reports and queries and train staff on development and tuning.
Confidential, Dallas, TX
Oracle Consultant
Responsibilities:
- Designed, developed, tested and implemented a Web enabled Order Entry system.
- Oracle E-Business Suite. Developed programs to load data from intermediate tables to interface tables.
- Unit Testing of the conversion/interface programs.
- Developed application to print complex commission checks using Reports 6i.
- Developed Reports Server and implemented a queuing mechanism to run or submit predefined reports.
- Mentored junior developers and assisted the development team technically in design, development and tuning.
- Developed validation procedures and error reporting on the data in the intermediate tables for interfacing.
