SUMMARY:

• Results - oriented, seasoned senior IT professional, skilled in Data Analytics and Microsoft Technologies with very good communication, team and interpersonal skills.
• Helping business to transform and get most out of technology by playing role of “Trusted Adviser”
• 16+ years of proven IT experience in solving challenging business problems with innovative enterprise solutions aligning business needs to IT capabilities. 5 + years strong data warehouse solutions exp.
• Various domain knowledge including Healthcare, Insurance, Tax, public sector, finance and banking.
• Experienced in Software Development Life Cycle. Skilled in Requirement Analysis, Software Architecture, Data Analytics, Reporting Systems, MDM, Data Visualization techniques. Strong Object Oriented Design patterns and principles, Good understanding of Azure and Cloud technologies in general.
• Expertise in Database design, RDBMS Concepts and skilled in Database programming in SQL Server 2005/2008/2014 with excellent data analytical skills and problem solving skills. Fair knowledge in Big Data technologies, Shell scripting DW appliances like Natezza
• Sound experience in ETL on MSBI platform, .NET Framework/ C#/ ASP.NET/ WCF/ ASP/ Web Services
• Worked for Fortune 500 organizations/clients like GE, HP, CapGemini, ACS/XEROX, Confidential etc.
• Important to me: Customer Satisfaction, Value Realization, Project Success, Technology Adaptability.

TECHNICAL SKILLS:

Technology and Tools: Business/IT Alignment ETL, Data warehouse, IT Transformation, Data Governance (MDM) Software Processes (SDLC, RUP, XP, Scrum Agile Methodology, CI concepts, ITIL) Modeling(UML),EDI,HL7,RAPS and EDPS file str SOA, WCF, Web Services Configuration Tools TFS, VSS, ECM Onbase, Share point, IBM Filenet Analytics: MSBI, DB Design, Power BI SQL Server 2008, 2012/2014 SSRS, Power BI RDLC, Crystal Reports Languages: - C#, VB.NET, VB6 Web ASP.NET, ASP, HTML, Javascript WCF, Web Services, Micro Services, XML, Automation: Autosys, Control-M Productivity MS Project, Visio, Erwin, Altova XML Spy, Word, Excel

PROFESSIONAL EXPERIENCE:

Confidential, Long Beach, CA

Solution Architect /Technical Manager - BI & EDW

Responsibilities:

• Architect and design data extract processes for various enterprise data ware houses including QNXT.
• Conceptualize and articulate solution roadmaps for many successful data integration projects.
• Translate user requirements into overall solution architecture for complex technical solutions.
• Manage team of 12 onsite and offshore members who support HEDIS/Risk Adjustment IT activities and development of new projects for HEDIS department.
• Involved in extensive data analysis and manage projects throughout lifecycle.
• Architect and design ETL from various source systems with different file formats such as EDI, HL7, RAPS, EDPS etc. Dashboard reporting development using Power BI, DAX formulas, power pivot.
• Lead and hands-on all the development and support work. Provide technical guidance to the team and. Provide Solution and Lead content management integration with various in-house systems.
• Involved in Estimating, Budgeting, ROI study, Resource Planning, Project Planning, Lead Execution, testing and deployment lifecycle of projects. Also responsible for leading for many Risk Adjustments IT projects.

ENVIRONMENT: MSBI stack (SSIS SSAS SSRS), SQL Server 2012/2014, SQL MDS (MDM), Power BI, IBM Filenet - Content Management, Work flow integration, Micro services, OCR/ICR (Unstructured data management), HIPAA, EDI, HL7, Natezza

Confidential, Long Beach, CA

Project Lead/Architect - BI & EDW

Responsibilities:

• Gather business requirements and develop conceptual design and technical design document.
• Translate user requirements into overall solution architecture for complex technical solutions.
• Identify and estimate project tasks. Manage and lead the onsite and offshore development team.
• OLAP Data modeling, Design, Develop, Test data integration applications
• Communicate with offshore team and coordinate requirements and enhancements
• Conduct peer review of other developers to ensure standards and quality.

ENVIRONMENT: ETL MSBI stack (SSIS SSAS SSRS), SQL Server 2008 R2, WCF, Web Services, Microsoft Enterprise Library, XML,TFS, .NET technology stack, MS SharePoint API’s and IBM Filenet for Document storage and retrieval. Shell scripting, EDI inbound, HL7 integration., HIPAA compliance

