Sql Server Data
Resume:
Resume of PRADEEP RATHINAM
SUMMARY OF QUALIFICATIONS
TWELVE Plus years of experience in MS SQL Server 2012/2008/2005/2000 Database, Reporting and BI Architect in Manufacturing .
Extensive experience with SQL Server 2008/2012/2005/2000, Oracle 10g/11g.
Expert in designing logical and Physical database models as per business requirements.
Good hands on Data Migration by using different tools.
Extensive experience in all phases of Data Warehouse/ Datamart development including prototyping, Data modeling, analysis, design, development, testing, documentation, and training other team members.
Good knowledge in designing data warehouses with snowflake and star schemas.
Good knowledge on Reporting Tools SSRS, COGNOS (Cognos Incentive Compensation Management, Query Studio, Report Studio etc.)
Developed Ad-Hoc / Self-Service Reporting capabilities.
Cross-platform integration, using SSIS to simultaneously load data from multiple data Sources of different formats from different systems.
Implemented data version by using different techniques, Slowly changing dimension (through SSIS) Audit tables (Triggers).
Proficient in creating Index, Views, Complex Stored Procedures, appropriate functions, and Triggers.
Expert in Performance tuning by using different tools Execution plan, SQL profiler, Dynamic management views and Dynamic management functions.
Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by triggers and Primary and Foreign Keys.
Good knowledge about SQL server internals, command Parser, Query Optimizer, Query Executor and Storage Engine.
Developed SHELL scripts to Deploy and process SSIS package.
Good hands on in troubleshooting and resolving database integrity issues, blocking and deadlocking issues and MS SQL development issues.
Expert in handling concurrency issues by using different isolation levels Read uncommitted, Read committed, Repeatable read, Serializable and Snapshot.
Excellent interaction skills, including facilitation, negotiation, leadership and influencing
Excellent verbal and written communication skills and the ability to interact professionally with a diverse group, executives, managers, and subject matter experts.
Expertise in understanding and supporting the client with project planning, project definition, requirements definition, requirements gathering, analysis, design, testing, system documentation and user training.
A well-organized, goal-oriented, highly motivated effective team member.
Discuss with the business team to clarify the requirements to get clarity of certain business functionalities.
Developed dash boards by using COGNOS and SSRS reporting tools.
Expert in SDLC model – AGILE, Waterfall & Prototyping.
TECHNICAL SKILLS:
Operating Systems: Windows 9X/NT/2K/XP/Vista/Win 7, UNIX, MS DOS
Databases: MS SQL Server 2005/2000/7.0/6,Oracle 10g, 11g, MS Access.
ETL Tools: SQL Server Integration Services (SSIS).
Database Tools: SQL Profiler, SQL Query Analyzer, Management studio Index Analyzer, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs.
Languages: C#, ASP.Net.
Reporting Tools: SQL Server Reporting Services (SSRS), COGNOS, Cognos Framework Manager, Cognos ICU.
DB Modeling Tools: MS Visio, ERWIN.
Internet Technologies: ASP.Net, Web services, XML
Defect Reporting: Version One, IBM Clear Quest-7.0.1.
Configuration Management: TFS 2010 / 08, Clear Case-7.1.00.
Scripting: JavaScript, VBScript.
Web Languages: HTML, XML,
EA Tools: HP Project and Portfolio Management, TROUX.
OLAP Tools: Cognos.
PROFESSIONAL EXPERIENCE
Jan 2011 – Present Boeing Company
BI Architect Bellevue, WA / Chennai India
Enterprise System Architecture Tool Suite Boeing's Enterprise-wide Authoritative Source and Data Repository for all Computing Technology Standards and Application Standards and Architecture. This site is intended to assist Business and Information Technology users who need to find, understand or manage computing portfolios of technology products and business applications.
Technology / Environment: SQL Server, SSIS (ETL), SSRS, Cognos, BIRT, ORACLE, Shell Scripts and Enterprise System Architecture Tool (TROUX 9.1 / 9.2), HP Project and Portfolio Management.
Responsibilities:
Requirements, Impact Analysis and Sprint Planning.
Architecture, Designing and Review
Test strategy & planning
Migration from ORACLE Reports / Views to SQL Server.
Create Conceptual/Logical/Physical models design and Data integration. Design Data structures and database in SQL Server.
Created reusable ETL & Reporting templates using SSIS & SSRS.
Develop real time - dashboards, standard and ad-hoc reports using SSRS, COGNOS, COGNOS Incentive Compensation Management for Project Costs.
Migrate ORACLE reports to SSRS, COGNOS and FLASH/BIRT reports.
Perform T-SQL tuning and optimizing queries for Reports which take longer time in execution.
Developed interface and reporting stored procedures, views for efficient data storage and manipulation.
Develop the Slowly Changing Transformation to maintain the Historical Data.
Good exposure on visualization tools Cognos and BIRT.
Create and maintain data flow diagrams for existing and future ETL processes.
Create and maintain detailed source-to-target ETL mapping specifications.
Implement the continuous improvement logic for SSIS packages.
Design, build and deploy the SSIS packages.
Developed automated deployment process using Team Foundation Server (TFS).
Developed and designed Landing Page / Dashboard.
Oct 2007 - Dec 2011 Boeing Company
Lead Developer BI Renton, WA
Develop a delivery system (web portal) to deliver flight manuals. Enhance and maintain windows based administration tool and develop interfaces with content management systems.
Technology / Environment: SQL Server, SSIS (ETL), SSRS, Web Reports, ASP.Net, HTML 5.
Responsibilities:
Requirements, Impact Analysis and Sprint Planning
Architecture, Designing and Review
Test strategy & planning
Develop canned reports using SSRS and Cognos with drill down capabilities.
Create workflows using windows workflow foundation.
Develop web service using .Net to publish data.
Consume data from web service to SQL Server database.
Created automated unit and regression testing bed in VSTS.
Create Conceptual/Logical/Physical models design and Data integration. Design Data structures and database in SQL Server.
Configuration management, Deployment / installation and Production
Created reusable ETL & Reporting templates using SSIS & SSRS.
Develop the Documents for Logging/Error Handling for SSIS Packages.
Respond quickly to bug fixes, enhancement requests and production ETL related issues.
Develop detailed technical specifications and operational support documentation in collaboration with data analysts.
Develop data profiling and source-target mappings.
Optimize queries, stored procedures and server performance.
Manage timely flow of data to the data warehouse for business intelligence IT partners for use in reporting.
Configure the SSIS Package for run time Parameters and Config file.
Oct 2004 – Sep 2007 Boeing Company
Developer BI Chennai India
Configurator is a web based application that makes the process of configuring customer airplanes more agile, provide better visibility of available options and capture and validate customer-negotiated configurations.
Technology / Environment: SQL Server, SSIS (ETL), SSRS, VB.Net.
Responsibilities:
Requirements & Impact Analysis
Test strategy & planning
Develop Stored Procedures, Triggers, Views and DDL statements.
Develop web service using .Net to publish data.
Design Data structures and database in SQL Server.
Configuration management, Deployment / installation and Production
Develop Reports using basic web .net web reports and SSRS.
Develop Queries for SSIS Packages.
Develop the Documents for Logging/Error Handling for SSIS Packages.
Implemented Code Review tool and process in place to improve the quality.
As a developer demonstrated excellent development skills and progressed to lead the team.
EDUCATION:
2004 Bachelor of Engineering in Computer Science from University of Madras, Chennai, India. Secured 75%
CERTIFICATIONS:
Microsoft Certified Technology Specialist - .Net Framework 4, Web Applications.
CAREER ACHIEVEMENTS:
Pride award (5 times), awarded by the customer, for exceptional performance in delivering
Awarded “Most Spirited Team” award.
Submitted several Knowledge artifacts, below are the titles:
oSilverlight Overview
oData Access Layer different data access techniques.
Contact this candidate