SUMMARY:

• Visionary and innovative technologist seeking challenging position in the high - tech industry to make the most of my technical background, customer focus, creativity, passion, industry experience, and leadership skills
• Seeking position as Senior Confidential Developer which enables use of exceptional knowledge in Java, Hive, Pig and HBase to improve analytic systems and collaborate on program development
• As a Cloud Solutions consultant, I provide infrastructure services within private and public clouds as well as automation. I like uncharted territory and problems that are difficult to solve. Designed and built highly available, secure private AWS clouds.
• As an SAP HANA consultant, I provide services related data provisioning, data analysis, modelling, business logic, development, performance improvement and implementation.
• As an Business Intelligence Consultant, I provided services to build a data warehouse, ETL, Reporting, Dashboards, Reports, Cubes, etc. using Cognos, Business Objects, TM1, Tableau, Microsoft BI, etc.
• 16 years of industry experience, strong innovative and technical background
• 3+ years as Sr. Big Data Consultant with Analysis, Design and Development of Enterprise Grade Applications
• Experienced in building highly scalable Big Data solutions using Confidential and multiple distributions i.e., Cloudera, Horton works and NoSQL platforms(Flume, HBase, Cassandra, Couchbase and MongoDB.
• Strong Knowledge and development experience in Confidential and Big Data Ecosystem including MapReduce, HDFS, Hive, Pig, Spark, Cloudera Navigator, Mahout, HBase, Zookeeper, Kafka, Strom, Sqoop, Flume, Oozie and Impala
• 3+ years strong hands on experience on Confidential
• 5+ years deep dive experience with SAP HANA Technical Analysis, Estimation, Design, Modelling, Development & Implementation
• 4+ years of experience on planning tools like IBM Confidential using Architect, Performance Modeler, Turbo Integrator, Rules, etc.
• 3+ years of experience with Tableau designing interactive visualizations and dashboards
• 10+ years of IBM Confidential experience using the full suite to develop Reports, Cubes, Dashboards, Events, Alerts, etc.
• Real time experience in developing, debugging and tuning Map Reduce jobs in Confidential environment
• Ability to design and support development of a data platform for data processing (data ingestion and data transformation) and data repository using Big Data Technologies like Confidential stack including HDFS cluster, MapReduce, Spark, Scala, Hive and Impala
• Experience working with over a dozen different databases like HANA, Oracle, DB2 flavors, SQL server, Sybase, Teradata, Netezza, Informix, MySQL, Aurora, Dynamo DB, etc
• Experienced in building or administrating Confidential cluster with HDFS, Spark, Kafka, Zookeeper, Impala, Hive, YARN, Hue, Oozie
• Experience with Oozie Workflow Engine in running workflow jobs with actions that run Confidential Map Reduce and Pig jobs.
• Proficiency in UNIX/Linux fundamentals in relation to UNIX scripting and administration
• Working knowledge in Confidential HDFS Admin Shell commands.
• Experience in designing and developing Enterprise applications using Java/J2EE technologies on Confidential MapReduce, Hive, Pig, Sqoop, Flume, Oozie, Spark, J2EE tools & technologies like JDBC, Spring, struts, MVC, RAD, Hibernate, XML, JBoss, Apache Tomcat and IDEs tools Eclipse 3.0, My Eclipse, RAD
• Over 4+ years of experience working in Oil and Gas Industry in Upstream, Midstream and Downstream areas
• Diverse business experience like Oil & Gas, Hospitality, Manufacturing, Storage and Transportation, Utilities and Government, etc.
• Worked multiple hats like Lead, Architect, Designer, Modeler, Administrator, Developer, Implementer, Tester, etc.

TECHNICAL SKILLS:

AWS Cloud Technologies: IaaS, SaaS, PaaS, FaaS, EC2, EFS, S3, Glacier, Storage Gateway, RDS, Aurora, DynamoDB, MySQL, ElastiCache, Redshift, VPC, Cloudfront, Route53, CloudWatch, CloudFormation, TrustedAdvisor, IAM, EMR, SWF, SQS, SNS, SES, NoSQL, Docker, etcBig Data: HDFS, MapReduce, JavaAPI, JSP, JavaBean, Pig, Hive, Sqoop, Flume, Oozie, HBase, Kafka, Impala, Spark Streaming, Storm, Yarn, Eclipse, Spring, PL/SQL, Unix Shell Scripting, Cloudera

RDBMS/DBMS: SAP HANA, Oracle, SQL Server, Sybase, Teradata, Netezza, DB2, IBM AS400 ISeries, Informix, MySQL, MS Access.

Planning Tools: IBM Confidential V9.5, V9.5.2, V10.1.1, V10.2, Perspectives, Architect, Turbo Integrator, Rules, Tm1 in Worksheets and Excel VBA

BI Tools: Cognos Framework Manager 10/8.x/ReportNet, Report Studio 10//8.x/ReportNet, Query Studio, Business Insight, Dynamic Cube Designer, JavaScript in Reports, Cognos SDK, Active Reports, Cognos Impromptu 6.x/7.x, Analysis Studio, Metric Studio, Cognos Impromptu web reports 6.x/7.x (IWR), Cognos PowerPlay 6.x/7.x, PowerPlay Enterprise Server 7.0, Cognos PowerPlay Transformer 10/8.x/6.x/7.x, Cognos Scheduler 7.0, Cognos Connection 8.x/ReportNet, Cognos Upfront, PowerPlay web, Cognos Access Manager, Cognos Query, Cognos Visualize, Cognos Planning & TM1, Microsoft BI, SSIS

Operating Systems: Windows 7/XP/2000/NT/ 98/95/3.11/3.1, Win Server 2008/2003, MS-DOS, UNIX, Linux, and Novell NetWare

Programming: C/C++, Visual C++, Java, and VB. NET, SQL, PL/SQL, PHP, Python, SSH, Node.js

ERP: SAP, Oracle Apps, PeopleSoft, BPCS, and JDE

Miscellaneous: Lotus Notes, SharePoint, Harvest, Star team, Visual SourceSafe, Active Directory, LDAP, SSO (SingleSignOn), Quality Center, USD, Ms Visio, MS Office 95/97/2003/2007/2010, HyperV, VMWare, etc

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Responsible for building scalable distributed data solutions using Confidential .
• Performed performance tuning and troubleshooting of MapReduce jobs by analyzing and reviewing Confidential log files.
• Developed several custom User defined functions in Hive & Pig using Java
• Installed and configured Confidential Map reduce, HDFS, Cassandra and Developed multiple Map Reduce jobs in java for data cleaning and preprocessing.
• Collected the logs from the physical machines and the OpenStack controller and integrated into HDFS using Flume.
• Experience in running Confidential streaming jobs to process terabytes of xml format data.
• Configuring HIVE and Oozie to store metadata in Microsoft SQL Server.
• Experienced in migrating HiveQL into Impala to minimize query response time.
• Developing and running Map-Reduce jobs on YARN and Confidential clusters to produce daily and monthly reports as per user's need
• Used SparkAPI over HortonworksHadoopYARN to perform analytics on data in Hive.
• Experience on implementation of a log producer in Scala that watches for application logs, transform incremental log and sends them to a Kafkaand Zookeeper based log collection platform.
• Worked on Sequence files, RC files, Map side joins, bucketing, partitioning for Hive performance enhancement and storage improvement.
• Sqoop jobs, PIG and Hive scripts were created for data ingestion from relational databases to compare with historical data.
• Created HBase tables to load large sets of structured, semi-structured and unstructured data coming from UNIX, NoSQL and a variety of portfolios.
• Involved in submitting and tracking Map Reduce jobs using JobTracker.
• Used Pig as ETL tool to do transformations, event joins, filter and some pre-aggregations
• Implemented Hive Generic UDF's to implement business logic.
• Datasets will be loaded from two different sources like Oracle, MySQL to HDFS and Hive respectively on daily basis.
• Developed multiple MapReduce jobs in java for data cleaning and preprocessing.
• Experience in developing multiple MapReduce programs in java for data extraction, transformation and aggregation from multiple file formats including XML, JSON, CSV and other file formats.

Confidential

SAP HANA consultant

Responsibilities:

• Implement and manage continuous delivery systems and methodologies on AWS
• Understand, implement, and automate security controls, governance processes, and compliance validation
• Define and deploy monitoring, metrics, analysis and logging systems on AWS
• Implement systems that are highly available, scalable, and self-healing on the AWS platform
• Design, Manage, Monitor High Availability systems
• Design, manage, and maintain tools to automate operational processes
• Deploying, managing, and operating scalable, highly available, and fault tolerant systems on AWS
• Implement and Manage Disaster Recovery and Backups
• Migrating an existing on-premises application to AWS
• Implementing and controlling the flow of data to and from AWS
• Selecting the appropriate AWS service based on compute, data, or security requirements
• Identifying appropriate use of AWS operational best practices
• Estimating AWS usage costs and identifying operational cost control mechanisms
• Picking the right AWS services for the application
• Leveraging AWS SDKs to interact with AWS services from your application
• Writing code that optimizes performance of AWS services used by your application
• Code-level application security (IAM roles, credentials, encryption, etc.)
• Designing and deploying dynamically scalable, highly available, fault tolerant, and reliable applications on AWS
• Selecting appropriate AWS services to design and deploy an application based on given requirements
• Migrating complex, multi-tier applications on AWS
• Designing and deploying enterprise-wide scalable operations on AWS
• Implementing cost control strategies

Confidential

Responsibilities:

• Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support.
• Extensively worked on Data Provisioning in HANA using BOBJ, Sybase Replication Server, SLT, SMartData Access
• Extensively worked on SAP ECC as a source system for generating reports using BEx Query Designer.
• Report development on manufacturing modules and integration experience with FICO.
• Understanding the business challenges and translating them into requirements and developed Analytics and Reporting Queries according to Business Requirements.
• Worked extensively on Data Modeling design like creating complex calculation views, Analytical views, attribute views, decision tables, runtime aggregations, Info Objects, Info Cubes, DSO, MultiProviders, Info Sources, Info sets, Time dependent master data and also in ETL activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc.
• Created many complex and customized reports for specific business requirements and also involved in new features of SAP BI security like Analysis authorization.
• Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models.
• Cooperated with the Client's process teams in identifying and documenting necessary reporting requirements to build a reporting architecture.
• Build and enhanced BI objects that include Info Objects, Data Sources, Transformations, DTP, DSO, Info Cubes, Multi-providers, Info set and Open Hub.
• Integrated BO with SAP ECC and SAP BI 7.0 to build Universes.
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
• Hierarchies are implemented to support drill down reports.
• Customized queries using navigational attributes and filters in BEX analyzer and used customer exits as per client requirements.
• Designed report templates with BEX Analyzer and Web Analyzer using key figures, features, hierarchies, variables, properties, exceptions and conditions in the query definition.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies
• Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based)
• Involved working with content models, attributes and measures, hierarchies.
• Monitoring and troubleshooting data loads.
• Worked on RDS to implement ETL Replication and also using Rapid Marts for SAP road map

