SUMMARY

• Highly motivated SQL server developer with 7+ years of IT experience with database development/Administration on data design, and business intelligence technologies with expertise on ETL process, reporting and support using SQL server 2012/2008/2005, SSIS and SSRS.
• Strong experience in client requirement analysis, physical, logical design development, resource planning, coding, debugging, testing, deployment, support and maintenance of business intelligence applications using SQL Server 2000/ 2005/2008/2012, DTS, SSIS, SSRS and SSAS 2005/2008/2012 .
• Primary knowledge on C# and ASP.NET.
• Expert in writing T - SQL queries, stored procedures, common table expressions (CTEs), user defined functions, indexed views and DDL/DML triggers for data consistency and data manipulation.
• Expertise in performing most of the SQL server enterprise manager and management studio functionality using T-SQL scripts and batches.
• Expert level knowledge in relational database management system (RDMS) and data warehouse concepts such as tables, user defined data types, indexes and indexed views.
• Strong experience in optimizing various queries by creating clustered, non-clustered indexes, and indexed views.
• Extensive experience in data extraction, transforming and loading (ETL)using SQL Server Integration Services (SSIS), DTS, Bulk Insert and Bulk Copy Program (BCP).
• Proficient in creating and deploying SSIS packages from heterogeneous sources like Excel, CSV, Oracle, flat file, text format data by using multiple transformations in SSIS such as data conversion, conditional split, bulk insert, merge, aggregate, derived column and union all.
• Experienced in designing jobs, alerts, SQL mail agent, and scheduling DTS and SSIS packages.
• Experience in designing, developing, deploying and processing cubes in SSAS.
• Proficient knowledge in designing partitions, aggregations for performance tuning in SSAS.
• Proficient in calculating measures and dimension members using multi-dimensional expression (MDX), and user defined functions.
• Experience in writing MDX queries in Analysis Services and Reporting Services.
• Strong experience in developing various types of complex reports like reports using cascade parameters, drill down and drill through reports, matrix reports, sub reports, parameterized reports, Ad-Hoc and charts using SQL Server Reporting Services (SSRS) based on client requirement.
• Excellent experience in monitoring SQL server performance tuning, installing, configuring, managing and troubleshooting in SQL server 2000/ 2005/2008/2012 using SQL profiler, query analyzer, enterprise manager, index tuning wizard and windows performance monitor.
• Good knowledge of implementing backup and disaster recovery procedures.
• Thorough knowledge in all phases of software development life cycle (SDLC), quality procedures and standards while executing projects.
• Excellent leadership skills with an aptitude of analysis, troubleshooting, problem solving and adopt to work independently as well as in a team.

TECHNICAL SKILLS

Databases: SQL Enterprises Manager, SQL Profiler, Query Analyzer, SQL Server Agent, SQL Server Analysis Services (SSAS)

Languages: T-SQL, MDX, HTML, XML, .NET

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS)Import Export Data, Bulk Insert

Reporting Tools: SSRS, Crystal Reports, Power BI, Power Pivot

Data Migration: MSDTS, SSIS, BCP, Data Migration, SQL Loader, Import/Export Wizard

Operating Systems: Windows 98/NT/2000/XP,2003/2008 Server, Windows 7/8, UNIX

Packages: MS Office 2003/2007/2010/2013

PROFESSIONAL EXPERIENCE

Confidential, Woodcliff Lake, NJ

Sr. SQL SSIS/SSRS Developer

Responsibilities:

