Professional Skills

• Expertise in Dimensional Modeling - Star and Snowflake
• Expertise in Conceptual, Logical and Physical data models - OLTP and OLAP.
• Expertise in ETL Architecture, Design Development INFORMATICA 9.x
• Strong experience in developing home grown ETL frameworks - PL/SQL and T-SQL programming
• BI Schema Architecture- Schema objects, Public objects, Report service documents MICROSTRATEGY 9.x
• Business Intelligence in Cloud based Environment
• Expertise in BIG DATA Hadoop technologies - Hive, Sqoop, Hbase, Map Reduce and HDFS
• Demonstrated expertise in EDW Solution and Data Architect
• Data Analysis, Data governance and Data quality reporting
• Published, updated, and provide training on data standards, polices, and procedures.
• Extensive experience in RDBMS - ORACLE 11g/10g/9i, MS SQL SERVER, DB2 UDB and MySql
• Strong Experience in Data Model Erwin and MS Visio
• Good understanding of MPPs -Teradata
• Good at scripting languages - Perl, Unix shell
• Strong Experience in Agile-Scrum Delivery model

Professional Experience

Confidential

Solutions Architect

• Provide architectural solutions and services for data intake, integration and enrichment covering data intake, integration, meta data, data quality and data security
• Architect solutions for key business initiatives ensuring alignment with future state analytics architecture vision
• Work closely with the project teams as outlined in the SDLC engagement model to provide guidance in implementing solutions at various stages of projects
• Engage constructively with project teams to support project objectives through the application of sound architectural principles
• Develop and validate that the proposed solution architecture supports the stated implied business requirements of the project
• Review technical team deliverable for compliance with architecture standards and guidelines
• Adopt innovative architectural approaches to leverage in-house data integration capabilities consistent with architectural goals of the enterprise
• Create architectural designs for different stakeholders that provide a conceptual definition of the information processing needs for the delivery project
• Expanding the existing legacy based Data warehouse application into Enterprise Centralized Data Hub based out of Hadoop Ecosystem
• Adopting and Architecting Analytic solutions using Big Data technologies i.e. Hadoop Stack, Kite SDK, Avro Schema evolution, Hbase, Hive,NoSQL DBs

Confidential

Confidential is World's Biggest Cloud-Based Business Network for Confidential Chain Management.

Technical Architect / Lead

• Supply Chain Intelligence is an advanced business intelligence analysis platform, with a packaged reporting data warehouse powered by data from Confidential transactional database, uses pure-html analytics front end, 100 ad-hoc reporting which allows Confidential Power users to create and publish reports, and Confidential Casual users to run and schedule reports. Multiple subject areas are available based on various GT Nexus products.
• Responsible for identifying and controlling BI projects scope, quality, and schedule. Worked on strategic initiatives
• Implementing Business Intelligence and Data Warehousing principles, ETL methodologies, Approaches, Technologies and architectures including the concepts, designs and usage of data warehouses and data marts
• On-site interaction with Product Management
• Responsible for Dimensional Data Modeling
• Developed ETL solutions using Informatica PowerCenter 9.x
• Involved and managed an ETL conversion project to convert existing ETL logic in Legacy stored procedures to Informatica PowerCenter
• Worked alongside BI team, DBA team and the application development team to identify and fix performance bottlenecks and data quality issues
• Created a pilot environment for the development team to test Informatica Data Quality tools
• Mentored team members with velocity methodologies on coding and naming standards
• Coordinated releases and liaison with Production Support team on issues logged during batch loads
• BI Schema Architecture - Large Scale Multi Enterprise, Multi-Tenant Environment
• BI Deployments - Setting up process
• BI Administration - Data security and User accessibility
• Adhere to Agile Development
• Agile - Scrum Master
• Deployment Strategies
• Produced technical artifacts including Data dictionary, Bus Matrix, Data Flows, ER diagrams, Data Interaction Diagrams, Mapping Documents etc.

Technologies: SQL Server 2005/2008/2012, INFORMATICA PowerCenter 9.x , Microstrategy 9.x, MS Visio

Technical Architect / Lead

• Confidential system which will provide analytical benchmarks on various factors like
• Transit Time
• Port of Loading Dwell Time
• Port of Departure Dwell Time
• On Time Arrival On Time Departure
• This will help the customer to measure the business performance.
• Installation
• Architecture, Design Development of complete end-to-end Data Flow RDBMS HDFS NoSQL HBase RDBMS
• Design and development of ELT / ETL process
• Development using Hadoop ecosystem frameworks
• Integrating DW and Hadoop

Technologies: CDH 4.2.2, Hadoop, HDFS, Map Reduce, HIVE, Sqoop , Hbase, Phoenix, MSTR 9.4

Confidential

Confidential, is a pioneer in cybersecurity and machine intelligence.

Data Architect / Senior Engineer

• The Confidential is a traffic intelligence solution, providing real-time identification and mitigation of any unwanted or malicious traffic for the protection and management of large IP networks.
• Developed project plan to support the business process reengineering effort, the development of the business architecture, and the supporting artifacts to the complete the logical layer of an data warehouse implementation
• Responsible for Dimension Modeling
• Responsible for Logical and Physical data model
• Architect and Design of home grown ETL framework
• Developed ETL using database programming PL/SQL
• Develop logical and physical design for variety of data formats to process very large amounts of data, including batch and real-time data.
• Worked closely with DBAs, Product development teams, infrastructure and project managers in agile environment to produce deliverables
• Responsible for prototyping for each model as POC to technical team
• Extensive involvement in performance tuning and Query Tuning Explain Plan, Optimizer with Hints, Analyze, Indexing strategy, db2advice
• Worked on Documenting Data Models, logic, coding, testing, changes and corrections.
• Maintenance of data warehouse, data fixes, fixing existing bugs
• Produced technical artifacts including Data Flows, ER diagrams, Data Interaction Diagrams etc.

Technologies: Oracle 10g, DB2 9.5.0, PL/SQL

Confidential

Confidential has proven social technology and smart social specialists who help customers to answer their most urgent business questions.

Sr. Database Analyst/ Project Lead

• Confidential is a market/media intelligence product. Confidential Platform gives the clients a real-time access to a comprehensive archive of traditional and social media, filtered and classified to be relevant to Clients Company, brand and business goals.
• Responsible for Dimension Modeling
• Responsible for Logical Model and Physical implementation
• Architect and Design of home grown ETL framework
• Developed ETL using database programming PL/SQL
• Develop logical and physical design for variety of data formats to process very large amounts of data, including batch and real-time data.
• Worked closely with DBAs, Product development teams, infrastructure and project managers in agile environment to produce deliverables
• Extensive involvement in performance tuning and Query Tuning Explain Plan, Optimizer with Hints, Analyze, Indexing strategy, db2advice
• Worked on Documenting Data Models, logic, coding, testing, changes and corrections.
• Maintenance of data warehouse, data fixes, fixing existing bugs
• Produced technical artifacts including Data Flows, ER diagrams, Data Interaction Diagrams etc.
• Support all production oracle issues as needed and participate in emergency on call support activities

Technologies: Oracle PL/SQL, Oracle 9i, Oracle 10g, Toad 8.2 Expert Version , Erwin/ERX 3.5.2