OBJECTIVE

• Looking for a senior developer or team lead position to solve the challenging projects, improve my knowledge and transfer my experience to my colleagues.

SUMMARY

• 12+ Years of IT experience which includes 6 years of BI and Data Analysis, Design, Development & Support of MS SQL Server 2008, 2005 and 2000 in Warehouse, Production and Development Environments and more than 4 years in .NET development.
• Hands - on experience in analyzing, designing and documenting Logical, Physical data models, SQL Server Strategies and plans.
• Highly experienced working with C# & VB.NET Front-end & back-end development (ETL Script Task & SSRS Script)
• Involved in designing, developing and deploying complex Data Warehouse using (Star Schema, Snow Flake Schema) depending upon business needs as supported by organization.
• Involved in Query Optimization and Performance Tuning.
• Performed and implemented complex ETL Strategies that would extract data from various different heterogeneous sources like Oracle, DB2, Flat Files, and Excel Files and dump it into centralized Data Warehouse in accordance to business scenario.
• Utilized various SSIS transformations according to the business needs during the transformation phase and also extended the functionality of SSIS packages by implementing transactions, checkpoints, error-handling, logins, and configurations and deployed them on the production servers.
• Created and optimized OLAP Cubes by creating Partitions, designing aggregations, KPIs, Calculated Members using MDX, defining proper attribute relationships and hierarchies.
• Developed the Ad hoc report models and optimized the report execution by creating report snapshots, report cache and implemented the security by creating various roles on the Report Manager.
• Deployed reports to the Report server in Native Mode and implemented Report delivery using Subscription in SSRS
• Implemented OLAP cubes and their data source schemas using SSAS 2008 and Processed partitioned MOLAP Cubes using SSAS as well as SSMS.
• Optimized Cubes by pre calculating Aggregations and hierarchies.
• Created several KPI’s, perspectives, and calculated members that were eventually used in the BI application for reporting purpose.
• Excellent experience documenting Code as well as BI solutions and maintain documentation versions using VSS and TFS.
• Good exposure to different multinational companies in USA, Canada, England, Dubai & Iran.
• Ability to accomplish any sort of SMART project within specifications, time and budget
• Expert in .NET & Business intelligence, leadership and team building
• Outstanding consultancy with broad knowledge of computer science
• Highly organized, self-motivated, punctual and self-disciplinary personality
• Fully responsible for business growth and corporate objectives
• Crisis resilient, persistent with adaptable personality

TECHNICAL SKILLS

RDBMS: MS SQL-Server (T-SQL, SSIS, SSAS, SSRS), MySQL, Oracle, MS Access, FoxBASE

Programming languages: C#, VB.Net, Java (JEE), Visual C, Groovy, Ruby on Rails, C++, Visual Fox, Delphi, Assembler (IBM360 and x86), Cobol, Fortran, Pascal

Script languages: JQuery, JavaScript, DOM, CSS, ASP.Net, JSP, Java Servlets, HTML, XHTML & XML, SEO, LINQ, AJAX

Programming Frameworks: WPF, WCF, Hibernate, NHibernate, ASP.NET

IDE: MS Visual Studio, Adobe Dreamweaver, Oracle JDeveloper, JavaBeans, Eclipse

Microsoft office Suite: Word, Excel, Access, PowerPoint, Project, Visio

PM methods: Extreme, Agile, SCRUM & Waterfall SDLC, Extreme Programming

PM software: MS Project, MS Visio, MS Office suite, UML

PM Skills: Business process modelling & management (BPM), Business performance management, PPM, WBS, TOC, CCPM, PERT, DMS, EDM, ECMS, RMS

App. development models: Cloud Computing (SaaS) & n-tier Client Server architecture (online banking, e-commerce, Smartphone, Tablet Applications), Grid computing

Web Content Man. Systems (WCMS): Joomla, DotNetNuke, MojoPortal, Drupal, WordPress

OS: Windows, Linux (Ubuntu, Red Hat, Android), Unix (Solaris)

Telematics: 802.11p, ICT (Information & Comm. Technology), Intelligent Transportation, Wireless Access for the Vehicle Environment (WAVE), Dedicated Short Range Comm. (DSRC), Odometry, dead reckoning, Fleet management, GPRS, EDGE, VOIP

Simulators: OPNET, QualNet, NS2, MATLAB

PROFESSIONAL EXPERIENCE

Senior Consultant & ETL Developer

Confidential

Responsibilities:

