SUMMARY:

• Over 7+ years of experience in the IT industry as a dedicated MS SQL Server Developer.
• Over 6+ Years of experience in data warehouse development with Integration Services (SSIS), reporting services (SSRS) and Analysis services (SSAS).
• Extensive experience with different phases of software development life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
• Extensive experience in developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and Sub queries with T-SQL.
• Strong knowledge in database design features including ER Diagrams, normalization, tables, views, indexes, constraints, keys, data dictionaries, and data integrity.
• Profound knowledge and ability to write stored procedures, temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions.
• Expertise with DDL and DML statements, RDBMS’s, data dictionaries and normal forms.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Worked on administration tasks such as data loading, batch jobs, configuring IIS, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs.
• Experience in query optimization (SQL tuning) using SQL Profiler, Database Tuning Advisor (DTA), Index tuning wizard and Performance monitor for performance tuning.
• Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL)solutions for data warehousing using SQL Server Integration Service (SSIS)
• Developed ETL process using SSIS with various control flow, data flow tasks and store procedures for work order validation process.
• Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Creating SSIS Packages and involved in Package configurations and deployments between Development and QA and Production servers.
• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both relational databases and OLAP cubes.
• Expert in designing and generating reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, matrix, dynamic reports and other features of reporting service.
• Good understanding of Microsoft Reporting Service(SSRS) with Report authoring, Report management, Report delivery and Report security.
• Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Expert in creating parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Cached, Adhoc reports using SSRS.
• Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
• Experienced in working with Star Schema modeling to develop ROLAP/MOLAP Cubes using SQL Server 2005/2008 Analysis Services.
• Experience in Cube designing in Business Intelligence Development Studio using SSAS.
• Strong experience in defining d relationships in SSAS.
• Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications.
• Ability to manage multiple tasks and responsibilities in high-pressure environments.
• Track record of taking projects to successful completion.
• Excellent analytical, problem solving skills and a team worker with a strong customer focus.
• Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Coordinating with the Systems Administration team, install and maintain Boardwalk approved application software and systems that integrate with Boardwalk's database systems.
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• Design, document, and promote security "best practices", policies, standards and protocols.
• Migrating application code and objects from development/test environments to production.
• Working with development and systems teams to perform application and database tuning.
• In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development.
• Migrating Databases from SQL Server 2005 to SQL Server 2008.
• Setup and maintenance of appropriate database and application monitoring.
• Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
• Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
• Evaluating data modeling, database administration, and database backup and recovery tools and make recommendations.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Responsible to Monitor and troubleshooting Log Shipping.
• Review of physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
• Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle.

TECHNICAL SKILLS:

• MS SQL Server 2012, MS SQL Server 2008R2
• MS SQL Reporting Services 2008R2/2012 (SSRS)
• MS SQL Server Integration Services 2008/2008R2 (SSIS)
• Report Builder 3.0, MS-Access 2007, Windows 2008 Server
• Windows XP, MS Visio, Team Foundation Server.

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

BI SQL Developer

Responsibilities:

• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• Worked on various tasks and transformations like Execute SQL Task, Execute Package Task and Conditional Split, Derived Column, Data Conversion, Union ALL, Merge and Lookup while loading the data into Destination.
• Created stored procedures, user-defined functions, views for both online and batch requests handling business logic and functionality of various modules.
• Gathered business requirements in meetings from business users to develop, test and deploy the reports in Report Server.
• Developed and tested stored procedures, SSRS reports and deployed them to Reporting Servers, Team Foundation Server into development region, test region, UAT and then into production.
• Provide development, QA and production support to troubleshoot day-to-day data related issues.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Developed various reports including Matrix, Conditional, Drill-down, Sub reports, parameterized reports, Drill-Through, and Linked-Reports.

Environment: MSSQL Server 2008R2, MSSQL Server 2010, MSSQL Server 2012, T-SQL, SSIS 2008R2, SSRS 2008R2, SSIS 2010, SSRS 2010, MS Excel, MS Word, Windows 7, Team Foundation Server, HIPAA.

Confidential, Fort Worth, TX

MS SQL Server Developer

Responsibilities:

• Created various reports including Matrix, Conditional, Drill-down, Sub reports, parameterized reports and also created number of complex formulae in sub report.
• Designed and created Report templates, bar graphs and pie charts based on the financial data of patients and also scheduled monthly/weekly/daily reports to run automatically.
• Very well understood Epic Systems software and generated reports to display data on patient care, registration, scheduling, and billing systems.
• Identified the database tables and created reports based on the business requirements usingSSRS 2008.
• Developed Functions, packages, Tables, Views, Indexes and other SQL joins and statements for applications. Designed and implemented stored procedures for automation tasks.
• Loaded data to Data warehouse using SSIS 2008R2
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export data from Excel Spreadsheets, Text file, MS Access and CSV files.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan and worked in Enterprise Manager for job scheduling.
• UsedSSISandT-SQLstored procedures to transfer data fromOLTPdatabases to staging area, then used various SSIS tasks such as Conditional Split, Derived Column, data validation checks during Staging, and finally transfer into data warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Created SQL server configurationsforSSISpackages and experience in creating Jobs, Alerts, SQL Mail Agent, and scheduleSSISPackages.

Environment: MSSQL Server 2008R2, T-SQL, SSIS 2008R2, SSRS 2008R2, MS Excel, MS Access, Windows 7, Epic Application.

Confidential ., Dallas,TX

MS SQL Server Developer

Responsibilities:

• Developing Stored Procedures and Functions used for inserting, updating, or transforming data.
• Developing complex T-SQL queries used for data investigation.
• Creating table indexes and constraints to ensure data integrity and enhance query processing.
• Created new reports from the scratch for new requirement and modifies some of the existing reports using SSRS.
• Provided documentation of reports and the development process in order to support the system.
• Created requirement documents, technical design documents and knowledge sharing documents.
• Involved in complete Software Development Life Cycle (SDLC) including system study, interaction with users & management, designing, coding, testing and deployment of the system.
• Developed chart reports, parameterized reports, drill down report, drill through report, matrix report and master detail reports.
• Created expressions in SSRS to provide flexibility to users by providing them with variety of options for seeing the business information in tables/charts etc.
• Creating data sources and subscriptions for SSRS reports to be delivered in different formats i.e. PDF, Excel, and Image.

Environment: SQL Server 2008, SQL Server Management Studio 2008, Visual Studio 2008, Microsoft Visio, MS Word, MS Excel.

Confidential, Chicago,IL

MS SQL Server Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.
• Used Query Analyzer to optimize SQL Queries.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.

Environment: SQL Server 2008, SQL Server Management Studio 2008, Visual Studio 2008, Microsoft Visio, MS Word, MS Excel.