Professional Experience Sql Server
Resume:
Thamizharasan Subramani
**************@*****.***
Database/Data warehouse Architect
Qualification Summary
Seasoned technical BI lead with over 13 years of professional experience specialized on data management, database development and administration, BI reporting, system integration and enterprise applications within several industrial verticals like Manufacturing, Telecommunications, Technology, Airlines and Hospitality.
Highlights of Qualifications:
Proficient with full development cycle of a Database/ Data Warehouse, including requirements gathering, design, implementation and maintenance.
Proficient in designing and maintaining databases for both OLTP and OLAP applications.
T-SQL Query / ETL / Report optimization (highly proficient)
Create flexible data model design that is scalable, reusable, while emphasizing performance and business needs.
Skilled in developing MS BI (SSIS/SSAS/SSRS) application
Ability to develop architectures for complex business systems
Professional Experience
Business Intelligence Consultant @ Microsoft 08/2014 – Present
Projects: ASG Finance, MSSALES
Redmond, WA.
Development and Architecture of Data Warehouse and Business Intelligence solutions, Responsible for the day to day administration of the Microsoft Finance BI application.
Leading team of 8, both onshore and offshore.
Re-designed cubes, removed numerous conflicting calculated members and added new ones as needed in SQL 2014 Tabular model.
Involved in BI semantic Model & CUBE(Multi-Dimensional and Tabular) implementation and maintenance
Cube partitioning – Tabular model
Designed and documented all the ETL/SSIS Plans.
Performance tuning of existing SSIS packages
Hands on experience with Cosmos; migrating SSIS to Cosmos for downloading commerce data to Cosmos and Cosmos to SQL Server.
Implemented efficient and effective performance tuning Stored Procedures, T-SQL.
Prepared the code for migration to test environments and coordinate the environment builds.
Technologies: SQL 2014, 2012, T-SQL, SSAS/SSIS/SSRS, MDX/DAX, PowerPivot, TFS
TATA Consultancy Services (TCS)
Client: Hilton Worldwide, Memphis, TN, USA 08/2011 – 7/2014
BI Architect
Led group of 5 people, and communicated over 20 people in diverse group to achieve internal development goal
Requirement analysis and design document, Interfaces with clients to define business objects, gather report requirements, architects data warehouse solutions, and balance responsibilities between on/off-shore resources to maximize productivity.
Studied, troubleshoot and configured corporate wide scheduling system. Parallelized and optimized schedule implementation decreasing load time span by ~50%.
Optimized corporate wide ETL/SSIS operations cutting the overall load time in half, which was critical achievement to support data delivery service level agreement.
Executed change management and release management processes based on business needs.
Report requirement gathering for both Cognos and SSRS; monitor report performance and assisted Cognos developer to improve the performance.
Assisted developers with release testing and application enhancements (improved searches, sorts, grooming, web page displays)
Configured TFS version control tool for the corporate BI
Installed, configured SQL 2005, 2008 R2, SSIS, SSRS and Cognos 8 – setting up Test and Stage servers.
Recognized for displaying excellent problem solving and team management skills.
Maintained BI architecture documents up-to-date.
Implemented Data archival and purge strategy by using SSIS; involved in server migration.
Technologies: SQL 2005, 2008 R2, SSIS, SSAS, SSRS, Cognos 8.0, MS TFS, Visio
TATA Consultancy Services (TCS)
Client: Verizon, Irving, TX, USA 02/2010 – 01/2011
Sr. DBA/Developer (CRMM)
Performed load balancing, failover tests for server and/or clients, database backup/restore strategy plan and implementation, SSIS package optimization that loads data into multiple servers
Troubleshoot and resolve performance issues with application server and database servers.
Provide technical solutions to developers to resolve SQL issues for different databases and SQL performance tuning. Help QA with test scope and test plan.
Provided programming, testing, performance tuning, and production support on MS SQL 2005 database
Resolved Production outages and system issues quickly. Prepared root cause analysis, and resolution.
ETL/SSIS optimization and provided permanent solution for long running SSIS.
Technologies: SQL 2005, SSIS, SSRS, TFS
TATA Consultancy Services (TCS)
Client: Hawaiian Airlines, Inc, Chennai, India 07/2009 – 01/2010
MS BI Lead
Responsible for understanding and reviewing requirements from clients and identifying data sources for the Data Mart
Led team of 12.
Involved in the Analysis and Design as a POC of ETL part of the entire solution
Developed SSIS Packages, SQL Server Stored Procedures and Views required for the ETL and Reports.
Involved in writing, testing and performance tuning of complex T-SQL queries required for the entire application
Created and maintained MS SQL Server 2008 DDL(Tables, Indexes, Procedures, Functions, Views, Triggers, Users) and DML scripts
Extensively worked on creating SSIS transformations like Conditional Split, Merge Join, Lookup, Sort, Aggregate, Pivot, Script Component etc.
Key contributor in capabilities like revamping security implementation, creating and documenting standard operating procedures and code review checklists etc.
Conducted knowledge sharing sessions to the rest of the team members on the functionality and database structure.
Reviewed ETL designs and codes and recommended changes if any
Technologies: SQL 2008 R2, SSIS, SSAS, SSRS
TATA Consultancy Services (TCS)
Client: Microsoft, Hyderabad, India 07/2007 – 06/2009
Sr. Database/Data Warehouse Analyst – MCRS, APAC Report
Interacted with clients to understand the business requirement and Develop Test, Debug SSIS/SSRS.
Developed Reporting Services Report Model/SSRS for user to create ad-hoc reports.
Involved in writing, testing and performance tuning of complex T-SQL queries required for the application.
Worked on production support environment like running of SQL jobs, creation and scheduling of SQL jobs.
Common responsibilities include peer review and issue logging.
Development and Architecture of Data Warehouse and Business Intelligence solutions.
Microsoft SQL Server Configuration, Upgrade and Maintenance
Database Administration, Performance Tuning and Optimization
Involved in ETL migration from Informatica 8x to SSIS 2008R2
Managing and administering Informatica 8x ETL packages
Technologies: SQL 2008 R2, SSIS, SSRS, TFS
Verizon, Chennai, India 06/2006 – 06/2007
Lead SQL Developer
Led team of 5.
Modelling and designing database (tables, relations, indexes, triggers, views, etc.)
Monitoring Database consistency and daily jobs to ensure the status; Finding root cause for failed jobs and provided permanent fix.
Developing complex queries for report requirements.
Responsible for designing and managing production database backups.
Worked closely with client to ensure data integrity.
Migrated DTS packages to SSIS.
Wrote complex DTS Packages.
Technologies: SQL 2000, 2005, DTS, SSIS, TFS
Ramco Systems, Chennai, India 04/2004 – 05/2006
SQL Developer – Ramco ERP
Understanding business logic and implemented them in Stored Procedures
Sound knowledge of ERP system for the manufacturing industry.
Optimized existing T-SQL/Stored Procedures.
Created web pages using ERP tool.
Technologies: SQL 2000, VSTF
Network Technology Solutions, Chennai, India 06/2003 – 03/2004
Application Developer
Visual Basic and SQL Developer
Education
Master of Computer Applications, Vel’s College of Science (University of Madras) 2003
Contact this candidate