Business Intelligence technical lead developer/ architect
Resume:
Srinivasa Viswanatham
Email: **************@*****.***
360-***-**** (Cell)
________________________________________
Professional Summary:
• 15 years in the IT domain working on Microsoft technologies and applications.
• Microsoft Certified Technical Specialist : Business Intelligence Development and Maintenance.
• Specialized in architecting and implementing BI/DW projects to enable informed decision making.
• Specialized in managing projects from gathering requirements through implementation.
• Experience in T-SQL, Database Analysis, Design, Development, SQL Server Stored procedures, Functions, Triggers and Views.
• Skilled in SQL 2005/2008 Business Intelligence tools, Data Warehousing and ETL processes.
• Expert in SQL Server Reporting Services, Integration Services and Analysis Services.
• Expert in Ad-hoc reports, drill down and drill through reports and cross tab reports.
• Working knowledge of C#, ASP.NET. Well trained in .NET framework and technologies.
• Expert in the complete Software Design life Cycle.
• Technical / team leader experience.
• Excellent Communication Skills, team player and Project Management Skills.
Professional Abilities:
• Build requirements with key stakeholders and users
• Perform Business Analysis
• Design for Scalability, Usability, Performance, Extensibility, Reliability
• Estimation, Scheduling and Scope Control
• Meeting and Managing Client Expectations
• Adherence with Project Management Standards
• Reliable Deployment, Usable Installation packages
• Configuration Management/ Version Tracking/ Source Code control
• System Integration
• Advanced Problem Solving skills
• Rapid Trouble shooting
• Documentation for General, Technical or Business audience
• Interpersonal Communication
• Strong Team Work
• Customer Focused
Technical Summary:
Business Intelligence:
• Advanced extensible reporting skills using SQL Server Reporting Services (SSRS)
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS)
• Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS)
• Ability to deliver comprehensive BI through MS solutions including MS Excel, Microsoft office SharePoint Server and Performance Point Server.
Technical Skills:
• MS SQL Server 2005/2008/R2, T-SQL, MDX, Stored Procedures, Functions, Triggers, Views
• MS SQL Server Reporting Services, Analysis Services and Integration Services
• MS Office Tools
• Visual SourceSafe
• C#, ASP.NET
• DB2, CICS, VSAM, COBOL, IMS DB/DC, JCL
Professional Experience:
Client : Microsoft, Redmond WA (Dec 2011 » Present)
Technical Architect/ Lead Developer
• Actively support the Microsoft Global Outsourcing (MGO) BI platform and Office 365 BI, where strategic business information resides in a centralized location.
• Microsoft Global Outsourcing Unit oversees Microsoft’s outsourcing strategy, contracts and business relationships with third-party support partners worldwide.
• The applications utilize SQL Integration services to move data from transactional sources into a centralized dimensional database. This database is the basis for SQL Server Reporting Services reports and SSAS cubes that are in turn the ultimate source for Excel Pivot table analysis.
• Actively engage in design discussions for all Business Intelligence and database initiatives.
• Architect and execute Business Intelligence solutions including ETL, OLAP and Reporting requirements. Identify client needs and propose solutions.
• Responsible for translating business data requirements into conceptual, logical and physical data models.
• Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS)
• Built the data warehouse based on dimensional modeling/methodology.
• Analyze, Build and maintain SQL Server Integration Services (SSIS) packages for loading Data Warehouse.
• Manage and lead team in building data integration packages and reports in Business Intelligence platform.
• Implement Control flow, data flow, logging, event handling and package configurations using SSIS.
• Develop and deliver dynamic reporting solutions using SQL Server Reporting Services (SSRS).
• Implement report layout, report parameters, report items, drill through and interactivity in a report.
• Reporting services integration with SharePoint, deployment and using reporting services in SharePoint.
• Built PerformancePoint Dashboards in SharePoint.
• Created Stored Procedures, Views, and Functions.
• Responsible for performance tuning of stored procedures using SQL profiler and Database tuning wizard.
• Designed and developed Data Warehouse/OLAP solution.
• Designed and developed Complex SSAS cubes based on OLAP reporting needs.
• Develop and Deploy SSAS databases and objects. Diagnose and resolve performance issues.
• Implement custom logic in a cube using MDX.
• Skills : MS SQL Server 2008 R2/T-SQL, MS Reporting Services, Microsoft Visual Studio, Business Intelligence Development Studio, Integration Services, Analysis Services, Share point, MS Office
Client : Washington State Employment Security Department, Olympia WA (July 2010 » Dec 2011)
Technical Lead/ Senior developer
• Actively engage in design discussions for all Business Intelligence and database initiatives.
• Architect and execute Business Intelligence solutions including ETL, OLAP and Reporting requirements. Identify client needs and propose solutions.
• Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS)
• Design and manage the team in developing complex SSAS cubes based on OLAP reporting needs.
• Develop and deliver dynamic reporting solutions using SQL Server Reporting Services (SSRS) for New Generation Tax System application.
• Build, test, deploy and manage reporting needs as requested by the business unit leaders using SQL Server Reporting Services.
• Implement report layout, report parameters, report items, drill through and interactivity in a report.
• Embed SSRS reports in custom applications.
• Created Stored Procedures, Views, and Functions.
• Responsible for performance tuning of stored procedures using SQL profiler and Database tuning wizard.
• Designed and developed Data Warehouse/OLAP solution.
• Designed and developed Complex SSAS cubes based on OLAP reporting needs.
• Develop and Deploy SSAS databases and objects. Diagnose and resolve performance issues.
• Implement custom logic in a cube using MDX.
• Design, Develop and Deploy SQL Server Integration Services (SSIS) packages for loading Data Warehouse.
• Implement Control flow, data flow, logging, event handling and package configurations using SSIS.
• Skills : MS SQL Server 2008 R2/T-SQL, MS Reporting Services, Microsoft Visual Studio, Business Intelligence Development Studio, Integration Services, Analysis Services, DB2, MS Office
Client: Washington State Department of Corrections, Tumwater WA (June 2004 » June 2010)
Senior Developer/ Consultant
• Actively engage in design discussions for all Business Intelligence and database initiatives. Identify client needs and propose solutions.
• Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS).
• Design, develop and deliver dynamic reporting solutions using SQL Server Reporting Services (SSRS) for Offender Management Network Information application.
• Build, test, deploy and manage reporting needs as requested by the business unit leaders using SQL Server Reporting Services.
• Implement report layout, report parameters, report items, drill through and interactivity in a report.
• Embed SSRS reports in custom applications.
• Mentor users on SQL and SQL Server Reporting Services (SSRS).
• Created Stored Procedures, Views, and Functions..
• Responsible for performance tuning of stored procedures using SQL profiler.
• Designed and developed Data Warehouse/OLAP solution.
• Develop and Deploy SSAS databases and objects. Diagnose and resolve performance issues.
• Implement custom logic in a cube using MDX.
• Design, develop and deploy SQL Server Integration Services (SSIS) packages for loading data mart.
• Implement Control flow, data flow, logging, event handling and package configurations using SSIS.
• Implement package logic by using variables.
• Skills : MS SQL Server 2008/T-SQL, MDX, MS Reporting Services, Microsoft Visual Studio, Business Intelligence Development Studio, Integration Services, Analysis Services, DB2, MS Office
DHL-Airborne Integration and Transition, Seattle WA (Oct 2003 » June 2004)
Technical Lead
• Lead team on transition efforts as part of integration process
• Involved in developing the system appreciation documents for several billing applications
• Created job flow diagrams, data flow and business process diagrams
• System analysis and development of billing application
• Technical Support for the team during development process
• Skills: IBM Mainframe, VS COBOL II, DB2, CICS, VSAM, JCL, MS Office tools.
Nationwide Insurance, Columbus OH (Nov 1997 » Sep 2003)
Projects with Nationwide Insurance
• Business Component Services
• Auto Class Plan M
• Auto Integration
• Auto Processing System
Team Lead/ Programmer Analyst
• Analysis, Design, Development, Implementation and Maintenance of several Mainframes applications.
• Involved in the business requirements analysis, high level design and program level specifications.
• Assigning tasks to team members and working with them closely in order to meet deadlines, and ensure a quality product.
• Involved in the preparation of test plans and setting up the test environment.
• Debugging, testing, defect fixing and transmittals to production environment.
• Skills: IBM Mainframe, VS COBOL II, DB2, CICS, VSAM, JCL, IMS DB/DC, MS Office tools
Education:
• Bachelor of Engineering from Sri Krishna Devaraya University, Andhra Pradesh, INDIA.
Certifications:
• Earned Certified Associate in Project Management (CAPM) title.
• Microsoft Certified Technical Specialist : SQL Server 2008 Business Intelligence Development and Maintenance.
Contact this candidate