Summary

Sixteen years of experience in IT industry. Extensive experience in BI and Big Data Analytics. Excellent skills on Data Warehousing. Main focus is on Information Management and works primarily on Big data and analytics architecture using various tools like Hadoop, SPARK, Flume, No SQL, HP Vertica, Tableau, IBM Cognos BI FPM Suites and SAP Business Objects/SAP BI etc. Experience also includes Project/Program Management, Client Management, Strategic Planning, Technical Architecture and Infrastructure Architecture for Big Data and Business Intelligence Efforts

PROFESSIONAL EXPERTISE

• Designed the Solutions architecture for the Universal Analytical Platform for various clients.
• Managed Delivery of High visible projects under tight deadlines in BigData / BI environment.
• Managed Assessments, Strategic Planning, Defining Scope, Schedules, Architecture for BI Big Data Projects
• Proven experience in complete life cycle of Design, Implementation of Big Data / EDW
• Functional and Business Experience in Government, Supply Chain Management, Managed Health Care, Retail and Oil and Gas.
• Executed projects in Business Intelligence BI , Enterprise Data Warehousing EDW , Master Data Management MDM and Customer Data Integration CDI .
• Vendor Management, Client Management and Master Plan for High profile projects in the consulting industry.
• Provided BI Strategy and Road Map for Various clients
• Expert in providing solutions for Business Intelligence / Analytics.
• Strong experience in developing network based products.

Software:

SKILLS Languages: C, C , Java, VC 6, C , VB.Net, ASP.Net1.1/2.0

Big Data: Hadoop, Flume, Spark, Hive, Pig and HBase

Cognos Tools: Cognos SDK, Cognos mash up services, Impromptu, OLAP Technology, Cognos TM1, Metric Studio, Event Studio, Analysis Studio, Power Play Transformer, Power Play Enterprise Server, Access Manager, Cognos Upfront, Frame Work Manager, Architect, Cognos Office, Cognos Administrative Tools, Cognos Report Net, Cognos 8, Cognos 10.

MS BI Tools: SSRS, SSIS, SSAS and Power Pivot.

SAP Business Objects: Crystal Reports, Web Intelligence, Xcelsius, Universe.

RDBMS: Oracle 10g, Oracle 9i,Oracle 8.x, DB2, PL/SQL,Sybase, SQL Server 2000/2005/2008 Reporting Services, Analysis Services and HP Vertica.

Scripting Languages: VB Script, Java script, JQuery.

Methodologies: Windows Internals, MFC, Win32 SDK, Html, ASP, XML, Xlib, Motif

under X windows, TCP/IP Concepts, Socket Programming, Multi Threaded

Programming, Server Programming using IOCompletionPort.

Other: COM/DCOM, ATL, Data Ware House.

Work Experience

Role:

• Designed an Analytical Platform Strategy.
• Worked on integrating data from Message Queues, Standard Files and Change Data Capture System to HDFS and other Analytical Data bases.
• Worked on keeping versions of data in HBase and Vertica for point in time analysis.
• Developed various mechanisms to load HDFS data to Vertica.
• Prototyped Spark module to analyze real time ticketing and flight information data to generate alerts.
• Worked on Flume to integrate message queue data to DHFS and local file system.
• Integrated and analyzed HBase table using Hive.
• Analyzed data using Hive and Pig.

Role:

• Worked on building analytical platform with Hadoop and Vertica.
• Loaded data from HDFS to Vertica for analysis.
• Developed reports which use Cognos Mashup services to update DB.
• Converted Cognos reports which were using DB2 to use Vertica DB.
• Converted DB2 stored proc to cognos reports.
• Used JQuery heavily to make asynchronous call to update DB.
• Used JQuery to read the JSON format result from Cognos mash up service and updated the report.
• Developed SDK program in Java to validate user's authorization.
• Developed Java Servlets to download different types of files from DB. The files were stored in DB as BLOBS.
• Developed Java Servlets to upload files to DB.
• Deployed the application in IBM Websphere.
• Worked with the team to integrate jsp pages with in Cognos reports using iframe.
• Developed the model in FM.
• Developed complex reports involving Union of queries, repeaters and master detail relationship with in a list.

