We provide IT Staff Augmentation Services!

Sql Bi Developer Resume Profile

SUMMARY

  • Eight years of excellent experience in IT industry as SQL Server developer/Business Intelligence developer with Computer Science background and Financial, Insurance, Health care and Banking experience.
  • Expertise in MS SQL Server with SSMS/SSIS/SSRS 2000/2005/2008R2/2012, ETL, OLTP and OLAP.
  • Managed See's e-commerce and intranet systems throughout their lifecycle including planning, design, development, quality assurance, load testing, roll-out, and post live technical analysis. Experience on data modeling. Relational OLTP and dimensional
  • BI/Data Warehouse Design Tools: Erwin, Rational Databases: DB2, Oracle, MS-SQL Server. Managed and supported Production databases.
  • Very good knowledge in HIPAA compliance.
  • Strong knowledge of Health Care Insurance, EDI HIPAA transactions. Worked on EDI Transaction sets including 837, 834, 835, 270, 271, 276, 277.
  • Good Hands on experience dealing with On-Site/Offshore model and worked with Development, Production Support and Quality On-site/Offshore experience.
  • Experience in Data Warehouse Modeling with SQL Server Analysis Service SSAS .
  • Experience with Object-Oriented Programming with C .NET, JAVA.
  • Experience with third party controls tool kits like Telerik.
  • Experience in solving issues related SharePoint Environment and SQL server.
  • Experience in Data Modeling Logical and Physical Design of Databases , Normalization and building Referential Integrity Constraints.
  • Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store ODS .
  • Extensive experience in developing Stored Procedures, Views, Indexes, Triggers, Cursors, XML, Joins, user defined data types, functions and other Complex Queries on SQL Server 2005/2008
  • Hands-on experience with Erwin Data Model Tool and strong knowledge of Relational Database Modeling/Loading and Dimensional database modeling concepts and also star/snowflake Schemas implementation.
  • Expert in developing T-SQL DDL, DML statements, Data Integrity constraints , Rules, Performance Tuning, Query Optimization and Validation issues.
  • Excellent in High Level Design of ETL DTS Packages SSIS Packages for integrating data using OLE DB Connection from heterogeneous sources Excel, CSV, Oracle, flat file, Text Format Data by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all Migrated Database from SQL Server 2000 to 2005, 2005 to 2008 by using side by side migration.
  • Experience in Microsoft Visual C .Net in script component of SSIS.
  • Developed Crystal Reports as per the client needs and maintain documentation of reports for future references.
  • Expert in writing complex formulas in Crystal Reports, SQL queries using Crystal Designer, Crystal Dictionaries, and migration of Crystal Reports in different versions.
  • Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services 2008/2005, Crystal Reports and Excel spreadsheet.
  • Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS and embedding then into web services in .Net.
  • Experience in using variables, expressions, functions for the reports and in handling Parameterized reports in SSRS
  • Built effective queries for high-performance reports and rendered them to HTML, XML, PDF and Excel formats using SSRS
  • Created SQL Server Analysis Projects SSAS and proficient in Referenced relationships for Business Intelligence applications using MS SQL Server 2005/2008.
  • Experience in writing efficient multi-dimensional expression MDX as per the design requirements.
  • Created OLAP Cubes and performed data mining on the data using the fact table and the dimension.
  • Expert in Cube Designer in Business Intelligence Development Studio BIDS to edit various properties of a cube, including the Measure groups and Measures, Cube dimensions and Dimension relationships, Calculations
  • Experience in Managing Alerts, Operators and Jobs through SQL Server Agent and also with SQL Mail.
  • Experience with Database Backup and Recovery Procedures and also in Disaster Recovery DR
  • Data Modeling experience focusing on high-activity Normalized transaction systems OLTP , highly-usable Renormalized Reporting Systems OLAP as well as staging areas and data marts
  • Has very strong background in a disciplined software development life cycle SDLC process and has excellent analytical, programming and problem solving skills.
  • Experience in working with Operating System such Linux Ubuntu and Windows OS 7/2003 administration activity and Security.
  • Good hands on experience with production support on Large VLDB instance and provided support 24x7
  • Good knowledge of various mathematical modeling methods for financial derivatives and risk modeling, hedging.
  • Experience in Insurance Sales and Marketing domain.
  • Done onsite-offshore coordination.
  • Delivered 24/7 support including scheduled and emergency night and weekend work.
  • Has the ability to work in a fast paced environment, Good team player and can work independently. Helped the database developers on technical issues

