| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateKOUSHIK
EMAIL AVAILABLE
PH NO: PHONE NUMBER AVAILABLE
SUMMARY:
7+ years of experience in design, development, coding and testing of business and commercial applications
in MSSQL Server 2012/2008R2/2008/2005, MS Access, and Windows 2000/2003/2008.
Extensively worked on system analysis, design, development, testing and implementation of projects and
capable of handling responsibilities independently as well as a proactive team member.
Excellent knowledge of entire Software Development Life Cycle(SDLC) methodologies like waterfall
model and Agile methodology
Experience in designing Star, Snowflakes schemas and database modeling using Erwin tool.
Experience in OLTP/OLAP environment and Data Warehouse.
Strong knowledge on Oracle Architecture and Database Management.
Extensive experience in SQL Server Analysis Services OLAP Cubes, and Data Mining .
Work experience on MS SQL Server 2012/2008R2/2005/2000, Oracle, VB 6, crystal reports 6.
Experience in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS
Designed and developed matrix and tabular reports with drill down, drill through using SSRS.
Experience in writing Complex SQL Queries involving multiple tables inner and outer joins.
Worked as MS SQL Server Developer on enterprise and performance critical applications.
Extensive experience in developing Stored Procedures, Views, Cursors, Triggers and Complex Queries in
MS SQL Server.
Involved in migration of legacy data by creating various SSIS packages
Expert in Data Extraction, Transforming and Loading ( ETL) using various tools such as SQL Server
Integration Services (SSIS), DTS, Bulk Insert and BCP
Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS
Cube using MDX, Drill-down, Drill-through And Cascading reports using SSRS.
Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL
Profiler and SQL Server Debugger.
Expert in generating drill down reports in SSRS 2008.
Experience in Handling Heterogeneous data sources and databases Oracle, Teradata, and csv and XML
files using SSIS.
Enhancing the Reports visually by adding the visual elements like charts, graphs to SSRS reports Involved
in Logical and physical Design of the Database using Erwin tool.
Auto-generated analysis reports using SQL Server, ACCESS, Business Objects and Crystal Reports and
Excel pivot tables.
Developed interactive web-based reports and forms with VB.NET and ASP.NET and ADO.NET and html.
Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
Exceptional Computer Science background with programming skills in VB as a Junior Programmer.
Excellent verbal and written communication skills with a strong focus on customer facing interaction,
customer service, and presentation.
Experience in using Team Foundation Server (TFS) and Visual source safe (VSS) as a tool for repository
of codes and version control, branching and merging into production.
Experience in tuning the reports that includes modifying, Testing the required TSQL and MDX queries
using DMV's and creating the necessary environment for Deployment.
Proficient with automated testing tools Win Runner, Load Runner and QTP for testing Client / Server
and Web based applications
Test & Deploy code across various SDLC Environments like TEST, UA/UT/Production.
Self-Motivated and possess ability for critical thinking, analysis, good interpersonal and communication
skills.
Ability to work excellently as an individual and also as part of a team with minimum amount of supervision.
Technical Skills:
Databases MS SQL server 2000/2005/2008/2012, Oracle, Teradata, MS Access, Netezza
SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler,
Tools Data Base Engine Tuning Advisor, SSIS, SSRS, Business Intelligence Development
Studio, Data Transformation Services
Languages Transact- SQL, SQL, HTML, XHTML, C , XML
ETL Tools SQL Server Integration Services (SSIS), SQL Server DTS
Reporting Tools SQL Server Reporting Service (SSRS), Crystal Reports, Business Objects.
SQL server Management Studio, SQL server Query Analyzer, SQL server mail
SQL Server Tools service, DBCC, BCP, SQL server profiler.
Data Modeling
Erwin tool, Microsoft Visio 2000/2003
Tools
Windows server 2003, Windows 2000 advanced server/professional, Windows NT,
Operating Systems
Windows XP professional /standard, Windows 7 and UNIX.
Other Tools Microsoft Visual Source Safe, TFS, Microsoft Office, MS Visio.
PROFESSIONAL EXPERIENCE
Client: Cigna Health care, Bloomfield, CT Jan 2015 Till Date
Position: SQL Server SSRS/SSIS Developer
Responsibilities:
Interact with the system analyst & business users to gather business requirements, system specification and
enhancement.
Created SSIS packages to pull data from text files, XML files, SQL server and excel and exported to excel
spreadsheets, flat files and vice versa.
Published migrated data using SSIS, DTS Wizard (data transformation services) tool through data flow
tasks, look up transformations and script tasks.
Extensively worked on mappings, incremental data loading, and SSIS transformations that include:
lookup, filters, aggregators, scripts, multicasts, derived (not limited).
Intensively used SSIS Import/Export Wizard, for performing the ETL operations.
Scheduled the created SSIS /DTS packages using SQL server agent.
Worked on error handling using try and catch blocks and performance tuning using counters in SSIS.
Created complex stored Procedures, triggers, cursors, tables, views and other SQL joins and statements
for applications by using T-SQL.
Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database
models, data dictionaries, and data integrity.
Created complex SSIS Package using Script Task, For Each Loop, Derived Columns, Fuzzy Lookup,
Condition Split, Sort, Union All, Execute SQL Task, Data Flow Task and File System Task.
Used various data transformations like Conditional Split, Script Component, Derived Column, Sort,
Merge Join and Data Conversion etc.
Involved in extracting the data using SSIS from OLTP to OLAP.
Worked on the Audit Logs that capture the audit details before and after the package execution using
Variables and Parameters.
Created SQL server reports using SSRS 2005/2008 for manager, customer support and that can deliver at
client s station.
Designed different type of SSRS reports: Tabular, matrix (cross tab), conditional, list items, charts and
sub reports.
Created cascading (collapsed) parameters to a report, and added report parameters that can be used in
user-defined function.
Responsible for ongoing maintenance and change management to existing reports and optimize report
performance.
Designed printable, interacted reports (drill-down and sorting functionality).
Created and designed reports based on query parameters and report parameters .
Involved in creating cubes and dimensions for the new data warehouse using SQL server analysis services
(SSAS).
Took part in creation of star schema and snowflake dimensional schema in MS analysis services (SSAS).
Supported in creating KPI, calculation members and measure groups, and MDX queries.
Worked with preparing the documentation for analysis, Technical Specification documents, Functional
Specification documents, mapping documents etc., for various migrations and up gradation projects.
Environment: SQL Server 2012/2008/2008R2 Enterprise Edition, Netezza, SQL Server Business
Intelligence Development Studio (SSAS, SSIS, SSRS), Microsoft Office Share point Server, XML, MS
Visual Source Safe.
Client: Cardinal HealthCare, Dublin, Ohio Oct 2013 Dec 2014
Position: Sr. SQL Developer/ MSBI developer
Responsibilities:
Designed SSIS Packages to handle data migration (ETL Processes) from transaction system
Created the Staging tables, successfully migrated old data from legacy system into SQL Server using SSIS
Packages.
Used Sequence Container in Control Flow for linking all dimension tables.
Extensively used SSIS transformations such as Slow Changing Dimension, Lookup, Conditional split,
Sort, Merge Join, Aggregate, and Execute SQL task etc.
Generated reports using SSRS. Identified the Data Source and defined them to build the Data Source
Views.
Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill
through functionality and Graphical presentations such as Charts and Dashboard type metrics using
SSRS.
Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server.
Scheduled the monthly/weekly/daily reports to run automatically . Worked on querying data and creating
on-demand reports using Report Builder in SSRS reports and send the reports via email.
Responsible for scheduling the subscription reports with the subscription report wizard. Deployed the
generated reports directly on the client s workstation.
Used Query Optimization and SQL Server Profiler for tuning report queries and improves performance in
SQL Server.
Performed activities like creation and indexing of the tables.
Created Views and Indexed Views to reduce database complexities for the reports.
Enhancing and deploying the SSIS Packages from development server to production server.
Environment: MS SQL Server 2008/2005, SQL Server Integration Services (SSIS) 2005, SQL Server
Reporting Services (SSRS) 2005, T-SQL, MS Office, Windows Vista
Client: Pizza Hut, TX June 2012 Sep 2013
Position: SQL Developer/MSBI Developer
Responsibilities:
Actively participated in interaction with users, team lead, DBA s and technical manager to fully understand
the requirements of the system.
Scheduled Complex Stored Procedures using SQL Server Agent.
Monitored and modified Performance using execution plans and Index tuning
Involved in project planning, also schedule for database module with project managers.
Responsible for writing T-SQL code for creating cursor and handling data validations
Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user
defined data types and functions for the project.
Developed, tested and implemented Referential Integrity rules and regulations through constraints,
triggers and views, partitioned views.
Created indexes on selective columns to speed up queries and analyses in SQL Server Management
Studio.
Created SSIS Packages user data from the Flat files on monthly and weekly basis.
Created Database objects views, and functions and developing procedures for implementing
application functionality at the database side for performance improvement.
Defined constraints, rules and defaults and developed SQL scripts to Insert/Update and Delete data in
MS SQL database tables.
Created views as required by front end developer for easier implementation on web pages, and triggers on
those views to provide efficient data manipulation.
Assisted and supported issues related to the queries and database systems.
Involved in rebuilding the indexes at regular intervals for better performance.
Designed SSIS packages to load data from different sources Text files, Excel to staging and staging to
Data warehouse.
Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly
Reports including current status
Created datasets, data source and involved in deploying the reports in to the report server.
Created SSIS packages using script task by C#.
Created reports using SQL Server 2005(SSRS) and integrated into the web front end.
Involved in generating Matrix reports, Sub reports and complex reports with multi value parameters for
the analysis of Performance.
Created Drill reports which give all the details of various transactions like closed transactions, pending
approvals, and summary of transactions and scheduled this report to run on quarterly basis using SSRS
(Reporting services).
Worked on Performance tuning, and optimization of procedures and queries.
Created ad-hoc queries from SQL Server databases for custom reporting needs. Worked on querying data
and creating on-demand reports using Report Builder in SSRS.
Developed complex Stored Procedures to generate various Drill-through reports, parameterized reports
and linked reports using SSRS.
Environment: SQL Server 2005, T-SQL, SSIS, SSRS, VB.NET, ADO.NET, Microsoft Excel, Microsoft
PowerPoint.
Client: US BANK, St. Louis, MO Oct 2011 May 2012
Position: SQL Server Developer
Responsibilities:
Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS packages.
Experience in creating complex SSIS packages using proper control and data flow elements.
Worked on different kinds of Transformations in SSIS like Slowly changing dimension (SCD s), Lookup,
Merge, Derived column, Multicast, Conditional split, Aggregate, Fuzzy lookup, Pivot and Un Pivot as
per the client requirement.
Implemented Logging and Event Handlers on SSIS packages for trouble shooting.
Excellent report creation skills using Microsoft SQL Server 2008/2005 Reporting Services (SSRS) with
proficiency in using Report Designer as well as Report Builder.
Created SQL Server Reports based on the requirements using SSRS 2012.
Involved in analysis of Report design requirements and actively participated and interacted with Team
Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
Created complex reports which involve more number of groupings and multi-value parameters.
Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process
for monthly Statements.
Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on
periodic basis.
Designed and developed databases using Oracle, MS SQL server.
Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
Created multiple reports with drop down menu option having complex groupings within the report.
Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
Experience in working on Cube structure optimization for MDX query performance in Analysis Services
2008/2005 (SSAS)
Worked on OLAP Data warehouse, Model, Design, and Implementation.
Used Service Oriented Architectural approach for developing Information Systems and later on used it for
databases.
Troubleshooting performance issues and fine-tuning queries and stored procedures.
Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups
and KPIs to analyze performance of Strategic Business Units as well as corporate centers
Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
Checked the configuration and performance of the existing databases including data file allocation, index,
fragmentation and impact on system performance. Analyzed potential problems (response delay, locking,
server down time, etc.) to avoid and optimize by following the Normalization standards to maintain data
consistency and by performing data validation.
Worked very closely with Business Customers, End Users and resolved any business process related issues.
Environment: Windows server 2003, IIS 6.0, MS SQL Server-2012/2010/2008/2005 Enterprise Edition,
SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, OLTP, Erwin, Performance Point
Sever, Office-2007, MS Excel, Oracle, C#.NET, ProClarity Analysis.
Client: ITC, India July 2009 Sep 2011
Position: SQL Developer
Responsibilities:
Gathered requirements to identify and create database objects such as tables, views, triggers and indexes.
Involved in Normalization of the database and bringing it to 3NF.
Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential
integrity.
Created ER diagrams using Visio.
Created Views to enforce security and data customization.
Created Non-Clustered indexes to improve query performance and query optimization.
Involved in the performance tuning and optimization of T-SQL queries.
Responsible for Data migration from SQL Server 2000 to SQL Server 2005 Databases.
Created Stored Procedures for commonly used complex queries involving join and union of multiple
tables.
Developed user requested reports using Crystal Reports and Excel.
Created Drill down and Drill through reports using Crystal Reports.
Environment: MS SQL Server 2005, Windows NT platform, Visual Basic 6.0, Crystal Reports.
|
