SUMMARY

• Result oriented Enterprise Data and BI Solution Architect with more than 17 years of IT experience in information architecture, software architecture and enterprise data management.
• Hands on experience in managing Business Intelligence, Data Warehousing hubs, and can work/work with various roles(BI developer, E Data Warehouse & ETL Architect, Data Modeler, Project Manager) and have good technical understanding of business/funtional processes.
• Experience in data integration, product development, big data analytics, cleansing, merging, validation, visualization and data mining analysis, establishing, measuring various reporting frameworks.
• Experience in cloud automation, Hadoop architecture and engineering, UNIX/Linux, coding and scripting, research, training, leadership in increasing productivity and quality services.
• Experience in Big data ecosystem related technologies, configuration, supporting, monitoring Hadoop clusters, Cloudera distribution, management and Amazone Web Services.
• Experience in Hadoop architecture (Pig, Hive, Scoop, HBase ) and various components such as HDFS Job Task Tracker, Name, Data Node and MapReduce programming paradigm.
• Excellent understanding and knowledge of NOSQL, MongoDB HBase Cassandra
• Good understanding of XML methodologies, SOA, Web Services Web Services (SOAP/RESTful)
• Experienced in Quality Aspects, Change Management, Quality Configuration audits, metrics implementation, Build Release planning and manual automated testing of Software products, managing the product development life cycle both in Waterfall and Agile methodologies.
• Led project - based cross-functional teams comprised of engineers, report designers and user experience experts in the development of new analytical tools, introduced new capabilities to various Financial, banking, Insurance and Retail Business clients.
• Extensive experience on SAP functional configuration with the Financial Accounting Controlling FI-CO modules. Strong configuration experience in SAP R/3 and ECC 6.0, SAP BI/BPC.
• Experience in implementation, maintenance and support of HCM/ ERP systems using SAP R/3 with specific functional experience in SAP HR/HCM module Core HR/HCM Payroll - Streamline and integrate essential workforce processes such as employee administration, organizational management, time management, benefits, payroll, and legal reporting. With SAP ERP HCM.
• Expertise in Data Modeling using Entity Relationship, Multi-Dimensional/Star Schema.
• Extensive experience in processes, design principles in Development/Administration using various ETL (Informatica, BODS, IBM DataStage, Talend, other open sources) Tool sets.
• Expertise in Mutli BI/Platform framework system integration, authentication & authorization (kerberos, LDAP), content migration using various reporting products (Cognos, MSTR, Business Objects) Products.
• Expertise in building projects using Micro Strategy product suites including Micro Strategy Narrowcast Server, Micro Strategy Desktop, Micro Strategy Web, Micro Strategy Administrator, Micro Strategy Intelligence Server and Micro Strategy Architect.
• Extensive knowledge in building Business Objects deployment & administration.
• Experience in QlikView Server and Publisher maintenance, scheduled jobs, extracts and report reloads.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau versions.
• Expertise in Business Continuity and Disaster Recovery Planning; delivered maximum business value for Infrastructure, Data Center Technologies, Large Scale Systems and Networks.
• Excellent working experience in analytical, problem-solving, and decision-making skills.
• Experience in transforming relations databases/data warehouse landscapes using Big Data Technologies both cloud and on-site deployments using various resource & budget effective products like Amazon Redshift, S3, EC2, EMR, Cloudera/Horton Hadoop and Hive, RapidMiner, Python/Java.
• Experience working with Network network virtualization using VMware.
• Experience with Six Sigma, Project Management, and System Development Methodologies.
• Experience using Zachman Enterprise Architecture Framework to align systems with business.
• Expertise in IT Services Management (ITSM) and ITIL, methods, processes, strategic technology infrastructure planning, and developing cost effective solutions to meet customer business requirements.
• Ability to work independently and organize workload with minimal direct supervision, strong technical, management and leadership skills.

TECHNICAL SKILLS

Database: Oracle 11g, 10g, 9i, 8i, Sybase 12, DB2 8.1, SQL server 2005, 2008, MS SQL server, SSAS, Teradata, NoSQL, MongoDB, Cassandra.

Programming Languages: SQL/SQL*Plus, PL/SQL, T-SQL. Phython, UNIX Shell Scripting / PERL, VB script, Java, J2EE, Teradata SQL assistant.

ETL: Informatica Power Center 9.1/9.5, 8.6/7.1.3/ 6.2 SAP BO Data Services 4.0/XI3.2/3.1/3.0 IBM Info Sphere(DataStage, Quality Stage)& Information Analyzer DataStage 7.5.2 (Designer, Director, Manager, Administrator)