BI Architect

• Supply Chain Exception Reporting: The exception reporting DW is loaded with all the supply chain exceptions from Demand forecasting and Fulfillment. The Cognos reporting environment is integrated with JDA Supply Chain Software. The Exception based dashboards are key to drive the Walmart's business. The dash board shows all the key Alerts for different hierarchies. We handled 3 million SKUs.

Role:

• Developed Power Play cubes which loads exception data with all the hierarchies.
• Worked on a POC project in Hadoop Map Reduce to handle Exception Files.
• Developed drill through reports from Cube which shows the SKU level information.
• Developed 4 different types of dash board for all different kinds of exception.
• Implemented Security in FM level for planners to see their corresponding data.
• Played a key role in Dimensional Data modeling.
• Designed the FM models.
• Designed aggregate tables to handle large volume of data.
• Developed reports using DMR model.

Senior BI Architect

• T L Data Warehouse for Entergy. The environment was created as the Entergy Data Warehouse for Time and Labor. We are designing Cognos reports on Time and Labor and Absence Management. The source system was developed in PeopleSoft. I lead the report development effort.

Role:

• Currently serving as a technical lead on the project.
• Conducted business meeting to collect the requirement.
• Played a key role in Data modeling.
• Designed the FM models.
• Managing 3 offshore resources to deliver Cognos reports.
• TMI. . Discovery and Selection projects to build a strategic road map for the HR Data Warehouse systems. The scope was to investigate the current aging solution, engage the business, gather business requirements, gather solution requirements, and create the roadmap forward.

Role:

• Designed and developed Cognos Cubes using Query packages.
• Provided Drill through capability between Power Play Studio and Query studio. Provided a mechanism to pass parameters from Cube to Query.
• Designed and developed dash board reports.
• Regulatory Data Warehouse for Entergy. The Regulatory Accounting Reporting project will support the Regulatory Planning and Support department by providing them access to varying levels of financial detail to develop and support rate filings across an entire Legal Entity. The team used Peoplesoft, Informatica, Oracle and Cognos

.

• Role:
  • Created Query packages in Cognos FM.
  • Applied Role based security to query subjects.
  • This model was complex and had numerous tables.
  • Used determinants to deal with multiple facts.
  • Developed user friendly query packages which are further used by business community in query studio to develop queries.
  • Used Cognos Go office.
• Tax Data Warehouse for Entergy. This environment was created as the Enterprise Data Warehouse for Entergy for Tax Information across the enterprise. The team improved tax data accessibility by tracking and reporting core tax and financial data. The team used Peoplesoft, Informatica, Oracle and Cognos. I managed offshore team to deliver the Cognos System.

Role:

• Designed and developed Cognos solution.
• Managed an offshore cognos resource.
• Designed and developed lot of complex reports with drill through and drill down capabilities.
• Developed Event studio event which will send automated emails after the data load.
• Used KPIs to provide Metric studio solution.
• Applied Role based security to Power Play Cubes.
• Used Cognos SDK in .Net to send automated emails with reports to clients on a quarterly basis.
• Developed a .Net program using Cognos SDK API's to execute a report.
• Migration projects

Role:

• Migrated Cognos 7 objects to Cognos 8 using migration tools.
• Migrated Cognos report net objects to Cognos 8.
• Developed and prototyped multi server architecture for Cognos 8.

Confidential

Senior BI Consultant

