Big Data Solution Architect Resume
SUMMARY
- Senior IT consultant wif experience in Big Data technologies, relational databases and exposure to pre - sales functions
- Hands-on experience in setting up, evaluation and administration of Big Data technologies
- Develop & delivered several training sessions on Apache Hadoop administration to architects and administrators
- Vast experience in database administration / development, UNIX shell & Perl scripting, debugging in the areas of relational databases
- Well versed in all phases of the software development life cycle; developing stored procedures, triggers in Sybase environment; designing of logical and physical data models
- Proficient in customer engagement, relationship management, communication, problem resolution and team building
- Adept at analyzing, testing and implementing physical database design to support system requirements relative to database, analyze transactions and data volumes.
- Provide database technical administration and support, including processing change management requests, monitoring, performance tuning and database cloning.
- Provide periodic reviews of database performance and monitoring levels and take appropriate action to rectify problems. Strategize and plan performance enhancements and improvements
- Track record of conceptualizing and executing strategies to achieve key organizational targets
- High-level leadership and mentoring ability. Excellent interpersonal and communication skills
- Knowledge of international work cultures by virtue of overseas exposure in the US
- Completed ‘R Programming’, ‘The Data Scientists Toolbox’ and ‘Getting & Cleaning Data’ offered by John Hopkins University through coursera.org
- US Citizen wif 15+ years of work experience in the US
PROFESSIONAL EXPERIENCE
Confidential
Big Data Solution Architect
Responsibilities:
- Conduct research and competitive analysis associated wif new opportunities
- Understand client requirements documented in RFP’s
- Develop creative proposals and value propositions customized to meet the business objectives of clients
- Hardware estimation, effort estimation for proposals in the Telecom vertical
- Coordinate wif the finance teams on commercials
- Technologies used - Various distributions of Hadoop like Cloudera, HortonWorks
- Mentor and train a team of 10 offshore resources to provide 24/7/365 support to a US based client involved in the business of fleet management
- Act as a single point of contact to the customer for all day to day operations, issue resolution, change management, escalations etc.
- Technologies used - Sybase ASE, Replication Server
Confidential
Architect
Responsibilities:
- As part of automation initiatives, developed scripts to automate the installation and configuration of Hadoop on virtual machines theirby enabling the business users to focus on the business problems rather TEMPthan the complexities of setting up Hadoop. Later, extended the same to implement on Amazon EC2 cloud.
- Involved in the design & development of a POC for a leading insurance customer. The POC demonstrated actionable insights that can be generated from hitherto unused enterprise data sources (web logs) using Big Data technologies (Hadoop, Hive).
- Involved in a POC that demonstrated a reduction in the time taken to process the data by implementing the same process using Big Data technologies. A leading insurance customer of Wipro, runs a forecasting process on Informatica /Oracle 11g every month that takes close to 21 days to complete. Identified a module, developed Map/Reduce scripts that incorporated the business logic similar to the current process, generated data to scale and ran it on a 5 node Hadoop cluster. The logic involved aggregation, sorting, lookups etc. In the current process, the time taken was 13 hours and on the 5 node cluster the time recorded was 2 hours. Through dis proof of concept, successfully demonstrated that periodic, long running tasks can gain a lot of efficiency by exploring alternative mechanisms of processing and data stores such as Hadoop.
- Designed & deployed a solution to launch Hadoop clusters on the cloud using Apache Whirr, integrated wif monitoring solutions Nagios & Ganglia.
- Develop & deliver several training programs on Big Data technologies to internal teams
- Currently working for a client of Confidential that is a world leader in the exploration and drilling of Oil & Natural gas. The client currently TEMPhas 18+ Tb of time series data that cannot be stored & queried in a traditional RDBMS and are now exploring various possibilities in the Big Data space to migrate.
- Technologies used - Apache Hadoop, HBase, Pig, Hive, Solr, Sqoop, Whirr, Mongodb, CDH 5.x, HortonWorks 2.x, Phoenix, OpenTSDB, KairosDB, R
- Develop creative proposals and value propositions customized to meet the business objectives of clients
- Coordinate wif the finance teams on commercials
- Conduct onsite due diligence sessions
- Tower resource competency building wif prime focus on recruitment and resourcing, account visits and direct interaction wif engineers.
- Managing client visits across different locations ensuring customer / prospect visit objectives are met
- Maintain the Knowledge Repository and the reusable required for developing solutions
- Liaison wif Delivery Managers for preparing, updating and maintaining case studies of the existing/ completed engagements
- Evaluation of new tools & technologies as part of an initiative to introduce new service lines besides being involved in presentation walk through wif the customer. As part of dis activity, was involved in evaluation of a tool that migrates closed sources databases (Oracle, MS-SQL etc.) to open source database (MySQL)
- Transitioned database operations from a major bank in Tokyo, Japan to Pune, India; led a team of 8 DBAs on various database technologies besides functioning as a single point of contact for the client on transition issues.
- Involved in understanding & documentation of database administration processes, procedures & reports; coordinated and tested connectivity & infrastructure readiness between offshore & onsite locations.
- Coordinated escalations.
- Technology used - Sun OS, Sybase 12.5.x, Replication Server 12.5.x, Oracle 10g & MS-SQL 2005.
Database Technical Manager/ Team Lead
CONFIDENTIAL
Responsibilities:
- Functioned as Technical Manager/ Team Lead for a major US based investment bank providing support 24x7x365 for about 250 ASE servers in the European region through a team of 8 members.
- Developed scripts in Shell & Perl to analyze historical data and generate information on noisy servers, frequency and other related factors.
- Implemented standard operating procedures for various day-to-day activities & resolution of common errors as part of service improvement plans.
- Managed escalations, provided technical solutions/ support to the team, conducted regular team meetings on information sharing, conflict resolution, progress and status updates.
- Ensured optimum utilization of resources through distribution of workload besides being involved in evaluation & appraisal of team members.
- Conducted interview and evaluated new team for the support phase.
- Technology used - Sun OS, Sybase 12.5.x and Replication Server 12.5.x.
- Functioned in a heterogeneous environment ranging from mainframes running DB2, middleware systems running Sybase, Oracle and UDB to NT servers running SQL Server across seven geographic locations for a major healthcare organization.
- Accountable for keeping the OLTP and DSS production servers online and available in a Sybase environment as database administrator and part of the Georgia Database Services team apart from keeping the source (DB2) and destination (Sybase) systems in a replication environment in sync and resolving any issues.
- Developed scripts and implemented SQL BackTrack for daily and weekly backups; performed upgrades and applied emergency bug fixes (EBFs) to production and test servers and monitored tools like BMC Patrol and SmartDBA on a regular basis for resolution of performance issues.
- Migrated servers from HP platforms to AIX platforms during switchover and acquired knowledge on Oracle 8i.
- Involved in migration of 2 projects involving Oracle instances and a disaster recovery project for all Oracle based systems in the Georgia region.
- Focused on testing & evaluation of new database backup & recovery and performance monitoring tools apart from managing day to day DBA activities.
- Technology used - AIX, Sybase 12.5, Replication Server 12.5, Oracle 8i/10g, Perl.
Confidential, NC
Job Profile: Database Administrator
Responsibilities:
- Ensured synchronization of existing model wif the physical database prior to weekly database build for resolution of conflicting issues.
- Resolved normalization anomalies on addition of new tables by developers and provided inputs to improve performance of stored procedures and triggers.
- Configured new servers and migrated databases across servers based on requirements; developed and implemented a parsing tool using Perl 5.0 to extract relevant sections of code from stored procedures, triggers, views and Powerbuilder libraries to improve performance of queries.
- Developed numerous scripts in the korn shell to perform tasks like consistency checks on databases, update statistics on heavily used tables and performance of routine database dumps.
- Technology used - SunOS, Sybase 11.9.2, Perl, ERWin, DBArtisan.
- Involved in understanding of requirements and development of data model to capture information pertaining to all stages of a well development from prospecting to drilling (The database served as a repository of ‘Lessons Learned’, ‘Best Practices’, ’Standard Procedures’ etc. based on real life experiences of rig personnel).
- Technology used - SunOS, Sybase 11.5.1, ERWin, DBArtisan.
Confidential, Englewood, CO
System Engineer
Responsibilities:
- Involved in design, development and testing of scripts using Sybase stored procedures; interacted wif end users for requirements, coded stored procedures and monitored performance & enhancements including enhancements.
- Developed over 100 reports ranging from customer information to installed hardware at service locations; ensured availability of data in the system through replication from SummitTrak database.
- Technology used - Sun Sparc 5, Sun OS, Sybase System 10 and Perl.
- Involved in design & development of module to be used by the telephony division to provide customer service representatives wif all information pertaining to billing & provide them wif tools to make adjustments etc., in an online environment.
- Designed the detail specification documents for developers to code stored procedures & triggers at an offshore site besides guiding developers pertaining to data model, performance & business logic.
- Led a team of 3 and focused on installation of Sybase SQL server including hard disk partitions, coding, design of user input screens and testing.
- Used SQR report writer for critical batch processes and to generate reports.
- Set up users, groups and privileges post development of system.
- Technology used - HP 817S, HP-UX, Sybase System 4.9, Accell (IDE).
TECHNICAL SKILLS
Big Data Technologies: Hadoop, Pig, Hive, Sqoop, Impala, Phoenix
Cluster Management Tools: pdsh, Puppet
Operating System: Red Hat, CentOS, Ubuntu, AIX, Sun OS, HP-UX
RDBMS: Sybase, Oracle, SQL Server
Replication: Sybase Replication Server
Mainframe Connectivity: DirectConnect
Monitoring Tools: Nagios, Ganglia, Munin, BMC Patrol, SmartDBA
Back up & Recovery: SQL BackTrack, native tools
Modeling Tools: ERWin
GUI Tools for DBA: DBArtisan
UNIX Tools: Perl, awk, shell scripts
Report Writers: SQR, RPT