SUMMARY:

• 17 years of overall IT experience with exposure to various domains including Healthcare, Retail, Supply - chain, Pay TV and Finance (Capital Markets)
• 11+ years of experience in Business Intelligence and Reporting services infrastructure. Expertise in Business Analysis, Information architecture, Data Analytics and Data modeling, Data Migration and Mining, Enterprise Data Integration, ETL and Reports development
• Worked on complete projects life cycles (SDLC) in variety of domains where I was responsible for interfacing with business users, requirement gathering and analysis, design, development and implementation and production support.
• Extensive experience in Project Leadership and Management. Managed teams of associates from disparate functions including development, maintenance and support groups.
• Well versed with Agile and SCRUM methodologies
• Worked in capacity of BI Solutions Architect, DWH Architect and Data Architect; consulted on best practices for various aspects of the BI projects.
• Extensively worked on source Data analysis, Data profiling and cleansing and implementing Data Quality measures.
• Designed Logical and Physical Data-marts using Dimensional Modeling (Star/Snowflake schemas) for Management Information systems and Decision support systems
• Sound understanding of multidimensional database design and architecture
• Contributed to team mentoring, technical and functional trainings for Team members as well as Business users. Actively managed the recruitment processes.

TECHNICAL SKILLS:

Operating Systems: Windows, Unix, Linux

Environment: s: Client/Server, Multitier architecture (MTS, IIS), Cloud Computing

Database: MS Access, MS SQL Server 7/2000/2008/2012/2014 , Oracle (9i, 10g), Sybase (12.5), DB2, Confidential Vertica

Scripting: VBScript, JavaScript, Perl, Shell Scripting, Python, MDX, DAX

Languages: Visual Basic, VB.NET, ASP.NET, ASP, XML

BI tools: Business Objects, Crystal Reports, Data Reports, Excel Writer, Composite(EII), SSIS, Confidential, SSRS, PowerPivot, Power View, Informatica, Erwin, Excel Writer, Tableau

Others: Autosys, Perforce, Team Foundation Server, JIRA, SharePoint, Visio, Microsoft Azure

PROFESSIONAL EXPERIENCE:

Confidential, IN

DWH Architect

Responsibilities:

• Interact with the key business users across the globe for understanding the custom business processes and map them to the Sales Analytics initiative
• Document the requirements using Agile manager, track the User Stories for all the Business portfolios and their respective progress
• Co-ordinate the Program updates in terms of technical as well as functional changes with the Business counterparts
• Head the teams for Logical/Physical Data Modeling, Data Sourcing and Data Cleansing, ETL Design, Implementing MDS, Cube Design, Reporting environment, making data available for downstream systems, etc.
• Head the efforts to design and develop multiple POCs (Proof of Concepts) using Dimensional data model in new MSSQL 2012 and 2014 database, SSIS for ETL and building an Confidential cube using Tabular model
• Designed, developed and presented various Dashboards, ad-hoc reports, KPI Metrices, trending reports, historical reports with slice/dice across various categories, etc. in order to substantiate the idea of new generation reporting platform to the business users and key decision makers

Environment: Microsoft Azure, SQL Server 2012 & 2014, Erwin, SSIS/ Confidential /SSRS, PowerPivot, Power View, Tableau, SharePoint, PowerShell/Perl scripts, etc.

Confidential, TX

Solution Architect/SME

Responsibilities:

• Work as a Business Engagement with six different Business portfolios, the key business users and project stakeholders and track the progress of the programs
• Using Agile manager, track the User Stories for all the Business portfolios and their respective progress in integrated ALM
• Work as SCRUM master for SME forums, QA and Data Migration scrums
• Co-ordinate the Program updates in terms of technical as well as functional changes with the Business counterparts
• Head the effort to design the Overall Test Strategy for the new platform through testing innovations for all the business portfolios
• Govern the development of the formalized solution to migrate the existing indigenous reporting and database tools to new generation platform
• Designed, developed and presented various Dashboards, ad-hoc reports, KPI Metrices, trending reports, historical reports with slice/dice across various categories, etc. in order to substantiate the idea of new generation reporting platform to the business users and key decision makers

Environment: SeaQuest, Confidential Vertica, Informatica, SQL Server 2008, Erwin, SSIS/ Confidential /SSRS, SharePoint, Dial, Shell/Perl scripts, ALM, etc.

Confidential

Solutions Architect/Data Architect/Project Coordinator

Responsibilities:

• Interact with Business users and project stakeholders and translate the requirements into functional and then technical specifications
• Provide expertise to translate the systems requirements into software design documentation
• Plan, design and shape the new generation of reporting platform using technologies (SQL Server/QlikView/Business Objects/MSBI) for the Business Data Repository
• Govern the development of the formalized solution to migrate the existing indigenous reporting and database tools to new generation platform
• Design, develop and monitor the logical / physical data marts, data base objects (like tables, indexes, procedures, packages, functions, etc.); perform data analysis via SQLs, data cleansing and implement data quality procedures.
• Designed, developed and presented various Dashboards, ad-hoc reports, KPI Metrices, trending reports, historical reports with slice/dice across various categories, etc. in order to substantiate the idea of new generation reporting platform to the business users and key decision makers

Environment: NeoView, SeaQuest, BOXI R3, LiveOffice, Informatica, Erwin, SQL Server 2008, SSIS/ Confidential /SSRS, SharePoint, Dial, Shell/Perl scripts, etc.

Confidential, NY

BI Solution Architect

Responsibilities:

• Interact with Business users and project stakeholders and translate the requirements into functional and then technical specifications
• Translate the business requirements into functional and technical specifications and design the complete BI solution architecture including the Physical/Logical Data marts, ETL methodology and Reporting infrastructure using variety of technologies such as Business Objects/Crystal Reports/MSBI/Informatica/DB2
• Conduct regular meetings with team and track progress of each project. Breakdown and distribution of task items.
• Help out on functional and technical issues to the team members. Train new resources on business as well as tools and technologies.
• Create the logical / physical data marts, data base objects (like tables, indexes, procedures, packages, functions, etc.); perform data analysis via SQLs, data cleansing and implement data quality procedures.
• Create UNIX shell scripts, Perl scripts to schedule the mappings in batch process with ETL process dependency.
• Create, enhance, maintain, upgrade, migrate and demonstrate numerous Business Objects Universes and Confidential Cubes against Sybase ASE and IBM DB2 and SQL Server databases using all the functionalities of universe designer module for full-client (DeskI) Business Objects / WebI reports development, SSRS Reporting infrastructure. Design and implement the security model using BOXI CMC.
• Create standard, Ad-hoc reports and report templates using horizontal/vertical tabular, the Cross Tab Reports, Top N Ranking/ Sorting Reports for highlighting significant data, summary reports with drill-down capabilities, pivots, charts, graphs, cube reporting, analytics, dashboards, scorecards and KPIs etc. using Crystal Reports, Business Objects DeskI and Web Intelligence(WebI) and LiveOffice. Confidential Cubes, SSRS Reports and Power Pivots.
• Creating of various Metrices and strategy measures for ease of ad-hoc reporting by business users.

Environment: Sybase (12.5 ASE), DB2, MS Access, BOXI R3, LiveOffice, Crystal Reports 2008, Informatica, Perforce, SQL Server 2008, SSIS/ Confidential /SSRS, SharePoint, Autosys, Shell/Perl scripts.

Confidential

Project Manager/BI Architect

Responsibilities:

• As a project manager and a billable resource I am responsible for managing the entire resource pool and suite of BI services we provide to Confidential along with management of my own deliverables.
• Conduct regular meetings with team and track progress of each project. Breakdown and distribution of task items.
• Help out on functional and technical issues to the team members. Train new resources on business as well as tools and technologies.
• Create various administrative reports for client and internal benefits and ensure optimal resource utilization and timely delivery of the projects.
• Interact with Business users and project stakeholders and translate the requirements into functional and then technical specifications.
• Creation of data models, logical and physical and implement data marts. Design the architecture of entire BI solution for the above projects. Performance tuning of SQL procedures.
• Create UNIX shell scripts, Perl scripts to schedule the mappings in batch process with ETL process dependency.
• Create, enhance, maintain, upgrade, migrate and demonstrate numerous Business Objects Universes and DeskI/ WebI reports development.
• Design and implement the security model using BOXI CMC.
• Develop dashboards, scorecards and KPIs for balanced scorecard, activity-based costing and strategy measures using Crystal Reports, Business Objects DeskI and Web Intelligence.
• Manage several different projects involving variety of business functions and models.
• Drive the migration effort from BOXI R2 to R3.

Environment: Sybase (12.5 ASE), DB2, BOXI R2 and R3, Informatica, Perforce, SharePoint, Autosys.

Confidential

Project Coordinator/BI Consultant

Responsibilities:

• Interact with Business users and project stakeholders and translate the requirements into functional and then technical specifications. Co-ordinate with the relevant data owners for accessing the data system.
• Design Data Mart or create Database objects depending on the requirement of the reporting system.
• Create UNIX shell scripts, Perl scripts to schedule the mappings in batch process with ETL process, write stored procedures for business logic needed for the reports. Performance tuning of SQL procedures.
• Create, enhance, maintain, upgrade, migrate numerous reports using Crystal Reports.
• Drive the migration effort from MS Access to Composite based reporting infrastructure. Also migrate the Crystal reports version 8.5 to version 10
• Managing the entire resource pool along with my own deliverables.
• Conduct regular meetings with team and track progress of each project. Breakdown and distribution of task items.
• Help out on functional and technical issues to the team members. Train new resources on business as well as tools and technologies.
• Create various administrative reports for client and internal benefits and ensure optimal resource utilization and timely delivery of the projects.

Environment: Sybase (12.5 ASE), Crystal Reports 8.5/10, BOXI R2, Informatica (7.1), Shell Scripts, Generic Query (GQ), Composite, Excel Writer, Perforce, Autosys, Erwin

Confidential

Team Leader/Project Coordinator

Responsibilities:

• Help out on functional and technical issues to the team members. Train new resources on business as well as tools and technologies.
• Legacy system study and creation of specification documents
• Co-ordination with business users and data owners. Reporting the progress and various Metrices.
• Design, development and implementation of the old process using new and more efficient design.
• Writing stored procedure, creating new database objects, testing & deployment of reports, mentoring and training the team members, ensuring the quality of the delivery, etc.

Environment: Sybase 11.9.2/12, Crystal Reports 8.5/10, Shell Scripts, Composite, GenericQuery (GQ).

Confidential

Systems Analyst/Project Coordinator

Responsibilities:

• Systems Analysis and Client interaction, Documentation, Functional mapping of the requirements to features in Confidential and onsite product implementation.
• Lead the implementation of following projects in the product SDLC
• Payment Gateway for online Credit card payment collection for Confidential Bank
• Responsible for Data modeling, physical database Design and maintenance of a Centralized database for Confidential, used for Reporting and analytics
• Confidential ’ S web based Issue Coordination System

Environment: Xeon processors with 2GB RAM for DB and Application servers, Windows 2003 as OS, ASP.NET,VB, COM+, MTS, XML, Erwin, SSL Internet Control, Oracle 10g, SQL Server 2000, Crystal Reports