• Responsible for creating reports based on the requirements using SSRS 2005.
• Created detailed reports for the customers to halp them decide which property to purchase by showing demographic information based on various parameters.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Analyzed the requirements and framed the business logic for the ETL process.
• Extensively used SQL Server Agent and scheduled jobs to run at defined time.
• Monitoring nightly ETL batch flow and resolving the issues and directing it to concerned person.
• Analyzed and framed the business logic for the ETL process as per the requirements.
• Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
• Identified and defined the Datasets for the report generation.
• Created Standard Reports and Cross Tab Reports and Drill Through reports.
• Created Cross-Tab, Drill-down, Drill Through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Converted very complex RPTs of Crystal Reports into RDLs of SSRS manually
• Developed stored procedures and used SSIS 2005 to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.
• Wrote SQL scripts using Script task to insert/update and delete data in SQL database, in creating configuration packages using C# Scripting.
• Created SSIS Packages to migrate slowly changing dimensions.
• Deployed the SSIS package on various servers using package configuration from test server to production servers.
• Uploaded reports on to the report manager and organized them in folders and delivered the reports using ‘pulled’ and ‘pushed’ methodologies.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• WritingMDX Scriptsto create datasets to perform reporting and included interactivedrill down reports, report models and dashboard reports.
• Fine-tuned the database objects and server to ensure efficient data retrieval.

Environment: MS SQL Server 2012/2008 (Query Analyzer, SSIS, SQL Profiler), MS SQL Reporting Services 2005/2008/2012, SQL Agent.

Confidential, Bellevue, WA

Sr. SQL SSRS/SSIS Developer

Responsibilities:

• Involved in gathering business requirements, interacting with the client and preparing detailed design document.
• Responsible for installation, configuration of SQL server 2008 and configuration of report manager.
• Created and optimized database objects such as views, functions and stored procedures as per requirement.
• Worked in extracting transforming and loading (ETL) data across multiple databases using SSIS packages.
• Created SSIS reusable packages to extract data from flat files, excel files into SQL database
• Created SSIS packages for file transfer from one location to other using FTP task.
• Created complex stored procedures with parameters and generated multi parameterized SSRS reports from them, where the user has a choice to select the parameters.
• Gatheird data from multiple databases across the organization and produced reports for different departments.
• Converted existing excels based reports and crystal reports to SSRS reports.
• Created drill down, drill through, linked, matrix, Charts, lists, sub reports using SSRS and managed their subscriptions.
• Created dashboards for Sales, Inventory, Performance and finance.
• Created OLAP cubes using SSAS and created reports from them.
• Deployedanduploaded the SSRS reportstoReport Manager & SharePoint serverfor the end users and involved in enhancements and modifications.
• Improved existing reports performance by using execution log2 and optimized the underlying procedure and queries.

Environment: MS SQL Server 2005/2008/2012, T-SQL, Informatica Power Center 8.6, Query Analyzer, SSRS, SSIS, Visual Studio.Net, Windows 2008.

Confidential, Irving, TX

Sr. SQL BI Developer

Responsibilities:

• Created new databases and objects such as tables, stored procedures, constraints, and indexes to maintain referential integrity of data.
• Optimized queries by deleting unnecessary columns, eliminated inconsistent data, normalization of tables, developed joins and created clustered/non-clustered indexes wherever necessary.
• Involved in writing various DB objects like user defined functions, triggers, and indexes for accomplishing various tasks.
• Performed daily and weekly data loads by scheduling corresponding ETL jobs in SQL server agent.
• Used data transformation services (DTS) an ETL tool of SQL server to migrate data from various data sources.
• Involved in full life cycle development includingDesign, ETL strategy, troubleshootingReporting, and Identifying facts and dimensions.
• Experienced in ETL Administration responsibilities for the enterprise Data using Informatica tool
• Participated in all stages of software development life cycle (SDLC) while developing logical architecture for SSIS packages.
• Utilized various data flow transformations like lookup, row count, data conversion, conditional split, sort, aggregate to migrate data between different data sources as per business requirements.
• Used VB.Net, VB.Scripts for loading data using SSIS packages.
• Responsible for validation and deployment of SSIS packages from development to QA and production environment.
• Designed various managed reports as per the requirement, like sub reports, parameterized report, drill down, drill through using data warehouse and analysis services or cube as source
• Developed MDX queries and Data Mining Expression (DMX) queries for SSAS and SSRS (2008)
• Designed, deployed and maintained various SSRS reports like parameterized reports, sub-reports, cross-tab, drill-down, drill-through reports using RDL.
• Identified and provided necessary steps to enhance the user response time by checking fragmentation and re-indexing tables for efficient application access and methods.
• Performed security related issues by creating user logins, roles, permissions and granting access to database according to their role.
• Documented all processes and tasks of all databases, stored procedures, functions, views for future references and maintenance.

