V N KALYANI. M

Contact no: 248-***-****

acxsdd@r.postjobfree.com

PROFESSIONALSUMMARY:

Over 8+ years of IT experience in Database Design, Development and Support of MS SQL Server 2012, 2008, 2005and 2000.

Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2012/2008/2005/2000.

Expertise with DDL and DML statements, RDBMS, data dictionaries and normal forms.

Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Complex Views, Dynamic SQL, Triggers and Cursors.

Experienced in writing stored procedures, using temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions.

Experienced in transforming complex business logic into Database design, Migration and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views, Data Modeling and DTS.

Proficient in PL/SQL procedures, functions, packages, stored and tuning on queries while extracting and loading data into sources.

Experience in using Try Catch Block introduced in SQL Server 2005.

Experience in writing complex T-SQL queries using Inner Joins, Outer Joins and Cross Joins.

Expert in SQL Server tools like SQL Server Reporting Services, SQL Server Integration services, SQL Server Analysis Services.

Extensive experience with T-SQL, Functions, Views. Created complicated SQL procedures to meet the requirements of the systems being developed.

Experience in gathering business requirements and translating them into technical specification and creating reports with respect to business requirement.

Experienced in creating different types of Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports, Summary Reports, List Reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).

Strong ability in defining query for generating drill down reports, handling parameterized reports, Cascaded Reports, Custom Reports and creating stylish report layouts in SSRS2005/2008.

Proficient in migrate earlier versions of SSRS to new 2012/14 format, and developed and deployed new reports as required.

Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP, and XML.

Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.

Created and maintained Databases, creating Roles and managing user permissions, resolving deadlocks.

Reviewed, analyzed, and modified programming systems including encoding, testing, debugging and installing to support an organization's client/server software applications.

Extensively used tools like SQL Profiler, Database Engine Tuning Advisor and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.

Provided after hours and 24/7 database maintenance and support.

Well-versed with database including, backups, disaster recovery, database maintenance, user authorizations, database creation.

EDUCATION

Bachelor of Computer Sciences from Osmania University, India.

Master of Computer applications from Viswa Bharathi University, India.

TECHNICAL SKILLS:

Databases Tools

SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

ETL Tools

Data Transformation Services (DTS) – Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools

SQL Server Reporting Services (2012/2008/2005/2000), MS Access, MS Excel, Crystal Reports XI.

Database

MS SQL Server 2014/2012/2008/2005/2000, MS Access, Oracle 11g/10g/9i

Programming

T-SQL, PL-SQL,C#, ASP.Net, VB.

Web Technologies

HTML, DHTML, XML, VB Script, Java Script (Validation),

Operating Systems

Windows 95/98/2000/XP/NT/2003, Vista, DOS, UNIX,

Modeling Techniques/Tools

Flow Charts, Sequence Diagrams, Activity Diagrams, Use case diagrams, Data Modeling, ER Diagrams, MS Visio, MS Visual Source Safe 6.0/2005, SharePoint Designer 2010,

PROFESSIONAL EXPERIENCE:

CERNER Corporation, Kansas City,MO Jan’15– Current

Role: SQL Server/BI Developer

Responsibilities:

Involved in all phases of SDLC, and gathered business requirements from business people.

Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.

Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).

Created ETL me tadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.

Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments.

Created complex Stored Procedures using Linked Server, CTE, Temp Table, SQL Joins, ranking functions and Dynamic SQL and responsible for performing T-SQL tuning, multi-tasking and optimizing queries which takes longer time in execution with SQL Server 2008/2012.

Performed Documentation for all kinds of reports and DTS and SSIS packages.

Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.

Used T-SQL to create various queries.

Assisted in production wrote queries to produce reports using SQL Server 2008/2012 Reporting service (SSRS)

Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.

Created Scorecards and added them to dashboard using Dashboard Designer and deployed the dashboard to SharePoint.

