Kishan

acw966@r.postjobfree.com

703-***-****

SQL BI Developer

PROFFESIONAL SUMMARY:

Over 7+ years of IT experience in Analysis, Design, Development, Implementation, Troubleshooting and Support of MS SQL server 2012/2008/2005/2000 in OLTP, OLAP Environments as a developer.

Good hands-on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, & Dynamic-queries.

Experience in Database Normalization, Designing, Creating Indexes, Developed Queries and T-SQL Scripts in MS SQL 2012/2008/2005/2000.

Experience in optimizing the query by creating various Clustered, Non-clustered indexes and indexed views.

Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).

Excellent in High Level Design of ETL - DTS Packages & SSIS Packages - for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

Experience in using C# and VB.Net scripts for the Script task and Script component in SSIS.

Experience in using Performance point server 2010 and Share point server 2010.

Extensively worked on developing SSAS cubes, Aggregation, Data mining models and deploying and processing SSAS objects.

Actively involved in migration of SSRS reports from SQL 2000 to SQL 2008/2005 and migration with DTS to SSIS 2008/2005.

Proficient in OLTP, OLAP and Data warehousing Design concepts

Experience in Data Migration using tools like BULK_INSERT, BCP and Replicationbetween different homogeneous/heterogeneous systems and SQL Server.

Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.

Experience in developing Dashboard, Ad-hoc and ParameterizedReports, Create complex reports (ex: drill down reports using different objects) using SSRS.

Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS 2008.

Experience in report writing using SQL Server Reporting Services (SSRS) and in creating various types of reports like table, matrix,chart report, web reporting by customizing URL Access.

Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.

Worked very closely with Customers, End users and powered users collect requirements and training or resolve any business process related issues.

Data Modeling Experience in creating Logical, Physical data models using tools like ERWIN and Visio.

Excellent analytical, interpersonal and communication skills & desire to excel, fast learner, hardworking and versatile team player.

TECHNICAL SKILLS

Databases

SQL Server 2012/2008/2008 R2, SQL Server 2005, SQL Server 2000/7.1, Access, Oracle 8i/9i/10g, MySQL.

Database Tools

SQL Server Management Studio, Performance Monitor, Query Analyzer, Query Optimizer, SQL Profiler, Data Transformation Services (DTS), ETL, Bulk Insert and BCP, Business Intelligence Development Studio(BIDS), SQL CMD.

Languages

T-SQL, MDX, C, C++, PL/SQL, C#.Net, ADO.NET./PIG/HIVE

Reporting Tools

SQL Server Reporting Services (SSRS), Crystal Reports 9.0/8.5,OLAP

Change Management Tool

Visual Source Safe (VSS), Team Foundation Server (TFS)

Operating Systems

Windows Server 2000/2003, 2008, 2008 R2, Windows NT 4.0

Windows 7/vista/XP/98/95.

PROFFESIONAL EXPERIENCE:

GOLDMAN SACHS, Jersey City, NJ March 2015 - Present

ROLE: MS SQL BI Developer(SSIS, SSRS, SSAS)

DESCRIPTION:The Goldman Sachs Group, Inc. is a leading global investment banking, securities and investment management firm that provides a wide range of financial services to a substantial and diversified client base that includes corporations, financial institutions, governments and individuals. Founded in 1869, the firm is headquartered in New York and maintains offices in all major financial centers around the world.

RESPONSIBILITIES:

The project was mainly into data warehouse reporting using SSRS 2008 and SSRS 2012 and ETL Architecture Design during the initial phase and process design for loading dimension and fact tables.

Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.

Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using (SSIS).

Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.

Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.

Worked on various tasks and transformations like Execute SQL Task, Execute Package Task and conditional split, Script Component, Merge and Lookup while loading the data into Destination.

Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.

Responsible to support SQL Servers with ever-changing workloads, and achieving some level of predictable performance (or minimizing variance in plans and performance).

Responsible for Database and Log Backups and Restoration, Backup Strategies and Scheduling Backups.

Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios.

Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Knowledge of developing reports from Cubes using the KPI's for decision making, also debugged data connections, data sources and Data Source Views.

