SUMMARY:

• 4+ years of experience in MS SQL Server 2008/2008R2/2012/2014 and Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2008/2008R 2/2012/2014.
• Expert in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS )
• Highly proficient in the use of T - SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Experience in extracting and transforming (ETL process) data using DTS/SSIS Import Export Data from various sources, Bulk Insert, Log Shipping, BCP and DTS/SSIS Packages.
• Microsoft SQL Server by using SSIS and DTS utility of SQL server 2008/2008R2/2012/2014
• Experience with all phases of software development life cycle (SDLC) and project methodologies.
• Created and Designed a Multi-Dimensional Analysis (Configured OLAP Cubes, Dimensions, Measures, MDX Queries, Data mining, Data Source and Data Source Views and Star and Snow Flake schema) using SQL Server 2005 Analysis Services (SSAS).
• Knowledge in query optimization & performance tuning, Using SQL Server Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Good SQL Server Administration skills using various backup recovery, replication, restoration and DTS servers, Model (simple, Bulk and full), database maintenance plan.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tool.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources like Oracle Database, Excel and Flat file to Microsoft SQL Server by using SSIS and DTS utility of SQL server 2008/2008R2/2012
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries
• Experience in maintaining SQL Server security by assigning logins, server, database roles and server permissions.
• Experience in working on administration tasks such as data loading, batch jobs, data unloading, user and application table management, upgrades, creating databases/ file groups/ files/ transaction logs
• Experience in OLTP/OLAP system study, Analysis and modeling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modeling.
• Creation and maintenance of Databases, creating roles and managing user permissions
• Experience in working with report development in MS-Office Access, MS Excel and Crystal Reports.
• Experience in Performance Tuning, Query Optimization, Execution Plan, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Experience in making formal and informal presentations to technical and non-technical staff
• Expert in Creating and managing roles for security in SSRS reports.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional.
• Experience in implementing high availability process like log shipping, Mirroring, and Clustering.
• Experience working in a clustered OLTP environment with Very Large Databases (VLDB) and having version control (Visual SourceSafe and Team Foundation Server).
• Experience in maintaining SQL Server security by assigning logins, server, database roles and server permissions.
• Experienced in manual, automation, integration and performance testing
• Excellent interpersonal communication, problem solving, documentation and business analytical skills.
• Quick learner and good performer both in team and independent job environments.

TECHNICAL SKILLS:

Database: SQL Server 2008/2008R2/2012/2014

Technologies: SQL Server Management Studio, SSIS, SSAS, SSRS, Profiler, BI Express, Database Tuning Advisor, MS Office, Excel, MS Project

Version Control Tools: MS Visual Source Safe (VSS), Source Version Control (SVN), Microsoft team foundation server (TFS)

Programming Languages: C, C++, HTML, XML

Operating Systems: Windows 95/98/NT/2000/XP/Vista/7, MS DOS

PROFESSIONAL EXPERIENCE:

Confidential, Oak Brook, IL

SQL Developer

Responsibilities:

• Installation and configuration of Microsoft SQL Server 2014 Management Studio.
• Design and develop SSIS packages, store procedures, configuration files, Tables, Views, Indexes
• Used SSIS to extract data from MDM Staging Database and MCDMDM Database.
• Used FTP to transfer large volumes of data to different servers.
• Used Table Difference, Look Up’s, and Conditional Splits for finding Deltas.
• Created SSIS jobs for monitoring the jobs that depend on daily loads and loading DB2 Database Tables using SQL Server Agent.
• Automate tasks using active x script (similar to VB script). Be able to implement failure alerts using email in SSIS.
• Involved in Object Oriented Design (UML, activity diagrams, Use cases and Object Modeling).
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Got a detailed understanding of business functionality and took the responsibility of preparing the Functionality Test Plan which was used by testing team while doing their testing process.
• Designed the packages in order to extract data from SQL db, flat files and loaded into Oracle database.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Involved in design, programming, deploy and Unit Testing of requested Reports
• Performed data conversions from flat files into a normalized database structure
• Developed numerous ad-hoc reports using SSRS for day to day financial reporting
• Installed and configured the components required to integrate SSRS with MOSS Enterprise Edition
• Developed CTE’s, Constraints, and Complex queries to fetch the data from different servers.
• Developing Micro strategy reports for business reporting needs.
• Responsible for creating Metrics, Filters and Prompts to enable decision-makers create customized reports.
• Fine-tuned SQL queries to improve query performance and to reduce runtime
• Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS).
• Created SSIS packages for loading Fact Tables, Dimension Tables from Excel, Oracle, and DB2 Databases.
• Created a number of fact tables, dimensions, measure groups using SQL Server Analysis Services representing aggregations in several different ways.
• Created partitions and designed various storage modes to increase the performance of cubes using SSAS.
• Used Team Foundation Server (TFS) for version control.
• Attend the daily scrum status and reports are up to date.
• Wrote DTS scripts for data transfer and Involved in System testing.
• Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing.
• Worked on SSIS and DTS Packages, DTS Import/Export for transferring data from Heterogeneous Database (Text format data) to SQL Server
• Data migration (import & export BCP) from Text to SQL Server.
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.