Created SSIS packages to load data from Oracle to Sql Server using various Transformations in SSIS.

Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.

Created new database objects like Functions, Packages, Triggers, Indexes and Views using

T-SQL in Development and Production environment for SQL Server.

Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.

Involved in shell scripting, windows shell scripting.

Involved in migration from SQL Server 2008 to SQL Server 2012.

Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).

Created Packages in SSIS with error handling.

Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.

Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.

Created reports in SSRS with different type of properties like chart controls, filters,Interactive Sorting, SQL parameters etc

Work as part of a team and provide 7 24 supports when required.

Do general technical trouble shooting and give consultation to development teams.

Performed development support, document reviews, test plan, integration of the system.

Environment:MS SQL Server 2008/2012, DB2, T-SQL, MS Excel, HTML, IIS, ETL,TFS, MS Access, Visio, JavaScript, Vb.Script, XP professional, Crystal reports, Progress, Shell Scripting,PL/SQL, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, SharePoint Designer, Import & Export Data, SSRS,SSIS,SSAS.

Client: Citi Bank, Irving,TX Oct’13 – Nov’14

Role: SQL Server/Reports Developer

Responsibilities:

Gathered business requirements from users and translated them as technical specification for development.

Identified various data sources, formulated data dictionaries, design and develop data models based on the given specs and requirements.

Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS/DTS

Created ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.

Developed reports using SSRS and published as PDF, Excel, and CSV formats.

Created Complex T-SQL, Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc. on various database objects to obtain the required results.

Created different type of reports which include: A Cross-tab, Conditional, Sub reports, Drill-down and Parameterized, Linked reports and deployed and scheduled Reports in Reports Manager using SSRS to generate all daily, week, monthly and quarterly Reports.

Created queries to produce reports using SQL Server 2008/2012 Integration Services (SSIS) and Reporting service (SSRS).

Oracle PL/SQL and shell scripts, Data conversions, Data import/export and Data cleansing were developed.

Defined Check constraints, Business Rules, Indexes, and Views.

Worked on querying the data and creating-on demand reports using Report Builder in SSRS.

Developed and delivered dynamic reporting solutions using MS SQL Server 2008 Reporting Services (SSRS).

Participated in requirement gathering, application design and training operational users.

Worked on all types of report types like tables, matrix, charts, sub reports etc.

Migration of stored procedures and database objects between development and test environments.

Worked with users in training and support.

Attend regular project meetings and weekly status meeting.

Environment: SQL Server 2012/2008R2,SSIS, SSRS, SSAS, PL/SQL,DTS, Shell Scripting, T-SQL, SSMS, BIDS, Windows XP.

Client: SSM Healthcare, Saint Louis, MO Apr’ 13 – Sep’13

Role: SQL Server Developer

Responsibilities:

Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.

Created checkpoints and configuration files in SSIS packages

Performed incremental data load in BIDS using Lookup Transform, Cache Transform, and Merge Join Transform and worked on Change Data Capture.

Automated execution process of packages using SQL Server Agent by creating jobs and error reports using Alerts, SQL Mail Agent and SMTP.

Involved in upgrading the databases and servers of SQL Server 2008R2 to SQL Server 2012

Experience in creating packages to transfer data between ORACLE, MS ACCESS, Informix, Flat Files, Excel Files, to SQL Server 2008R2 using SSIS.

Developed various T-SQL stored procedures triggers, views, and adding/changing tables for dataload and transformation, and data extraction.

Involved in creating SSIS jobs to automate the reports generation.

Great Expertise in Deploying SSIS Package to Production and used different types of Package configurations to export various package properties to make package environment independent.

Created data sources, connection strings and defined the datasets for generating the report.

Worked on Performance Tuning, SSIS packages error handling.

Supported the team in resolving in DTS and T-SQL related issues.

Used TFS to store all the related work and report the same by creating Tasks in TFS.

Designed and written the queries in the query builder for retrieving the data.