TECHNICAL SKILLS

Databases

SQL Server 2000/2005/2008/2008R2/2012 Enterprise/SQL Server 7.0, MSAccess, Oracle PL/SQL, IBM DB2/UDB8.x/7.x/5.x,MY SQL

SQL, T-SQL, MS Report Builder 3.0

Performance Tuning

Capacity Planning

Installation, Upgrade, Migration

ODBC, OLE DB

Extracting, Transformation and Loading ETL

SQL Server Integration Services SSIS , DTS

SQL Server Reporting Services SSRS

SQL Server Notification Services

SQL Server Service Broker

Master Data Services

Data Quality Services

SQL Server Replication, Log Shipping, Failover Clustering, Database Mirroring

Operating Systems

Windows Enterprise 2003/2000 Advanced Server/2000 Server/Windows 2000 Professional/Windows XP Professional, Vista, Windows 7, Linux

Applications

Erwin 3.5/4.1/7

Visual Studio 6.0/.NET/2005, Cold Fusion.

Light Speed 2005

Log Parser 2.2

Language

C, C , SQL, T-SQL, PL-SQL, Visual C , Python, VBA, JAVA,ASP.NET, C , HTML, XHTML, XML,UNIX, Shell Script, CSS, PHP, JavaScript, Telerik Web Controls, EDI Auditing, Mercator/EDI connector.

Protocol

HTTP, TCP/IP, FTP

Administering

Database Engine

Security, Managing SQL Servers, Managing Large Databases, Linked Server, High Availability, Importing Exporting Bulk Data, Backing up Restoring, Deploying Application

Packages

MS Office 2007, MS Office Excel, MS Power Point

Confidential

Role: Sr SQL BI Developer

Responsibilities:

  • Participated in meetings with all the members of the project to discuss, plan and implement strategies that would ensure all the business requirements reflect in the project development.
  • Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses extraction, Transformation and the direction of data flow and Metadata using SSIS.
  • Identified all data fields and database columns that needed to be expanded to meet HIPAA requirements.
  • Worked extensively on inbound transaction set 834 Benefit Enrollment maintenance claim, Adjudication EDI 837 , Remittance 835 and Claim status 276/277 .
  • Reviewed EDI 837 claims and flagged HIPPA non-compliant claims received from the Payer side.
  • Designed and deployed various SSIS packages to import the data coming from a Heterogeneous Database and applying various transformations on it so as to modify the data into a usable format for further applications.
  • Created automated packages to efficiently archive the data into the Data Warehouse for future analysis and usage.
  • Defined Referenced relationships with the measure groups and fact tables. Managed the Metadata associated with the ETL processes and used it to populate the Data Warehouse.
  • Managed production support and defect/enhancement request tracking.
  • Developed Stored Procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables and implemented the calculations in stored procedures by aggregating physical measures.
  • Created views/indexed views consisting of computed columns to facilitate easy user interface.
  • Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
  • Write code to extract data from the Cosmos data center using Scope on the Cosmos system, C , batch files, T-SQL for the MSN NIF pipeline, aggregate data for forwarding to internal teams. Configure and host Malevich site for efficient code review process.
  • Designed dynamic SSIS to transfer data crossing different platforms, validate data during transferring, and archived data files for different RDBMS.
  • Experienced in SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
  • Used SSIS, T-SQL Stored Procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
  • Wrote stored procedures and User Define scalar Functions UDFs to be used in the SSIS packages and SQL scripts.
  • Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
  • Developed tabular queries for efficient analysis of report using Pivot/Unpivot in T-SQL.

