SUMMARY

• Around 6.5 Years of experience in IT as SQL Developer and Analyst, involved in requirement gathering, analysis, configuration, deployment and administration of Enterprise database applications
• Experienced in all the stages of Software Development Life Cycle and in the migration and up - gradation of databases.
• Accommodated and facilitated Joint Application Development (JAD) session, documented, analyzed and synthesized the results as parts of business requirements.
• Extensively worked on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflake schema.
• Actively involved in the enterprise Data Warehouse designing using Kimball design methodologies and following DW Design best Practices.
• Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization.
• Created Indexes, Views, Index views, Constraints, Stored Procedure, User-Defined functions, CTEs, and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency.
• Monitored and tuned the performance of Complex T-SQL queries and stored procedures by analyzing the execution plan and also using tools like SQL Server Profiler.
• Created partitions on tables, indexes and index views as well as querying and managing partitions from optimization point-of-view according to the business criteria.
• Responsible for Database consistency checks using DBCC utilities, Performance Tuning and Query Optimization.
• Worked on data import from different file systems including XML, text, and CSV and Excel files.
• Performed data cleansing using different transformations within SSIS packages to eliminate redundant data from the pre-staging database.
• Designed SSIS packages using various Transformations such as Fuzzy Lookup, Fuzzy Grouping, Aggregate and Derived Column Transformations.
• Experience in Error Handling and Debugging packages using Checkpoints, Data Viewers, Breakpoints, Event Handlers and Loggings (SSIS or Custom Loggings).
• Created package configurations to provide an easy solution to migrating packages from different business environments like development to testing or testing to production.
• Designed ETL packages using proper Loggings and Checkpoints, secured packages with Encryption in conjunction with passwords.
• Responsible for designing test cases for testing the ETL packages.
• Involved to planning and designing SSAS Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Optimized cubes by assigning appropriate storage modes to partitions, and created usage based optimizations for better query performance.
• Created automated backup of OLAP cubes as well as normal backup using SQL server management studio.
• Generated various reports like tabular, matrix, parameterized, sub reports, drill down and drill through reports using SSRS.
• Experience with the formatting of reports for various visual representations using conditional formatting and templates.
• Hands-on experience of setting up schedules for push and pull delivery methods for SSRS reports using Standard and Data Driven Subscriptions.
• Deployed different type of report on Share Point 2010 and used dashboard.

TECHNICAL SKILLS

Tools: SQL Server Reporting services MS BI (SSRS, SSIS and SSAS), Tableau, Dreamweaver CS5, TOAD and WAMP.

Languages: ASP, ASP.NET, PL/SQL, PHP, C#.Net, and Basics in Java and JSP.

Web Technologies: HTML, CSS, JavaScript, XML, XSL and XPATH.

Databases: SQL Server 2005/2008, My SQL, Oracle 10g/11g.

Frameworks: NET 3.0/3.5

IDE: Eclipse 3.x, Visual Studio, Visual Web developer.

Operating System: Windows, Linux (Solaris).

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