Environment: Microsoft SQL Server 2014, Oracle, MS Access, Excel, Teradata, Windows Server 2008, IIS, Visual Source Safe, Net Frame Work, XML Parsing, VB6, VB Script, and TFS.

Confidential, Woodland Hills, CA

SQL Developer

Responsibilities:

• Installation and configuration of SQL Server 2008
• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data using Erwin
• Involved in writing Transact-SQL (T-SQL) Queries, Stored Procedures, Triggers, User Defined Functions (UDF), Views, Indexes, and User Defined Data Types strictly following the Data Integrity using Constrains, Rules and Default
• Used multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally load into the Staging Data base
• Using SSIS, loaded XML data to the Database tables and Extracting Data using SSIS into Excel Files for Marketing purpose
• Working knowledge in Data modeling, creating star and snowflake schemas in SSAS
• Created reports with SQL Server Reporting Services (SSRS)
• Responsible for data retrieval by extensive use of multiple joins normalization and view
• Resolved various performance issues by running Database Consistency Checks DBCC command
• Used Visual Source Safe (VSS) for version control
• Involved in performance tuning, query optimization, Database Maintenance plans
• Responsible for developing processes automation of maintenance jobs, tuning SQL Server, locks and indexes configurations
• Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
• Design, deploy, and maintain various SSRS Reports in SQL Server 2008/2008R2/2012
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Involved in the preparation of detail Unit Cost, Price and Volume Trends, Expense Variances and Profitability Reports using SSRS.
• Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration of SharePoint with SSRS.
• Used SQL Server Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Developed a thorough knowledge by working on Full Life Cycle of the Software Development Life Cycle (SDLC) phases namely Analysis, Design, Coding and Testing

Environment: SQL Server 2005/2008, SSIS, SSAS, SSRS, Erwin, .Net Frame Work, XML, MS Excel, ASP.Net.

Confidential

SQL Developer/ Data Analyst

Responsibilities:

• Participated in the installation of SQL Server. Installed SQL Server Enterprise manger tools using SQL Server Setup Program.
• Configured and monitored database application.
• Created and when required, modified already existing stored procedures, triggers, views, indexes.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Tested queries to optimize the procedures and triggers to be used in production.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Defined stored procedures for module integrity and application.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Migrated the Existing DTS packages to the SSIS Batch jobs and enhanced the packages with monitoring features so that audit information of the packages and their execution results are loaded in to the audit table.
• Created SSIS Packages and used OLEDB Source as an existing Oracle Database.
• Involved in Performance tuning and Query Optimization.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
• Created and managed the databases in development environment.
• Managed the use of disk space, memory and connections.
• Designed and implemented several complex reports and administration modules.
• Designed VB forms using the forms and crystal reports were made for business reporting purpose.
• Involved in performance tuning of the database and T-SQL queries using Explain Plan.
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports.
• Prepared of project documentation.
• Prepared test plans for assembly testing & System Integration testing.

Environment: MS SQL Server 2008, Visual Basic 5.0, Win NT, Crystal Reports 8.0, Windows 2000/NT/XP, SSIS, SSRS, SSAS, T-SQL, OLAP, OLTP, Query Analyzer, Data Mart, ETL, MS Office 2003