Summary

• More than 10 years of experience in Data Warehouse and Business Intelligence
• Managed and Implemented BI and DW project from start to End
• Experience in Data Warehousing and Data Mining
• Experience in Infrastructure planning, capacity planning and system implementation
• Experience in Leading and Managing team
• Experience in gathering requirements from user for DW and BI Applications
• Experience in Resource, Team and Project Management
• Experience in Finance,Healthcare,Logistic,Retail,Insurance
• Experience in implementing POWER BI
• Experience in Hive, Hadoop Big Data
• Experience working in Scrum, Agile and waterfall methodologies
• Experience in implementation through SSAS/SSIS/SSRS
• Implemented DW with Kimball and Inmon BI methodologies
• Experience in No-SQL
• Experience with Microstartegy
• Experience working with Microsoft Gold partner
• Experience of Visualization software such as Qlik view, Tableau
• Experience in OLAP schema design, cube development, data warehouse design
• Experience with Excel Services, Share point, Performance point and ProClarity
• Implemented KPI and Dashboard
• Experience in Data Warehousing, Data Mart and Cube Development
• Experience in Master Data Services and Data Quality Services
• Experience in Data Governance
• Worked with high performance teams developing and implementing state-of-art data warehouse applications. Ability to understand or get the customer to articulate the business needs in terms of business value
• Strong expertise as solution architect designing and delivering solution deployment architecture, Infrastructure sizing, performance and scalability options, benchmarking tuning application, database and hardware for test, development and production environment
• Experience in Data Modeling using ERWIN, Backup tool Red-gate sql backup.
• Experience in Database Backup, Recovery and Disaster Recovery procedures
• Experience in Microsoft Dynamics
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs

Professional Experience:

Confidential

DW/BI Architect/Lead

Responsibilities:

• Leading the Team for Data Warehouse and Business Intelligence Implementation
• Create Vision and Roadmap for DW/BI implementation for Clients
• Architect the strategy to implement data warehouse and business intelligence for the organization
• Presenting and providing solutions to Executive for business process
• Resource Management for DW and BI implementation
• Mentors team in development of ETL, Model and Analytical Component
• Project Management, Estimation and Manage delivery to Business
• Manage the workflow and progress of key projects from initial project inception to the actual project launch/ completion. This includes meeting with key stakeholders to define project scope, plans, goals, determining and monitoring project milestones, timelines, deliverables, and metrics
• Defining Strategy and architecture comprising of different tools for each layer and presenting to different stakeholders
• Hands on the each phase of project helping team to deliver efficient solution in Modeling, ETL and Analytics

Confidential

DW/BI Architect

Responsibilities:

• Team Lead for Data Warehouse and Business Intelligence Implementation
• Architect the strategy to implement data warehouse and business intelligence for the organization
• Lead the Data warehouse and Business Intelligence implement process from start to end
• Managed the workflow and progress of key projects from initial project inception to the actual project launch/ completion. This includes meeting with key stakeholders to define project scope, plans and goals, determining and monitoring project milestones, timelines, deliverables, and metrics
• Determine best technical solutions to satisfy business and functional requirements. Develop long range plans to provide adequate use of current technology in support of business
• Handled Requirement Gathering process, data analysis and data quality issues
• Integrated Big data in DW and Visualization using Excel
• Initiating the data modeling process with dimensional modeling, ETL architecture
• Project and Resource Management
• Implemented Master Data Management
• Leading the Data Governance
• Presented architecture and plan to the executives
• Improved the Productivity of Employee by reducing analysis time of days hours to minutes
• Saved man hours by training users to create their own analysis in a very simple way and quality use of IT hours
• Efficient Decision making based on data have helped company in big way in saving money in personalized and efficient marketing and better return
• Implemented Power BI architecture
• Managed the resources for ETL and BI Development
• Trained users for data warehouse and BI usage in Excel and Power Pivot
• Meeting with Executive and gather the requirement for KPI
• Planned, Design and helped in Implement Dashboard using KPI on SharePoint Environment
• Lead the testing and auditing requirement with the team including analyst
• Implemented DW and BI for individual business process such as sales, marketing, product inventory, purchasing etc.
• Created SharePoint environment for sharing analysis with users using excel
• Services and other SharePoint services
• Designed the Maintenance procedure for DW and BI Environment

Environment: SQL Server 2005/2008/2012,Power BI,PowerPivot, IIS, Management Studio, Erwin, Enterprise Manager,SSIS,SSAS,SSRS, MDX,Crystal Report-SQL, Share point 2010/2013,Qlik View, Tableau, Microsoft Dynamics, Microstartegy

Confidential

Lead Business Intelligence Architect/Analyst

Responsibilities:

• Serve as primary contact for the operational needs of the Data Warehouse
• Advise senior management on leading trends, best practices and opportunities on BI and analytics.
• Implemented Data warehousing and Business Analytics with SSAS
• Implemented Data warehousing and data marts as per user requirement.
• Created a central environment with important business rules to get accuracy in data.
• Supervised and guided the design, development, testing and implementation activities for the entire project using structured methods/techniques.
• Architect DW and BI implementation for organization
• Implemented the DW and BI project from base. Gathering user requirements to implementation.
• Trained the user about the technology and how to use that and improve the productivity
• Planned different implementation strategy for different levels of user in organization
• One of the reasons Program got extension and better funding because of great reporting and analysis out of data.

Environment: SQL Server 2000/2005/2008, IIS, Management Studio, Erwin, Enterprise Manager,SSIS,SSAS,SSRS, Crystal Report-SQL, BCP, Replication, Report Server, Report Builder, Sql Server Profiler Microsoft Access, Share point, Performance Point Service, Qlik View, Microstartegy

Confidential

SQL Server DBA/Developer

Responsibilities:

• Development Database Maintenance of SQL Server on Windows 2000 advanced server.
• Created user defined data types and added them to model database for future purpose
• Developed schema object like table, view, and index.
• Setup SQL mail services using Outlook client and Exchange Server
• Used DTS, BCP, DBCC and SQL-Profiler extensively.
• Planned and tested processes for backup and recovery.
• Helped in Data warehouse development
• Managed Replication databases fixing the errors when they arise.
• Run DBCC consistency checks, and fixing data corruption in application databases.
• Created logical and physical data modeling for development database using Erwin Tool
• Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to Users and groups.
• Worked on Crystal Reports for Reporting.
• Performed Diagnosis Tuned database and SQL statements as and when required.
• Data migration import export - BCP from Excel and Access file to SQL Server
• Worked on DTS packages for transferring data from various data sources like Oracle, MS Access, Excel, .Txt file, .CSV files.
• Worked with developers to tune the queries, run scripts and move the database from production to development servers
• Developed Application using VB.Net

Environment: SQL Server, T-SQL,.Net, Crystal Report, Query Analyzer, Outlook, DTS, BCP, SQL-Profiler, Enterprise Manager, Windows 2000.