SUMMARY

• Around 8 years of extensive experience in database activities like Data Modeling, Database Design and Development, Coding, Implementation, Maintenance and Performance Monitoring and Tuning using tools such as Index Tuning Wizard, SQL Profiler, Troubleshooting and Replication on Windows environment.
• Experience in Analysis, Design, Documentation, Development, Testing and Implementation in Client/Server applications using Confidential SQL Server 2005/2008/2012 and BI Suite for various Business, Finance and Health care domains.
• Expertise in Relational Database Management Systems using SQL Server 2000/2005/2008/2012.
• Proficient in Database Programming and Development using SQL Server and good experience in creating T - SQL (DDL, DML), Triggers, Views, User Defined Functions and Complex Stored Procedures.
• Expertise in Data Extraction and Transforming and Loading (ETL) using DTS package in MS SQL Server 2000 and SQL Server Integration Services (SSIS) in MS SQL Server 2008 with Import/Export data, Bulk insert and BCP.
• Experience in SQL Server 2005 OLAP database development including KPIs, Data Mining, working with slowly changing dimensions (SCD).
• Expert in creating Jobs, Alerts, SQL Mail Agent, Scheduling DTS packages.
• Expert in Confidential SharePoint Server and IIS web server to produce sites for file sharing, web databases and web publishing.
• Supported team in resolving SQL Reporting services and T-SQL related issues and proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Sub reports and formatting them.
• Expert in using different Recovery Models simple, full and bulk-logged depending on availability of database.
• Proficient in creating logical and physical data models using Erwin data modeling tool.
• Managed full life cycle Custom Development for several business applications from inception to completion.
• Ability to quickly learn and adapt to the rapidly changing Internet economy.
• Been involved in Agile practices such as daily scrum and sprint planning
• In-depth knowledge in Object Oriented Concepts and experience in OOAD Technologies, developing Use Cases, Activity diagrams, Sequence Diagrams and Class Diagrams using case tools like Rational Rose.

TECHNICAL SKILLS

• MS SQL Server
• Confidential Visual Studio 2010
• Confidential Integration services 2010/2008/2005
• Windows 2000/2003 Advanced Server
• Windows Exchange Server 2003
• Windows NT 4.0/3.5
• Windows9.x
• Windows XP
• MS-Access
• Oracle8.i
• Oracle 9.i
• T-SQL
• XML
• MS Visual studio 2005
• ERWIN 7.1
• Confidential SharePoint
• Confidential Visio 2003

PROFESSIONAL EXPERIENCE

Confidential, Virginia Beach, VA

MS SQL SERVER/SSIS/SSRS Developer

Environment: MS SQL Server 2008, SQL Server Reporting Services 2008, SQL Server Integration Services 2008, MS Excel, Oracle 11g.

Responsibilities:

• Gathering requirements from users and creating code design documents.
• Working with higher level management to acquire requirements.
• Creating SSRS 2008 Reports which are parameterized.
• Creating data driven subscriptions to the reports.
• Work with right fax to fax the reports to the facilities.
• Created .NET code to generate control files which are used to send faxes through right fax.
• Worked on loading of Authorizations into FACETS schema in Oracle databases.
• Created SSIS Packages to perform ETL operations on files received from third party vendors to load into FACETS schema.
• Worked on logging, scheduling, configuring SSIS packages.
• Worked on generating response files to be sent back to different third party vendors for the input files received.
• Worked on loading Flat Files, Excel Files into tables.
• Created database objects like tables, procedures, indexes and functions in both Oracle and SQL Server databases.
• Worked on fine tuning queries using execution plans.
• Created SSIS Configurations using XML Configuration and OLEDB Configuration.
• Scheduled jobs using TIDAL. Deployed SSIS Packages and Config’s using in house built tools to QA and Prod environments.
• Worked with JIRA to monitor tasks assigned and completed.
• Deployment of reports and working on production fixes for them.
• Working on tight schedules for deliverables and delivering the solution.

Confidential, Chicago, IL

MS SQL SERVER/SSIS Developer

Environment: MS SQL Server 2008/2012, SQL Server Reporting Services 2012, SQL Server Integration Services 2008/2012, MS Excel, Oracle 11g.

Responsibilities:

• Migrating Data from Oracle to SQL Server Using SSIS.
• Wrote complex queries, DDL, DML, functions, triggers, stored procedures, and views for new and existing applications.
• DesignedSSIS packages to Extract data from different sources like SQL server 2008, MS Access, Oracle 11g and transform and then load intoDimension and Fact tables in Data Warehouse using SSIS
• Load Data from different sources to support applications like I2B2, which in turn help researchers to lookup data.
• Tuned several slow running queries in Production. Implemented Indexes to achieve time performance.
• Used config files in SSIS to ease the process of moving the packages across servers (development to production)
• Used SSRS to create, execute, and deliver tabular, matrix, and charts reports.
• Designed, developed, modified and enhanced the database structures and database objects.
• Used conditional formatting to change the behavior of the report depending upon the requirement.
• Debugged and deployed reports in SSRS.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.
• Scheduled and monitored SSIS Packages using bat files and Visual Cron Job Scheduler.
• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report according to the requirement.
• Created standard report Subscriptions and Data Driven report Subscriptions
• Created several SSIS packages in Confidential SQL Server 2012.
• Transferred data into various formatted files and immediately updated my managers with the automated email systems.
• Used Confidential SharePoint Server to provide a framework for web application development.
• Optimized queries by looking at Execution Plan for better tuning of the database.

Confidential, Overland Park, KS

MS SQL SERVER Developer/MS Business Intelligence Developer

Environment: MS SQL Server 2008, SQL Server Reporting Services 2008, SQL Server Integration Services 2008, MS Excel, MS Windows Server 2003, Oracle 10g/9i.,Team Foundation Server 2010

Responsibilities:

• Collected business requirements from users and translated them as technical specs and design docs for development.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Developed Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Bulk data migration using SSIS from flat files.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS packages and scheduled them as jobs to run automatically to Process the cube, load data etc.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Developed different Parameterized Reports, which consist of, report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Report parameters included single valued parameters, multi-value parameters that also consist of different parameter types like hidden, internal, default (queried and non queried parameters).
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Used Team Foundation Server (TFS 2010) to track the changes in code.
• Used Environment variables to configure the SSIS packages.

Confidential, Chicago, IL

MS SQL SERVER Developer/MS Business Intelligence Developer

Environment: MS SQL Server 2005/2008, SQL Server Reporting Services 2005/2008, SQL Server Integration Services 2005/2008, MS Excel, MS Windows Server 2003, Oracle 10g/9i.

Responsibilities:

• Database planning in relation to physical and logical data architecture.
• Worked with XML files to load them into database using SSIS packages and XSD’s. Also worked with the XML’s to bulk load-using XQuery.
• Used Batch files to schedule the SSIS Packages built in the environment.
• Built SSIS Packages for smooth running of Interfaces necessary for the new application.
• Created Configuration Files and implemented Error Handling to support the SSIS Packages.
• Worked with multiple scripts optimizing them for smooth transition of data from old legacy system to new application
• Deployed database objects and SSIS packages into production.
• Worked with scripts for Performance Tuning by Indexing of the tables.
• Created Complex Stored Procedures, Triggers, Tables and other database objects for supporting the SSIS Packages and application.
• Created SSIS packages to import and export data from Excel, Xml and Text files and transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Worked through successful implementation of Packages by testing them and moving them to production.
• Interacted with end users to understand the business requirements and implemented those in the interfaces.
• Worked with cleaning of data by analyzing to successfully migrate the existing data to new database.
• Worked with multiple databases i.e. SQL Server and Oracle for the migration of databases from old system to new system.
• Setup Interfaces to automate and generate reports to User accessible locations on a daily basis.
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.
• Assisted in setting up the new application on the application server and worked to implement LDAP and SSO for effective functioning of the application.
• Developed and maintained system documentation, diagrams and flowcharts.
• Worked with project manager and technical leads for resolution of technical issues.
• Automating and Daily monitoring of jobs, figuring out errors and solving any Blocking issues that arise

Confidential, Redmond, WA

MS SQL SERVER Developer/MS Business Intelligence Developer

