We provide IT Staff Augmentation Services!

Specialist Resume

SUMMARY

  • Overall 8 years of IT experience as .NET developer, MSBI(SSIS/SSRS), Crystal Reports, MS SQL Server Developer 2005/2000, Business Objects 6.x/ XI R2 (Designer, Desktop Intelligence, Web Intelligence, Info View, Central Management Console& Broadcast Agent) in various Industry verticals like Insurance, Finance, Banking.
  • Expert in Data mart modeling, Data Conversion, Normalization and Data Modeling, Multi - Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.
  • Knowledge of SQL Server Management Studio 20012/2014.
  • Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, Relational Database models, Data integrity.
  • Experience in monitoring SQL Server Performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
  • Knowledge of development in Big Data projects using Hadoop, HDFS, Map Reduce, Hive and Sqoop. Good knowledge using Cloudera Hadoop Distributions.
  • Good experience in Reporting tools like Crystal 2008/8.5, Business Objects, Web Intelligence and SSRS.
  • In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server .
  • Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
  • Implemented complicated transformations to be used in SSIS packages.
  • Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services 2005 (SSRS).
  • Developed complex business reports using custom formulas, conditional formatting, sub reports, drill-down reports, cross-tab reports, ad-hoc reports in Crystal Reports.
  • Expertise on Crystal Enterprise to deploy, schedule, publish and distribute Crystal Reports
  • Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows Performance for monitoring and tuning SQL Server Performance.
  • Has good experience in Business Objects XI R2/ (CMC, Web I), Designer, Infoview and Import Wizard and Crystal Report Version 11.0(XI).
  • Maintained positive communications and working relationships at all business levels.

TECHNICAL SKILLS

  • Business Objects 6.1, XI, Reporter, Designer, Supervisor,
  • VB.NET, VB 6.0, C, C++
  • MS-SQL Server 2000/2005/2008/2012 , Oracle 9i, MS-Access
  • Crystal Reports, SSIS/SSRS, Tableau 9

PROFESSIONAL EXPERIENCE

Confidential

Specialist

Responsibilities:

  • Leading a team of 11 members.
  • Actively participated in gathering Business Requirements and System Specification.
  • Protecting the Production environment. This includes raising the correct tickets, regression testing and ensuring that impact of changes to be assessed and the risks considered.
  • Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
  • Developed physical data models and created DDL scripts to create database schema and database objects using T-SQL 2005 to store data and to maintain database efficiently.
  • Designed data models using Erwin.
  • Used ETL to implement the SCD transformation, to maintain historical data in data warehouse. Applied various transformations like Data Conversion, Multicast, Conditional Split, Derived column in SSIS.
  • Developed and deployed data transfers packages using SSIS 2005, also maintained the jobs running on Servers.
  • Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Staging DB to Data warehouse and Data marts.
  • Responsible for error handling in the packages.
  • Deploying, Testing and Scheduling SSIS packages using SQL Agent.
  • Used linked tables, pass through queries and many other access features also wrote code in VB.Net to perform some reporting tasks.
  • Developed functions, views and triggers for automation
  • Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
  • Managing historical data from various heterogeneous data sources (i.e. Excel, Access).
  • Worked with production control team to deploy code and for schedule run in both staging while testing and production.
  • Deputed at client place (ML Tokyo, Japan) for production support training.

Environment: MS SQL Server 2005, T-SQL, BI tools 2005 ( SSIS, SSRS), MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Windows 2003, MS office, MS Visual Studio

Confidential

Consultant

