SUMMARY

• Having 7+ experience in SQL Server Development (2012, 2008 R2 & 2005) Including writing T - SQL Programming, SSRS and SSIS.
• Involved in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2000/2005/2008/2012.
• Upgraded the existing environments from SQL Server .
• Expert in creating Databases, Tables, Stored Procedure, Triggers, Views, Cursors, User defined data types, Indexes, Derived Tables and Common Table Expressions (CTEs) using T-SQL programming to facilitate efficient data manipulation and data consistency.
• Experience in providing enterprise reporting solutions, crystal Reports, performance point Server, ProClarity and SharePoint Services.
• Expertise knowledge in MDX and Advance MDX, and DAX Language.
• Having experience on SQL Server 2014/2012 database development and administration.
• In-depth experience of Transact-SQL (DDL, DML), Designing and Normalization techniques on the database tables.
• Good experience in creating User Defined Functions and Triggers in observing Business Rules.
• Maintenance of C# application by adding the additional functionality, fine tuning the application, and Production Support for the application.
• Expert in Extracting, Transforming and Loading (ETL) data from Flat File, Raw File, XML and any OLE BB Data Source to Excel, Flat File, Raw File, any OLE DB or MS SQL Server Destinations by using SSIS services.
• Used Object Oriented Programming (OOP) techniques and created classes in C#.NET 3.0 for the calculators.
• Microsoft Business Intelligence, Power Builder. Operating Systems Windows 7/XP/NT/2003/2000 Configuration Tools MS Visual SourceSafe, MS Team Foundation Server Framework Microsoft .NET Framework 4.0, 3.5, 3.0.
• Expertise in Creating, Deploying and managing SSIS package.
• Expertise knowledge using user interface using ASP.NET, C# .NET Microsoft .NET framework.
• Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Designed and created MDX queries to retrieve data from cubes using SSIS.
• Monitored and Optimized SSIS package performance to reach the expected time frame for data loading.
• Expertise in Creating, Deploying and managing Reports through SQL Server Reporting Services (SSRS).
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
• Developed Standard Reports, Sub Reports, Cross Tab Reports, Used various Charts and graphs like Bar Chart and Line graphs in SSRS.
• Expert in Query Optimization and tuning the query, creating Indexes to improve the query performance.
• Expertise in Data Extraction, Transforming and Loading (ETL) between different Systems using SQL tools (SSIS, DTS, Bulk Insert, and BCP).
• Good knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Expertise in creating Cell Level Security in cubes using SSAS.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Expertise in creating Dashboard Reports to support end users using SSAS.
• Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating databases/File groups/files/Transaction logs.
• Experience in SQL Mail Agent, Database Mails and Scheduled DTS and SSIS Packages.
• Good Knowledge of SQL Server Clustering, Replication, Data Mirroring, Linked Servers and Log Shipping.
• Participates in Disaster Recovery exercises, testing and reporting during hardware/software upgrades.
• Knowledge on Replication Models such as Transaction, Snapshot and Merge in SQL Server 2005.
• Extensive experience in developing, enhancing and maintaining web application.
• Participated in all phases of SDLC starting from Analysis to Delivery of the application development projects and also supported enhancements and maintenance of existing applications.
• Good analytical and programming skills in C#, ASP, ASP.NET, VB Script and Java Script.
• Hands on experience in project management tools like Team Foundation Server (TFS), Clear case and VSS.
• Strong analytical skills with ability to quickly understand client's business needs.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.

TECHNICAL SKILLS

Relational Databases: MS SQL Server 2000/2005/2008/2008 R2/2012, Oracle 8i/9i/10g/11g, SQL Server Management Studio (SSMS), MS Access.

Tools: and Packages: SQL Server Management studio, Enterprise Manager, Profiler, SSIS, SSRS, Microsoft Visual Source Safe, Visual Studio .Net.

Languages: T-SQL,SQL, PL/SQL, C, C#, ASP.Net