Confidential

Responsibilities:

• Built Strategic, Analytical and operational dashboards using Tableau and Xcelsius.
• Understood the business requirements document and Data model design document to come up with the Cognos model design.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Implementing best-practices for the dashboards with a solid understanding of the use of Contexts and their impact on performance.
• Develop Ad-hoc Business object reports according to user’s requests.
• Involvement in end-to-end activity of dashboard development from requirements gathering to deployment phase.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Confidential

Responsibilities:

• Conducted requirements review meetings
• Designed a high level master model in to map data flow with regard to different regions/vendors/products/crudes/chemicals/etc inbound and outbound
• Perform Installation & Configuration of IBM Confidential 10.1.1 in a distributed environment.
• Creating Dimensions & building cubes using TI Scripts.
• Written TI scripts to Import the data from Cognos Power Cubes and ODBC connection
• Created various elements, dimensions, cubes, TI Processes & Chores using TM1 Architect
• Maintaining TM1 Admin server
• Creating different TM1 servers serving different applications
• Architected the automatic migrations from Dev/Acc/Prod
• Regional TM1 instances created to avoid latency of work
• Create and Manage Replication across regional TM1 instances
• Providing and automated TM1 security model by importing the security model defined at Confidential .
• Creating Input Templates using TM1perspectives.
• Assessed complexity of change requests
• Mentoring Team, and Acting Liaison between Business & Technical World
• Writing scripts for TM1 Server automatic restart and automatic Backups.
• Write back TM1 data to relational database
• Adding TM1 users, Password resets etc
• Installing the TM1 Applications, Deploying the CUBES and DIMENSIONS