Responsibilities:

  • Responsible for development and integration of many querying and reporting functions for a multitude of system users and clients.
  • Creating, developing, maintaining and testing the Universe for running the queries against the Database using Designer.
  • Analyzed client requirements and developed custom reports and queries with Business Objects and Web Intelligence.
  • Import data from multiple data sources, transform it, and then publish reports to nearly all standard formats, including XML, PDF, ODBC, and many others.
  • Created and extensively documented a prototype done for Web front-end to leverage the reporting architecture and generate Chart based reports in a scheduled mode using XML data.
  • Assisted client in re-engineering its IED (Institutional Equities) application using Sybase Database techniques.
  • Analyzed the existing database and designed Universes using Designer module for generating reports.
  • Used various data providers like Freehand SQL and Stored Procedures to extract data from different sources and tuned for better performance.
  • Resolved loops by creating Aliases & Contexts and checked integrity of universes.
  • Exported universes to the repository to making resources available to the users.
  • Exported the Reports to the Broadcast Agent and used the Broadcast Agent server to Schedule and Monitor the Reports which offered robust performance and ability to balance Loads.
  • Generated analytical reports using Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae features.
  • Automated document Scheduling, Publishing and Distribution for Webi and Info View clients using Broadcast Agent server.
  • Deployed Crystal reports to CMC (Central Management Console) for users to view reports in Infoview and run, schedule them in PDF and Excel formats.
  • Used the Universes, Stored Procedures as source for Business Objects Querying, analysis and reporting.
  • Manage multiple BO universes using Business Objects Designer and Infoview.
  • Used Designer as a part of Universe Development for Defining the Parameters of Universe, Inserting the table, making Joins, Resolving Loop's, Creating Classes, and Objects.
  • Creation of ad-hoc reports and modified existing reports.
  • Created variables, formulas and filters in report level.
  • Created the Reports using the Universes as the main Data providers and wrote complex queries including Sub Queries, Case and decode functions,using Crystal reports XI

Environment: - Business Objects 6.5, Designer, Webi, Full-client, broadcast Agent, Supervisor, Crystal reports XI, Oracle9i, PL/SQL, and Windows NT/XP.

Confidential

Programmer Analyst

Responsibilities:

  • Worked and enhanced the flow of internal applications
  • Developed and tested user-friendly navigators by utilizing JavaScript and VB .NET
  • Worked on database development, administrator applications, web forms, procedures and triggers
  • Assisted in the conduction of bet support and high-level release testing
  • Contributed in the execution of programming activities and design
  • Performed business requirements analysis and data modeling
  • Designed object relation diagrams, process flow diagram and objects modeling
  • Worked with the team of coding and handled coding of batch process operation
  • Created the triggers, functions and stored procedures
  • Implemented changes in coding and designs using knowledge of VB .NET
  • Conducted release testing, bug verification and software testing
  • Drafting reports with the help of the Crystal Reports tools and creating project presentations
  • Created reports using of formula fields, parameter fields, group selection, record selection, and Crystal syntax in Crystal reports.
  • Developed complex business reports using custom formulas, conditional formatting, sub reports, drill-down reports, cross-tab reports, ad-hoc reports.
  • Performing extensive data analysis and correction

Environment: VB.Net, SQL Server 2000, Crystal Reports 2008, Windows NT, XP

Confidential

Software Programmer

Responsibilities:

  • Involved in development of various kinds of reports as per the modules.
  • Designed systems and database applications, coding, writing specifications by using knowledge of Visual Basic Programming.
  • Assisted software developers and programmers on software and application development projects.
  • Performed coding, debugging, modifying, developing computer applications and systems.
  • Maintained and enhanced existing internal applications.
  • Conducted analysis, designed products and programmed computer software that required extensive research.
  • Involved in creating reports.

Environment: VB6, SQL Server 2000, Crystal Reports 8.5

Confidential

Software Programmer

Responsibilities:

  • Involved in development of different modules.
  • Designed systems and database applications, coding, writing specifications by using knowledge of Visual Basic Programming.
  • Assisted software developers and programmers on software and application development projects.
  • Performed coding, debugging, modifying, developing computer applications and systems.
  • Maintained and enhanced existing internal applications.
  • Conducted analysis, designed products and programmed computer software that required extensive research.
  • Involved in creating reports.

Environment: VB6, SQL Server 2000, Crystal Reports 8

Hire Now