• Developed BI reports in SQL Server 2005/2008 using reporting Services.
• Developed Complex Reports using MS Reporting Services 2005/2008
• Developed Reports with Custom Sort Order.
• Installed and configured Dev, test and Prod environment.
• Web Server and Report Server resides on one server and reporting server DB resides on DB server.
• Developed a custom .Net program to fire the reports as soon as the ETL jobs are done.
• Developed a report prototype using MS Info Path.
• Developed SSIS packages using BI studio.
• Developed ETL jobs DTS packages in MS SQL Server 2000 and migrated the same to SQL Server 2005.
• Worked as SharePoint 2.0 admin and extremely familiar with Document Libraries, Sub Sites and Web Parts.
• Developed modules using C .Net 3.0 ASP.Net 2.0.
• Built Web Services using C for AJAX controls.
• Mentored junior developers in OO .net principles, practices methodologies.

Confidential

Senior Software Developer

• Lead a team of 4 cognos developers.
• Applied security to Cognos reports. The cognos reports show data to user based on the user group they belong. The security was applied at Frame Work manager level.
• Converted some of the Cognos reports to Sql server using SRSS Reporting Services.
• Developed some prototype using Analysis Studio.
• Designed and developed Power Cubes. Migrated the Impromptu based IQDS to series 7 based IQDS.
• Migrated Architect based package to Series 7 Frame Work Manager model.
• Migrated Impromptu reports to Report Net.
• Modified the model in Frame work Manager to use different schema. The tables in old schemas were taking too much time to execute sql so created and optimized tables in different schema using ETL process. We modified the existing model to use the new schema.
• Created user classes in Access Manager using Macros.
• Developed complex reports which will burst everyday for different user groups.
• Tuned reports to reduce the execution time.
• Modified the existing reports to use new data source in addition to the old data source. Our business Process had to add a temporary data source and our existing reports had to show the numbers from both old and new data source. So modified the model in Frame Work manager to include new Data source and added new IQDS and made the Power Cubes to add numbers from both Data Sources. Modified the reports also to use both new and old Data Source.
• Developed dash board report.
• Developed a Java module using Cognos SDK which will trigger an event and execute the report.
• Developed Java module using Cognos SDK which will down load the report to the local hard disk and sends the report to different server using sftp protocol. This report was executed everyday.
• Worked extensively on Unix scripting which was used to build the cubes everyday.
• Development Lead in CMMI Level III.
• Pearson received IT Service Provider of the Year award for this project last year. The award was presented by Technology Association of Iowa. I was a key Player who helped Pearson to get this Award.

Confidential

Consultant

I

• Developed telnet client for Cisco router and Packet Shaper. The telnet has been implemented using win32Socket calls and C . Involved in the investigation and development of COM based telnet component. Developed test application to test the entire device DLLs. Simulated the PPI to test the entire device DLLs. Instead of console, this application gets all test cases from xml file. XML DTD has been written to test the validity of XML file. Xml parser has been written to parse the xml file. The xml file handles two cases like adding device and deploying policy to the device. It's a multithreaded application which takes care of synchronization.
• Explored the Load balancing and SSL acceleration features of Intel Load Balancers. Dealt with Intel 7110/7115 and 7180/7185. Worked in cryptography mechanism of importing and exporting certificates from serv er to Load Balancer.

Confidential

Software Engineer

• Designed and developed Java applet which receives display related data from Win32 server creates an image with that data and displays the image inside the applet. The Win32 server is a multithreaded application which communicates with the kernel mode driver and gets the display- related details and sends those details to the Java applet. The keyboard and mouse events are sent from Java applet to the Win32 server. The Win32 server receives those events and puts those messages into the system queue.
• Designed and developed XLIB module that sends the display output to a window on the UNIX machine. This module is developed by using Humming Bird's Exceed XDK. This user mode component is a multithreaded application. All synchronization objects are used for thread synchronization.
• Worked in memory leaks. Logged all the information regarding memory allocation and freed up by seeing the status of handles. Fixed many memory leaks.

Confidential

Programmer

• MFC based tool for producing hierarchy of classes used in an application.
• Useful for documentation. Maintained interlink between pages. Relationship between the classes was represented pictorially.