Creating Ad Hoc and parameterized various Reports using SQL server 2008 R2 / 2012 Reporting Services.

Report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types like hidden, internal, default (queried and non-queried parameters).

Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.

Have used BCP, BULK INSERT to transfer data from and to SQL server database.

Implemented security to restrict the access to users and to allow them to use only certain reports.

ENVIRONMENT:MS SQL SERVER 2008 R2, SQL Server 2012, MS SQL Server 2005/2008, SSIS, SSRS, SSAS, Microsoft Visual Studio 2008, SQL Profiler, Microsoft Visio, Excel 2007, Windows NT/2003.

KIEWIT CORPORATION / INEIGHT, Omaha, NE June 2013 - Jan 2015

ROLE: SQL Server BI Developer

DESCRIPTION:Kiewit is one of the largest construction companies in North America, with a growing presence in Australia. Throughout its history, Kiewit have built roads that connect the world, dug canals to carry water to thirsty lands and bored tunnels through mountains. Kiewit build and mine. Kiewit shape the landscape and create energy solutions and do it all with integrity. Kiewit had 2012 revenues of more than $11 billion and consistently ranks among the top five contractors by Engineering News-Record.

RESPONSIBILITIES:

In this agile project all tasks are assigned to the team members using the Share point priority Tasks. The tasks are completed as per the priority hierarchy.

Responsible for development of stored procedures, functions and database Triggers.

Imported data from Cache Monitor using SQL Server Integration Services (SSIS) package Involved in migrating from cache to SSMS.

Involved in creating stored procedures, Indexes in MS SQL Server environment using 2012.

Created, indexes, Triggers, Stored Procedures in SSIS Package.

Created Complex ETL Packages using SSIS to extract data from Cache Monitor to SSMS with execute SQL Task and Incremental Load. And even created and dropped indexes in execute sql task.

Created SSIS packages for Migrating from one Database to the other using Data Reader Source.

Used VB scripting in SSIS.

Access SQL Server using front end applications like VB.

Writing C# code in SSRS.

Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Merge and Send Mail task etc.

Performed remote and onsite application system design, development and ongoing maintenance on multiple AS/400s

Managing and scheduling daily jobs relating to data transfers, backup and recovery.

Created Clustered Indexesand Non-Clustered Indexes

To increase the performance of database.

Even used special field casting and data conversion in Data Reader Source.

Wrote PL/SQL packages to calculate Missing Information and Determining Eligibility in the processing of a Medical/Health Families Application.

Created reports based on the format specified in the design document.

Involved in creating Sub reports in MS Reporting services (SSRS).

Passed parameters to the Reports using Report parameter menus.

Used Deployment wizard for deploying the Reports.

ENVIRONMENT:Windows 2007 enterprise, SQL Server 2008/2005,SQL Integration Services(SSIS), Business Intelligence Development Studio, Visual Studio 2008/2005,IBM AS/400.

VOYA FINANCIAL (Formerly ING), West Chester, PA Sep 2012-Apr2013

ROLE: SQL BI Developer (SSIS, SSRS, SSAS)

DESCRIPTION:Voya Financial(Formerly ING) is one of the leading financial services company in North America providing retirement, investment management and insurance related services to help make their customers a secure financial future. The current project mainly involved in the migration of data by extracting data from different sources (Excel, Oracle, Flat file, CSV, Access, Sybase) and loading it into required data bases by means of designing efficient SSIS packages. The project also involved in designing new GUI interfaces and the maintenance of existing C#.NET application. The project also involved in production server activities for database development and monitor periodic Jobs.

RESPONSIBILITIES:

Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases.

Converted ETL from DTS to SSIS.

Extensively used T-SQL to manipulate and architect to produce results for users.

Worked with development teams in the design of physical databases and in modification.

Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.

Successfully migrated SSIS packages from development to test to Production environments using SSIS Configure files and deployment wizard.

Created SSIS process design architecting the flow of data from various sources to target.

Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.

Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.

Actively engaged in client meetings in requirement gathering and development updates.

Developed SSIS packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.

Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.

Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.

Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

ENVIRONMENT:

MS SQL Server 2005/2008, Windows 2003/2008, SSIS, SQL Server, Management Studio, SQL Server Business Intelligence studio, Microsoft Excel and Access.

