SUMMARY

• SQL Server/BI Developer with 5+years of experience in design & coding of database, and applications of MSSQL Server 2014/2012/2008 . Work experience in the field of Data Warehousing and Business Intelligence applications with expertise in SQL Server Integration, Analysis and Reporting Services
• Experience working on all phases of software development life cycle (SDLC).
• Expert level skills in data modeling, data mapping, table normalization, optimization and performance tuning.
• Experienced in extracting, transforming and loading the data using SSIS in SQL Server 2012/2008, bulk insert and BCP. In addition transferring/rewriting DTS to SSIS packages.
• Expert in data migration from DB2/ORACLE/ACCESS/EXCEL/FLAT Fileto SQL SERVER 2012/2008/2005 and other destinations using SSIS.
• Experience in error and event handling, precedence constraints, break point, check points and logging.
• Proficient in data warehousing and SSAS skills: KPIs, calculated members, perspectives, hierarchies, partitions, OLTP, OLAP, relational and dimensional modeling skills (star schema and snowflake schema).
• Performance oriented in developing and extending cubes, dimensions and data source views, data mining models and deploying and processing SSAS objects.
• Strong experience in design and construction of data marts and data warehouse.
• High expertise in creating reports using crystal reports and SSRS (report builder and report server project), like: ad - hoc, drill-down, drill-through, cross-tab, sub-reports, pivot, chart, tabular and parameterized reports. Additionally, creating snapshots of reports.
• Expert in automating process by creating jobs and error reporting using alerts, SQL mail agent, FTP and SMTP.
• Extensive experience with SQL Server and T-SQL in constructing tables, views, triggers (DDL/DML), indexes, joins, constraints (keys) with their integrity, functions, stored procedures, user profiles, relational database models, and data dictionary.
• Hands-on working experience with analyzing query plans using: extended stored procedures, dynamic SQL, managing indexes and deadlocks (troubleshooting).
• Experienced in performance monitoring/tuning, devising and implementing performance tuning strategies utilizing DBCC, query optimization via enterprise manager-SQL, system monitor, and error logs.
• Experience on working with .Net technologies such as ASP.Net and C#.Net.
• Working experience in design and implementation of backup and recovery, security and data transformation services.
• Exposure in implementing replication models, database mirroring, raid technologies, log shipping, failover and load balance technologies.
• Hands on experience in installing, configuring, managing, upgrading and migrating, and monitoring and troubleshooting SQL Server 2005/2008/2012.
• Expert level skills in using MS Office products (word, excel, visio, Access and power point).
• Shown strong analytical, administration, leadership qualities and problem-solving skills in delivering the projects within the client’s time frame by meeting their standards.

PROFESSIONAL EXPERIENCE

Confidential, Carrollton, TX

SQL Server BI Developer (SSIS/SSAS/SSRS)

Responsibilities:

• Created SSIS packages to pull data from text files, XML files, SQL server and excel and exported to excel spreadsheets, flat files and vice versa.
• Published migrated data using SSIS through data flow tasks, look up transformations and script tasks.
• Managed the metadata associated with the ETL processes used to populate the data warehouse using SSIS packages.
• Extensively worked on mappings, incremental data loading, and SSIS transformations that include: lookup, filters, aggregators, scripts, multicasts, derived (not limited).
• Implemented slowly changing dimensions in SSIS packages.
• Intensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Scheduled the created SSIS packages using SQL server agent.
• Worked on error handling using try and catch blocks and performance tuning using counters in SSIS.
• Created SQL server reports using SSRS 2012/2014 for manager, customer support and that can deliver at client’s station.
• Designed different type of reports: tabular, matrix (cross tab), conditional, list items, charts and sub reports.
• Created cascading (collapsed) parameters to a report, and added report parameters that can be used in user-defined function.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
• Designed printable, interacted reports (drill-down and sorting functionality).
• Created and designed reports based on query parameters and report parameters.
• On the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Posted XML files to server and updated database and returned the response back to ASP.NET.
• Involved in creating cubes and dimensions for the new data warehouse using SQL server analysis services (SSAS).
• Took part in creation of star schema and snowflake dimensional schema in MS analysis services (SSAS).
• Supported in creating KPI, calculation members and measure groups, and MDX queries.

Environment: MS SQL Server 2014/2012/2008 R2, SQL Server Integration Services (SSIS), SQL Server Data Tools (SSDT), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Panorama, Prospect Watch mark, ASP.Net, .Net Framework MS - Visio, MS- Access, Perl & MS- Projects, SQL Lite Speed, XML, IIS, Unix, Linux.

Confidential, Mason, OH

SQL Programmer/BI Developer

Responsibilities:

• Actively participated in gathering business requirements that are focused on providing a user friendly system usage.
• Created various database objects (tables, indexes, views, stored procedures, SQL joins and triggers), and implemented integrity constraints for enforcing data integrity.
• Intensive use of stored procedures. Wrote complex stored procedures and modified the existing ones, which helped in performance tuning and also balanced the processing load between front end and back end.
• Filtered bad data from legacy system using complex T-SQL statements, implemented various constraints and triggers for data consistency.
• Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
• Indexes were reorganized or recreated and SQL queries were modified for fine performance tuning.
• Developed SSIS packages with different data sources (SQL server, flat files, and excel source files) and loaded the data into target tables.
• Used most of the SSIS dataflow transformations such as conditional split, lookup, aggregate, merge join, union all, pivot, and OLEDB command and script task.
• Created SSIS packages to migrate slowly changing dimensions.
• Worked on error and event handling, break point and check points.
• Worked on different methods of logging in SSIS.
• Migrated SSIS packages from SQL server 2005 to 2008 and scheduled their execution time.
• Deployed the SSIS packages from development server to production server.
• Designed and build the dimensions and cubes with star schema using SSAS.
• Utilized performance point server to create Scorecards and dashboards to monitor Business performance.
• Developed different types of tabular reports, matrix reports (cross tab or pivot) reports, chart and graphs, reports that aggregate data using SQL Server Reporting Services.
• Developed both the drill down and drill through reports.
• Designed reports with grouping/sorting and parameters (including multi-value parameters) using SQL server reporting services.
• Embedded the reports on to application using MS report viewer in Visual Studio 2008.

Environment: MS SQL Server 2005/2008/2008 R2, Business Intelligence Development studio (BIDS), Erwin, ASP.Net, .Net Framework, Linux,VB Script, Windows 2008, UNIX, Visual Studio 2008.

Confidential, TN

SQL Server Developer

Responsibilities:

• Participated in designing, coding, testing and implementing user interfaces, procedures and functions for new and existing software application requirements.
• Responsible in writing the stored procedures, triggers and functions.
• Fine tuning the stored procedures and SQL queries for optimal performance.
• Involved in database normalization and de-normalization.
• Used SQL server agent for scheduling jobs and alerts.
• Responsible for performing maintenance duties like performance tuning, backup, restoration and disaster recovery.
• Migration of data from one environment to another environment.
• Used reporting services extensively for generating custom and ad-hoc reports.
• Modified and deployed reports that are generated using reporting services.
• Performed replication and log shipping.
• Developed SSIS packages to extract and transform data.
• Created SSIS package to get data from different data sources, consolidate and merge in to one single source.
• Scheduled jobs and alerts.
• Used performance monitor and SQL profiler to optimize queries and enhance the performance of database servers.
• Responsible for creating and implementing logins and user permission to databases.
• Created technical design document for the project.

Environment: MS SQL Server 2008/2008R2, T-SQL, DTS, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Server Business Intelligence Development Studio, Microsoft Visual Studio 2008, C#, ASP.NET, ADO.NET, XML.

Confidential, Columbus, OH

SQL Server Developer/DBA

Responsibilities:

• Creation of users, application development and maintaining the database, controlling user access right and managing data security.
• Installed SQL server 2005/2008 on windows 2008 advanced servers, applied services packs and security fixes.
• Involved in ERD data modeling, designing and building relational data bases.
• Responsible for creating databases, tables, cluster/non-cluster index, unique/check constraints, views, stored procedures, triggers, rules and defaults.
• Set up database maintenance plan for the database integrity checks, update database statistics, cleansing and solving data base troubles.
• Administering the MS SQL server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Using the database maintenance wizard to make some necessary changes and keeping the performance of the server at acceptable levels.
• Regular monitor of servers, which includes backup job monitoring and troubleshoot all the issues on regular basis.
• Designed and implemented data base backup and restore on SQL 2008.
• Perform full backups and transaction log backups; Restore them whenever necessary, creating backup strategies and scheduling them for execution.
• Configured and implemented snapshot, merge, transactional and peer-peer replications.
• Maintain and Trouble-shoot the replication issues by continuous monitoring of Replication.
• Designed and implemented disaster recovery procedures like log shipping and mirroring between production and DR servers.
• Documented capacity planning of all servers and made recommendations accordingly.
• Created linked servers to access data from one server to another.
• Monitoring and optimizing the performance of data base via index tuning wizard, performance monitor and SQL profiler.
• Resolving various performance issues and running DBCC commands, SQL tracer, SQL profiler and NT monitoring tools.
• Migrated the data from SQL server 2000 to SQL Server 2008 using SSIS packages.
• Implementing the data changes, scripts and new releases onto the production servers.
• Implemented and maintained policies, procedures and standards to ensure security and integrity of test and production data.
• Develop clinical and non-clinical reports for end users in an Epic Clarity Environment.
• Deploy Clarity reports in both BOE Infoview and Epic-Crystal Integration

Environment: MS SQL Server 2005/2008, Windows 2005 Advanced server/NT, XML, ADO.NET, SSMS,SSIS, SSAS, SSRS, Erwin 4.0, SQL Profiler, Database Maintenance Plan Wizard, Diagnostic Manager, Database copy Wizards, Performance Monitor, EPIC, Oracle, UNIX.