SUMMARY:

• Data Architect with 16 years of IT Industry experience with leading IT organization to leverage technologies towards the accomplishment of the strategic and tactical business objectives
• Experience in various domains such as BSFI - Retail, Business Banking, Risk & Compliance, Insurance and Manufacturing in Application Development, Migration, Maintenance and Support Projects
• Experience in all phases of Software Engineering - Requirement Gathering, Project Planning, Solution Architecture & Design, Development, Testing, Implementation and support with Waterfall and Agile methodologies
• Worked closely with business and functional teams to gather, analyze the requirement and translate them into conceptual, logical and physical data models
• Experience of interaction with executive management of customer teams for the Strategy, Architecture, Design discussions and with Federal Auditors for BSA / AML Audits
• Experience of Architecting and Implementing of OLTP, ODS, OLAP and MDM systems
• Extensive experience in creating Solution/ Data Architecture, Data Migration Strategy, Design Documents, Data Flow Diagrams, Data Models, Application Integration Documents and Data Mappings
• Passionate about SQL coding, Performance tuning, ETL development and Database administration task
• Experience of being part of Data COE / Practices of in different organizations that were responsible for defining and Architecting ETL frameworks, database standard and database design & coding best practice
• Experience of Onshore - Offshore teams, mentoring teammates, mobilizing and providing directions to the development teams

TECHNICAL SKILLS:

Databases: MS SQL Server 2014, 2012, 2008, 2005, 2000, 7 & Oracle 11g

ETL Tool: Informatica 8.6, Data stage, Quality Stage 7.5.2, MS SSIS 2012

Data modeling tool: Embarcadero 9, Erwin, MS Visio 2010

Reports: Crystal report 11,MS SSRS, OBIEE 11g

Application Development Tool: C# scripting, VB6, FileMaker 6, VBA

Methodology: Agile, Waterfall

OS: MS Windows XP, MS Windows 7/ 10, MS Windows server 2003 & 2008 R2

PROFESSIONAL EXPERIENCE:

Senior Data Architect

Confidential, Buffalo, NY

Responsibilities:

• Solution architecture, data modeling, creating Integration flows, data mapping and creating high level design documents.
• Work closely with the AML compliance officer and LOB teams for gathering the requirement.
• Participate in the PDD sizing and the estimations for the Center Technology.
• Reviewing functional specifications. Walking through the high level design solutions.
• Leading development team, coordinating with all upstream and downstream applications and managing technical deliverables.
• Setting up development, testing and production environment. Administering and managing SQL servers/ databases like data partitioning, backup strategy, defining data retention and archival strategies.
• Participate/ support internal and external audits involving FED, NY State and OCC audits.
• Writing SQL scripts, SSIS packages and reviewing code of team members.
• Performance tuning & optimization of databases, SQL code.
• Co-coordinating onsite activities for the offshore development team.
• Supporting QA and UAT testing, preparing implementation plan.
• Application/ system walkthrough and KT sessions.

Tools: and Technology used: Confidential SQL Server Integration server 2012, Confidential SQL Server 2012, Oracle 11g, Confidential ASP.Net 2010. Embarcadero, MS Visio 2010, EBO reporting, TIBCO business works (ESB), IBM FileNet, MS office 2010

Solution Architect

Confidential, Buffalo, NY

Responsibilities:

• Solution architecture, identifying batch/ real time integration process, developing POC, preparing integration data mapping documents, designing and architecting development frame works.
• Project planning, sizing and estimation.
• Created Data migration strategy for moving data from pilot system.
• Preparing/ walking through high level design document, leading development team and managing project deliverable.
• Conducting data mapping sessions for the ESB and the batch processes.
• Co-coordinating offshore development efforts.
• Preparing implementation plan and coordinating implementation task.
• Coding/ reviewing SQL codes.

Tools: and Technology used: Confidential SQL server Integration Server 2008, Confidential SQL Server 2008, Confidential ASP.Net 4.0, Confidential Silverlight, TIBCO Business Works(ESB service), Corticon Rule Engine, Business Objects reporting, ADOBE Live cycle. Embarcadero, MS Visio 2003, MS office 2010

