SUMMARY

• 15+ years of experience in end to end Data Warehousing, Business Intelligence, Big Data, Hadoop, Decision Science, Reporting and ETL in OLAP Applications using Informatica, SAP Business Objects, Tableau, Java, JSP, AJAX, .net, Oracle, SQL Server, HP Vertica, Cassandra, Pentaho.
• Expertise in Data modeling, architecting and developing highly optimized data warehousing solutions.
• Architected and developed a federated enterprise self - service reporting tool with web technologies
• SAP BO SDKs, Informatica, IBM Datastage, Web Services, Oracle, IBM DB2 and IBM Cognos
• Automated manual reports using PERL, UNIX shell scripts, SQL Loaders and Webfocus.
• Expertise in developing mappings, sessions and workflows using Informatica Power Center.
• Expertise in UNIX/ Linux Shell Scripting and Commands.
• Expertise in creating Reports using Webfocus, IBM Cognos and Tableau.
• Expertise in Dimensional Modeling, Star Schemas Snowflake Schemas in Oracle and Database design and HP Vertica.
• Experience in integration of data sources like Oracle, SQL Server, Teradata and Flat Files.
• Good expertise in Advanced BI Architecture using Hadoop, Cassandra and Pentaho. Very good knowledge in Hadoop and its eco systems.
• Experienced in Installing and configuring Hadoop cluster using Cloudera, HortonWorks, & DataStax.
• Experienced in Installing and configuring Hadoop nodes/ JasperSoft in Amazon Web Services (AWS) and configuring DNS, public domains using Elastic IP and Route 53.
• Experienced in Digital Optimization and Analytics using Pega 7 and Apache Mahout, Hadoop, Spark and KIJI (WIBI Data)
• Experienced in Tag Management and Clickstream data collection using Tealium IQ and Tealium AudienceStream.
• 6+ years experienced in client interaction, offshore team management, business requirement gathering, implementation and delivery management.
• Good communication, inter-personal, analytical and business analysis skills.
• Good problem solving, self-learning ability and can adapt to new environments quickly.
• Proactive and zeal to learn New Technologies and Tools.

TECHNICAL SKILLS

ETL Tools: IBM Datastage, Informatica- 6.1/7.1/8.5. Pentaho

OLAP Tools: Webfocus, SAP Business Objects-XI 3.1/4.1, IBM Cognos 6 - 10.2, Tableau, High Chart, D3 Charts, JasperSoft

Languages: C, C++, Java, JSP, AJAX, JavaScript, SQL, PL/SQL, Visual Basics, ASP, Dojo Framework, Unix Shell Scripting, MS SharePoint.

Databases: Oracle8i/9i, 10g, 11i, 12c, SQL Server 2005, Cassandra, HP Vertica, MS-Access

Big Data: Hadoop 1.3/2.0, Hadoop Ecosystems Pig/Hive/Sqoop/Hbase/MapReduce, KIJI

PROFESSIONAL EXPERIENCE

Confidential

Digital Optimization and Analytics

Responsibilities:

• Senior Technical Consultant (Architecting Big Data open source solution)
• Modeled and built the POC recommendation platform using Hbase, KIJI in AWS
• Defining metadata layer and collecting click stream data using Tealium Audiencestream.
• Analyzing the clickstream data in Hadoop and make the best recommendation (REST Service to Website) as per business rule.
• Using Pega 7 Cloud environment to build recommendation business rules

Environment: Hadoop (HP Vertica), Pig & Hive, Sqoop, Hbase, KIJI, WIBI Data, Adobe Target, Tealium Audience Stream and Tealium IQ, WebTrends.

Confidential

BI Architect / Lead

Responsibilities:

• Design and development of business intelligence solutions, including data integration (ETL), reports, dashboards, and defined semantic layers and metadata repositories to support Ad- hoc reporting and administration.
• Modeled and built the Business Intelligence module from the scratch.
• Consumed JasperSoft functionalities from a web platform using JSP and Web Services
• Maintained the Hadoop warehouse and loaded the enterprise wide infrastructure, healthcare, Insurance, internal application and various datasources.
• Hosted, deployed and maintained the application in AWS Cloud Environment