Environment: MS SQL Server 2005/2008, T-SQL, DTS, BCP, Informatica Power Center 8.6, Enterprise Manager, Query Analyzer, SSRS, SSIS, SSAS, VB.Net, Windows 2008.

Confidential, Minneapolis, MN

SQL /ETL Developer

Responsibilities:

• Extensively participated in all phases of projects life cycle.
• Helped front end developers in writing SQL queries, approving database changes and designing data models.
• Designed, developed and maintained security of relational databases.
• Involved in managing database integration issues such as migration of data from various databases, qintegration, database maintenance, disk space planning issues, and new applications.
• Created check constraints to maintain data integrity and performed tracing applications using SQL profiler.
• Optimized SQL queries to develop database objects such as triggers, joins, constraints, cursors, indexes, views, and created stored procedures to automate sequential updates in fewer transactions.
• Performed tuning of SQL server locks, and indexes configurations, administrating SQL server security and maintenance of databases.
• Tuned complex SQL queries, stored procedures and functions to improve the report generation time.
• Designed and developed user defined functions and stored procedures for reporting purposes.
• Migrated data from flat files to SQL server databases by using BCP and SSIS packages.
• Involved in writing MDX queries for analytical and reporting services.
• Created and ConfiguredData Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queriesusing SQL Server 2005 Analysis Services.
• Monitoring and implementing disk space expansion to ensure dat company’s databases are scalable.
• Troubleshooting and resolving access to databases and identifying performance issues.
• Performed testing and implementing of database backup procedures, restore procedures, disaster recovery procedures and contingency plans.

Environment: MS SQL Server 2005, Enterprise Manager, SQL profiler, Query Analyzer, Crystal Reports, Windows 2003/XP.

Confidential

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Installation, configuration of MS SQL Server 2005 instances and databases for development and testing purposes using SQL Server setup program.
• Implemented and monitored database application and security.
• Created tables, indexes, views, constraints and stored procedures for modular integrity and application as per client’s requirement.
• Designed and implemented database triggers and stored procedures to check the referential integrity of database.
• Monitored performance tuning of databases and SQL queries using execution plan.
• Tuning and optimization of stored procedures.
• Designed complex SQL queries to fetch data from multiple tables in remote databases using joins and database links.
• Managed disk space, database files, transaction log, and data transfers between various servers using BCP.
• Designed and implemented various complex reports.
• Involved in troubleshooting and performance tuning of database.
• Performed Administrative tasks like managing roles, users, profiles and creating scheduling maintenances and backups to database.
• Troubleshooting problems related with databases, application tools, development tools and minimizing production down issues.
• Involved in development, execution and maintenance of disaster recovery plans using different types of database backups, restore and replication.
• Maintained consistency of database by using database consistency checks (DBCC) at regular intervals and fixed data corruption in application databases.

Environment: MS SQL Server 2005, Transact - SQL, Enterprise Manager, Query Analyzer, Windows 2003

Confidential

SQL Server Developer

Responsibilities:

• Interacted with front end developers and managers to analyze the need of business requirement and developed technical specifications.
• Designed and implemented schema on all databases for different kinds of storage as per the business requirement.
• Optimized databases by creating clustered indexes, non- clustered indexes and views.
• Utilized views such as partition views, parameterized views for complex join queries between multiple tables from different databases.
• Created incremental load packages to load the updated and new data into the enterprise data warehouse.
• Developed triggers, indexes, stored procedures and enforced business rules through checks and constraints.
• Created complex SSAS OLAP cubes by using aggregations, partitions and calculations based on OLAP reporting needs.
• Scheduled full and transactional log backups for the user and system related databases by using database maintenance plan wizard.
• Worked on all kinds of reports, DTS, SSAS and SSIS packages.

Environment: MS SQL Server 2005, Transact - SQL, Enterprise Manager, Query Analyzer, SSIS, SSRS, Tuning Advisor, Windows 2003