Professional Summary:

• 7 years of experience in IT as SQL Developer/SQL BI Developer working in various domains such as Finance/Banking, Insurance and Healthcare in 2012/2008R2/2008/2005/2000 Windows Environment.
• Very good working experience in T-SQL, MS SQL, SQL BI tools SSIS, SSRS, SSAS , Stored Procedures, SQL DBA.
• Experience in Designing, Developing, Testing, Implementing and Production/Support phases of SDLC for Data Warehouse, Client/Server, RDBMS and Web Based Application working in Agile, Waterfall.
• Experience in dealing with Relational Database Management Systems including Normalization, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Stored Procedures, Triggers and Cursors.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS 2008.
• Strong experience in SQL Development, ETL development using Microsoft SSIS, Business Intelligence delivery using SSAS and Reporting solutions using SSRS. Also generated reports using Crystal Reports.
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from 2000 to 2005/2008.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in migration of SSRS reports from SQL 2000 to SQL 2005 and SQL 2008 and SQL 2008 R2.
• Extensive experience in writing Distributed Queries between SQL Servers by creating link servers and federated servers.
• Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard. Experience in dealing with high volume transactional data in SQL.
• Good Experience in Software development life cycle SDLC involving system analysis, design development and implementation using waterfall and agile methodology.
• Experience in delivering OLAP solutions by developing Corporate Dashboard Reports SSRS, Report Model and Ad Hoc Reporting using Report Builder functionality.
• Experience with Performance Tuning, Query Optimization and SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Calculated measures and dimension members using multi-dimensional expression MDX , mathematical formulas, and user-defined functions.
• Proficient in usage of SSIS Control Flow tasks For Loop, Execute package/SQL tasks, Script task, send mail task and SSIS Data Flow tasks Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot and Un-Pivot .
• Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server and ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Good Experience in using tools like Bulk Copy BCP , Data Transformation Services DTS and SSIS.
• Have good knowledge with C and .NET.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ SSAS.
• Experience in Designing, Developing, Documenting, Testing of ETL jobs and mappings in Server and Parallel jobs using Data Stage to populate tables in Data Warehouse and Data marts.
• Experience in creating reports through PROCLARITY. Used PROCLARITY for accessing and analyzing cubes and dimensions
• Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports.
• Built effective queries for high-performance reports and rendered them to HTML, XML, PDF and Excel formats using SSRS. Also done reporting using Excel with Power pivot.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SSRS in Business intelligence development studio.
• Working experience with on site and offshore team based on the schedules.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

SQL-SSIS-SSRS-Crystal Reports Developer

Responsibilities:

• Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Lookups, Multicasts, Merge, and Merge joining, Pivot and Unpivot Control Flow Transformations.
• Worked on Data Flow tasks like Foreach Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Migration Experience from SQL Server 2005 to 2008R and SQL Server 2008 to 2012.
• Generated periodic reports based on the statistical analysis of the data using SSRS. Worked on Excel 2010, Power Pivot for providing ad-hoc reporting for the clients.
• Extensively used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities. Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS. Pulling the data from T-SQL stored procedure to make the parameterized reports.
• Used SSIS to solve business problems by copying/ downloading files, sending e-mail messages in response to events.
• Good Knowledge with C , Hadoop and .NET. Also have knowledge in developing N Tier Application in .NET using 3 layers approach Presentation layer, Business Layer, and Data access layer .
• Scheduled and deployed reports and uploaded files to a report server catalog from the report manager.
• Generated Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph Reports by using Crystal Reports.
• Created Ad Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports using SSRS and Crystal Reports.
• Modified the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically.
• Designed and developed various reports using Crystal Reports and gave option to export to excel and .PDF files.
• Involved in understanding and transmitting the business requirements for the project, and translating these into functional specifications.
• Deployed the packages to production using XML package configuration.

Environment: SQL Server 2012/2008R2/2008/2005, SSRS, Crystal Reports, SSIS, SSAS, T-SQL, MS SQL, ETL, Data Stage, .NET, C , Visual Studio 2005, XML, XSLT, Shell/ Unix Scripting, MS Office.

Confidential

SQL-SSIS-SSRS Developer/SQL DBA

Responsibilities:

• Key role in team of 4 in brining 2005 SQL database environment to SQL 2008R2 by migrating, converting and re-writing DTS packages and updating them to SSIS packages.
• Used SQL Server Package Configuration technique to make Dynamic configurations. Also used Text Files/ SQL Server Logging for all SSIS packages.
• Created On demand Pull and Event Based delivery Push of reports according to the requirement. Deployed and configured the reports in the Report Server.
• Worked with various SSIS packages which involve Transactions, Restartability and roll back techniques. Scheduled the packages to keep extracting the data from OLTP at specific time intervals.
• Responsible for tuning T-SQL procedures, triggers and other database objects. Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Designed and Developed Data stage Jobs to Extract data from heterogeneous sources, Applied transform logics to extracted data and Loaded into Data Warehouse Databases.
• Created shell script to run data stage jobs from UNIX and then schedule this script to run data stage jobs through scheduling tool.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on ad hoc or scheduled basis.
• Experience in performing administrative tasks like database files management, backup/restore, security management, Database Mirroring, Log shipping, Replication, data integration and synchronization.
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Created and managed Web-based reports using SSRS to deliver information to both external and internal users.
• Worked with Performance tuning, SQL Server Profiler and debugging tools. Responsible for rebuilding the indexes and tables as part of performance tuning.
• Added SQL Server Providers for logging to capture information about a package at run time, making it easier to troubleshoot package performance and failure. Performed package, container and task level logging.
• Configuration and Deployment of all reports across various SDLC environments. Monitored and provided support to the application during testing and production environments
• Build database queries and test cases for the testing team to test the reports. Also generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.

Environment: SQL Server 2012/2008R2/2008/2005, SSRS, SSIS, SSAS, T-SQL, MS SQL, ETL, Data Stage, DB2, Oracle 9i/10g, Visual Studio 2005, XML, XSLT, Shell/ Unix Scripting, MS Office and Visual source safe.

Confidential

SQL-SSIS-SSRS-SSAS Developer

Responsibilities:

• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.
• Created complex SQL stored procedures and developed reports using Microsoft SQL Server 2008 and 2008 R2.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development. Extracted data from star schema DSS data warehouse by creating and maintaining complex SSIS.
• Created cubes and dimensions and measures and calculated measures according to the business requirements.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Created several SSIS packages for performing ETL operations to transform data from a cube using MDX.
• Generated reports from the cubes by connecting to Analysis server from SSRS.
• Experience in creating snapshots of static reports and configure subscription.
• Worked on SRS document and implementing into functional level by making Data Models using ERWIN.
• Involved in Report Authoring, Report Delivery using both Pull and Push strategy and Report Management for various types of reports.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non SQL Server databases.
• Developed the SSIS packages to transform data from SQL 2000 to MS SQL 2005 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Worked in creating hierarchies for dimensional tables like date dimensions and region dimension tables. Browsing the cube for analysis and validation of the data. Processing the cubes and dimensions on a daily basis using the SSIS tasks.
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS 2008.
• Involved in the SSAS storage, partitions, Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.

Environment: SQL Server 2008/2008 R2, Business Intelligence Studio SSIS, SSRS, SSAS , OLAP, T-SQL, MS SQL, Erwin, MDX, Oracle 10g, ProClarity, Unix, XML, MS Excel.

Confidential

SQL-SSIS-SSRS Developer

Responsibilities:

• Created and maintained the databases using SQL Server. Also Installed and Configured SQL Server on the server and client machines provided connections and managed databases.
• Worked on data transfer migration using Export/Import and Data Transformation Services DTS .
• Generated database monitoring and data validation reports in SQL Server Reporting Services SSRS .
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Utilized SSIS to produce a Data Mapping and Data Mart for reporting worked with Multi-threading Concepts with Synchronous and Asynchronous transactions.
• Designed logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in development and production environment for SQL Server 2005.
• Created schema objects, granting of roles and privileges to the users, compilation of procedures etc.
• Deployed SSIS packages and Reports to Production Servers. Deployed and configured the reports in the Report Server.
• Used various transformation components in the data flow task to implement business logic.
• Configured SSIS packages using Package configuration wizard to allow package run on different environments.
• Used SSIS for data population from different sources and create packages for data conversions and load data into flat flies or excel files.
• Worked on Migration of packages from DTS using SQL Server Integration Service SSIS .
• Assisted internal and external report needs and designed solutions based on specific requirements using SSRS and focused on the reengineering of the ETL processes using the SSRS 2005.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Involved in creating Technical Specification Document for the project. Also in Normalization and De-Normalization of existing tables for faster query retrieval.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc. Created logging, custom logging and error handling packages.
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking deadlocks /user counts and connections/locks etc.