Confidential

Responsibilities:

• Created various reports such as List reports, Cross-Tab reports, Drill through Reports, chart reports, Active Reports, Dashboards, and reports with lot of conditional formatting using different tools
• Worked on DQM Frameworks and converting CQM to DQM
• Created a few Dynamic Cubes for some realtime data
• Created OLAP Cubes in Cognos Transformer, and analyzed the data using Cognos Power Play.
• Designed Models, created Dimensions & Levels in Transformer
• Triaged user acceptance and testing defects
• Working with Production issues, errors, anomalies, emergencies
• Integrated Confidential with Confidential to generate the reports based on TM1 Cube.
• Assisted users in troubleshooting their reports.
• Involved actively in training sessions and demonstrated use of Cognos tools to End-users
• Internationalization of Reports - Multilingual reports released to International properties
• Extensive use of Parameter Maps and dynamic labels and or queries to facilitate International output
• Created dimensions, levels and hierarchies.
• 2000 different reports sent out every hour to different departments at different properties
• Designed & Configured a dedicated dispatcher for this application to handle this kind of load
• Advanced routing done to send all requests to this dispatcher
• Creation of database objects like Tables, Views, Materialized Views, Indexes, Partitions, Stored Procedures etc
• Formulating the ETL mappings to implement the business logic.
• Role based Security in Framework Manager using Security Filters, and Cube Security in Custom Views in Transformer.