MS SQL Support Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers and created documentation for the same.
• Created stored procedures with proper error handling, transactions and performance tuning features.
• Created Indexes, Views, Index views, Constraints, Stored Procedure, User-Defined functions, CTEs, and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency.
• Act as the Business Analyst for the Cost report and some other Kiewit Applications.
• Coordinating with the Functional Team for any Project requirements that come in solution design.
• Actively optimizing and enhancing more than 250 different reports of Kiewit Business whenever a user puts in a request as a member of production support.
• Deployed SSRS reports to the reporting server in SharePoint Integrated mode and assisted in troubleshooting deployment problems.
• Created different schedules for report delivery to e-mails and shared directories, enabled snapshots, subscriptions, caching to improve the response times and reduce traffic to the report server.
• Used TFS (Team Foundation Server) for code check-in and check-out and manage different versions of complicated code and distribute them to different teams in the organization.
• Optimized cubes by assigning appropriate storage modes to partitions, and created usage based optimizations for better query performance.
• Created automated backup of OLAP cubes as well as normal backup using SQL server management studio.
• Involved in debugging of packages with help of Breakpoints, Checkpoints, Event Handlers and Loggings.
• Implemented Package configuration/parameters to make packages dynamic in order to modify the SSIS packages from a test /development environment to the production servers for day to day operation.
• Created SSISDB catalog with SQL Server 2012 to support SSIS package deployments in SSMS.
• Optimized the performance of slow executing SSIS packages by making changes as Control Flow and Data Flow like avoiding blocking transformations, increasing buffer size.
• Automated the ETL process by scheduling SSIS package execution by creating jobs.
• Designed SSIS package templates as base code for package development incorporating package configurations, connection managers and logging in it.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server Analysis Services.
• Created several reports using SSRS like drill through reports, linked and sub reports.
• Managed very large reports that return a large volume of records and optimized their performance using techniques like cascading parameters and filters.
• Designed several scorecards and dashboards using Power Pivot to display information needs by other departments and upper management.
• Deployed SSRS reports to the reporting server in SharePoint Integrated mode and assisted in troubleshooting deployment problems.
• Created different schedules for report delivery to e-mails and shared directories; enabled snapshots, subscriptions, caching to improve the response times and reduce traffic to the report server.
• Optimized reports by optimizing the embedded queries, or optimized the stored procedures that generate them.
• Used TFS (Team Foundation Server) for code check-in and check-out and manage different versions of complicated code and distribute them to different teams in the organization.
• Have received appreciations from the client for the prompt response on any work assigned.

Environment: Microsoft SQL Server 2008R2/2012, MS Windows Server 2008, SSIS, SSAS, SSRS,, T-SQL, SharePoint, C#.Net, SharePoint, TFS

Confidential, Morrisville, NC

MS SQL Server Developer

Responsibilities:

• Actively involved in gathering system specification requirements for the project.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Created complex stored procedures with proper error handling, transactions and performance tuning features.
• Designed indexes and indexed views to speed up query performance and used Database engine tuning advisor for further suggestions.
• Created Triggers to enforce user defined integrity as per the business logics.
• Created complex stored procedures to perform Index maintenance, data profiling, for loading data marts and generating datasets for reports.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Created staging database to perform various ETL data massaging operations such as data profiling, data cleansing and data verification.
• Designed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources.
• Developed complex mappings using SSIS to transform and load the data from various source systems like Oracle, Excel and Flat files into the SQL 2012 Server target staging database.
• Extracted data from various sources like Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Implemented Master/Child Packages so only the Master Package has to be scheduled which will in turn fire the other packages.
• Involved in debugging of packages with help of Breakpoints, Checkpoints, Event Handlers and Loggings.
• Implemented Package configuration/parameters to make packages dynamic in order to modify the SSIS packages from a test /development environment to the production servers for day to day operation.
• Created SSISDB catalog with SQL Server 2012 to support SSIS package deployments in SSMS.
• Optimized the performance of slow executing SSIS packages by making changes as Control Flow and Data Flow like avoiding blocking transformations, increasing buffer size.
• Automated the ETL process by scheduling SSIS package execution by creating jobs.
• Designed SSIS package templates as base code for package development incorporating package configurations, connection managers and logging in it.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server Analysis Services.
• Created several reports using SSRS like drill through reports, linked and sub reports.
• Managed very large reports that return a large volume of records and optimized their performance using techniques like cascading parameters and filters.
• Designed several scorecards and dashboards using Power Pivot to display information needs by other departments and upper management.
• Deployed SSRS reports to the reporting server in SharePoint Integrated mode and assisted in troubleshooting deployment problems.
• Created different schedules for report delivery to e-mails and shared directories; enabled snapshots, subscriptions, caching to improve the response times and reduce traffic to the report server.
• Optimized reports by optimizing the embedded queries, or optimized the stored procedures that generate them.
• Used TFS (Team Foundation Server) for code check-in and check-out and manage different versions of complicated code and distribute them to different teams in the organization.

