SUMMARY

• Professional with over 19 years of experience as a Technical Lead/Data Architect, Data modeler, Application Developer, Data conversion, Data migration in the Financial, Tax and Banking sector.
• Designed and created data warehouse Data Model STAR schema with FACT and Dimension
• Developed complex Data Models - by conducting interviews/requirements/meetings with Business Unit.
• Designed and Developed Complex application for ETL (Extract Transform Load) into Data Warehouse and Transactional databases.
• Expert in Data profiling, Data cleansing, bulk data processing, Data Integrity, Data Governance, database performance tuning/engineering of applications.
• Designed and developed complex data conversion/migration tools to convert/migrate data from different data sources.
• Experience working as a Technical Lead focusing on project coordination, development efforts, troubleshooting and overseas project Interfacing/Manage
• Managed teams’ in-house and offshore development team.
• Worked with the business unit customers directly to gather the requirements to meet the customer’s needs.
• Experienced in Waterfall, Agile and Scrum development methodology and Design Patterns
• Proficiency in Product development, Customization, Multi-tier architecture, Services Oriented Architecture (SOA) and Project management.
• Proven ability manages complex projects/applications requirement encompassing technical specifications, analysis, design, web sites, implementation, management and application maintenance.
• Project experience on development environments in the areas of analyzing, designing, developing and implementing a wide range of commercial applications using object oriented and client server technologies like PL/SQL, databases like Oracle, SQL Server, Pro *C, C#, VC++.
• Explored Big Data Technologies to support client needs.
• Excellent team leader with very good analytical, programming and management skills.
• Versatile team player with excellent analytical, presentation and interpersonal skills.
• Strong problem solving and analytical

AREAS OF EXPERTISE

• Data Warehouse Development
• Data Profiling/Data Modeling
• Data Conversion/Migration
• Data Analysis and Data Integrity
• Software Design and Development
• N-Tier Architecture
• Waterfall, Agile and Scrum
• Technical support and troubleshooting
• Project/People Management
• Quality Control and Assurance
• Leadership and Team Building

TECHNICAL SKILLS

ETL Tools: SQL Server Integration Services (SSIS), SAP Data Services.

Big Data Technologies: Hadoop 2.6.0, Hadoop (HDFS & Map Reduce), HIVE

Reporting Tools: Business Object Universe designer, Business Object WEBi, Tableau, PureShare, SQL Server Reporting Service, Jasper and Cristal Report.

RDBMS: SQL Server 2000/2005/2008 , Oracle 7.x/8.x/9.x/10g, MS Access, PL/SQL and T-SQL.

CMS: SharePoint 2010

Languages: C#, Java, XML/XSLT, Visual C++ STL, Visual Basic, Python

Modeling Language: UML 2.0

Framework: J2EE, .NET 2.0/3.5, WCF, Jersey, Struts 1.2/1.3, Hibernate, Tiles, Eclipse Modeling Framework (EMF), VC++ SDK/MFC/COM/COM+/ActiveX.

BPM: Savvion

Rule Engine: Drools.NET and JRule

Servers: WebLogic 6.1/7.0/8.1, JBoss 6.0, IIS-4.0/5.0/6.0, WebSphere, Apache, Tomcat, NodeJS and IBM AS/400

Cloud Hosting: Rackspace and AWS (EC2, S3 and Lambda services)

Tools: Team Foundation Server, Visual Studio, Eclipse, Microsoft Visio, RedGate ANTS Profiler, Microsoft CLR Profiler, JProfiler, TOAD, ER/Studio, Erwin Data Modeler.

Libraries: JQuery, Knockout

Source Control: Visual Source Safe (VSS), Team foundation Server (TFS), Subversion (SVN) and IBM Jazz.

Operating Systems: HP UNIX, SCO UNIX 5.0, SOLARIS 2.5, Windows 95/NT/2003/XP.

PROFESSIONAL EXPERIENCE

Confidential

Data warehouse Consultant

Responsibilities:

• Data Architect on implementation of near real-time Data Warehouse.
• Responsible to create and manage Conceptual, Logical and Physical Data Model.
• Work on Data Mapping - Source to Target.
• Provided support for Tableau Analytics dashboard development and Site Admin.
• Designed/developed ETL data load into data warehouse from various sources using Data Services and performance tuning of ETL jobs.
• Assist for troubleshooting to the project team members.
• Played scrum master role to help ensure the scrum team is successful.
• Responsible to manage the project timeline, resources, and scope to meet business requirements.

Confidential - Arlington, VA

Data warehouse Consultant

Responsibilities:

• Worked on Business Objects Report design (BOXI 3.X & 4.X), Universe Design, development & Unit Testing.
• Worked on Ad Hoc reporting requirements using BOXI.
• Troubleshoot Issues and provide solutions for Business Objects Tickets created by the users.
• Created LOE for Business Objects Tasks.
• Developed Production Insertion Guides (PIG) for deploying ETL/Data Structure/Business Objects releases.
• Worked on developing applications using Oracle Database.
• Worked on applying Patches to Oracle (CPU) in the Development/Test Servers.
• Worked on Apache/Tomcat Upgrades & Troubleshooting applications for issues.
• Worked with security team to resolve all JRE related security scan items.
• Implemented Transport layer security on both database server and client side.

Confidential

Data warehouse Consultant

Responsibilities:

• Established Data Architecture to create BI, ETL Standards and Procedures to meet Business Unit’s needs.
• Responsible for Requirements gathering, analysis, Design and Development of Star schema/Data Mart using ER/Studio.
• Responsible for creating LOE for the overall project.
• Responsible for Data profiling/Data Analysis, Data Governance and Data Cleansing.
• Worked on Data Mapping - Source to Target (Multiple Source to Target)
• Designed/developed ETL data load into data warehouse from various sources using SQL Server/SSIS and performance tuning of ETL jobs.
• Worked on Meta Data Management and Assessed Big Data Technologies for client needs.
• Designed and developed Business Objects Universe and reports using Webi reports.
• Provide troubleshooting and consulting services to the project team members.
• Responsible for Define and enforce common Data warehouse best practices.
• Provided support for Business Unit after the implementation.
• Provided support for Tableau Analytics dashboard development and Site Admin.