Sql Server Microsoft Office
Resume:
PROFESSIONAL SUMMARY
A Microsoft certified Professional with over 7 plus years in Database Design, Development, Administration, ETL Implementation and support of OLTP/Data warehouse systems using Microsoft SQL Server 2014/2012/2008/2005/2000 across various SDLC environments
Worked Extensively on Data Modeling, Normalization and De-Normalization Techniques for both OLTP and OLAP systems
Excellent experience in Designing Database Objects like Tables, Constraints, Views, Indexes, partitioning and Validation Checks.
Experienced in writing complex T-SQL Commands, Stored procedures, Triggers and Functions, Views in MS SQL Server 2000/2005/2008.
Excellent knowledge in Performance Tuning and Query Optimization using SQL Profiler, Execution Plans Performance Monitor,DMF’s and DMVs
Expertise in administering SQL Server Installation, configuration, Security, Backups, High Availability, Performance tuning and maintenance with outstanding troubleshooting capabilities.
Configured and maintained Transactional/Snapshot replication for standby/Reporting environments and having outstanding capabilities in troubleshooting replication errors and handling logs.
Highly experienced with SQL Server 2008/2012 up gradation & Upgrade Advisor (In place & Side-by-Side) for large and mission critical applications.
Highly experienced on SQL Server 2005 migration from SQL Server 2000 and 2012 Migration from 2005 and 2008.
Experience in using DMV and dynamic management functions for finding out long running queries.
Implemented SQL Server concepts like database mirroring, database snapshot, DDL triggers, online indexing.
Created Linked Servers between SQL Server & other heterogeneous systems like Oracle, Sybase, and IBM DB2. Also created DTS packages for data transfer between various environments.
Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP, DTS and SSIS services.
Migrated/Upgraded DTS 2000 Packages to SSIS Packages across all environments.
Worked with several Control Flow Tasks, Data Flow Tasks and Transformations (Lookup, Merge Join, Conditional Split, Slowly Changing Dimensions, and Data Conversion etc) in SSIS Package Development.
Highly experienced in Developing, Deploying, Scheduling, Troubleshooting, Optimizing and monitoring) for performing Data transfers and ETL Purposes across different servers with DTS/SQL Server Integration Services (SSIS 2005) Packages
Expertise in handling Errors by using Event Handler and can provide Logging, Custom Logging for SSIS Packages.
Experience in scripting SSIS Packages using Active X Script and VB.NET.
Creating large enterprise reports, sub reports using charts, report parameters, dropdowns and images using SSRS 2005/2008.
Created Ad-hoc reports and data driven subscription reports by using Report Builder in SSRS.
Solid design and development experience in Developing various kind of reports (cascading parameters, pick lists, drill down and drill through)
Expertise in Troubleshooting, Installation, Configuration and Deployment of Reporting services using SSRS (2005/2008).
Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
Experience in designing Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, and Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
Developing OLAP cubes using SSAS 2005 and calculates the metrics that were revealed in the functional analysis.
Expertise skills in calculating measures and dimension members in SQL Server Analysis Services (SSAS 2005) using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
Developed cubes using Partitions, KPI’s, and Perspectives, slow moving dimensions etc and created various user roles.
Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
24 X 7 Production Database on Call Support.
Effective written and verbal communication skills and a well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting and problem solving skills.
EDUCATIONAL QUALIFICATION
MASTERS from McNeese State University, Lake Charles, LA, USA.
CERTIFICATIONS
TS: Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance (Exam 70-445)
TS: Microsoft SQL Server 2005 - Implementation and Maintenance (Exam 70-431)
Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (Exam 70-467)
TECHNICAL SKILLS
Programming Languages
SQL, T-SQL, PL/SQL Dynamic SQL, MDX, SQL*Plus 3.3/8.0, HTML, XML, DHTML, C, C++,VB Script, Shell Scripting, C# .NET,VB .NET, ASP .NET, ADO .NET, Visual Studio, XML, HTTP, ActiveX, MS Access, Lotus notes.
RDBMS
Microsoft SQL Server 2014/2012/2008/2005/2000/7.0, MS-Access 97/2000/2003, Oracle 10g/9i/8i, Sybase Server, SQL, PL/SQL, MS SQL, SQL*Plus, Teradata V2R5, IBM DB2 UDB 8.2/8.0, MS Visual Source Safe 2005.
Data warehousing
SQL Server 2012/2008/2005/2000, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS). Business Intelligence Development Studio (BIDS), SSMS, DTS Packages, MDX Queries, ETL, Performance Point Server, ProClarity, OLAP, OLTP, SQL*Loader,
Database Design Tools and Data Modeling
MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball & Inman Methodologies, MSX, MS Access, MS Project.
Business Intelligence Tools
SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio, Crystal Reports, Cognos, Hyperion.
Tools and Utilities
SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS
Packages
MS Office, Ms Outlook (Microsoft Office Suite), Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007
Version Control and Configurations
Team Foundation Server (TFS), Visual SourceSafe 6.0/2005, Remedy Change Management, Clear Case, Clear Quest
Portal
SharePoint Portal Server 2003/2007, Windows SharePoint Services
Web Technologies HTML, XML, XSL, JavaScript, IIS (4.0/5.0/6.0,7.0)
PROJECT EXPERIENCE
United Airlines, Houston, TX September’ 11- Till Now
SQL DBA/BI Consultant
Responsibilities:
Database Installation and configuration:
Installed& Configured SQL Server SQL2012/2008R2/64/32 bit versions on Windows 2012/2008/ 64/32 bit servers on Enterprise systems comprising of clustered and standalone enterprise Data Centers.
Applying latest service packs, hot fixes and security patches.
Creating new Instances, databases, schemas, objects and tablespaces/filegroups.
Recommendation of database file systems/drives and configuration of file groups layout.
Database Administration and Monitoring
User, groups, privileges, roles and profile management.
Monthly data growth and periodic data growth trend analysis.
Developing and implementing system monitoring and alerting procedures.
Capacity planning and allocating disk storage for databases.
Create and maintain database links/linked servers to external databases.
Configuration, creation and administration of jobs and schedules.
Provide 24X7 database support on rotation basis.
Review database and application error messages, troubleshoot, identify course of action and implement solutions.
Deployment of patches/hot-fixes from Dev, QA to Production.
Documentation of lesson learnt, best practices, processes and standards.
Database Backup and Recovery
Implemented database backup and recovery procedures.
Provided options for disaster recovery and fail over scenarios.
Create, configure and monitor Standby databases (DR).
Database Development and Database Modeling
Worked with the application team, SME, business leads and vendors to identify project requirements.
Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers, Rules and Defaults.
Involved in Data modeling and responsible for Forward/Reverse engineering various database objects using ERWIN.
Create and Maintain Entity-Relationship(ER) diagrams (Relational data models).
Table normalization and de-normalization.
Migration and Upgradation
Migrated SQL server 2000/2005/2008/2008R2 to SQL Server 2012 across various environments including Dev, UA, Production and DR environments
Gathering and analyzing Pre-migration requirements by using Upgrade advisor and documenting anomalies
Doing In-place upgrades and New server builds,Migration of logins, DTS Packages to SSIS Packages
Verification of Post-migration results, Legacy compatibility and Feature pack installations
High Availability and Disaster Recovery
Implemented and Scheduled Replication process for updating our parallel servers.
Worked on Active/Passive two node Clustering servers for high availability.
Performance Analysis and Tuning
Monitoring and tuning the performance of database using AppDynamics, Perfmon, SQL Profiler, Data Collector and Trace files.
Query level Performance analysis and tuning with the help of DMV’s, Query plans, Database tuning advisor and SQL Server Profiler.
Involved in Defragmentation & Performance tuning using DBCC Showcontig, REINDEX, INDEX DEFRAG, Update Statistics
Sql Server BI:
Involved in the gathering requirements from the business users and created the Functional Specifications, Technical Specs, Design Documents and Approach Documents and Implementation of BI Analytics needs.
Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
Created different Parameterized Reports (SSRS 2005/2008R2/2012) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing complex transformations using SSIS/DTS packages
Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and cleaning the data from different Sources into Company Format.
Developed the packages with monitoring features and logging capturing the audit information of the packages and their execution results for support and troubleshooting
Scheduled SSIS Package Jobs and monitored the jobs using SQL Server Agent.
Worked with Snow Flake and Star Schema, Involved in Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis Services (SSAS).
Created Calculated Measures by writing MDX queries and developed Key performance Indicators (KPIs).
Developed numerous Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2012) and Excel Pivot tables based on OLAP cubes and SQL Server Tables.
Environment: Windows2008/2012, MS SQL SERVER 2000/2005/2008R2/2012/2014, Visual Studio
2012, Share point 2010, TFS 2013, ORACLE 11g, Informatica POWER EXCHANGE
APAC Customer Services, Cedar Rapids, IA March’11-September’ 11
SQL/BI Consultant
Responsibilities:
Involved in Gathering the Requirements, Design, Development, Testing and Implementation of BI/ (ETL, Reporting, Analytics) needs.
Supported Users for various Reporting and Analytics requirements across multiple Business Units and departments.
Worked on developing Tables, Indexes, Views, Creating complex stored procedures, Triggers and user defined Functions.
Involved in Source Data Analysis, Design and creation of Data Mappings for Extraction of bulk data from heterogeneous RDBMS sources like Oracle, ADSI and other OLEDB data sources.
Identified Data Sources and Data Source views mappings for ETL using SSIS.
Developed, deployed and monitored SSIS Packages for new ETL Processes and
Used SSIS to Migrate data from various data sources like Oracle, Flat files, upstream systems into Staging, ODS and DWH areas using DTS/SSIS.
Used SQL Agent, Shell scripts, VB script, and batch (.bat) files to Schedule and maintain SSIS Packages and batch jobs.
Experienced in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
Used multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
Created Drill-through reports, parameterized reports and linked reports using Crystal 2005 and 2008 and were integrated in the Performance point server.
Worked with official Templates, Mailing Subscriptions and created shared data sources that can be used across different processes.
Developed SSAS cubes and loaded dimensions and facts using ETL. Defined attribute properties in a Parent Child Dimensions.
Created data source views and defined granularity with in a measure group and drill through actions.
Involved in the Code Review sessions and reviewed cubes, changed the cubes and documentation according to the requirement based on evaluation and revenue opportunities using SSAS.
Designed and developed Reports, Scorecards, KPIs and Dashboards SharePoint 2010
Created and published Analytical reports by using proClarity tool and Performance Point Server 2007.
Integration of dashboards using MOSS 2010 and various custom web parts
Administered and Maintained the Security of SQL Server 2008/2005, SSRS and SSIS by creating logins, maintaining item level security, managing roles and granting permissions.
Administered and Maintained the Back-ups and Restores of SQL SERVER databases and SSAS Cubes on a daily basis and Disk/Memory Management by Truncating/Backups of the Transaction Logs.
Environment:
MS SQL Server 2005/2008, SQL Server Analysis Services (SSAS),SQL Server Integration Services (SSIS), SQL Services Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), XML, T-SQL, PL/SQL, MDX, MS Project, MS Access 2000 & Windows 2K platform, Microsoft Office Share Point (MOSS),Performance Point Server 2007 (PPS), ProClarity, Oracle 10g, Oracle 11g, C#,.Net, Team Foundation Server (TFS), TOAD .
Wells Fargo Home Mortgage, West Des Moines, IA June'10 – March’11
SQL/BI Consultant
Responsibilities:
Involved in Gathering the Requirements, Design, Development, Testing and Implementation of BI/ (ETL, Reporting, Analytics) needs.
Supported Users for various Reporting and Analytics requirements across multiple Business Units and departments.
Designed and developed more than 50+ enterprise reports(SSRS/Crystal Reports) using the data from ETL Loads and various heterogeneous data sources.
Worked on developing Tables, Indexes, Views, Creating complex stored procedures, Triggers and user defined Functions.
Involved in Source Data Analysis, Design and creation of Data Mappings for Extraction of bulk data from heterogeneous RDBMS sources like Oracle, ADSI and other OLEDB data sources.
Identified Data Sources and Data Source views mappings for ETL using SSIS.
Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes
Used SSIS to Migrate data from various data sources like Oracle, Flat files, upstream systems into Staging, ODS and DWH areas using DTS/SSIS.
Used SQL Agent, Shell scripts, VB script, and batch (.bat) files to Schedule and maintain SSIS Packages and batch jobs.
Experienced in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
Developed numerous Enterprise reports using SAP Crystal Reports (2000/2005/2008) and Excel Pivot tables based on OLAP cubes and SQL Server Tables.
Used multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
Created Drill-through reports, parameterized reports and linked reports using Crystal 2005 and 2008 and were integrated in the Performance point server.
Worked with official Templates, Mailing Subscriptions and created shared data sources that can be used across different processes.
Created and published Analytical reports by using proClarity tool and Performance Point Server 2007.
Integration of dashboards using MOSS 2007 and various custom web parts
Administered and Maintained a Website based on the SQL Server data.
Administered and Maintained the Security of SQL Server 2008/2005, SSRS and SSIS by creating logins, maintaining item level security, managing roles and granting permissions.
Environment:
MS SQL Server 2000/2005/2008, SQL Server Integration Services (SSIS), SQL Services Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), XML, T-SQL, PL/SQL, MDX, MS Project, MS Access 2000 & Windows 2K platform, Microsoft Office Share Point (MOSS),Performance Point Server 2007 (PPS), ProClarity, Crystal reports, Oracle 9i, C#,.Net, Team Foundation Server (TFS), TOAD, SAP Business Objects.
Camelot Integrated solutions Inc Houston,TX Dec'09 - June’10
SQL Developer
Responsibilities:
Involved in the installation of SQL Server. Installed SQL Server Enterprise manger tools using SQL Server Setup Program.
Worked on the SQL Query analyzer and Optimized SQL queries for efficiency and the front-end developer with their queries and procedures.
Involved in the database development by Created Tables, Indexes and Constraints etc.
Performed the Migration of access objects to SQL Server 7.0.
Development in T- SQL Included the Creation of Indexes, Views, Triggers, Stored Procedures and Packages in T-SQL.
Keenly Configured and monitored database application.
Designed and Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports and MS Reporting Services based on the complexity of the report.
Implemented several complex reports and administration modules and also involved in the security of these reports.
Developed the stored procedures for module integrity and application.
Created database triggers in T-SQL to check the referential integrity of the database and also to perform the dependable activities between different Database objects.
Custom Designed VB forms using the forms and crystal reports were made for business reporting purpose.
Monitored the performance tuning of the database and T-SQL queries using Execution Plan.
Environment:
MS SQL server 2000, Visual Basic 6.0, Win NT, Crystal Reports 8.0 and MS Visio professional
REFERENCES: Available Upon Request
Contact this candidate