Reporting: BO XIR3.1, BI 4.0 (DeskI, Qwaas, Xcelsius, Live office, LCM, Federator), Crystal 2008, 8.5,8.0/7.0/6.0, 6.5/6.1B,5.0/5.1, Cognos10.1 & 8.x BI(Report Studio, Analysis Studio, Query studio) MicroStrategy 7.i/ 7.5/8.0/8.1/9.0/9.0.1 Qlikview 10/11/12, QlikSense Tableau 9/9.3.

Platform: UNIX, AIX, Lynx, Windows Standard & Professional (XP, NT, 2000, 2008)

Web & App Server: Apache 3.0, IIS 5/6.0, Tomcat 5.5/6.0, Web logic 9.2/10.3

Utilities/Tools: HP QC, Service Now, Putty, SmarTerm, TOAD, Project 2003 Standard, Visio 2003 Professional.

Cloud Technology: AWS(Redshift,RDS), MS Azure,VMware, RackSpace ( Saas, PaaS, Iaas)

PROFESSIONAL EXPERIENCE

Confidential

Lead Senior Data Architect/Program Lead

Responsibilities:

• Defined Personal Excess Liability product end to end dataflow process for downstream systems.
• As a lead, primarily responsible for designing, implementing and supporting multiple Data Warehouse initiatives.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML methodologies. Conducted JAD sessions for effective communication of vision and goals between stakeholders and gathered business requirements.
• Designed and developed complex Framework Manager Packages to implement departmental security in the packages that can leverage in the reports.
• Designed Data Flow Diagrams (DFDs), Entity Relationship Diagrams (ERDs) and web-page mock ups using modeling tools.
• Responsible for designing and implementing multiple Data marts, designed ETL architecture for the Data Warehouse.
• Responsible for data model changes and source to target mappings to fulfill the growing requirements of business intelligence reports, analyzed source databases and created mapping documents, implemented Metadata and Business Glossary.
• Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau. Effectively used data blending feature in tableau and defined best practices for Tableau report development. Administered user, user groups, and scheduled instances for reports in Tableau.
• Generated Complex reports in Cognos 10.1 report studio including Drill Down reports from DMR modeled Frame work model. Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.
• Created side-by-side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Documented test plans, test scripts, and validations based on design specifications for unit testing, system testing and functional testing.
• Worked on Cloud automation initiative, set up hadoop cluster, wrote MapReduce & python code to access structured/unstructured data.
• Worked on AWS Redshift profile setup for database migration and evaluated product features for new data warehouse build.
• Responsible for Netezza & Exadata proof of concert to combine OLAP/OLTP systems.
• Responsible for training business and IT users regarding Data Ware house and its concepts.

Confidential

Lead Data Architect/BI Steam Program Lead

Responsibilities:

• Gathering, analyzing, functional requirements and data specifications with the stake-holders.
• Defined functional requirement to simplify business users daily reporting requirements, managed various Agile based initiatives using internal custom developed applications and provided support to global users. I have worked with various business units (BSER/Volumes/Dodd Frank/ABM reporting STREAMS).
• Worked in Data Warehouse and BI Projects along with the team of Informatica, Talend (ETL).
• Created conceptual, logical, and physical data models, data quality; SQL and PL/SQL development, extract, transform, and load (ETL) strategies, tuning, replication and solving object-relational mapping challenges analysis of business and technical requirements, and mapping them to implementation strategies and design (system/application architecture).
• Worked on Business Intelligence standardization to create database layers with user friendly views in oracle that can be used for development of various Tableau reports/ dashboards.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights. Building, publishing customized interactive reports and dashboards using Tableau.
• Architected and migrated content from Business Objects Documents to Microstrategy Documents, defined projects and created Schema Objects like Attributes, Facts, Hierarchies, Transformations and Public Objects like Metrics, Filters, Prompts, Consolidations, Custom Groups, Drill maps and Templates.
• Responsible for new BI big solution, scoped the implementation of business intelligence and dashboarding tools to build out a decision support system.
• Initiated data validation research to resolve accuracy issues in data used for analytics and reporting
• Initiated cloud datawarehouse build, Amazon Redshift clusters, Apache Hadoop clusters, data distribution, and data processing big data tool set.
• Define deployment document and supporting the applications for any production issues, conducted code review sessions with offshore and onshore teams and suggesting changes when necessary.

Confidential

BI Project Lead/Data Architect

Responsibilities:

• Initiated user user gathering, analyzing, functional requirements and data specifications with the stake-holders
• Worked with various IT Business Managers, Architects, End users in documenting requirements, providing estimates, creating high and detail Level design specifications.
• Designed Data Warehouse using DataStage ETL (extract, transform and load) tools to load legacy business data. Performance Tuning on the source and target at DataStage Level and Data Loading.
• Developed PL/SQL stored procedures for source pre load and target pre load to verify the existence of tables.
• Performed Analysis and Design of ETL methodologies in all the phases of Data Warehousing life cycle.
• Worked on Informatica Power Center Mapping Designer, Mapplet Designer, Transformation developer Warehouse Designer, Workflow Manager, Repository Manager and Workflow Monitor.
• Design and maintenance of data loading system from trading source system to reporting warehouse using Data Services Integrator.
• Defined Business Objects system infrastructure process flow to support various BOE products, new instances, upgrade dependencies, Crystal and WebI publication and scheduling.
• Defined user management best practices and created user creation process document.
• Created shared Business Objects architecture, design, multiple instance sizing, component integration.
• Created user groups, assigned user level access rights at folder, user groups and connection level.
• Upgraded Business Objects universes, WebI, crystal 2008, and dashboard models from version 3.1 SP3 to version BI 4.0 SP4.

Confidential, NJ

Enterprise Data & BI BW Architect/Program Lead

Responsibilities:

• Designed and developed multi-dimensional model (Star Schema and Snowflake Schema) using Erwin.
• Worked with the business users to gather the business analysis reporting requirements. Designing and developed ETL process.
• Analyzed source data coming from various databases and files and working with business users and developers to develop the data Model.
• Performed data center and server consolidation, workload planning, migration, and implementation projects for various business sectors.
• Worked with Business Users and Data Warehouse Designers to understand the processes of Development, Methodology, and then implement the ideas in Development accordingly.
• Developed, tested Stored Procedures, Functions and packages in PL/SQL for Data ETL, Performed Data conversions, troubleshooting the load failure cases, database problems.
• Administered the Business Objects systems infrastructure, including installs, upgrades, and troubleshooting, publishing reports using publication.
• Defined end-to-end web server/web application /BOE integration, CMS clustering in both Windows and UNIX platforms.
• Defined architecture Business Objects 4.0 (base 4.0 and applied SP4), security, capacity planning, tuning, upgrades/ alert monitoring. and migrated content across the environments., design, multiple instance sizing, component integration.
• Worked with Business Managers, Architects, End users and all the stake holders in documenting requirements, providing estimates, creating high and detail level design specifications.
• Created Heat map with alert mechanism. Various KPI graphs were drawn. Kept eye on Qlikview best practices.

Confidential

Senior BI/DW Lead Architect

Responsibilities:

• Comprehensive experience in all phases of application development from initial requirements gathering, systems design, specification, and project planning through construction, documentation, deployment, and training.
• Performing end-to-end incident management. Responsible for time-critical User Service/ Infrastructure restoration, technical troubleshooting within complex IT systems environment. Working with customers, internal IT and infrastructure teams, third party data providers etc. throughout the service restoration process. Defining and delivering Hadoop platform stack including data storage and high-performance in-memory processing technologies.
• Actively participating and closely working with business and strategic decision making, focusing on on adopting and collaboration with Free and Open-Source Software projects. Helping to adapt company strategy to the changing technological landscape of Bigdata.
• Created advanced support call activity tracker using Xcelsius gauges, charts, and other components, metrics, key performance indicators to generate interactive flash files and integrated with webapps for daily tracking calls.
• Extracted data from GL module and created universe and generated report for plan view & statutory reporting.
• Technical set up of Business Objects suit, setup of development, quality and production environments.
• Managing Problem tickets during the support phase after Go-Live and ensure smooth Go-Live and transition.
• Delivery, Cost, Utilization. Change Management and weekly conference calls with end user and SAP Business Objects teams.
• Preparing system volume testing, regression test cases to check the parameters with production server.

Confidential

Senior BI/DW Architect/Project Lead

Responsibilities:

• Deliver value added solution that focus on IT Service Management, Business Transformation and Organizational Change Management based on ITIL best practices that focus on the people, process, technology and information perspectives of providing integrated organization wide business solutions within the IT infrastructure.
• Worked with various development teams on multiple source database systems for tracking, analyzing and reporting framework for Investment banking business managers.
• Define project scope, goals and deliverable that support business goals in collaboration with senior management and stakeholders.
• Participated in technical weekly meetings, status reports, presentations, project for senior management across IB business sectors.

Confidential, Jersey City, NJ

Senior SAP Data Warehouse/Project Lead

Responsibilities:

• Key role - In full life cycle BI infrastructure deployment.
• Experience in SAP conceptual design, requirement analysis and detail design, configuration of Organizational Management.
• Responsible for guiding internal customer groups in configuring the HR modules Payroll, Personnel Administration and Travel Management.
• Developed UNIX Shell scripts to pull data files from various sources via ftp, cleanse using Informatica batch/session jobs. Created Bulk load stored procedures.
• Developed PL/SQL and triggers to implement business rules, optimized SQL queries.
• Developed report specifications for critical BO application, Integrated SS On with site minder.
• Manage Supervisor system level activities. Support ongoing user’s maintenance project.