PENSON FINANCIAL SERVICES, Dallas, Texas Dec 2011 - Aug 2012

Role: SQL Server Developer/ SSRS/ SSIS/ SSAS Developer

DESCRIPTION: Penson Worldwide is a leading independent execution, clearing, settlement and technology firm servicing the global financial services industry. It provides a range of solutions to help service the customer and expand the business.

RESPONSIBILITIES:

Worked as a developer in creating complex Stored Procedures, Triggers, and Functions.

Managed index statistics, Tables, Views, cursors and optimizing queries using execution plan for tuning the database. Implemented different types of constraints on tables.

Used Try catch and @@error for exceptional handling.

Designed Star schema (identification of facts, measures and dimensions) and Snowflake schema. Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using RDL.

Created queries for generating drill down reports in SSRS 2005.

Formatted the SSRS reports using the Global variables, expressions and Functions.

Responsible for ETL operation using SQL Server Integration Services (SSIS) 2005 and Worked with users in training and support and also have experience in incremental data loading.

Responsible for developing, monitoring and deploying SSIS2005 packages.

Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.

Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX.

Identified and defined Fact relationships in SSAS.

Installed and Configured SQLServerActive/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.

ENVIRONMENT:

SQL Server2005/2000 Enterprise Edition, SSRS, SSIS, SSAS, SQL Server 2005 Partitioning MS IIS, Windows 2000/2003 Advance Server, XML, MS Excel, Access and Visual source safe.

BIRLA SUN LIFE INSURANCE COMPANY LIMITED (BSLI), India. Nov 2010 - Oct 2011

Role: SQL Server Developer

DESCRIPTION:Birla Sun Life Insurance is one of India’s leading life insurance companies. Because of the strong investment lineage of Birla group Birla Sun Life Insurance is able to offer a comprehensive variety of products and services that suit the diverse needs and risk-return profiles of every investor. The Project started in 2003 with a life Insurance Plan .The requirement here was assisting building database and also modifying when required. Integrating different databases and finally giving report about the effective policies sales.

RESPONSIBILITIES:

Involved in Physical and Logical design of the databases.

Developed DTS Packages to transfer the data between SQL server database and files.

Created and maintained Data Transformation Service (DTS) packages for migrating data.

Scheduled Jobs for DTS packages.

Used BCP/Bulk Insert to publish table output to text files.

Created advanced T-SQL queries using DDL, DML and Indexes, Views, Cursors, Triggers, User Defined Functions and Stored Procedures.

Used all Declarative Constraints for maintaining Data Integrity.

Created Views to restrict access to data in a table for security.

Involved in performance tuning of T-SQL queries and Stored Procedures.

Implemented Auditing using triggers.

Created schema objects, rules and granted roles to the users.

Used SQL Profiler to debug T-SQL and slow running queries.

Monitored the Database Performance using execution plans and Index tuning.

Optimized the query performance with modifications in TSQLqueries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins.

Involved in scheduling backups of databases and logs and restoring them when necessary.

ENVIRONMENT:

MS SQL Server 2000/2005, T-SQL, Windows 2000 server, Windows NT 4.0,Visual Studio 2000/2005.

MEGASOFT LIMITED, India May 2009 - Oct 2010

ROLE: Jr. SQL Server Developer

DESCRIPTION: Megasoft Limited is an India based Software Company which has proven record as provider of quality technology and innovation by full suite of innovative offerings in products, applications and technology platforms.

RESPONSIBILITIES:

Designing the system architecture.

Created new tables, written stored procedures for Application Developers and some user defined functions.

Created SQL scripts for tuning and scheduling.

Performed data conversions from flat files into a normalized database structure.

Created and managed users, roles and groups and handled database security.

Created Triggers to enforce data and referential integrity.

Defined Check constraints, Business Rules, Indexes, and Views. Used Citrix to remote access the developing application.

Used SQL Server to create stored procedures, views and calling through the application.

ENVIRONMENT:

C#, ASP.NET, SQL Server 2000/2005, Visual Studio 2000/2005, Citrix.

Contact this candidate