Environment: Microsoft Sql server 2008R2/2012, SSIS/SSRS, BIDS,Tortoise SVN, MS Visual Studio 2010, T-Sql, UltraEdit, SQL Profiler, MS office.

Confidential

Role: SQL BI Developer/Analyst

Responsibilities:

  • Created the Dimensional model for the General Ledger using the star schema model.
  • Got the requirements from the business analyst for the audit and designed the dimensional model based on the inputs.
  • Worked with team in meeting deadlines for the creation of database and tables and writing stored procedures, views.
  • Involved in data modeling for the application and created ER diagram using Erwin.
  • Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users as per agile methodology.
  • Created databases, tables, stored procedures, indices, foreign keys and any other objects within the databases based on requirements from Developers
  • Wrote stored Procedure, scripts, cursors for the bulk application, tested them on the test servers and moved them to the production
  • Created triggers to keep track of changes to the fields of tables when changes are made
  • Strong experience with SQL Server performance tuning and optimization, query optimization, index tuning, caching and buffer tuning.
  • Create a Microsoft Access project and connect it to an existing Microsoft SQL Server database
  • Created web parts, workflows, info path forms and used SharePoint designer for master page creation.
  • Developed an e-commerce website for appliances distributor.
  • Identified VP-ASP e-commerce framework as most cost-effective solution for the client. Managed a team of three developers during implementation.
  • Created SSIS Packages using SSIS Designer for export heterogeneous data from Access, OLE DB Source Oracle , Excel Spreadsheet to SQL Server 2008
  • Designed and developed SSIS Packages .dtsx files to import and export data from MS Excel, Access, SQL Server 2008R2 and Flat files.
  • Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using MS Reporting Services
  • Involved in design and deployment of Report Models for generating Ad-Hoc reports as per the client requirements.
  • Worked on different kinds of Transformations in SSIS as per the client's Requirement.
  • Created Extract, Transform and Load ETL processes.
  • Developed windows based applications in VB.net 2003 for interacting and retrieving data from SQL Server, also made applications for entering criterion and opening reports from Crystal Reports.
  • Created complex reports in Crystal Reports using procedures from SQL Server by passing in stored procedure parameters.
  • Designed high level ETL Extraction Transformation Loading architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
  • Designed and developed SSIS packages to move data from production environment to different environments within the organization.
  • Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
  • Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
  • Worked with Offshore team for ticketing issues, Development process and Quality support for various Subject areas.

Environment: Agile, Scrum, Microsoft SQL Server 2008R2/2012, T-SQL,SQL Server Integration Services, Spotfire 5.0, Visual Studio 2008/2012 SSIS , SSRS, BIDS, HTML, Web Services, SQL Server 2008 Manager Studio, SQL Analyzer and Enterprise Manager and SQL Agent,

Confidential

Role: MS SQL Server/ BI/DBA

