SUMMARY

• Overall experience of 5+ years as Business Intelligence Developer and Data Analyst in Data Warehousing, Database Design and Development in Production, Insurance and Finance sectors.
• Strong Communication & Management skills with excellent role - playing capabilities.
• Experience with strong skills in in MS SQL Server2012/2008R2/2008/2005 including Microsoft Business intelligence tools like SSIS and SSRS.
• Experience in creating Jobs, Alerts and scheduling Packages.
• Experience in developing ETL packages using SSIS with various transformation tasks.
• Experience in using Precedence Constraints, Break Points, Check Points, and Logging using SSIS.
• Good experience in designing and scheduling complex SSIS Packages for data migration from various sources like SQL Server, Oracle Database, Excel and Flat file.
• Experience with SSIS performance tuning using counters, error handling, event handling
• Worked extensively on SSRS reporting tools using various reports such as Charts, Drill Down, Drill-Through Filters, Reports, Multi-valued parameters, Sub-Reports, SSRS tabular, matrix reports.
• Working experience on error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Experience in Performance Tuning in SSIS packages using Block and Unblock Transformations.
• Extensively used SSIS transformations such asMerge, Derived column, Data conversion, Aggregate, Conditional split, Multicast, Union All, Sort, Fuzzy lookups and Lookups.
• Worked on designing SSRS reports based on the project requirement.
• Worked on different staging environments like AIT, REG, UAT.
• Working experience on mainframe file uploads and downloads.
• Experience on troubleshoot of various packages during execution.
• Troubleshoot of issues related to package configurations and connection managers.
• Worked on various connection managers, control flow tasks and data flow tasks.
• Involved in database backup and restorations in SQL Server.
• Configured Package security by providing password protected
• Working experience on IBM Cognos ICM tool for data imports, calculations in different models
• Experience in writing and executing complex queries in Database such as Stored procedures, Functions, Triggers, Cursors, Joins, PL-SQL, T-SQL.
• Extensive experience in Writing Transact SQL (T-SQL) Queries, Dynamic-queries and implementing SQL Server Indexing.
• Good experience in using performance monitor/SQL profiler for handling Performance Tuning of long running queries and dead lock issues.
• Excellent ability to solve adhoc requests with ease in the project and execution, troubleshooting and fixing errors as required.

TECHNICAL SKILLS

Relational databases: SQL Server 2012/2008R2/2008/2005

ETL Tools: SQL Server Integration Services (SSIS), Import Export Data, Data Transformation Services (DTS)

Reporting Tool: SQL Server Reporting Service (SSRS), IBM Cognos ICM

Languages: T-SQL, HTML, XML, SQL, C, VB.Net, ASP.Net

Web Technologies: HTML, XML

Operating systems: Windows98/NT/2000/XP, Windows Server 2003/2008.

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst

Responsibilities:

• Used Yelp data set for analyzing the data using the data mining model
• Fetched the data in single row and selecting valid businesses from the yelp dataset
• Data is being analyzed in both SQL and JSON formats
• Focused on Business and Ratings tables from the dataset and applied data mining models to predict a) stars for business based on attributes for a business. b) for a given review what would be the rating for a business from the user.
• Converted JSON file to CSV file using online converter tool to normalize the data
• Using SQLPLUS to insert the huge data into the tables
• Used data miner model applied data mining algorithms for business table classification model
• Performed two methods Token and Theme for sentiment analysis for analyzing the text from the review table using data miner
• Applied clustering and classification models for Token model and only classification for Theme model

Environment: Creation of virtual machine, SQLPLUS, 11g oracle enterprise edition, SQL developer 4.1.3 version, Yelp dataset, Online converter tool, Data miner model

Confidential

Sr. SQL BI Developer

Responsibilities:

• Involved in the development of SSIS Packages & SSRS reports using BIDS.
• Created and executed SQL Server Integration Service (SSIS) packages to populate data from the various data sources, created packages for different data loading operations for different applications.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Developed Stored Procedures, Functions, Triggers, Tables, Views, SQL joins and statements for applications using T-SQL.
• Used CTEs for recursive functionality to bring the organization structures.
• Built table valued functions, scalar valued functions to suffice the needs for business rules and for the implementation in stored procedures.
• Performing extract/transform/load (ETL) routines using SQL Server Integration Services(SSIS).
• Interacted Business Analysts to understand the requirements and the impact of the ETL on the business.
• Used existing ETL standards to load into staging tables
• Perform Data Analysis, determining business logic and applying them to Development.
• Creating new jobs or using the existing jobs, reviewing the results to determine success/failure, documents success/failure, troubleshoots failures, provides up-to-date communication and maintains documentation.
• Designed dimension modeling for data warehouse. Developed data warehouse to generate OLAP cubes and identified measures and dimensions according to different requirements.
• Extensive experience in Extracting, Transforming and Loading (ETL tools) using SSIS, DTS, Import/Export Data, Bulk Insert, BCP, DTS Packages and SSIS packages.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Created user defined functions in SSRS using VB script.
• Worked on row and column grouping, filtering and sorting the data in the repots using SSRS.
• Worked on complicated requests like LSIT, Efolio, Agent Profile requests.
• Given KT’s to new joiners in the project and SME for Tech Arch activities
• Worked on execution of Inbounds & Outbounds on various environments like AIT, DEV, REG, UAT.

Environment: MS SQL Server 2005/2008, MS Reporting Services 2005/2008, SQL Server Integration Services 2005, T-SQL, Windows Server 2003, Windows XP Professional, MS Excel 2003, Team Foundation Server

Confidential

Software Developer

Responsibilities:

• Worked extensively on the major enhancements to the dotnet existing code
• Design and execution of SQL queries, stored procedures, functions and indexes
• Worked on Database tables, views, joins for analyzing the data
• Prepared the technical documentation for the new business requirements for the upcoming portal enhancement
• Worked on Unit testing and Performance testing with onshore team
• Delivered the project required targets weekly on time and given extensive trainings to the new joiners in the project.
• Involved in Design, Development and maintenance of new Installs and Existing SSIS Packages, including creating technical specifications for new SSIS requirements.
• Responsible for the Migration of existing data to SSIS (SQL Server Integration Services).
• Analyzed the requirements and framed the business logic for the ETL process.
• Developing code for the process of loading the data into our databases and following the process of cleansing the data before loading.
• Developed T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Involved in building the ETL design process and implementation.
• Responsible for creating Dynamic SQL store procedures to create the tables and manipulate the data on the fly.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments.
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions and facilitated easy implementation to the front end of the application.
• Loading source files in to raw tables for data mining and data ware housing tasks.
• Performed performance tuning for longer running store procedures.
• Used Merge function to check against old records and load only new records.

Environment: SQL Server 2008/2005, SSIS, SSRS, T-SQL, VB Script.Net, MS-Excel, Visual Studio 2005