Operating Systems: Windows vista/XP/2003/2000/NT 4.0/9x, MS-DOS

Web Technologies: HTML, XML, XSL,, IIS(4.0/5.0/6/0)

Operating Systems: Windows 2008, Windows 2000/2003 Server, Windows NT, Windows 95/98/2000 XP, UNIX, LINUX.

Data Modeling Tools: ETL, Visio, Microsoft Office Suite.

BI Tools: SQL Server Integration Services(SSIS), SQL Server Reporting Tools (SSRS), Crystal Reports

Configuration Management Tools: Visual Source Safe, Team Foundation Server

PROFESSIONAL EXPERIENCE

Confidential - Dallas, TX

SQL/MSBI Developer

Responsibilities:

• Created various database tables and procedures to update and clean the old data.
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications
• Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
• Designed SSIS Packages in SQL Server 2012 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
• Performed activities like analyzing and improving the architecture of databases, creation & indexing of the tables.
• Involved in designing the data warehouse and core Database for the system including tables, Stored Procedures, Indexes, UDF and triggers.
• Performed operations such as Fine-tuning queries and stored procedures and providing consultation to other developers.
• Designed SSIS packages to extract data from OLTP having sources like MS SQL Server 2000, Oracle Database, Text Files, Excel and Access to OLAP systems (SQL 2005/2008) and scheduled jobs to call the packages and stored procedures.
• Implemented SSIS (ETL) to extract and transform data from RDBMS and Flat files/CSV, SQL Server 2012 instances and to load into staging and then to DW for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel, Text file, XML file to different data Marts.
• Configured and scheduled packages to be deployed out to a production environment using SQL server Table file configurations in SSIS.
• Having hands on experience in DR Processes including Log Shipping and Database Mirroring.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Configured packages for development, QA and Production environments
• Created tabular, matrix, Drill down and drill through reports, multi value parameter reports.
• Generated Daily, Weekly, Monthly, Subscriptions, Dashboard reports for the analysis of managers and end users by using SSRS.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Expert in designing 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, cascading prompts, matrix dynamics reports and other features of reporting service.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS in Business Intelligence Development Studio (BIDS).
• Defined report layouts and created Parameterized, Drill down, Drill through and Aggregation reports in MS SQL environment using SSRS.
• Deployed the SSRS Reports to the server for the use of end users.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Used Query Optimization and SQL Server Profiler for tuning report queries and improved performance in SQL Server.
• Created different Power Pivot reports as per the client requirement.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.

Environment: Microsoft SQL Server 2012 and 2008 SSMS, SSIS, SSRS, Microsoft Visual studio 2012, Team foundation server, C#

Confidential - Richmond, VA

SQL / MSBI Developer

Responsibilities:

• Worked on the analysis of the Design Specification documents for the Packages and coordinated with team members at the time of changes in Business requirements and changes in Data Mart Schema.
• Designed, reviewed, and created primary objects based on logical design models, user requirements and physical constraints.
• Monitoring SQL Server performance using SQL Server Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuild indexes if necessary.
• Responsible for making an analysis of transactions of the client and determining solution for settlement of the client account.
• Worked on some ranking functions such as RANK, NEWID, PIVOT, APPLY, ROW NUMBER.
• Developed customized reports based on the patient database according to the requests using T-SQL.
• Extensively used Views for complex joins queries involving multiple tables from different databases.
• Maintained databases with Data Base Consistency Checks (DBCC) such as Rebuilding Indexes and Integrity Checks.
• Used execution plan to identify slow running queries to resolve query performance by designing proper indexes and updating statistics
• Wrote complex stored procedures for the Application Development using T-SQL.
• Worked on Common Table Expression which uses rank function to calculate the ranking of clients based on the policies they insured.
• Actively participated and interacted with project manager and other team members to process the complex business logic and requirements of the project.
• Responsible for extracting and loading client historical data from source to SQL environment for performing various business operations using SSIS.
• Upgraded the data from one server to another server (SQL Server 2008 to SQL Server 2012) for the SSIS Packages and SSRS reports.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems with different transformation and scheduled Jobs to run the packages on a daily basis.
• Implemented the changes in the existing ETL process to move data back and forth from ODS to all the integrated systems.
• Developed SSIS Packages to extract data from Excel spreadsheets, Microsoft Access database and flat files, load them onto SQL server 2012 for Data Analysis and Reporting by using multiple data flow transformations such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Created Clustered and Non-clustered Indexes for Query Optimization and also involved in Database Tuning.
• Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
• Created/modified complex stored procedures to fit to the changing requirements and to enhance performance and developed custom functions, indexes to ensure accuracy, quality and consistency of the database.
• Created triggers that capture the customer updates and made the required transformations to move the customer preferences to ODS.
• Created Tables, Stored Procedures, Views, Constraints and User Defined Functions.
• Involved in the design, development and deployment of customer purge, mass consolidation process in ODS.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Worked on the performance optimization of the ODS import jobs.
• Worked on the analysis of test cases with the team members and make the necessary changes.
• Designed, developed the customer comparison reports in MS SQL Server environment using SSRS 2008.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Providing the client with documentation, with component and task level details.
• Performed the Unit testing for packages developed to ensure that it meets the requirements.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Used the SQL Profiler, query execution plans to trace the performance of TSQL Statements, procedures and functions.

Environment: MS SQL Server 2012/2008, SQL Server Reporting Service (SSRS) 2012/2008, SQL Server Integration Service (SSIS) 2012/2008, T-SQL, PL/SQL, Excel.

Confidential, Morgantown, WV

MS SQL / BI Developer

Responsibilities:

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.
• Worked withT-SQLtocreateTables, Views, Triggers and Stored Procedures.
• Created complexjoinsand implementedConstraintson tables for maintainingData Integrity.
• Frequently used to connect to the health care data marts at different locations using C#.Net and ADO.Net for scheduling jobs.
• Designed and developed custom .NET components and user controls using ASP.NET
• Wrote VB Scripts to create custom SSIS transformations, in addition to using built-in SSIS transformations.
• Involved in creating high levelETLarchitecture for overall data transfer toOLTP, ODSwith the help ofSQL Server 2005, 2008Integration services.
• Involved inrelational database modelinglike, designing the tables, algorithmic diagrams for the input data (entity diagrams), indexes etc.
• Worked on retrieving data from Legacy sources, retrieve files on daily, weekly and monthly basis,file-transfersfrom one location to other.
• Created complex SSIS packages using appropriatecontrol and data flow elementswithSSIS Standards likeerror handling, loggingand working withpackage config files.
• Exporting the database from Local server to the remote server and importing the current running database from remote server to thelocal DB Server using SSIS.
• Created Tablix reports, Tabular/Matrix reports based on requirements.
• Created Dashboards using SSRS.
• Reduced the overallETL time bySQL Query performanceTuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.
• Created databases, tables, and fields for data entry,performingdatabase capacity planning.
• Enhanced anddeployed the SSIS packagesfrom development server to production server andscheduled jobs.
• Supported the production team when issues rose in the packages.

Environment: MS SQL Server 2008R2, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, BCP, T-SQL

Confidential, Torrance, CA

SQL /ETL Developer

Responsibilities:

• Gathered requirements from the business users, created technical specification documents.
• Defined relationship between tables and enforced the referential integrity constraints.
• Gathered the data from different sources using SQL Server Integration Services (SSIS) 2008 using different transformation, constraints, checkpoints and configuration settings.
• Used C#. Net and VB.NET to develop different modules of the end-user interfaces and different SSIS packages.
• Worked with SQL Profiler, Tuning Wizard, Execution Plan and Performance Monitor in order to analyze and optimize the queries, procedures.
• Added/modified Users, Groups, folders, rights and involved in the implementation of log shipping, mirroring to maintain the high availability of the servers.
• Created/modified SQL Joins, sub-queries, indexes, stored procedures, triggers and other T-SQL, PL/SQL code to implement business rules and automate the tasks.
• Involved in documenting the project steps and presenting to the team members.
• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.
• Worked withT-SQLtocreateTables, Views, Triggers and Stored Procedures.
• Created complexjoinsand implementedConstraintson tables for maintainingData Integrity.
• Frequently used to connect to the health care data marts at different locations using C#.Net and ADO.Net for scheduling jobs.
• Designed and developed custom .NET components and user controls using ASP.NET
• Wrote VB Scripts to create custom SSIS transformations, in addition to using built-in SSIS transformations.
• Involved in creating high levelETLarchitecture for overall data transfer toOLTP, ODSwith the help ofSQL Server 2005, 2008Integration services.
• Involved inrelational database modelinglike, designing the tables, algorithmic diagrams for the input data (entity diagrams), indexes etc.
• Worked on retrieving data from Legacy sources, retrieve files on daily, weekly and monthly basis,file-transfersfrom one location to other.
• Created complex SSIS packages using appropriatecontrol and data flow elementswithSSIS Standards likeerror handling, loggingand working withpackage config files.
• Exporting the database from Local server to the remote server and importing the current running database from remote server to thelocal DB Server using SSIS.
• Created Tablix reports, Tabular/Matrix reports based on requirements.
• Created Dashboards using SSRS.
• Reduced the overallETL time bySQL Query performanceTuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.
• Created databases, tables, and fields for data entry,performingdatabase capacity planning.
• Enhanced anddeployed the SSIS packagesfrom development server to production server andscheduled jobs.
• Supported the production team when issues rose in the packages.

Environment: MS SQL Server 2008, SSRS 2008, SSIS 2008, SSMS, TFS, VB.NET, C#.NET, T-SQL, PL/SQL, Oracle 10g, MS Share Point, Access and Excel.

Confidential, Columbia MD

SQL Server MSBI Developer

Responsibilities:

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Migrated all DTS packages to SQLServer Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Created Query Parameters and Report Parameters to control data returned by the query and filter data at report level.
• Developed tables, Views, Stored Procedures and Triggers using SQL Server Management Studio.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Established Inner Join, Outer Join and created Indexes whenever necessary.
• Modified report content and exported reports in multiple formats based on user input.
• Developed logical and physical data models, design data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
• Scheduled the reports to run on daily/weekly/monthly basis and email the results to the users in the required format.
• Created User Defined functions for sharing formulas across multiple reports.
• Modified existing reports according to requirements of the end users.

Environment: MS SQL Server 2005/2008, SSRS 2005/2008, SSIS 2005/2008, SSMS, ASP.NET, VB.NET, C#.NET, T-SQL, PL/SQL, Oracle 10g, MS Share Point, Access and Excel.

Confidential

SQL Developer

Responsibilities:

• Involved in gathering requirements from business users.
• Involved in transformation of data from various sources and legacy systems like Teradata, SQL Server 2000 and Excel into SQL Server 2000 using DTS.
• Created triggers that capture the claims and wrote complex formulas that calculate the amounts related to those particular claims.
• Created number of complex formulas to calculate the amounts related to different claims in sub reports using different types of variables like shared variable and retrieved them from master report
• Created complex stored procedures to fetch and manipulate data in the databases.
• Created Tables, Stored Procedures, Views, Constraints and User Defined Functions.
• Wrote and Optimized Triggers, Stored Procedures and Queries in T-SQL.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Customized reports by adding new features such as report alerts, cross-tabs, running total, sub-reports and drill-down fields.
• Modified report content and exported reports in multiple formats based on user input.
• Designed/modified database schema objects to support existing and new business related application development for a global-application.
• Write/test SQL scripts to perform application specific data manipulation

Environment: MS SQL Server 2000, T-SQL, DTS, Teradata, Excel.