Responsibilities:

  • Analyzing and reporting Credit Risk Management data. Compare and analyze WF score facility with FICO score. Analyzing borrower exception scoring.
  • Developed complex programs in VB Script, which connects to SFTP server to get the initial data which is in CSV Format, with best execution plan.
  • Performed data conversions from flat files into a normalized database structure.
  • Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
  • Created complex Stored Procedures, Triggers, Functions UDF , Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
  • Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
  • Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
  • Created packages to convert flat file to XML file.
  • Created cubes and dimensions SSAS for the analysis of sales in specific areas.
  • Good understanding of SSRS with Report authoring, created weekly and monthly reports as per requirement using SSRS.
  • Developed Report Models for building Adhoc reports using Crystal Reports. Developed optimal stored procedures and queries to create data sets for reports.
  • Used the SSIS Import/Export, migrated the Database such as Oracle and Access database, flat files to SQL server 2008.
  • Developed UDM business rules to be captured in the model to support richer analysis.
  • Configured mail tasks to know the job status of SSIS packages.
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring and archived data files for different DBMS.
  • Designed high level ETL Extraction Transformation Loading architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
  • Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
  • Worked with Offshore team for ticketing issues, Development process and Quality support for various Subject areas.
  • Designed front-end using Java Servlets, JSP, HTML, CSS and JavaScript, utilizing AJAX technology.
  • CFML Cold Fusion Markup Language Technology is used with SQL Server 2005 with HTML, JAVA SCRIPT and CSS.
  • Writing UNIX Shell scripts to manage import/export processes. Working as PL/SQL Developer packages, procedures/triggers , with a development team, responsible for developing and maintaining Oracle PL/SQL applications and database programming in client server and web environments.
  • Tune various packages for reducing their processing time by using parallel processing approach and using MYSQL Profiler in MYSQL Server 2008.
  • Created daily queries involving self joins, correlated sub-queries, CTE and XML techniques for diverse business requirement. Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies
  • Created databases, tables, stored procedures, indices, foreign keys and any other objects within the databases based on requirements from Developers
  • Wrote stored Procedure, scripts, cursors for the bulk application, tested them on the test servers and moved them to the production
  • Created triggers to keep track of changes to the fields of tables when changes are made
  • Strong experience with SQL Server performance tuning and optimization, query optimization, index tuning, caching and buffer tuning
  • Create a Microsoft Access project and connect it to an existing Microsoft SQL Server database
  • Created web parts, workflows, info path forms and used SharePoint designer for master page creation.
  • Developed an e-commerce website for appliances distributor.
  • Identified VP-ASP e-commerce framework as most cost-effective solution for the client. Managed a team of three developers during implementation.
  • Created SSIS Packages using SSIS Designer for export heterogeneous data from Access, OLE DB Source Oracle , Excel Spreadsheet to SQL Server 2008
  • Designed and developed SSIS Packages .dtsx files to import and export data from MS Excel, Access, SQL Server 2005 and Flat files
  • Worked on different kinds of Transformations in SSIS as per the client's Requirement.
  • Created Extract, Transform and Load ETL processes.
  • Developed windows based applications in VB.net 2003 for interacting and retrieving data from SQL Server, also made applications for entering criterion and opening reports from Crystal Reports.
  • Created complex reports in Crystal Reports using procedures from SQL Server by passing in stored procedure parameters.
  • Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using MS Reporting Services
  • Involved in design and deployment of Report Models for generating Ad-Hoc reports as per the client requirements
  • Created Report Snapshots and Report caching to show the data changes over time
  • Assisted in developing OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services SSAS and Reporting Services SSRS
  • Integrate SQL Server 2005 Reporting Services with Microsoft Share point Portal Server to deliver automatically generated reports to the Share Point portal
  • Experience in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
  • Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional expression MDX to access them.
  • Development of system maintenance tasks such as Database Backup Recovery, database mirroring and replication and apply in Dev and Testing Environment
  • Assigned permission to user s , roles, and object. Administrate security for servers logins Windows and SQL Accounts
  • Designed User Interface using ASP.NET, C . Written Business Layer in C and wrote web service Interfaces using C . NET, ADO.NET
  • Developed Pages using Ajax enabled Telerik Controls for rich UI design and reduce post back effect.
  • Responsible for adding new columns and expressions for existing Crystal reports as per the requirements from the clients.
  • Skills into maintaining, writing, debugging and testing code in applicable programming languages
  • Monitored growth of data and managed space allocation accordingly.
  • Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server
  • Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
  • Coordinating with offshore folks and leading and mentoring the onsite team.
  • Provided 24x7 production support for the US client's mission critical database environments.

Environment: Agile, Scrum, MS SQL Server 2008R2/2012, BIDS,MYSQL Server 2008, Visual Studio 2008/2012 SSIS, SSRS, SSAS , Oracle, Unix, OLTP, OLAP,T-SQL, Telerik Controls, SharePoint 2010, MDX, HTML, Web Services, JSP, Excel VBA, ASP.NET, MS Access 2007,Java script, C .NET, CSS ADO.NET, T-SQL, MS Report Builder 3.0 and SQL Server 2005 Manager Studio, Crystal Reports, SQL Analyzer and Enterprise Manager and SQL Agent. SQL Query Analyzer, SQL profiler, IIS 6.0, Enterprise Manager, ERWIN Data Modeler, Windows Server 2003/2008, DTS, Share Point Portal Server, HTML, XML