Confidential, Orange County, CA

Technical Lead /Senior Consultant

Responsibilities:

• Analyze, Review and perform GAP analysis in Requirement.
• Involved in design discussions with architects for Architecture Design, Database Design and HLD.
• Designed and derived Workflow requirements across user departments.
• OLTP Database design, data modeling and writing stored procedures in SQL Server 2005.
• Development of project on .NET 2.0/3.0/3.5 framework.(WinForms, C#, WCF, CAB architecture)
• Co-ordinate with end users on clarification, classification of defects, change requests during UAT.

ENVIRONMENT:, SQL Server 2005, C#.NET, CAB Framework, WCF,ADO.NET, Microsoft Enterprise Library, XML,.NET Framework 2.0/3.0/3.5, ASP.NET, Windows Services, TFS, Test, Infragistric Controls, RDLC, Aspose total for automation. Hyland Onbase for ECM.

Confidential, Orange County, CA

Technical Lead/Senior Analyst

Responsibilities:

• Involved in Requirements and of Estimation using 3-point estimate technique.
• Architecture Design and HLD using Visio. Writing of Unit and Functional Test Cases.
• Development of project on .NET 2.0 platform.(ASP.NET, C#)
• Designed and Developed XML Web Services. Involved in XML Schema Design.
• Database design and writing stored procedures in SQL Server 2000.
• Also Involved in front end design using Web Forms, HTM, JavaScript, XSL.
• Worked on unit testing, Integration testing and Functional Testing of application.

ENVIRONMENT: C#, ASP.NET, SQL Server 2000, .NET Framework2.0, Ajax, Web Services, IIS 6.0, XML.

Confidential, Boise, Idaho

Senior Consultant /Analyst

Responsibilities:

• Involved in Requirement Gathering and preparation of SRS.
• Architecture Design and HLD using Visio, Detail Design document preparation.
• Development of project on .NET platform. Designed and Developed XML Web Services based on SOA Architecture
• Development of Windows Services for batch processing, Listeners development using MSMQ
• Also Involved in front end design using WebForms, .NET Controls, XSL and SVG.

ENVIRONMENT: C#, ASP.NET, SQL Server 2000, MSMQ, .NET Framework, SVG, Web Services, Windows Services, IIS 6.0, XML, XSL.

Confidential

Senior Consultant/Analyst

Responsibilities:

• Involved in Requirement Analysis.
• Architecture Design and HLD using Visio, Detail Design document preparation.
• Preparation of Unit and Functional Test Cases.
• Front end development using .NET Web Forms and developed .NET user controls.
• Worked on unit testing, Integration testing and Functional Testing.
• Tuning the queries for optimization
• Co-ordination with client for Change requests and preparing Impact Analysis.
• Used WebTrends to analyze IIS Activities

ENVIRONMENT: VB.NET, ASP.NET, Oracle 9i, Web Trends, IIS 5.0, XML, XSL.

Confidential

Sr. Software Engineer

Responsibilities:

• Involved in Requirement Gathering and SRS preparation based on primary requirements by client.
• High Level Design document preparation using Visio, Detail Design document preparation.
• Development of project on .NET platform and development of Web services
• Front end development using .NET Web Forms, Server Controls.
• Unit testing and and co ordinations with end users for clarifications and changes.

ENVIRONMENT: C#, ASP.NET, Web Services, .SQL Server 2000.

Confidential, Chicago, IL

Consultant/Analyst

Responsibilities:

• Involved in Requirement Gathering.
• Architecture Design and HLD using Visio, Detail Design document preparation.
• Development of project on VB COM Technologies.
• Writing of Unit and Functional Test Cases, Test Scenarios. Production Deployment at client site.

ENVIRONMENT: Visual Basic 6.0, SQL Server 2000, COM+ and Windows 2000.

Confidential

Software Engineer

Responsibilities:

• Jewelry Management System. (JEMS)
• Order Processors for Grocery and Branded Products (OPER) for client Pacific Agro foods (Export) Ltd

ENVIRONMENT: Visual Basic 6.0, SQL Server 7.0, ADO. Crystal Reports