Solution Architect

Confidential, Buffalo, NY

Responsibilities:

• My roles and responsibilities include solution architecture, Data modelling, creating data dictionary, identifying batch/ real time integration process, data mapping documents, creating high level design( Confidential ) documents.
• Project planning and sizing
• Conducting project status meeting and walking through the Confidential .
• Leading the development efforts, reviewing all technical artifacts and code.
• Preparing implementation plan and coordinating implementation task. Post implantation support.

Tools: and Technology used: Confidential SQL server Integration server 2008, Confidential SQL server 2008, Confidential ASP.Net 4.0, Confidential Silverlight, TIBCO business works (ESB service), Corticon rule engine, Business Objects reporting, ADOBE life cycle. MS Visio 2003, MS office 2010

ETL Technical Lead

Confidential, Buffalo, NY

Responsibilities:

• Defined and Architect the ETL framework for Confidential & Confidential - which includes defining all the process and artifacts of the SDLC cycle.
• Designed and Development centralized platform for managing & tracking all ETL process via Dashboard & reports.
• Performing data Analysis, conducting data mapping sessions.
• Creating technical specification documents & designing staging databases.
• Coding and leading development efforts of the team.
• Providing testing and post production support.

Tools: and Technology used: Confidential SQL server Integration server 2005, Confidential SQL server 2005, MS Visio 2003, MS office 2007.

Project Lead

Confidential

Responsibilities:

• I was leading the 30 member development & QA team. I was responsible for the delivery of modules which were developed by Confidential teams.
• Attending daily SCRUMS, providing weekly & monthly project status reports were part of my responsibilities.
• I was designated as external reviewer for DB model, SQL codes and SSIS packages which were development Confidential teams.

Tools: and Technology used: Confidential SQL server Integration server 2008, Confidential SQL server 2008, MS Visio 2007, MS office 2007, Confidential Team Foundation Server 2010

Database Specialist

Confidential

Responsibilities:

• Planning project activities, designing and documenting the Confidential and Confidential, data model, designing integration workflows, developing SQL procedures, view and functions and other database related activities
• Designing and documenting Confidential and Confidential, preparing the mapping document, building data standardization (Name and address) rules for many Countries, Build MS SSIS custom component to support special standardization requirements.
• Designed UI for managing the MDM specific data survival shipping and ranking rules.
• Developed ETL process using IBM DataStage for integrating customer data into the centralized repository.
• All US and Australian customer name and address were standardize using IBM quality stage.

Tools: and Technology used: Confidential SQL server Integration server 2005, Confidential SQL server 2005, MS Visio 2003, MS office 2003, Confidential C#,.Net, Data stage, Quality Stage 7.5.2

Database Specialist

Confidential

Responsibilities:

• I was responsible for design & development of software and managing SQL development server for Global Software licensing and Procurement team.
• Design, development and supporting dashboard report for the higher management.

Tools: and Technology used: FileMaker pro 6, Confidential SQL server Integration server 2005, Confidential SQL server 2005, MS office 2000, Confidential ASP, Business Objects IX

System Analyst

Confidential

Responsibilities:

• Study, analyze and document user requirement
• Design and develop sub systems (manufacturing and costing applications) integrated with main ERP application.
• Maintain the entire system of Confidential - software and hardware.
• Managing user access and SQL server maintenance.
• Network maintenance between main office and divisions
• User training.

Tools: and Technology used: Confidential Visual Basic 6, Confidential SQL server 2000, MS office 2003, MS DTS jobs, Crystal reports 8.5, Wang COBOL

Analyst Programmer

Confidential

Responsibilities:

• Meeting business users and understanding the requirements.
• Study of existing ERP system and documenting user requirements for the Confidential client.
• Design and document specification, data migrating strategy.
• Leading development activities and allocating task to developer and testers

Tools: and Technology used: Confidential Visual Basic 6, Confidential SQL server 2000, MS office 2003, MS DTS jobs, Crystal reports 8.5, Wang COBOL