Confidential

Role: MS SQL Server/ SSIS/SSRS/SSAS.

Responsibilities:

  • Involved in requirements gathering and knowledge transfer sessions.
  • Collected requirements from the end user, gathered examples of their work. Tried to learn more about it by practicing the end user process manual report generation using pivot function to gain clear understanding about the work.
  • Proposed various changes to enhance the functionality of the existing system.
  • Developing and implementing database objects like stored procedures, Triggers, Indexes, Functions etc. for all the MSC applications and tools
  • Developed SSIS packages to import data from various sources and to export from SQL server to various formats like txt, excel, xml etc.
  • Extracted data from Oracle and migrated into SQL Server 2008 using SSIS.
  • Integrated SharePoint with SSRS and managed reports subscriptions, delivery, generation, rendering, and sharpshooting via SharePoint User Interface.
  • Created complex Stored Procedures to validate the data from source and update the records and insert them into a newly created table.
  • Designed, Installed and configured core Informatica MDM Hub components: Informatica MDM Hub console, Hub store, Hub server, cleanse match server, IDD Data Modeling.
  • Created Views and Indexed Views to reduce database complexities for the reports.
  • Created Methodology documents and Process documents using Visio
  • Ensured performance of queries by removing unnecessary columns , eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary
  • Performed Query optimization and Performance Tuning of stored procedures, Functions using SQL Profiler and Database tuning wizard.
  • Created Several Scripts in C .Net to generate customized script Tasks and several customized report expressions
  • Involved in testing, bug fixing and documentation for the project
  • Database migration experience from DB2 on mainframe platforms to Sql server 2008 with the IBM DB2 Migration Toolkit.
  • Responsible for installing and configuring MS SQL Server along with Visual Studio on a network domain system.
  • Created SQL Server Integration Services SSIS packages to export and import data from various sources systems to SQL Server.
  • Created the mappings using transformations such as the Derived Column, Union All, Pivot, Sort and Conditional Split.
  • Used most of the tools in SSIS packages like looping, data formatting, check points, error handling, email notification etc.
  • ETL Process designed to take advantage of parallelism, use surrogate keys, account for slowly changing dimensions, adhere to conformed dimensions, utilize custom error data flows, and incorporate delta loads.
  • Implemented the Master/Child Package Model so that only the Master Package has to be scheduled which will in turn fire the other packages.
  • Deployed SSIS packages to production, schedule them to run on routine basis and monitor the error log for any errors.
  • Responsible for the development of the report layout based on the requirements of the end users.
  • Various types of reports Drill down, Matrix, and Navigating with charts were created using SQL Reporting Services 2005 SSRS .
  • Created complex variables, expressions, parameters, predefined conditions, joins, multiple breaks, sorts in SSRS.
  • Daily/Weekly/Monthly Reports were scheduled to be executed and sent to end users via email.
  • Responsible for responding to end-user questions, requests and concerns.

Environment: MS SQL Server 2005/2008R2, SSIS, T-SQL, Visual Studio.NET Oracle MDM, SQL Server Integration Services, SQL Server Reporting Services, Analysis Services, Visual Studio 2005,Crystal Reports, SharePoint , T-SQL, Excel, Access, C .Net, Windows 2000/XP, IIS 5.0

Confidential

Sql server BI Developer