Environment: SQL Server 2005/2008, SSIS, SSRS , DTS, C , T-SQL, VisualStudio.net, TSD, XML, SSMS, MS SQL, MS Excel, MS Access, Visual Studio 2008.

Confidential

SQL-SSIS-SSRS Developer/SQL DBA

Responsibilities:

• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Generated database monitering and data validation reports in Proclarity and Reporting Services SSRS .
• Deployed SSIS packages and Reports to Production Servers. Used SQL to run ad-hoc queries and prepare reports to the management.
• Upgraded databases from SQL Server 2000 to SQL Server 2005.
• Responsible for the design and development of .Net web applications for firm's Solutions.
• Implemented complex conceptual database design into SQL Server 2005 using Normalization, various Constraint and Triggers.
• Providing information and assistance to the Database Architects on physical models, setup and maintenance of metadata.
• Responsible for Query optimization and Performance tuning. Used SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries.
• Proficient in the use of T-SQL for developing complex creating Database, Tables, Indexes, Views, Triggers, Stored Procedure, User Defined Function, relational database models and data integrity, SQL joins and query writing.
• Maintained system monitoring jobs and provide high availability support.
• Created partition table for very large database for good performance and Provided business intelligence support for the applications and systems.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Worked on Migration of packages from DTS using SSIS. Also migrated data using ETL Tool in SSIS.
• Participated Databases Architecture and data Modeling design. Performed DBA functions, installing, configuring and supporting database systems.
• Implemented high availability on the various servers using replication/mirroring. Involved in database Backup and recovery.
• Reported all events and requirements through established reporting mechanisms in SSRS.
• Reviewed and developed data models and database designs with development teams
• Created SSIS packages for extracting data from data base and load those data in tables in SQL server.
• Designed and developed MS SQL Server Reporting Services SSRS under SQL Server 2000 and SQL Server 2005.

Environment: MS SQL Server 2000/2005, MS Office, SSIS, SSRS, DBA, T-SQL, ProClarity, C , OLAP, UML, Erwin, DTS/SSIS, SSMS, BIDS.

Confidential

SQL Developer/SQL DBA

Responsibilities:

• Interacted with Team and Analysis, Design and Develop database using ER Diagram, Normalization and relational database concept.
• Involved in Design, Development and testing of the system.
• Identified goals and objectives of projects. Created project plan by gathering the requirements from the management.
• Developed SQL Server Stored Procedures, Tuned SQL Queries using Indexes and Execution Plan .
• Developed User Defined Functions and created Views. Created Triggers to maintain the Referential Integrity. Implemented Exceptional Handling.
• Meeting with Business Analyst and data modeling team to understand requirements and existing system tables, relationships and database constraints.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Verified data for missing values and incorrect data and then cleaned and structured the data based on the format required.
• Created various database objects tables, indexes, views, stored procedures and triggers and implemented referential integrity constraints for enforcing data integrity and business rules.
• Good Knowledge in working with SQL Server - Integrating Services SSIS and Reporting Services SSRS .
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development, Implementation, Upgrade enhancements, maintenance, production support and bug fixing for the product.
• Performed DBA tasks through Enterprise Manager, Query Analyzer, English Query, Import Export wizard.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Creating and automating the regular Jobs. Developed the Functional specification documentation for the modules to be developed.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler. Rebuilding Indexes and Tables as part of Performance Tuning Exercise.
• Involved in performing database Backup and Recovery. Worked on Documentation using MS word.

Environment: SQL Server 2000/2005, T-SQL, MS SQL, SSMS, MS Office, SSIS, SSRS, BCP, Visual Basic 6.0/5.0, Query Analyzer, Crystal Reports 7/4.5.