Executive summary

• Seasoned, goal-driven technology leader with 15 years of work experience in full life cycle of software development SDLC across various industries including Retail, Financial Services and Healthcare.
• Adept at architecting and delivering enterprise data warehouse/marts, BI ETL solutions, enterprise level products, web and mobile extensions, including end-to-end architectural plans and designs.
• As part of architecting and delivering compelling, scalable and extensible solutions, led cross-functional initiatives working closely with product management, product development
• Planned, tested, and implemented long term strategies for new product features using latest technology, open source and third party interfaces and worked on sun setting outdated tools and technology,
• Managed and worked with geographically diverse teams in USA and offshore India.

Area of expertise/knowledgebasE

Professional experience detail

Confidential

Lead DW Architect

• ACA-CDR is very large terabyte data repository build to support automation backbone of - Affordable care Act.
• Lead the Data Repository Architecture team and was responsible for:
• End to end design of entire product architectural roadmap consisting of large and scalable oracle data repository ,multiple data marts with 24x7x365r availability
• Establish road map for BI Analytics and reporting solution to generate compliance reports.
• Design of multiple high available Informatica based ETL solutions, related data models to populate the repository from various sources.
• Created design for SOA based Java J2EE Web Services for individual operations and Informatica based bulk operations running on top of ESB Enterprise Service Bus .
• Architected and designed E2E error handling and mandated system security, auditing and logging strategy.
• Liaisoned with various stakeholders - Program Executives, PMO, Requirement team, Developers and testers.
• Working on proof of concept to migrate to Green plum db and Hadoop based ETL to further enhance performance of repository.

Confidential

Lead Architect/Development Manager

• The Investigative Data Analytics is data repository with analytics tools for IRS-Criminal Investigators to triage massive amount of heterogeneous data pertinent to tax fraud, money laundering and criminal activities. As the lead architect I was responsible for:
• Entire design of highly secure ,scalable complex product architecture consisting large 1 terabyte sql server based data repository with 20 data marts, SSIS based ETLs.
• Designed interface to third party enterprise HP Autonomy indexing search engine APIs for faster search,
• Integrated message based interface to IBM identity insight APIs for identity resolution
• Architected 508 accessibility complaint Java J2EE based UI to present search results to investigators.
• Led the Proof of concepts:
• To integrate third party I2 visual analytics adding visualization to search results
• Use Business Objects Inxight Now part of SAP Data services for unstructured data processing
• Integrate Autonomy federated search for external data sources and web crawling. Performed comparative analysis and assisted selection process for Search engine and visual analytics tool.
• Worked on product selection process, evaluated multiple solutions for enterprise search and text analytics.
• Managed development team.

Confidential

Worked on Association Management Software AMS Product - Enterprise Resource Planning software targeted towards nonprofit organizations. Product helps nonprofit organizations to manage their membership, publications, advertising, certifications, transcripts, conferences, exhibitions and marketing in efficient manner with focus on customer relationship management CRM . AMS has centralized account receivable functionality. AMS integrates with various general ledger/Accounts Payable systems, fax servers, collaboration portals, and credit card processing software/services. Product consists of nTier architecture made using .Net using technologies and Oracle/Sql db as backend. The AMS integrates with Business Objects Enterprise as a BI tool for operational reporting and data warehousing.

Confidential

Solution/BI Architecture and development

• Established architectural roadmap revised, renovated, strengthened it by researching, utilizing latest technology for company's product suite to see it evolve from a client server architecture transactional enterprise system to a n Tier object oriented web based solution to stay ahead of competitors and meet market demands.
• Designed data models, Developed Operational Reporting and BI layer for Operational Data, Involved in Analysis, Modeling and ETL of various Data Marts. Developed BI layer for the Data Mart of the product. Designed and Developed Financial batch process like Aging , Invoicing, Customer Analysis Interface to AR-AP ERP 's like Lawson, Oracle Financials .Developed designed BOE Universe and template Webi reports. Developed dashboards and analytics using Performance Management tools of BOE XI R2.Prepared a roadmap for deployments and release management of BI product to various clients. Architected, designed, developed and Integrated BOE with AMS Product
• Designed object models using design patterns, prepared architecture design documents. Developed core product class library, product extension library, user layer APIs. Designed wire frames and workflow for ecommerce solutions
• Collaborated with onsite/offshore India architects and developers and delivered Technology framework initiatives that reduce the cost and overhead of product development by using reusable object oriented, API based development. Including self extensible metadata driven user interface utilizing MVC design pattern.
• Worked with SOA Service oriented architecture based technology to implement Single Sign On, Identity management systems.
• Designed Web Services/API/Data pipe to enable integration of back office application with multiple third party vendors for email marketing ,CMS , Address verification, Credit card processing, GL/AP packages Great Plains, Lawson, Solomon and Oracle Financials. Involved in vendor selection process.
• Re designed legacy data migration tool and upgraded it to state of art SAP Business objects Data Integrator resulting into 80 improvement in data conversion time.
• Evaluated specifications and requirements for product .Involved in requirements definition, business level analysis. Captured business requirements via internal and external client interviews, storyboards, scenarios, and workshop facilitation. Built as-is and desired process models, and performed gap-analysis. Identified areas for process improvements. Decomposed high-level business requirements into technical specifications/tasks.
• Established standards for best coding/designing practices, automated build, deployment and QA processes.
• Mentored and trained offshore architects and developers at TMAR's offshore development partner in India
• Hands on development using .Net, Oracle, SqlServer, ETL, Webi ,Crystal , Cognos Reports, Gupta Sql Windows, VC , Pro C technologies. Analyzed software logs/system logs database, queries for performance tuning.

Technical Management/ Leadership

• Created project proposals outlining the project plan, risk plans, required human resources as well as software and hardware, and projected budget. Monitored and assessed the progress and quality of project deliverables.
• Provided thought leadership, mentoring, coaching and training to team members. Conducted design reviews and code reviews.
• Previous ProJects Detals Available Upon request

Technical Experience

• Databases: SqlServer, Oracle, T/Sql , PL/SQL, Stored Procedures, Triggers , Green plum , MangoDB , NoSql
• Data Warehouse/ETL: Informatica Power Center/Data Quality, Hadoop, SAP Data Services , SSIS ,SSIS
• BI/Reporting/Analytics: SAP Business Objects -Webi, Crystal Reports 9/XI , SSRS , Cognos , IBM I2
• Data Modeling: Rational IBM Info sphere Data Architect, Erwin
• Architectures: Global Enterprise Architectures, Client/Server, N-Tier Large Enterprise applications, SOA,Database, Data Warehouse, Internet/Intranet, E-Commerce , Mobile
• Application Development: VB.net/C .net, ASP.net, Java J2EE ,XML, HTML, Web Services, Visual Studio, Centura/Gupta Sql, MS SharePoint Fusion, Ingress, Unix, C, C , Pro C , Cold Fusion
• Version Control and Case Tools: Visual Source Safe VSS , Team Foundation Server TFS , Sub Version SVN , StarTeam. Rational Clear Quest, Parature. Rational Clear Case , Rational team Concert , Visio, UML
• Interfaces: Credit Card Interface Paypal , Content Management Systems , IBM I2 Visualization, Autonomy Enterprise Search IDOL , IBM Identity Insight
• Management: Multiple Projects, Phased Deliverables, Specifications, Analysis, Cost Benefit, , Proposals, Resource Allocation, Requirements Definition, Presentations, Demonstrations, Training Manuals, Mentoring
• Project Management Tools: MS Office Suite , Agile, Scrum, Iterative Development, Waterfall, RUP