SUMMARY

• About 7+ years of experience in MS SQL Server 2012, 2008, 2005 and 2000 and worked extensively on Integration services (SSIS), Reporting services (SSRS) and Analysis services (SSAS).
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services.
• Extensive experience in Information Technology with special emphasis on design & development of Database/Data Warehousing/Client - Server/e-commerce applications and Software Development Lifecycle (SDLC).
• Experience Working in Agile, Scrum and Waterfall model.
• Various domain knowledge including Publishing, HealthCare, Finance, Telecommunication, Manufacturing, Banking and ability to easily grasp new domain ideas/process.
• Expert in designing and implementing Database using various RDMSs like SQL SERVER, Oracle and MS Access.
• In-depth knowledge in various RDBMS concepts like Database, Tables, Table Normalization, User Defined Data Types, Views, Indexes, Stored Procedures, User Defined Functions, Triggers, CTE(Common Table Expression), SQL joins etc.
• Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Extensive knowledge in T-SQL queries (DDL and DML).
• Good experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping, Replication and SQL Server Clustering.
• Expertise in OLTP/OLAP System Study, experience in Dimensional Modeling, ER Modeling, Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Experienced in creating different types of Tabular Reports, Matrix Reports, and Drill-Down, Cross Tab Reports, Ad hoc reports, Summary Reports, List Reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
• Excellent knowledge in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.
• Expertise in Extract, Transform and Load (ETL) using SSIS and various tools including Bulk insert, BCP, Import Export data, DTS packages and SQL Server Integration Analyzed, designed and developed for a Data Warehousing and Data Migrations.
• Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Expertise with DDL and DML statements, RDBMS, data dictionaries and normal forms.
• Excellent Communication and interpersonal skills and strong ability and experience in seeking solutions effectively and aggressively in challenging environments.

TECHNICAL SKILLS

Operating Systems: Windows, Linux, MS Dos

Databases: MS SQL Server 2005/2000/7.0/6 , Oracle 8i,9i MS Access, MS Excel

ETL Tools: SQL Server Integration Services(SSIS), DTS (Data transformation services)

DWH/ BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Visual Studio

Utility & Tools: SQL Profiler, SQL Query Analyzer, Management studio Index Analyzer, DTS Import/Export, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs, Visual Source Safe.

Languages: SQL, T-SQL, PL/SQL, VB.Net, Java, C++

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal reports 8.0/9.0/10.0 , MS Excel. Tableau, QlikView

DB Modeling Tools: MS Visio, Erwin, Red gate

OLAP Tools: SSAS, Cognos

PROFESSIONAL EXPERIENCE

Confidential, Miamisburg, OH

SQL Server Developer

Responsibilities:

• Involved in Planning, Defining and Designing data, based on business requirements and provided documentation.
• Designed Data Mapping documents, DDL scripts, Data Dictionary and Meta data of the models and maintained them.
• Designed many Configuration files that were used to pass parameters from outside the Business Intelligence Development Studio (BIDS) into the packages using XML files.
• Designed and Deployed UNIX Shell Scripts.
• Worked on Query Optimization using SQL Query Optimizer, SQL Server Extended Events, SQL Profiler, Set Session Options, and Temporary Tables.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using MS Analysis services (SSAS).
• Identified Key Performance Indicators (KPI) and Metrics for Business needs in SSAS.
• Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints on various database objects to obtain the required results.
• Created different Parameterized Reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Created Linked reports, Ad-hoc reports and etc. based on the requirement. Linked reports are created in the Report Server to reduce the repetition of the reports.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.

Confidential, St. Petersburg, Florida

SQL Server/SSIS/SSAS/SSRS Developer

Responsibilities:

• Gathered business requirements from users and translated them as technical specification for development.
• Identified various data sources, formulated data dictionaries, design and develop data models based on the given specs and requirements.
• Extensively worked with SSIS to import, export and transform the data between the linked servers.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Created new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Created jobs, alerts to run SSAS, SSRS packages periodically.
• Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job.
• Migration of stored procedures and database objects between development and test environments.
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.
• Used different transformations like Conditional Split, Lookup, Merge Join, Aggregate, Fuzzy Grouping etc. for creating many SSIS packages.
• Created many Variables that were used to pass parameterized values into the package which makes the package Dynamic.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Worked on Event Handlers to do Event handling on error at the package and task level on error, on warning and configured it using send email task and script task.
• Developed and implemented SSRS reports with multi-parameter, chart, sub-report and interactive sorting capability for administration and accounting department.
• Set up Advanced functions, dashboard, drill-trough/drill-down, KPI/Indicators in reports.
• Scheduled and manage daily / weekly / monthly sales and operational reports based on the business requirements.

Confidential

SQL Server Developer

Responsibilities:

• Extensively involved in T-SQL programming on Microsoft SQL Server 2005 database engine.
• Provide database design support for new system development set standards for object names and usage.
• Worked with SQL stored Procedures, Functions, Triggers & Packages in SQL Server.
• Developed triggers with conditional predicates to restrict data manipulation events to certain business hours.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Responsible for enhancements development performance tuning trouble-shooting debugging & independent unit-testing.
• Defined and developed data migration strategy between different sources and platforms using DTS and SSIS Platform.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
• Operations and perform the Different required transformation in the Staging Database and make the data ready to load in the Data Warehouse Database.
• Involved in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities.
• Involved implementing Disaster Recovery for minimal downtime using different types of database backups, restore, and replication.
• Created E-mail tasks, Event wait tasks, pre and post load commands in the work flows, sessions using the Workflow manager for the Informatica Loads.
• Login and User Management: Worked on authentication by Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.
• Generated complex custom Reports using SSRS 2005 as per the customer requirement.

Confidential

SQL Developer

Responsibilities:

• Gathered requirement from the business users, prepared functional specification and design documents.
• Prepared program specifications and development of PL/SQL packages, procedures and functions as required by the business users.
• Generated server side PL/SQL scripts for data manipulation and validation.
• Analyzed the existing method for data repository refresh and then developed an package with tuned queries to improve the performance and reduce the time taken for their fresh.
• Loaded data into oracle database from flat files using SQL*Loader.
• Created Materialized View for extracting the data from the remote databases.
• Wrote PL/SQL procedures to generate DDL scripts that created database objects dynamically based on user inputs.
• Generated and maintained Keys, Constraints and Relationships between the tables for OLTP database.
• Maintained a series of UNIX shell scripts to manage batch order processing.
• Optimized critical queries to eliminate Full Table Scans, reduce Disk I/O and Sorts.
• Fine Tuned SQL statements for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans and Tracesessions for Cost based and Rule based Optimization.