Data Sql Server
Resume:
Anand Dasari
*****.******@*****.***
Anand Dasari
BI Architect
Professional Summary:
Over 15 years of experience in Software industry involved in designing, development, implementation, and maintenance.
Strong design skills and thorough understanding of object-oriented methodology.
Specialized in developing backend business objects for enterprise applications.
Experience in gathering requirements from the client and building analysis model
Experience in all phases of software development and quick learning ability.
Experience in mentoring, motivating and leading small to medium size team
Extensive experience in data modeling using ERwin, Visio.
Well versed in using Visual Studio 2005, SQL Server 2005, SQL Server 2008, and SQL Server 2012 for developing .NET applications.
Experience in ETL process using DTS,SSIS
Experience in building Data marts, OLAP Cubes using SSAS.
Experience in generating complex reports using SSRS.
Involved in configuring and deploying the reports for internal and external users.
Experience in writing efficient MDX queries.
Extensive experience in Building Intelligent projects mainly on Microsoft BI stack (SSIS, SSAS,SSRS)
In depth Knowledge in Transact SQL Programming and writing efficient Queries.
Advanced programming experience with .NET Technologies (C#, ASP.NET and VB.NET)
Intensive exposure of SQL Server Integration Services (SSIS), stored procedures, Triggers, Functions, Views, Jobs, Alerts.
In depth knowledge in Kimball methodology.
Developed efficient custom queries using MDX in SSAS.
Currently working on developing SSIS packages for high volume transactions (2 mil per day) .
Worked extensively in developing DTS packages in SQL server 2000
Proficient with database servers like SQL Server 2005/2008/2012, SQL Server 2000, MySQL, and Oracle 8i/9i.
Experience in Azure migration .
Extensive experience developing BI Analytics using Power BI and Tableau.
Worked as development SQL DBA to design databases and to write efficient queries.
Well versed with XML Technologies (Web Services, .NET Framework, XPath, XSLT).
Proficient in Interactive Web application development with Technologies ASP.net, ASP, JavaScript, VBScript, XML, XSLT, HTML.
Having In-depth knowledge in 3-Tier Architecture.
Actively involved in requirement analysis study and full SDLC.
Implemented Projects using Agile, Iterative methodologies.
Extensive functional experience in Insurance, Toll, Energy, Telecom, Billing, Health Care and Banking industries.
Extensive experience in developing decision support Datamarts.
Professional Skills:
Database: SQL Server 2017/2016, SQL Azure, Snowflake, MySQL, Oracle, Access,
Web technologies: ASP.NET, ASP PHP, J2EE, DHTML, XML/XSL, ADO, ADO.NET, SOAP, Web Services, IIS
Languages: C#, VB.NET, VB 6.0,JAVA
Reporting tools: Seagate Crystal Reports 8.5, 9.0, Infragistics, Dundas. Qlikview
Scripting Languages: Java Script, VB Script
Tools/Libraries: VS.NET/VS6, TFS,VSS, Github, Clearcase, COM/COM+, ActiveX, Rational Rose, Web service Studio, CLR Profiler. Sql Profiler, SSIS, Reporting services, SSAS, MDX, ERwin, Visio.
ER Studio
Operating Systems: Windows server 2016/2012R2.
Certifications:
Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008(70-452)
Microsoft Certified Technology Specialist (MCTS) SQL Server 2005 BI (70-445)
Microsoft Certified Professional in SQL server 2000.
Brain Bench Certified Oracle PL/SQL, RDBMS Concepts.
Qlikview 11Certifified developer.
Certified Business Intelligence Professional (CBIP) specializing in Data Analysis and Design.
Education:
B.Tech (Electrical & Electronics Engineering ), JNT University, INDIA
Professional Experience:
Novedea Systems 08/2005 - Present
Lead,Architect Business Intelligence
Primary responsibilities Include “Leader of the Business Intelligence Division, Product Architecture, Requirement Analysis, Prototyping &guiding Developers, Proof of Concepts, Efforts Estimation, Developing High Level design(HLD),Developing frameworks, setting up development and testing platforms, Coding complex modules, reviewing low level design, resolving complex issue and technical consultation.
Solutions include home grown software platform for business intelligence applications.
Working with software vendors to provide the cost benefit analysis for client project implementations.
Technical screening mentoring and onboarding of consultants to deliver the project with peak performance.
Oversees Business Intelligence road map and works closely with business units to ensure IT roadmap align with the overall strategy.
Architected and built Datawarehouse from design to implementation and support
Built the BI division from 6 consultants to 120 consultants.
Conducted mentoring and training sessions for consultants to ramp up the newer versions and technologies.
As an Architect, developed dimensional modeling and capacity planning for clients.
Worked closely with Microsoft, Tableau and Qlik to initiate partnership and successfully maintain the partnership for longer duration.
Implementing Snowflake POCs for clients and conducting training.
PROJECTS:
Bank of America, Dallas, TX 07/2014 – 08/2015
BI Architect/ Sr BI Consultant
Home Equity Line of Credit
HELOC DataMart project is a to build data warehouse and generate operational and management reporting for strategy and analytics.
Architect the ETL Framework and dataflow solution
Lead the team of 4 developers and mentored the team members.
Design the end to end process flow to load the data from Teradata and DB2 sources into SQL server Destinations.
Generated solution design document and finalize the requirement document.
Involved in Capacity planning for the Database and application servers for Testing and production environments.
Involved in designing the security model for geography, function domain users.
Designed E/R diagrams, Data modeling, Schemas, and database tables in SQL server.
Implemented Multiple BI solutions using PowerBI, Tableau.
Migrated the Databases from SQL server to Azure SQL.
Involved in designing the dimensional modeling and finalize the Facts and dimension tables.
Developed SSIS Packages to perform Data loads from various types of sources files (Teradata, DB2). Involved in de-duplication, Data Cleansing, and transformation of data.
Developed and performance tuning of complex stored procedures, user defined functions and views for data migration.
Involved in configuring and deploying the reports for internal and external users.
Environment: Azure, SQL Server 2017/ 2012, SQL Server Business Intelligent Studio 2012, SSIS, SSAS, SSRS, PowerBI, Tableau, C#,VB.net, SharePoint 2010,Team Foundation Server
Argo Data, Dallas, TX 05/2013 – 07/2014
BI Architect/ Practice lead
Analytical Science Group – Business Intelligence
As lead of Analytical Science Group –Business intelligence I am involved in providing business intelligence Architecture, design, development and support for Cash Inventory Optimization (CIO),
Workforce Management (WFM), Complaints Management, Teller solutions, lending solutions, management Insight Services (MIS), Fraud, Sales and services EMPI, EDM for banks. I am the member of team that was listed as top 20 most promising Data analysis’s consulting companies by CIO Review.
Architect the ETL Framework and dataflow solution for the enterprise.
Mentored the business analysts to prepare the requirement documents for Business intelligence and data analytics and data visualization.
Lead the team all phases of Business intelligence project software development.
Involved in Capacity planning for the Database and application servers for testing and production environments and worked with TSE to set up the server
Architected the SSIS solutions and Error handling for ETL.
Worked with Application developers to create and maintain the Enterprise Data dictionary.
Involved in designing the Business Unit model for the end clients.
Designed E/R diagrams, Data modeling, Schemas and database tables in SQL server 2008R2 and SQL Server 2012.
Build the automated deployment scripts and reduced the deployment time from 100 hours to 30 hours and conducted the training session for TSE on various SQL BI components and services.
Involved in designing the dimensional modeling and finalize the Facts and dimension tables.
Created and maintained reports for Sales and services solutions, Sales Management, Teller, Lending and Cash Inventory optimization.
Worked with business users to finalize the definitions for definitions KPIs, graphs and charts.
Developed SSIS Packages to perform Data loads from various types of sources files (Flat files, CSVs, Excel, XML). Involved in de-duplication, Data Cleansing and transformation of data.
Build and partitioned the cubes using SSAS with multiple fact tables.
Build the data driven subscription, Security for reports.
Extensively used MDX to build the multi-dimensional reports in SSRS
Involved in configuring and deploying the reports for internal and external users.
Lead the team of 5 certified SQL BI developers.
Created the business intelligence strategy document for the enterprise for 2014.
Actively involved in mentoring the developers, Business analysts and QA team members in implementing the best practices in SQL server BI project implementations.
Environment: SQL Server 2005,2008 R2, 2012, SQL Server business Intelligent studio 2005,2008R2 and 2012 Data tools, SSIS, SSAS, SSRS, C#,VB.net, .Net Framework 2.0,Team foundation server. ADS (Argo proprietary language)
Bank of America, Dallas, TX 06/2012 – 05/2013
BI Architect/ Sr BI Consultant
SDR /HTS Information Services
SDR project is a “Single source of truth” Business Intelligence model used to create accurate management reporting and analysis that is distributed to operational leadership for the purpose of performance management, strategy and analytics.
Architect the ETL Framework and dataflow solution.
Involved in preparing solution design document and finalize the requirement document.
Involved in Capacity planning for the Database and application servers for Testing and production environments.
Involved in designing the security model for geography, function domain users.
Designed E/R diagrams, Data modeling, Schemas and database tables in SQL server 2008.
Involved in designing the dimensional modeling and finalize the Facts and dimension tables.
Identified the Source Data sets from EQUATOR for Short Sale, HAFA, DIL and REO Data.
Worked with business users to finalize the attribute definitions for the call center data from Avaya and other call center systems.
Developed SSIS Packages to perform Data loads from various types of sources files (Flat files, CSVs, Excel, XML). Involved in de-duplication, Data Cleansing and transformation of data.
Developed and performance tuning of complex stored procedures, user defined functions and views for data migration.
Build and partitioned the cubes using SSAS with multiple fact tables.
Developed Operational reports, Short Sale Active, decisions, completions, approval, rejections, and performance reports for HTS project
Developed Call center metrics, Daily, hourly, Month to date, quarter to date vendor based, LOB and location based reports on inbound and out bound Call center data.
Developed the EVENT MODEL reports to management team for performance review.
Build the data driven subscription, Security for reports.
Extensively used MDX to build the multi-dimensional reports in SSRS and deployed in SharePoint 2010
Involved in configuring and deploying the reports for internal and external users.
Environment: SQL Server 2008 R2, SQL Server Business Intelligent Studio 2008, SSIS, SSAS, SSRS,MDX, C#,VB.net, .Net Framework 2.0, SharePoint 2010,Team Foundation Server
CBRE, Dallas, TX 07/2010 – 05/2012
Architect/ BI Consultant
Business Analytics 2.0
Business Analytics 2.0 project is aim to stream line the data loads/Data warehouse/Reports for various clients and build a centralized application to cater the business intelligence solution for Commercial real estate domain
Architect the Business intelligence solution.
Involved in preparing the data dictionary for data mapping and data load process.
Involved in Capacity planning for the Database and application servers.
Involved in designing the security model for geography, function domain users.
Designed E/R diagrams, Schema and database tables in SQL server 2008.
Developed the data modeling using ERwin.
Involved in designing the dimensional modeling.
Architected Data migration plan using SSIS.
Developed SSIS Packages to perform Data loads from various types of sources files (Flat files, CSVs, Excel).
Developed complex stored procedures, user defined functions for data migration.
Involved in code review, performance tuning.
Build cubes using SSAS with multiple fact tables.
Developed Operational reports, financial reports, scorecards, Survey reports, Management reports, performance reports and work order reports.
Build the user friendly dash board in SharePoint.
Build the data driven subscription for reports.
Extensively used MDX to build the multi-dimensional reports in SSRS and deployed in SharePoint 2010
Build the KPIs using performance point server and deployed in SharePoint.
Involved in configuring and deploying the reports for internal and external users.
Environment: SQL Server 2008,Erwin, SQL Server Business Intelligent Studio 2005, SSIS, SSAS, SSRS, C#,VB.net, .Net Framework 2.0, SharePoint 2010,Team Foundation Server
American Home Mortgage, Dallas, TX 03/2010 – 07/2010
BI Consultant
EBI
EBI project is to build the EBI Data mart and provide automated reporting both for operational and managerial reporting for foreclosure, loss mitigation, REO and call center departments.
My involvement as BI consultant/Architect is to provide warehouse road map identifies the data points for integration, provide access security for reports and to build the automated reports to optimize the business process.
Involved in Requirement gathering meetings with business users and analysts.
Involved in preparing the business meta data and technical metadata.
Designed E/R diagrams, Schema and database tables in SQL server 2005/2008.
Involved in designing the dimensional modeling.
Architected Data migration plan using SSIS.
Developed SSIS Packages to perform Data loads from various types of sources files (Flat files, CSVs).
Developed complex stored procedures, user defined functions for data migration.
Involved in code review, performance tuning.
Build cubes using SSAS with multiple fact tables.
Implemented Kimball methodology in building Facts and dimension tables.
Scheduled the ETL jobs for various data load
Developed Operational reports, management reports, performance reports and call center reports.
Build the user friendly dash board in SharePoint.
Build the data driver subscription for reports.
Involved in configuring and deploying the reports for internal and external users.
Environment: SQL Server 2005/2008, SQL Server Business Intelligent Studio 2005, SSIS, SSAS, SSRS, C#,VB.net, .Net Framework 2.0, SharePoint 2007, Visual SourceSafe, Redgate Tools
Essilor USA, Dallas, TX 09/2009 – 03/2010
BI Consultant
Enterprise Pricing
Enterprise pricing project is to build the central pricing data mart to help marketing team to publish the yearly catalog. It also provides the pricing trend over the years and different versions.
My involvement as BI consultant is to provide the client necessary path to build DataMart and reports using all components of SQL BI (SSIS/SSAS/SSRS).
Involved in Requirement gathering meetings.
Analyze the source data from the existing Optifacts data from various manufacturing labs.
Designed E/R diagrams, Schema and database tables in SQL server 2005.
Design the infrastructure for the various environments (Staging and Production).
Involved as DBA in various task not limited to file structure, log shipping, Deployment, Back up schedule.
Architected Data migration plan using SSIS.
Developed SSIS Packages to perform Data loads from various types of sources files (Flat files, CSVs).
Developed complex stored procedures, user defined functions for data migration.
Involved in code review, performance tuning.
Design the dimensional modeling for data warehouse.
Scheduled the ETL jobs for various data loads.
Involved in configuring and deploying the reports for internal and external users.
Deployed the SSIS packages, Cubes(SSAS) and rdls(SSRS) in various environments
Environment: SQL Server 2005, SQL Server Business Intelligent Studio 2005, SSIS, SSAS, SSRS, C#,VB.net, .Net Framework 2.0, Visual SourceSafe, Redgate Tools
BenefitMall, Dallas, TX 12/2008 – 08/2009
Architect
BenefitPoint Integration
Benefit Point Integration Project is to Converting heterogeneous legacy systems and build new data warehouse. Its targeted to Marketwise roll out in to new warehouse. Designed and Build the Sales, Commission, Revenue, Accrual Revenue Data marts .
Involved in Gap analysis for the integration.
Involved in JAD sessions with end users/Business users and other team members.
Worked with Business analysts in requirements and UAT meetings.
Designed E/R diagrams, Schema and database tables in SQL server 2005
Architected Data migration plan using SSIS.
Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files, CSVs).
Migrated DTS packages to SSIS Packages.
Developed complex stored procedures for data migration
Design the dimensional modeling for data warehouse.
Proposed multi fact table cube design to build data warehouse using SQL server analysis services 2005.
Scheduled the ETL jobs for various data loads.
Involved in proposing the capacity management for various environments.
Involved in configuring and deploying the reports for internal and external users.
Deployed the SSIS packages, Cubes(SSAS) and rdls(SSRS) in various environments
Involved in Change Management requests using InfoPath
Implemented AGILE process and involved in estimations for each sprint, and track the project in daily scrums.
Involved in escalating bottle neck issues to the management.
Used Redgate Tools to push the database objects into various environments.
Environment: SQL Server 2005, SQL Server Business Intelligent Studio 2005, SSIS, SSAS, SSRS, C#,VB.net, .Net Framework 2.0, Visual Studio Team explorer, Visual SourceSafe, InfoPath,
PVCS, Redgate Tools
CBRE, Dallas, TX 09/2008 – 12/2008
BI Architect
National Benchmark Initiative
National Benchmark Initiative project is to provider the Business Intelligence solution for survey of the participating clients on various cost involved in property management.
This project is target to migrate the existing reports developed in Microstrategy to SSRS 2008.
Architected Data migration plan using SSIS.
Developed complex stored procedures for data migration.
Design the dimensional modeling for data warehouse.
Proposed multi fact table cube design to build data warehouse using SQL server analysis services 2008.
Created complex MDX queries to for the datasets in SSRS using third party MDX query builder “Intelligencia Query for BIDS and Reporting Services “
Involved in proposing the capacity management for various environments.
Developed custom functions in reporting services using VB.net
Involved in configuring the reports using Report Manager.
Deployed the SSIS packages, Cubes and rdls and various environments
Involved in JAD sessions with end users and other team members.
Worked with end users in requirements and UAT meetings.
Environment: SQL Server 2008, SQL Server Business Intelligent Studio 2008, SSRS, SSIS, SSAS, MDX, Microstrategy, C#,VB.net, .Net Framework 2.0, Visual Studio Team Explorer
United Health Care Student Resources, Plano 11/2007 – 08/2008
Team Lead/Architect
Project: UAI Integration
UHCSR is a medical insurance provider that deals with University student medical insurance claims. The UAI Project is to load the student membership, revenue, claims, and TPA data into UHC data mart.
As a Team lead / Architect my role is to Propose, Design solutions for the integration project.
To develop Data modeling for the Data warehouse.
To estimates for each sprint, and track the project in daily scrums.
Get the requirements from clients and design ETL process for data loads.
Builds the data warehouse using SSAS. Involved in writing queries MDX
Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files, CSVs).
Involved in writing efficient Queries, Stored Procedures Functions, triggers.
Involved in tuning and performance improvement in stored procedures and functions, Indexes.
Involved in Change Management requests using InfoPath.
Conducted code reviews on Stored Procedures and SSIS packages.
Involved in Deploying SSIS Packages, Scheduling the packages
Design OLAP cubes in SSAS.
Write and alerts for jobs on failure.
Involved in Converting existing Cubes in Cognos to SSAS.
Involved in Converting, enhancing the existing reports in Cognos to SSRS
Involved marinating existing Datastage 7.1 Data loads.
Involved in escalating bottle neck issues to the management.
Designed E/R diagrams, Schema and database tables in SQL server 2005.
Involved in capacity management and Hardware requirements for databases in various environments.
Generated the complex reports using SSRS and deploy them in various environments.
Environment: SQL Server 2005, SQL Server Business Intelligent Studio 2005,SSIS, SSAS, MDX, SSRS, Datastage 7.1, Cognos 6.0,C#, VB script, .Net Framework 2.0, InfoPath, SharePoint Server SXML, VISUAL STUDIO.NET, VISUAL SOURCE SAFE, XML SPY
Rent A Toll, Plano, TX 03/2006 – 10/2007
Team Lead
Project: Pass24
Pass24 is a toll payment service option offered as a convenience service for car renters who use toll roads. Customers with Pass24 have access to unlimited usage of the toll roads in the region for a daily fee with the charges added to your rental agreement for extra convenience. Just agree to the Pass24 terms (Opt-In), pay the daily rate along with your car rental fee, and use the express toll lanes. No toll transponder is needed and toll usage is unlimited.
Responsible for designing and development of Pass 24 product.
Developed SSIS packages for to Extract, Transform and Load data (ETL) that we get from different clients such as Toll authorities, Rental Car agencies.
Used SQL Server Integration Services extensively.
Configured the SSIS Packages in SQL server jobs.
Designed, Developed OLAP Cubes in SSAS
Developed and deployed .dtsx files ( SQL server integration services files) in SQL Server 2005
Imports the data from different source files (Excel, Comma delimiter, Access files, XML)
Developed portal for users in asp.net, SQL server 2005.
Used webforms, ADO.net, Web services extensively.
Designed and developed a plug-n-play reporting framework that captures the customer click behavior data which can be mined by business analysts to formulate strategies for targeted offerings.
Developed Process, Reports in finance modules consists of AR, AP, and Invoice
Developed reports for sales team
I was in involved in requirement gathering from parties in involved in pas24( Ex: Rental Car Agencies and toll Authorities)
Designed E/R diagrams, Schema and database tables in SQL server 2005.
Wrote stored procedures, triggers, functions, alerts in PL/SQL.
Deploy and Monitor the SQL server Jobs
Back-up and Restore databases in Development, UAT and Production environments.
Responsible for release management, Deployment in dev, UAT, and production environments.
Actively attended the review meetings and interacting with the Business and Functional users for the requirements
Write and alerts for jobs on failure.
Involved in release scheduling and development monitoring with offshore team.
Helped the management in project estimates and recruiting consultants.
Environment: SQL Server Integration Services 2005, SSAS, MDX, SQL Server 2005, SQL Server Business Intelligent Studio 2005, SSAS, MDX C#, VB script, .Net Framework 2.0, ASP.net, Infragistics, XML, VISUAL STUDIO.NET, VISUAL SOURCE SAFE, XML SPY
Chevron Oronite, Houston, TX 10/2005 – 03/2006
Team Lead
Project: Global Sales
Chevron Oronite Company LLC is one of the world's leading developers, manufacturers and marketers of petroleum additives for lubricant base stocks and fuels. It is a subsidiary of Chevron Texaco Corporation, one of the largest energy companies in the world. Currently, Chevron Oronite manufactures over 250 different finished additive products in nine facilities around the world, and delivers them to bulk terminals worldwide. Chevron Chemical Company relocated to Houston, Texas.
Import the data into JDE (JDE to access DB), MySQL to SQL Server 2000 Using DTS packages.
Schedule the DTS packages for weekly, monthly, Quarterly reports
Developed Reports for sales and projections using Crystal reports 9.0
Publish the Reports in web using ASP.net
Developed triggers, Stored procedures, functions
Marinating Oronite Global Sales Data Mart.
On demand reports support.
Coordination between the chevron ITC and Oronite IT support.
Demand Management and Collaborative Forecast and Planning reports application Support.
Actively attended the review meetings and interacting with the Business and Functional users for the requirements
Providing permanent fixes to the Production related problems.
Working on different Work Requests as per specifications.
Providing solutions to improve the existing processes.
Troubleshoot production problems.
Solving the user requests in an effective manner and documenting them for further reference.
Provided fast solution to instant problem.
Direct interaction with the end users.
Built up very good relationship with Client.
Provide customers with timely outage reporting when necessary.
Environment: SQL Server 2000,MYSQL, C#, ASP.net, VBscript, JavaScript, ASP, Crystal Reports 9.0, XML, VISUAL STUDIO.NET, VISUAL SOURCE SAFE, XML SPY
Verizon, Dallas, TX 05/2004 – 10/2005
Sr. Analyst Programmer
Texas Instruments, Dallas, TX 10/2003 – 05/2004
Software Developer
UPS, Chicago, IL 06/2002 – 09/2003
Programmer/Analyst
Alibre Inc., Dallas, TX 03/2002 – 06/2002
Software Developer
Citibank, KL, Malaysia 05/2001 – 02/2002
Analyst Programmer
Medijaring Sdn Bhd, KL, Malaysia 09/2000 – 05/2001
Software Engineer
Masterminds IT Solutions, HYD, INDIA 08/1998 – 02/2000
Software Engineer
Contact this candidate