Environment: MS SQL Server 2012/2008/2008 R2,SQL server Reporting Services 2008, SQL Integration Services 2008, Confidential Visual Studio 2010, SQL Server Management Studio, MS Excel, T-SQL, ERWIN.

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes).
• Worked in Agile Environment and attended daily scrum meetings.
• Was actively involved in sprint planning to make sure they are minimum carryovers.
• Deploying new Database objects in production environment.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Wrote MDX queries to query data from cubes to the report.
• Created different Parameterized Reports (SSRS 2005/2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Create ad-hoc SQL queries for customer reports, executive management reports
• Testing and loading the data on Development and Production.
• Managing the use of disk space, memory and connections.
• Running DBCC consistency checks, and fixing data corruption in application databases
• Monitor and tune SQL scripts. Creating upgrade scripts for production database and supporting it.
• Exported and imported data from text files and Excel to SQL Server database using bulk insert and BCP utility.
• Checked Performance Tuning, Indexing, Query Optimization.
• Worked with project manager and technical leads for resolution of technical issues.
• Create reports based on data analysis and provide Heat-Mapping and Indicators in reports to help in effective handling of fraudulent activity.
• Created UDF’s, triggers, Stored Procedures for maintaining real-time servers which have 3 months’ worth of data which pull data from data warehouse.
• Created Indexes, both clustered and non-clustered for improving in performance as the tables contain huge pile of data.
• Monitoring jobs to pull huge data into real-time server for analysis purposes.
• Attending meeting with clients and upgrading and handling existing reports based on end-user requirements.
• Carried out migration to a secure sandbox environment and implementing security levels, encryption and certification on the server to ensure safety to sensitive data.
• Created cube for daily calculations of customer feedback based on different attributes and figuring out the satisfaction of customer and time and money spent on handling the call.
• Created multiple SSIS packages and deployed them to pull in data from 5 different sources regularly and use stored procedures for modifications in data and obtained derived tables to be used in reports.
• Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Added filters, columns, parameters, color coding to existing reports for user - friendliness.
• Monitored report manager granting access to end users based on level they need to look data at and providing the end-user with a clean and easily understood user-interface.

Confidential, Philadelphia, PA

MS SQL SERVER Developer/MS Business Intelligence Developer

Environment: MS SQL Server 2008, SQL Server Reporting Services, T-SQL, SQL Server Integration Services, MS Access, MS Excel, MS share point services

Responsibilities:

• Created Star schema dimension modeling for the data mart using Visio and created dimension and fact tables based on the business requirement.
• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report, Analytical Cube or an Excel pivot table
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table
• Produced operational reports in SSRS 2008 i.e. drill-down, drill-through, dashboard and matrix reports.
• Developed SSAS Cubes for building reports using SQL Server Business Intelligence Development Studio to support reporting and forecasting processes
• Wrote complex SQL queries and stored procedure to create reports using SSRS 2008 from the relational database and OLAP as SSAS 2008 source
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS
• Converted manual reports pasted together into parameter driven stored procedures to be used with Confidential Reporting Services 2008
• Attained legacy data to use as a source to develop new reports previously compiled and maintained manually
• Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables
• Created SSRS Data Model projects using Confidential Visual Studio 2008 and using Report Builder for report server to create reports
• Configured the report server and generated the report models for user interactions
• Responded to ad hoc requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.

Confidential, Cypress, CA

MS SQL Server/SSRS/ SSIS Developer

Environment: MS SQL Server 2005/2008, MS SQL Server reporting services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), T-SQL, SQL Server Query Analyzer, Visual Studio, Windows XP, Window Server 2003/2008.

Responsibilities:

• Installed, upgraded and migrated databases from Oracle database to MS SQL Server 2005/2008.
• Created business process diagrams defining current business processes.
• Generated reports using MS SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Developed ad-hoc reports, drill through reports, drill down reports, parameterized reports, and other report models using MS SQL Server 2005 SSRS.
• Constructed the OLAP cube using SSAS and used SSIS to transform the data into OLAP.
• Created T-SQL queries for schemas, views, stored procedures, triggers and functions for data migration. Involved in the project from planning stage to pushing codes to production.
• Designed ER diagrams and mapped the data into database objects and performed normalization of the database in OLTP.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agentusing SSAS.
• Wrote MDX scripts to create name sets and calculated members and created reports by dragging data from cube in SSAS.
• Worked as a technical expert in the design, development, and maintenance of OLAP cubes and databases
• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2005.
• Performed system study and requirements analysis, prepared data flow diagrams, entity relationship diagrams, data diagrams, and table structures to store the data.
• Created SQL scripts to insert/update and delete data in MS SQL database. Created database tables, wrote stored procedures to update and clean the old data and also helped the front end application developers with their queries.
• Designed and created different ETL packages using SSIS and transferred data from Oracle source to MS SQL server destination.
• Performance tuning of SQL queries and stored procedures using SQL profiler and index tuning advisor.
• Configured SQL mail agent for sending automatic emails on errors and developed complex reports using multiple data providers, user defined objects, charts, and synchronized queries.
• Used business object tools to develop reports and accessed, formatted, and delivered information to large populations of users.
• Developed complex reports using multiple data providers, user defined objects, charts, synchronized queries, and created star schema in SSAS to develop ad-hoc reports for the clients as per their requirements using SSRS in MS SQL 2008.

Confidential

SQL Server Developer

Environment: Confidential SQL Server 2000, Sql Server Integration Services, SQL Server Reporting Server, T-SQL, SQL Profiler

Responsibilities:

• Involved in gathering user requirements, draft specifications, design and create Database objects for performance tuning.
• Part of team for analyzing and implementing the physical design for the database.
• Responsible for drafting documentation for describing the metadata and writing technical guides.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Involved in Implementation of database design and administration of SQL based database.
• Optimized queries and stored procedures.
• Wrote T-SQL procedures to generate scripts that modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Created Stored Procedures, Triggers, Tables, Views and SQL Joins and other statements for various applications
• Responsible for transferring of the databases and database objects from Development to Production Server using DTS.
• Analyzed and tuned complex Queries/Stored Procedures in SQL Server 2000 for faster execution and developed database structures