Environment: Microsoft SQL Server 2008R2/2012, MS Windows Server 2008, SSIS, SSAS, SSRS, Erwin, T-SQL, SharePoint, C#.Net, SharePoint, Power Pivot, Power View, TFS

Confidential, Oklahoma City, OK

MS SQL Server Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers and created documentation for the same.
• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface the database and other applications in most efficient manner.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
• Created SSIS package to load data from XML Files and SQL Server 2005 to SQL Server 2012 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Prepared technical and functional designs in collaboration with teams and business users for Netezza
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2012..
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database objects like stored procedures, functions, tables, views.
• Configured the report viewing security for various users at various levels using Report Manager.

Environment: MS SQL Server 2012, T-SQL, SSIS 2012, SSRS 2012, TFS 2010, Advanced Server, SSMS, ER win v7.2, ASP.Net, C#, SharePoint.

Confidential, Fort Myers, Florida

MS SQL Server Developer

Responsibilities:

• Created views, Stored Procedures and Optimized existing stored procedures to achieve improved performance.
• Created packages to validate, extract, transform and load data to a centralized SQL server from the existing diversified data sources
• Migrated data from production and development databases to centralized SQL Server databases using SSIS to overcome transformation constraints.
• Developed SSIS packages to conduct simple and complex transformations, and executed these packages using the execution package.
• Created SSIS packages which include data staging like importing, Cleansing, Parsing by using SSIS tools.
• Developed advanced correlated and un-correlated sub-queries in T-SQL to develop complex reports and generated Sub-reports, Drill-Down, Drill- Through and Parameterized reports using SSRS 2008 R2.
• Responsible for monitoring and tuning SSRS Report Performance.
• Managed to Import and export the data from text files to tables using functions and stored procedures.
• Responsible for monitoring and tuning SSIS package Performance.
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.
• Assisted DBA in Experience in implementing Data and Database Security using various Default Database and Server roles and also by creating User-defined as well as Application roles.
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning on SQL server.

Environment: MS SQL Server 2008 R2, T- SQL, SSMS, SSIS, SSRS, SSAS, MS Access, Excel, Visio, Visual Studio, Windows Server, Erwin, Share Point, T-SQL, ETS, Power Pivot,.

Confidential, NY

MS SQL Server Developer

Responsibilities:

• Involved in all the phases of SDLC.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various types of Constraints and Triggers for Data Consistency.
• Used Stored Procedures for updating Servers.
• Used DDL and DML Triggers, Stored procedures to check the Data Integrity and verification at early stages before calling them.
• Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load data into Data Ware House.
• Used VB. Net and C# code in Script Task and Script Component.
• Developed, deployed and monitored SSIS Packages. Involved in creating log files for SSIS packages.
• Created SSIS Package configurations for executing in different environments.
• Enabled Check points in SSIS package. Created break points in order to view the status of data, variables and over all status of SSIS package.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Developed and Deployed different types of Reports like List, Matrix, and Chart and Sub Reports etc.
• Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created/ Maintained clustered/ non clustered Indexes for fast and efficient reporting process.
• Used SSRS to create interactive reports with an ability to drill down into details.

Environment: MS SQL Server 2005, SSIS, SSRS, T-SQL, Crystal Reports 10,Visual Studio 2005, MS Office 2003, SQL Profiler, Windows 2000/2003.

Confidential

MS SQL Server Developer

Responsibilities:

• Generated reports using SSRS.
• Used Classic ASP technology for displaying the reports.
• Updated all the web pages to ASP.NET 2.0.
• Expertise in developing SQL’s and stored procedures for interacting with the database
• Developed scripts for Client side validations using VBScript.
• Involved in code changes and enhancements
• Involved in deployment activities
• Involved in Support activities and handling user requests
• Monitoring daily, weekly and monthly activities
• Involved in creating project related analysis, approach and testing documents

Environment: SSRS, SSIS, Classic ASP, SQL, PL/SQL, VBScript, ASP.NET, Windows 2003, Oracle 10g, SQL Server 2005, Microsoft Visio 2007, VSS, MS Access