Created and worked with drill down reports and identified the report parameters.

Used various report items like tables, sub report and charts to develop the reports in SSRS.

Deployed and generated reports on to the server using the Reporting Services Report Manager.

Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.

Created subscriptions to provide a daily basis reports.

Using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Reports.

Managed and troubleshoot report server related issues.

Environment:MS SQL Server 2005/2008 R2, T-SQL, MS Excel, PL/SQL,ERWIN, HTML, IIS, MS Visual Studio.Net3.0, C#, VB.net, ETL,TFS, SharePoint, MS Access, Asp.net 3.0,Visio,Webservices, JavaScript, Vb.Script, XP professional, Crystal reports.

Reena InfoTech Pvt Ltd, India Apr’ 12- Mar’13

Role: SQL Server SSRS/SSISDeveloper

Responsibilities:

Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.

Developed dashboard reports to populate data using SSRS.

Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.

Collected business requirements from users and translated them as technical specs and design docs for development.

Created named query in SSIS Data Source View to get appropriate hierarchical summarize data for two dimensions

Generated multiple Enterprise reports (SSRS) from SQL Server Database (OLTP)and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.

Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.

Experience in designing and implementing SSIS, SSRS.

Bulk data migration using SSIS from flat files and xml.

Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non queried parameters).

Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.

Developed, monitored and deployed SSIS packages.

Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.

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.

Worked on all types of report types like tables, matrix, charts, sub reports etc.

Created Linked reports, Ad-hoc reports and etc based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.

Environment:SQL Server 2005/2008, DTS, SSIS, SSRS, SSAS, Microsoft Visual Studio 2005, SQL Server OLAP 2005, Reporting Services 2005, T-SQL, PL/SQL, MS Access, C#, ASP.Net, VB.Net, Java Script, CSS, VSS, HTML, ERWIN, Visio, Web Services, Windows 2003 Server.

Fortech Soft India Pvt Ltd, Hyd, India Jun’06–Feb’12

Role: SQL Server Developer

Responsibilities:

Gathered the requirements by discussing with users and team members.

Worked as a developer on databases like MS SQL Server 2000, MS Access.

Tested to optimize the Stored Procedures and Triggers to be used in production.

Transformed logical data models into physical database structures and defined the appropriate constraints and indexes as per the requirement of data retrieval and modification.

Involved in Normalization and De-Normalization of database.

Involved in implementation and scheduling of the backup and maintenance strategy on the development server.

Used T-SQL to create various queries.

Created Stored Procedures and Database objects.

Responsible for backups/restores, designing DTS packages and maintenance.

Created Various DTS Packages to Extract/Transform/Load source data into SQL Server in a highly efficient way from Sources like Excel, ORACLE, SQL 2000 and MS Access.

Automated the DTS/ETL to import and export data form text/ Excel file, in different format, to SQL Server and vice versa.

Optimized the performance of queries with modification in SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.

Involved in writing SQL batch scripts.

Developed Web forms, User controls and Custom controls for the web application in ASP.NET, C#Vb.net.

Data Transfer (using DTS) from Development to Testing and to Production Servers.

Designed and created Stored Procedures, Tables Views and DTS packages for existing SQL Server Databases.

Involved in Data Migration and used DTS to import and export data into tables using SQL Server 2000/2005, creating tables, views and Stored Procedures using SQL Server.

Fine-tuned queries for the performance of reports which were being deployed in Crystal Reports 10 and XI.

Planned Backup strategy based on projects requirements.

Daily Database backups and integrity checking.

Environment: SQL Server 2000, T-SQL, DTS, MS-Excel, Windows 2000/2003, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Profiler, Studio.Net2005, C#, Asp.net,Vb.net MS Access,

Vision, VSS, SSIS, VB Script Crystal Reports XI/10.

Note: I was on Maternity leave for two years in between 2006 and 2012

Contact this candidate