sql server developer
Resume:
HARI KRISHNA
***@*********.***
PROFILE
Over 7 years experience as MS-SQL Server Developer, involved in Design, Development and Support of MS SQL Server 7.0/ 2000/2005/2008 for both OLTP and OLAP Systems.
Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS. Configured report subscriptions both data driven and time driven.
Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors.
Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.
Experience in integration of various data sources like SQL Server, Oracle, DB2 UDB and Flat Files. Expertise in Unit Testing, Functional Testing, System Integration Testing, Review Test Cases and Test Results.
Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system.
Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using, Data Transformation Services (DTS) and SSIS with MS SQL 2005/2008.
Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues. Expert in generating drill down Reports in SSRS 2005/2008.
Experience in providing Logging, Error handling using Event Handlers, Pre, and post for SSIS Packages. Deployed reports across Test, Dev and production environments.
Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
Involved in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2000/2005/2008 across various environments.
Creating large enterprise reports, sub reports using charts, report parameters, dropdowns and images using SSRS 2000/2005/2008.
Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder.
Experiences in SQL Server Analysis Services OLAP Cubes, and Data Mining.
Performed Data Mining activities on central repository for various application and dashboard functionalities. Actively involved in the analysis of Cubes and added the Key Performance Indicators (KPI) to the created cubes.
Experience with Implementation and maintenance of Business Intelligence tools for analysts and executive dashboards.
Created Scorecards/Dashboard Pages in Performance Point Server (PPS)
Expert in calculating measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
Involved in creating daily full backups, hourly transaction log backups and weekly maintenance plans. Creating and Managing logins, users, roles and assigning necessary permissions.
WORK EXPERIENCE
VERIZON Nebraska Aug 2009 – Till date
Sr SQL Developer
Responsibilities:
• Involving in developing Data models, Data dictionaries, mapping documents and cross functional documents across systems for all the ETL needs.
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data loads and transformations.
• Created various database objects such as tables, indexes and views based on the requirements.
• 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/DTS packages.
• 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.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views.
• Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries.
• Refreshing the cube to get the latest information updated and deployment of Cubes to the production server.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that servers.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• 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
And integrated reports in MOSS 2007 using web parts
• Involved in setting up Performance Point Server and creating dashboards and scorecards in the PPS.
• Migrated Crystal reports to SSRS reports.
Environment: MS SQL Server 2008/2005/2000, VS2008/2005,Business Intelligence Development Studio (BIDS), T-SQL, MDX, Performance Point Server 2007, Visual Source Team Foundation Server (VSTS) .
COKE COLA NC Dec 2008–Aug 2009
Sr SQL Developer
Project: Data Reporting System
Responsibilities:
• Involved in complete SDLC including Requirement Specifications, Analysis, Design, Development, & Testing of application.
• Worked with the Data modeler in designing the Schema using Erwin with proper relationships defined.
• Helped the BA team design the Business Analysis reports using ProClarity 5.4 and Crystal reports
• Designed the complex views that we can use from the source to populate the warehouse with required columns.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables
• Helped offshore team on daily calls to design SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
• Designed Reports in SSRS, with several prompts and built ad-hoc reports in Report Manager.
• Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations.
• Worked with Data mapping, High level design and Detailed design documents.
• Used complex transactions and Validations to make sure that the data is correctly loaded into the warehouse.
• Used Balance and Control mechanism to make sure that the amounts we get from the source matches the amount loaded in the target.
• Applied Security in Packages to safe guard sensitive data, and used log providers to log events.
• Performed ETL Auditing to maintain Loads report.
• Used Log providers to log error into the table and send the report to the concerned department.
• Used Configuration files to deploy and install a package from one environment to another.
• Used and set the threshold value to count for errors before failing the package.
• Worked on SSRS to design reports and deploy them to the Report Manager.
• Worked on SSRS with expressions and designing of reports.
• Created maintenance plans to load data and to backup 3 months data.
• Extracted data from flat files and from RDBS sources like Oracle and SQL Server.
• Created recurring SSIS Jobs and scheduled Packages using SQL Server Management Studio for the Load.
• Attended functional testing and user acceptance sessions and worked on the feedback provided by them.
Environment: Windows 2000 Server, Windows 2003 Server, SQL Server Integration Services (SSIS 2008),Oracle 9i/ 10g, SQL Server 2005/2008, MS Access,T-SQL, PL/ SQL, Triggers, Packages & Stored Procedures, Erwin 4.2,SSRS 2008,Mercury Quality Center, IBM Rational ClearQuest.
State Farm Insurance, Bloomington, IL July 2007– Sep 2008
SQL Server Consultant
Project: Automotive Mutual Insurance
Responsibilities:
• Gathered requirements and design of data warehouse entities.
• Conduct code walkthroughs and review peer code and documentation.
• Created and maintained the data mart for different LOB.
• Fine tuned of database objects and server to ensure efficient data retrieval.
• Developed complex programs using T-SQL queries, including Procedures, Triggers, and functions.
• Used Visio for diagramming in the design phases.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• Performed Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column.
• Designed and developed SSIS packages, designed stored procedures, configuration files, tables, views, and functions.
• Created SSIS log files and configuration files to store configuration and to log execution of packages.
• Implemented complex transformations by creating custom transformations in addition to using built-in ones.
• Performed Data Migration from SQL Server 2000 to SQL Server 2005.
• Assisted in defining Query for generating drill down reports in SSRS.
• Developed SQL Server Integration Services (SSIS) packages to transform data from various data sources to MS SQL 2005.
• Assisted in creation of SQL Server Analysis Services (SSAS) cubes for analysis.
• Experience in using global variables, expressions and functions for the reports.
• Experience in handling parameterized reports in SSRS.
• Deployed packages from one environment to another (Development to testing to production).
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Oversaw unit and system tests and assisted users with acceptance testing.
• Implemented best practices to maintain optimal performance and optimized SQL queries for maximum efficiency.
• Performed documentation of standards, best practices, and ETL procedures
• Work with developers, DBA, and systems support personnel in elevating and automating successful code to production.
• Provided on-call support to production system to resolve any issues.
Environment: Windows 2000 Server, Windows 2003 Server, Rational ClearQuestSSIS 2005, DTS,
Oracle 9i/ 10g, SQL Server 2005, MSAccess,T-SQL, PL/ SQL, SQL,Erwin 4.2, SSRS
Automatic Data Processing (ADP) Jan 2006– July 2007
SQL Developer
Project: Pro Business Web Services
Responsibilities:
• Have used SQL Server 2005 Integration Services (SSIS) transformations in the data flow of a package to aggregate, merge, distribute, and modify data. Performed Data Cleansing and Profiling using Transformations in Packages.
• Involved in complete SDLC including Requirement Specifications, Analysis, Design, Building a Dimensional Data Model, Testing, Implementation, Debugging & Maintenance of applications
• Helped designing the ETL Specifications document and naming conventions for the project.
• Designed SSIS Packages to transfer data between servers, load data into database; Scheduled the jobs to do these tasks periodically;
• Created SSIS packages for application that would transfer data among servers and perform other data transformations.
• Involved in migration of DTS packages to SSIS
• Handled performance tuning to optimize SQL queries using query analyzer
• Worked on several transformations in Data Flow including Derived-Column, Script, Slowly Changing Dimension, Lookup, Data Conversion, Conditional-Split and many more.
• Used .NET Provider Data Reader Source Task to Read from RDBMS sources.
• Worked on XML Web Services Control Flow task to read from XML Source.
• Performed Unit Testing and Prepared maintenance plans
Environment: Windows 2000 Server, Windows 2003 Server, IBM Rational ClearQuest, SSIS 2005,Oracle 9i/ 10g, SQL Server 2005,T-SQL, PL/ SQL, Triggers, Packages & Stored Procedures, Erwin 4.2, SSRS.
Reliance India Telecom, India Mar 2003– dec 2005
Oracle SQL Developer
Project: Customer Information System
Responsibilities:
• Installation and configuring Oracle client/server. Writing complex stored procedures
• Creation of packages and Performance tuning the database as and when required
• Responsible for creation of logical data models based on entity-relationship diagrams. The models were developed in accordance with the rules of referential integrity and normalization
• Involved in interacting with the business community to understand their requirements
• Design and developed PL/SQL procedures, packages and triggers to be used by team members
• Developed packages using DTS.
• Created materialized views to increase the speed of queries
• Created test databases to test and tune the SQL queries
Environment: Windows NT/2000/2003 Server Oracle 8i, SQL Server 2000 SQL, PL/ SQL, ASP,TOAD
Contact this candidate