Environment: adoop(HortonWorks), Pig & Hive, sqoop, Hbase, Hadoop Eco Systems, MYSQL, JasperSoft, Unix Shell scripting, JSP, Java, HP Vertica.

Confidential

BI Architect / Lead

Responsibilities:

• Understanding the Design documentation specifications for loading the data into the Omni warehouse.
• Extensively worked on IBM Datastage and TWS Scheduler to load the data.
• Used Source analyzer to Import the source definition from Oracle and flat files.
• Used Warehouse designer to import the target definition.
• Created Mappings based on Business Rules to load data using various transformations like Source Qualifier, Aggregator, Sorter, Expression, Joiner, Lookup, Filter, Sequence Generator and Update strategy.
• Created Sessions and Workflows using the Workflow Manager.
• Developed Test cases and tested the mappings and sessions.
• Actively participated in doing the Major / small / Emergency Projects that come as an enhancement.
• Created Webfocus Fex code templates, Manual Fex files.
• Created Rich GUI using JSP and AJAX to bring Webfocus Content & Chart Creation to users.

Environment: ETM, Oracle 11g, IBM Datastage, Cognos Suites 10.1, AIX

Confidential

BI Architect / Lead

Responsibilities:

• Designed, Developed (canned reports and Management Cubes) and Implemented best practices in Ohio SACWIS project.
• Designed and Developed Framework Manager Model and Reports
• Installation and Configuration Series 7 (Power play Server, Upfront Data Store, Upfront Server, Impromptu Server, PP Gateway, Upfront Gateway, Impromptu Gateway)
• Installation and upgrades of Cognos applications across multiple environments (8.1.2 MR1, 8.1.2 MR2 and 8.3)
• Administering Cognos environment for issues, bug fixes and patches
• Implemented Cognos Audit Systems into entire environment (Turned on some service from Minimal Logging Level to Request Level)
• Involved Reports Performance Tuning
• Package Promotion from Development environment to Other environment

Environment: Oracle 9i, Informatica Power center and Workflow Monitor and Cognos 8

BI Architect / Lead

Confidential, CT

Responsibilities:

• Installed Cognos suite 8.1.1 MR1
• Designed and Developed Framework Manager Model and Reports
• Implemented and configured LDAP and Access manager
• Dealt with several Objectives, strategies and resources
• Setup and maintained user ids, passwords and user classes
• Administering Cognos environment for issues, bug fixes and patches
• Worked directly with Cognos on debugging efforts and trouble tickets
• Involved in Reports Performance Tuning

Environment: Oracle 9i, IBM Datastage and Cognos 8

Confidential

BI Lead

Responsibilities:

• Responsible for the overall architecture for a security reporting Data Mart in Oracle 10g.
• Designed and Developed Framework Manager Model
• Migrated reports from earlier versions to Cognos 8.1.2 MR2 (8.1.209.25 )
• Involved in the design and development of CRN reports in Report Studio.
• Published report sets and cubes on all Cognos web environments
• Involved Reports Performance Tuning
• Involved in testing of reports with the existing live data via VPN.
• Migrated applications Cognos 7 to Cognos 8
• Designed the Framework Manager Model with all the necessary joins, filters and calculations for all 33 reports
• Created Security at Framework Manager level for accessing different products at login level

Environment: Oracle 9i, Informatica-7.1 and Cognos 8

Confidential

BI Developer

Responsibilities:

• Understanding the Design documentation specifications for loading the data into the warehouse
• Extensively worked on IBM Datastage, Informatica Power center tools such as Power center Designer, Workflow Manager and Workflow Monitor.
• Used Source analyzer to Import the data from Oracle and flat files.
• Used Warehouse designer to import the target definition.
• Created Excel Macro Template to Create the Charts for IBDs
• Linked in Word Document in the prescribed format. Creating PDF using PDF Writer
• Data Extraction from various sources typically from flat file to Relation Database
• Wrote simple and complex SQL statements keeping in view the constraints and dependencies issues.
• Involved in database development and also part of Attributes/tables mapping team from previous database system to new database system
• Involved in Designing the Data warehouse and Data Marts.
• Database performance tuning and troubleshooting & fixing problems faced by application developer

Environment: Oracle 8i, 9i, IBM Datastage, Erwin, Power Designer, Power builder, Informatica-7.1 and MS Excel, MS Word.