SUMMARY

• Technically strong and business - savvy technology professional with over 14 years of experience in providing data solutions to large and mid-sized organizations including 4 years of experience as Big Data solution architect .
• I have developed and solution architected Big Data technologies for data ingestion and real time analytics .
• Leading the architecture of different big data technologies like Apache Kafka, Apache Spark, Hive, Map Reduce, PIG, Hbase
• Developed data pipelines for Data Science users . Helped business in evolving modern methods for data preparation.
• Hands on experience with big data tools such as Hive, Sqoop, HBase, Apache Spark, Apache Nifi and Apache Kafka.
• Developed and Architected Apache Kafka to use the service as enterprise data bus and utilized it for big data consumption, pushed the data in real time as events to build the real time reporting and analytics. Data bus was designed to consume data from variety of data sources.
• Architected the project to migrate the data from current ODS to big data lake, also used the current infrastructure of Informatica to transfer the data from ODS to data lake.
• Leading the hands on development and architecture for the Big Data Lake infrastructure which would be the central hub for housing all source data including key master data at the lowest grain and highest frequency possible.
• Worked with Amazon S3 data files to bring it to the Cox’s HDFS environment.
• Working knowledge of AWS and cloud related technologies.
• Hands on experience in configuring and implementing Hortonworks big data environment using AWS
• Over the years, architected and lead various engagements around delivering Business Intelligence & Data Warehousing solutions, formulation of data warehouse/database Architecture Strategy, Offshore Development Strategy, Strong consulting background equipped with architecture and project management experience and the ability to lead initiatives that enable strategic business capabilities through technology solutions.
• Currently leading the enterprise re architecture project for the EDW for efficient processing of the data.
• Managed and architected BI environments in Finance, Mobile Commerce, Insurance, Manufacturing and Entertainment industries.
• Delivered BI projects efficiently using both Agile and Waterfall methodologies.
• Architected and designed BI environments using different data warehouse methodologies.
• Vast experience with setting up business intelligence tools, corporate metrics and analytical standards.
• Worked with business users constantly and converted their requirements into analytics, dashboards and reports.
• Hands on experience with the reporting and ETL tools like Cognos BI 10.1, Qlikview, Informatica.
• Built Enterprise data warehouse using Netezza
• Architecture, design and development experience using Cognos series (Framework Manager Modeling, Report Studio, Transformer, Business Insight )
• Architected qlikview environment and developed corporate dashboards using Qlikview 10/11 series
• Developed simple to complicated ETL mappings using Informatica.
• Designed data warehouse and helped data modelers in developing data models for the data warehouse.
• Hands on experience with different data warehouse methodologies like Kimball, Inmon and Hybrid methods.

TECHNICAL SKILLS

Architecture: Big Data Hadoop, HDFS, Data warehouse, BI environments, Analytics

HDFS: Hive, Pig, Ambari, Sqoop, Hbase, Spark

BI Tools: Cognos BI series 7-10.1, Qlikview 10/11, OBIEE

ETL: Informatica 6-9 Series, Data Manger, Qlikview

Database: Oracle 8 /10i/ 11g, DB2,PL/SQL Programming

Project Management: Saleforce, MS Project

Data Modeling Tools: Cognos Framework Manager, Irvine

Microsoft: MS Access, MS Excel, MS Word,, MS Power Point, Visio

Certification: Certified Cognos Product Developer

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Data Architect

Responsibilities:

• Presently leading the data modernization effort in Confidential . Worked with business on day today basis to give them insight into the new technology’s and capabilities .
• Leading the effort in helping data science COE, helping data scientists in data prepation for predictive analytics and machine learning.
• Architected live streaming of API data using Apache Nifi and Kafka . This API basically streams the customers live chat with call center agents.
• Presently leading the Data Architecture & Platforms function at COX communication that entails leadership responsibility for envisioning, planning, build & deployment of enterprise data and analytics capabilities.
• Worked hands on in big data technologies (sqoop, hive, hbase) for the different kind of projects related to large data movement.
• Worked closely with production operation team to build different big data migration processes and better coding practices for HDFS environment.
• Worked with the business stakeholders to bring awareness about big data technologies to get the investment from business so that it benefits the organization.
• Leading the architecture and build out of the Big Data Lake infrastructure which would be the central hub for housing all source data and key master data at the lowest grain and highest frequency possible.
• Implemented BI functions using an Agile delivery methodology.
• Built good relationships with sales operations team and streamlined the process related bottle necks.
• Managed the project to Automate data quality checks so that source related data issues and processes can be fixed.
• Architected and designed multiple BI projects for Cox residential customer data .
• Architected and designed a warehouse for Sales Analytics.
• Managed the projects by directly working with offshore technical developers.
• Managed and Architected performance related projects for huge volume of data.
• Did lots of research on current EBI BI environment and focusing on how it can be made more business friendly and process oriented.
• Helped the team in Cox Business BI solutions.

