PROFESSIONAL SUMMARY:

• 16 years of overall IT experience with exposure to various domains including Healthcare, Retail, Supply - chain, Pay TV and Finance (Capital Markets)
• 10 years of experience in Business Intelligence and Reporting services infrastructure. Expertise in Business Analysis, Analytics and Data modeling, Data Migration and Mining, Enterprise Data Integration, ETL and Reports development
• Extensive experience in Project Leadership and Management. Managed teams of associates from disparate functions including development, maintenance and support groups.
• Worked on complete projects life cycles in variety of projects where I was responsible for interfacing with business users, requirement gathering and analysis, design, development and implementation and production support.
• Well versed with Agile and SCRUM methodologies
• Worked in capacity of BI Solution Architect, DWH Architect, Data Architect and consulted on best practices for various aspects of the BI projects.
• Extensively worked on source Data analysis, data 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
• Contributed towards team mentoring, technical and functional trainings, business users’ trainings and recruitment processes.

TECHNICAL SKILLS:

Databases: Windows, Unix, Linux

Business Objects: Crystal Reports MSBI Suite (SSIS,SSAS,SSRS), HTML/DHTML, VBScript, JavaScript, ASP, XML, Visual Basic, VB.NET, ASP.NET, Perl, Shell Scripting

Reporting/BI tools: Autosys

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

PROFESSIONAL EXPERIENCE:

Confidential, TX

DWH Architect

Responsibilities:

• Interact with the key business users and project stakeholders for identification of the existing systemic issues and challenges
• 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
• Study and analyse the existing reporting as well as oprational applications to identify the datasources
• Head the effort to design and develop a POC (Proof of Concept) using Dimensional data model in new MSSQL 2014 database, SSIS for ETL and building an SSAS cube using Tabular model for “Prosecutor” operational data store
• 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: SQL Server 2008 R2, SQL Server 2014, SSIS/SSAS/SSRS, PowerPivot,Power View, SharePoint, Shell/Perl scripts, Microstrategy, etc

Confidential, TX

Solution Architect /SME/PM

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
• Validate the Data Comparison Solution across all reporting domains and oversee the User Stories
• Govern the development of the formalized solution to migrate the existing indigeneous reporting and database tools to new generation platform
• Conduct regular meetings with various 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.
• 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.
• 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/BusinessObjects/MSBI) for the Business Data Repository
• Govern the development of the formalized solution to migrate the existing indigeneous reporting and database tools to new generation platform
• 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.
• 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, HP Vertica, BOXI R3, LiveOffice, Informatica, Shell/Perl/PowerShell scripts SharePoint, Dial, SQL Server, SSIS, SSAS, SSRS

Confidential, NYC

BI Architect/PM

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
• 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 SSAS 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. SSAS 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, Live Office, Crystal Reports 2008, MSBI SSIS, SSAS, SSRS, Informatica, Perforce, SharePoint, Autosys, Shell/Perl/PowerShell scripts

Project Manager/BO Consultant

Confidential

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.
• Conduct regular meetings with clients for reporting on progress of the project as well as presenting new solutions.
• 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, SSIS,SSAS,SSRS, Perforce, SharePoint, Autosys.

Systems Analyst/Team Lead

Confidential

Responsibilities:

• The reporting streams were divided in broad verticals called PBCore, MAC, PBXSR and Management. Lead the PBCore and then Management and PBXSR verticals.
• The Management reporting stream produces highly critical and sensitive reports for Confidential ’s PB Management. Was responsible for end to end solution which included Business analysis, Data modeling, database design, ETL development and Reports development and user signoff.
• Implemented Proxy vote reporting using BO-XI.
• Lead the project to automate the distribution of 1099 and 1042 (tax statements) reports through RDS (Report Distribution System)

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

Systems Analyst/Team Lead

Confidential

Responsibilities:

• Legacy system study and creation of functional and technical specification documents
• Co-ordination with business users and data owners. Reporting the progress and various metrices.
• Design, development and implementation of the old MS Access based reporting process using new and more efficient design and production platform
• 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 Emirates Bank (EBI)
• 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 Co-ordination System (MICS)

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

Confidential

Systems Analyst/Team Lead

Responsibilities:

• Systems Analysis thru client interaction, preparing functional designs, coding business and data centric components using VB and COM, building and deplyoing ActiveX Dlls, Testing and implementation was carried out by me.
• The Dynamic Crystal Report generator, a highlight feature, was conceived and implemented by me which helped win a lot of market share for the product across Andhra Pradesh.

Environment: Windows NT/2000/98, Visual Basic 6.0, Crystal Reports 8.0, MS SQL Server and MSDE