Responsibilities:

  • Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
  • Involved in developing E-R diagrams, logical physical data modeling, development and implementation of the system.
  • Experienced in SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
  • Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
  • Worked on ETL to implement the slowly Changing Transformation, to maintain Historical Data in Data warehouse.
  • Developed and deployed data transfers packages to the appropriate destinations using SSIS.
  • Worked with Managing the Offshore team for duties, time and milestone management for 24x7 support application.
  • Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
  • Created SQL server dynamic configurations for SSIS packages.
  • Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
  • Used BCP to transfer the data files to other server.
  • Scheduled the packages to run automatically for incremental data and deploy them to their destination servers
  • Developed tables, Views, Stored Procedures, Functions, Indexes 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.
  • Responsible for creating reports based on the requirements using SSRS 2008.
  • An expert in utilization of data flow items such as ADO.NET and OLE DB sources for data source setups Lookup component for finding existing rows on production Derived column for adding load dates with in-built SSIS system variables Multicasting for staging multiple copies of input data Pivot for financial auditing Conditional split for facilitating data routes based on various business rules Data conversion for imported flat file data to be loaded with appropriate data types for SQL Server tables Aggregate for enabling data aggregation such as SUM, Count, etc. and many more such as Character map, Merge and Merge join.
  • Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008.

Environment: SQL server Reporting Services 2008, SSIS, Agile, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, Scrum, T-SQL, Red-Gate SQL Source Control, MS Visio 2008, SQL Profiler.

Confidential

SQL Server Developer

Responsibilities:

  • The task was to create SSIS packages to convert the data from different types of clients related to health care industries for example Hospital, Nursing homes, Health care supplies, Health Care Institutions etc and convert those data from different format such as Excel Spread Sheet, PDF files, Access Database, Flat files to .txt format and load them to a desk top system named as CMS.
  • Enhanced major mainframe medical application for HIPAA information gathering and reporting.
  • Managed team of 3 offshore resources for Development and Level-2 support Reporting system.
  • Analyzed inventory of all software assets for Integration Tape Processing System ITP application
  • Identified all data fields and database columns that needed to be expanded to meet HIPAA requirements.
  • Data was brought in from multiple systems in many different formats including EDI and XML.
  • After rewriting their medical claims editing VB6 DLL in C the data interface was changes to accommodate the new XML and EDI data formats.
  • Created the technical specification document.
  • Used in built C parser to parse flat files, Monarch parse to parse PDF files, Excel parser to parse Excel files.
  • Writing T-SQL queries, Stored Procedures, View to extract data and to get the required value from the given data.
  • Created SQL jobs in Managements Studio.
  • Using SQL server reporting services SSRS and Crystal Reports delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
  • Helped in generating SQL server reports using the data from CMS system.
  • Worked under VP. Data Analyst as Junior Data Analysts.
  • Improved knowledge in fluently using different tasks in SSIS and research is still going on in that field.

Environment: MS SQL Server 2005/2000, SSIS/SSRS, Crystal Reports, Management Studio, MS Access 2003, Performance Monitor, HIPAA, T-SQL, VB Script, Index Tuning Wizard, OLAP, Oracle 10g, PL/SQL, TOAD, Oracle 10g, SQL Developer, Enterprise Manager, Autosys, DB2, Teradata, Windows 2003/2000/XP, Unix

Confidential

SQL Server Developer

Responsibilities:

  • Worked closely with BA, DBA to analyze business model, gather project requirement.
  • Loaded and mapped data into Staging Database using SSIS packages.
  • Performed data analysis for reports and presentations for senior management and external recipients.
  • Populated data for Test environment.
  • Developed, modified, and optimized very complex queries to data retrieval and modification
  • Created alerts, notifications, and emails for scheduled SSIS packages execution.
  • Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
  • Migrated SQL server 2000 to SQL Server 2005 in Microsoft Windows Server 2003 R2 Enterprise Edition SP2.
  • Generated reports using SQL Server Reporting Services and Excel spreadsheet.
  • Created Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
  • Comprehensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
  • Implemented in new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression CTE .
  • Performed installation of SQL Enterprise 2005 64bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers.
  • Involved in migration of SQL Server 2000 databases to SQL Server 2005 databases.
  • Supported Development UAT, System Test, Training, Staging and Production.
  • Documented the procedures and process.

Environment: SQL Server 2005, SSIS, Packages, Windows Enterprise Server 2003, IIS Server, Oracle 9i, Informatica.

Hire Now