Confidential, Atlanta, GA

Sr. Data Architect Consultant(BI Solution Delivery

Responsibilities:

• Designed data warehouse summary layer in star schema for structured and organized reporting.
• Architected reporting and analytical environments for deposits data.
• Providing strategic insight into the process oriented BI Development.
• Architected and designed Qlikview/Cognos BI development environment for Deposits.
• Performance tuned data warehouse and reporting environment for very large set of data.

Confidential, Atlanta, GA

BI Architect/Delivery Manager

Responsibilities

• Architected Cognos, Qlikview 10/11 and ETL environment for the report development.
• Managing the reporting team for analyzing mobile banking/ mobile commerce application market.
• Designed and developed corporate dashboards using Qlikview.
• Designed data warehouse and managed ETL environments.
• Developed ETL mappings using Informatica.
• Implemented incremental loading using Qlikview QVD files.
• Directing BI developers for implementing quality processes and also delivering BI products in timely manner.
• Framework Manager modeling using Cognos and development of complicated reports/analytics using Cognos products
• Over 4 years of experience in analyzing business for Mobile commerce/Mobile Wallet and smart phone application market.
• Defined all the corporate metrics, worked constantly with product managers in defining KPI’s for the business
• Responsible for summary report for executive management with every day’s transaction.
• Responsible for data warehouse design for reporting purpose.
• Responsible for unlocking the hidden data and helping the management in finding innovative ways for revenue.
• Complete understanding of mobile commerce and mobile wallet application market.
• Analyzing iPhone and Android users for mobile wallet applications.
• Analyzing smart phone users revenue for mobile banking.
• Leading billing project for mobile banking revenue.
• Working with business users regarding business data.
• Delivering reports and data to users in a timely manner.
• Helping users with ad - hoc reporting requests.
• Working constantly with users regarding data issues and concern.
• Responsible for delivering quality data to the users.
• Contributing to the team in designing and developing Cognos portal to users.
• Advising team with new and innovative ways of developing Cognos reports.
• Gathering requirement and analyzing data for reports and cognos portal design.
• Helping team with UAT of data mart tables and reports.

Environment: Informatica 9 Series, Cognos BI 10, Oracle 11g, Qlikview10/11, Windows 7

Confidential, Winston Salem, NC

Sr. BI Architect/Developer.

Responsibilities:

• Worked with business users and delivered good analytics for taking business decision.
• Involved in designing Cognos business portals for Sales and Marketing division.
• Involved in architecting and designing BI environment.
• Worked with metric studio for score carding using Cognos8.2
• Worked with Cognos 8BI Administration and Migration of reports from Reportnet1.1MR2
• Involved in setting up standard testing procedures for all BI portals.
• Expertise in Cognos Enterprise Suite including Cognos BI (10.0/8.3/8.1/8.2/8.3), ReportNet Reports and Cognos 8/10 BI Administration
• Involved in financial reporting for accounting department.
• Designed power cubes by using multiple IQD approach.
• Responsible for complex report studio report according to user requirement.
• Constantly involved with business users to bring value for the Cognos BI.
• Supported all major previously designed cogon’s reports.
• Responsible for testing business portals using complex validation queries.

Environment: Cognos BI8.2, (Transformer, Power play, Report Studio, Framework Manager), Access Manager, Informatica7.1, Oracle10g, Windows XP.

Confidential, CA

Sr. BI Consultant

Responsibilities:

• Trouble shooting Cognos Environment for better performance.
• Designed Cognos 8.0 reports in Report Studio
• Created one Power Play cube from scratch to their balance sheet.
• Designed drill through capabilities from cube to report studio report.
• Worked on folder level securities for specific user requirement.
• Created user accounts in access manager, and implemented securities for power play cube in Transformer model.

Environment: Cognos Report Net 1.1MR1, Cognos BI 8.0/Cognos 7.0 (Impromptu, Power play), Access Manager, Informatica7.1, DB2, Windows XP.

Confidential

Sr. BI Consultant /ETL Developer

Responsibilities:

• Gathered and analyzed the requirements with business users.
• Constant Interaction with Confidential ’s Business Analysts, In order to understand their entertainment business Structure.
• Helped the team in data warehouse architecture.
• Designed Fact Builds using Informatica 7.1.
• Balanced development between ETL and reporting to obtain good performance.
• Created Job Streams to join the Mappings in effective manner. Optimized Work flow of Job Streams.
• Lately Updated System from Cognos7.0 to Cognos 8BI.
• Installed and Configured Cognos Series 8.
• Used Framework Manager for modeling a meta data.
• Recreating Impromptu reports in Report Net version 8.
• Upgraded Powerplay cubes from version 7 to 8.
• Trained End User for using a product.
• Exposure to Cognos8BI Environment.
• Created Cognos Meta Data Package using Framework Manager.
• Designed Reports using Child tabular Model. Worked on Union of queries for complex reporting.
• Developed Reports for International and Domestic User’s.
• Created Prompts, Filters and Complicated Conditional formatting.
• Interacted with Cognos Corporation for Complicated reports through Webex.
• Created SQL Queries in DB Visualizer for data validation.
• Deployed the Ad-hoc Model and Reports from Development to Testing and to Production environment.
• Documented the process.

Environment: Cognos Report Net 1.1MR1, Cognos BI 8.0/Cognos 7.0 (Impromptu, Power play), Access Manager, Informatica7.1, DB2, Windows XP.

Confidential,

Responsibilities:

• Gathered and analyzed the requirements with business users.
• Created Cognos Meta Data Package using Framework Manager.
• Designed Reports using tabular Model.
• Created Prompts, Filters and Complicated Conditional formatting.
• Interacted with Cognos Corporation for Complicated reports through WebEx.
• Created SQL Queries in TOAD for data validation.
• Implemented Point-In Time Logic to meet Dynamic Report requirements.
• Created Stored Procedures and called them in Framework Manager to pass Parameters.
• Deploying the Ad-hoc Model and Reports from Development to Testing and to Production environment.
• Documenting the process.

Environment: Cognos Report Net 1.1MR1, Cognos EP Series 7.0 (Impromptu, Power play), Access Manager, Oracle 10i, Windows XP.

Confidential, Livonia, Michigan

Cognos Developer / Analyst

Responsibilities:

• Gathered and analyzed user requirements.
• Created ad hoc reports and queries using Query studio and complex reports using Report Studio in ReportNet.
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos connection in ReportNet.
• Used Framework Manager in ReportNet to model metadata from different Oracle sources for use in Report and Query Studio.
• Developed data-reporting infrastructure and created catalogs for reporting and decision-support purposes.
• Created Impromptu reports with various filter conditions to retrieve specific data.
• Applied Drill through for the reports to get detailed information of a particular field in another report.
• Included prompts for the reports to filter the data based on the selection.
• Created User Profiles in the Catalog for the security.
• Created Power Play cubes as per user requirement.
• Worked on Access Manager for giving security to Cognos Applications by creating Users and User Classes.
• Worked on Troubleshooting the IWR reports.
• Worked on Auditing for Impromptu Web Reports to keep track of the reports.
• Front-end development of the data warehouse using Cognos products as an administrator heavily involved with creating reports for users.
• Administered changes to PowerPlay Cube based upon new requirements for customer identification project.
• Worked closely with other developers and architects to tune the data warehouse for better query time.
• Responsible for Data Quality.
• Worked with senior management to better understand the data available in the data warehouse.
• Coordinated systems test planning for major phase of the warehouse.
• Provided End User Training and Support for Business Analysts.
• Interacted with the customers to gather website requirements for website development.
• Spent time with the customer, especially to discuss website layout, content, and testing.
• Developed complex customized websites using Java Script and Servlets.
• Integrated the different modules developed by the team.
• Websites interacted with MS Access database to store audit information about website usage and performance metrics.

Environment: JAVA, Servlets, JavaScript, MS Access, WindowsNT/98.