• Replace the reference database of First DataBank with MediSpan.
• Migrate SSRS reports to SharePoint Portal
• Created more than 50 ETL packages, data mapping, data QA
• Working with ERWIN and Visio to do reverse & forward engineering to update a business process @ OLTP - Using SSMS diagrams to optimise database design
• Optimized old SSIS packages & migrate DTS packages to 2008.
• Prepare ETL framework & provide guidelines to migrate company servers to Sql Server 2012
• Write VB scripts for SSIS & SSRS.
• Analyse and identify data issues/problem to solve and determine the best course of action to correct the data.
• Analyse reports of data duplicates & errors to provide seamless communication & data reports.
• Analyse database and data models to identify design issues and provide solutions.
• Identify, analyse and interpret trends or patterns in complex data sets.
• Perform report optimization to improve report performance.
• Risk Management portal developed in .NET 4.0
• Elist - Health care provider list will be generated using SSIS
• Rx - Prescription Management developed in .NET 3.5
• Used various Rich Data Controls like Grid View, Details View & various validation controls are used to validate each and every control on a Web form. Client side validations with JavaScript/JQuery.
• Designed and developed the required SQL stored procedures, T-SQL, triggers & DB functions.
• Involved in test cases preparation and performed unit testing.

Senior .NET & BI Developer

Confidential

Responsibilities:

• Gathered and analyzed business requirements to design staging database and dimensional model for ‘Perf’ data warehouse.
• Actively participated in team meetings (remotely) to make decision on structure of staging and data warehouse and design of ETL process.
• Designed logical and physical models for staging database and data warehouse using Erwin 9.0 database modeling tool.
• Created database projects for staging database and data warehouse in visual studio 2008, to store all related objects at one centralized location.
• Experience of working with BCP and BULK INSERT to load data for Unit Test project.
• Hands on experience in analyzing query execution plan in SSMS to improve query performance.
• Improved query performance by creating different kind of indexes such as Clustered, Non Clustered, Covering indexes.
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFS, CTEs and System stored procedures.
• Reviewed the existing stored procedures and improved efficiency by critically evaluating the code or by replacing them with UDFs to optimized performance of front end applications.
• Worked on C# and .net environments as a part of Script component and Script task along with supporting front-end applications according to the business requirements.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Created bottom up designed cubes using the SQL Server Analysis Services in support of front end applications and reports.
• Designed new Aggregations by creating Hierarchies and then pre calculating the Aggregations using Aggregation Wizard in SSAS.
• Partitioned Cubes in several drives on the SAN for better query performance and was involved in selecting appropriate storage modes MOLAP, HOLAP and ROLAP for the cube based on the usage.
• Implemented new and complex Calculated Members that will be permanently stored in cubes to boost query performance of reports.
• Created KPIs for trend analysis of the business measures
• Optimized packages by avoiding use of blocking transformation, executing tasks in parallel and optimizing code at source.
• Made changes to existing data warehouse with fact and dimensions to hold current as well as historical data for reporting purposes.
• Worked on complex stored procedures to perform Index maintenance, data profiling, metadata search, critical staging procedures for loading data warehouse.
• Performed different subscriptions and optimization techniques on Reports.
• Created ad-hoc reports, and complex Enterprise reports (drill down, and drill through reports, parameterized reports, cascading report) using SQL Server Reporting Services and report manager and linked reports using report builder.
• Scheduled delivery of several reports to multiple users through the use of subscriptions in several different formats like Excel, PDF and Text.

BI consultant & Data Analyst

Confidential

Responsibilities:

• Provide a framework of migration of C++ applications to web-based application and supervise a couple of migrations to Intranet.
• Involved in Database designing (physical and logical) to meet the new requirement using ERWIN.
• Created data-related documentation like file descriptions and definitions, entity relationships and attributes.
• Designed new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development environment.
• Created Stored Procedures for Reporting on Audit Information and Error Information during each ETL Process.
• Handling Query Optimization / Performance Tuning using SQL profiler & DB Tuning Advisor (DTA).
• Designed and facilitated the implementation of data warehouses required by application systems by Validating change requests and made appropriate recommendations.
• Advised and designed Data Marts according to the business requirements by following Kimball and Inmon methodologies that makes use of Star and Snowflakes schema.
• Debugged and troubleshoot different database objects along with SSIS packages and SSAS cubes.
• Good experience working on basic to intermediate level MDX queries and expressions that would serve as an extension to existing SSAS cubes.
• Promoted database objects from test/development to production servers by coordinating and communicating with production schedules within development team.
• Created different types of reports like drill down reports, drill through reports, sub-reports, and parameterized reports.
• Designed reports to include charts and logos that complies with the organizations culture and polices of reporting and documentation.

T-SQL & .NET Developer

Confidential

Responsibilities:

• Involved in creation of several database objects such as Tables, Functions, Stored Procedures, UDF's, Indexes and Views.
• Optimized T-SQL batches and stored procedures by using different techniques like creation of new indexes, modifying existing indexes for better coverage, correcting join order, converting Multi-statement table valued functions to inline table valued functions (to generate better execution plan and correct statistics.
• Performed Index analysis on tables and came up with more efficient solutions to use between different kind of indexes such as Clustered, Non-Clustered and Covering Indexes.
• Created complex stored procedures to perform Index maintenance, data profiling, metadata search (DB2 and Oracle), critical staging procedures for loading data marts & reporting database.
• Participated in Dimension modeling to design data-mart using Erwin modeling tool.
• Implemented SSIS package template so that all the developers will use it as a base to start their package development. The template holds package configurations, connection managers, variables, and logging helpers.
• Auditing framework for SSIS packages as a part of Package template was created that will audit package events such as start and begin of package, tasks and transformation execution and error information along with package versions.
• Designed staging database as intermediate stage for population Data Mart to perform various ETL data massaging operations such as data profiling, data cleansing and data verification.
• Created complex ETL (SSIS) packages to pull data from DB2/Oracle, load placement Agencies monthly data from Excel to SQL server, master child package to load and process Cubes.
• Optimized SSIS packages by using various techniques such as use of non-blocking, synchronous communication nature transformations, optimizing sources as well executing packages in parallel.
• Maintained, Scheduled and monitored Daily SQL server Jobs using SQL server agent involving more than 80 stored procedures.
• Created alerts and mail confirmation of all packages and cube processes in SQL server Agent to get event messages such as success/failure of package, procedure.
• Worked on .NET Scripts in Conditional Formatting for embedding the reports.

Senior Developer/System analyst

Confidential

Responsibilities:

• Gathered system requirements through end-user collaboration.
• Designed and developed different classes
• Tested, fixed the bugs and troubleshooting the technical problems.
• Created new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Created data-related documentation e.g. file definitions, entity relationships and attributes, etc.
• Created indexed views, indexing strategies and UDFs to be accessed by front end applications.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Imported data from MS Access, MS Excel and Text Files to SQL server using SSIS
• Provided back-end support for functional testing and performance testing.
• Created reports with the help of SSRS reports and presentations to meet business requirements.
• Implemented ETL processes using various tasks and transformations in SSIS
• Assisted production departments with the installation, operation and organization of data input into database system

Project Manager / IT Consultant

Confidential

Responsibilities:

• Revenue increase by wining many contracts through networking with other companies
• Save considerably by merging departments and cutting staff overheads
• Kerb the expenses by streamline procedures and remove the production chronic backlog
• System develop: Sale Order Processing, Credit Score and loyalty collection point system, and Decision Support Systems, Data Mining and Data Warehousing, office automation
• Provide consulting for wireless networking, quality control, office automation & software migration
• Develop solutions to boost System Security; improve security on wireless networks and Internet
• Consulting regards Decision Systems on financial institutes
• Provide solutions for e-Commerce, e-Business systems and doing SEO Jobs

Senior Consultant &.Net Developer

Confidential

Responsibilities:

• Responsible for communicating project status to team members and business users.
• Responsible for analyzing, designing, coding, debugging, testing, documenting and deploying changes to the system, maintenance plan
• Work with business users to define new requirements & prepare statement of work and project scope document
• Generate clear and concise design documentation
• Design and implement database designs in Microsoft SQL Server
• Worked on stored procedures and complex queries for achieving the business logic and reporting.
• Analyzed the historical data and extracted required data to support the management decisions.
• Created various DB objects like views, UDF’s, stored procedures, cursors, indexes etc. for achieving desired functionality and performance.
• Implement applications by ASP .Net, C#, HTML, JavaScript
• Generate reports by Crystal report writer and Send the Daily/Weekly Status Report to the project manager
• Attend the regular client call and discuss the weekly status with the project manager
• Conduct frequent status check meetings with the Team as defined by the project manager
• Partner with project manager to proactively plan for test phase and milestones
• Identify Training requirements and forward it to the project manager (technical and soft skills)