We provide IT Staff Augmentation Services!

Etl/bi Development Resume

Summary

Experience

  • 12 yearsof experience in analysis, design and development of business systems.
  • Strong domain and data warehouse design experience inContainer Shipping, Transportation industry, Membership Management, RetailsandE-Commercedomains.
  • Proven experience inAnalysis,Design&Developmentof high performance database objects.
  • Sound knowledge inSQL ServerAdministration Tasks.
  • ExcellentTeam Managementskills.

Business Intelligence

  • Skills inSQL Server 2005/2008 Business Intelligence Tools,Data WarehousingandETLprocess.
  • Extensive experience and proficiency in design, construction and implementation (Star Schema,Snow Flakes) of Business Intelligence.
  • Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS)
  • Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS)
  • Sound knowledge inMultidimensional Expressions (MDX).
  • Advanced reporting skills using SQL Server Reporting Services (SSRS),PerformancePoint 2010,Excel Services 2010,Scorecards,KPIs,Dashboard DesignerandCrystal Reports
  • Good knowledge inMicrosoft SharePoint 2010
  • Expert in SSRS configurations such asCaching,SnapshotsandData Driven Subscriptions
  • Expert in designing Enterprise reports using SSRS 2008 such as drill down reports, parameterized reports, linked reports, sub reports, tables, matrix and charts
  • Experience in creating Ad-hoc reports usingReport Builderin SSRS.
  • Expert EnterpriseData Modelerwith a deep understanding of developing transactional enterprise data models that strictly meetnormalization rules, as well as enterprise data warehouses using Kimball data warehouse methodologies.
  • Experience in providingLogging, Error handling by usingEvent Handler, and Custom Logging for SSIS Packages.
  • Extensive experience of usingScript TaskandScript Componentusing the languagesC#.NET and VB.NET
  • Scheduling and Monitoring ETL Processes usingSQL Server Agent,DTS Executilities and batch files.
  • Experience inDatabase Migrationfrom SQL Server 2000 to 2005 and 2008
  • Good development skills inVBAandExcel Macro

Database Design and Programming

  • Extensive experience in writing ComplexStored Procedures, Triggers and User Defined FunctionsinSQL Server 7/2000/2005/2008.
  • Development and implementation experience inSQL Server 7/2000/2005/2008.
  • Sound knowledge inTransact SQL.
  • Proven experience in large database design forERP Systems
  • Supported front-end applications under .Net framework, using C#.Net and ASP.Net

Database Administration

  • Creating and ManagingDatabases and Database Files
  • ImplementingAdministrative Taskssuch asAutomated Database Maintenance tasks by creating Jobs, Alerts and Operators through SQL Server Agent.
  • Used Database engine Tuning Advisor (DTA) forPerformance Tuning
  • Implemented DataPartitioningfor large databases
  • Administered DatabaseRecoveryPlanning and Process
  • Protection andDistribution of Data
  • Implemented different types ofReplication Models(Snapshot, Merge and Transactional) and databaseMirroring
  • DatabaseSecurityand NativeData Encryption

Application Development

  • Good experience ofSDLCwithOOPS/OODsfor Microsoft .Net Technologies.
  • Experience in Analysis, Design, Development, Testing of Client-Server & Web applications with.NET 1.1/2.0, C#.Net, VB.Net, VB6
  • Good Knowledge of .NET fundamentals,.NET framework, CLR, CTS
  • Proficient on Windows Forms, Windows Services, Web Forms & ASP.Net Web Services
  • Development and implementation experience inVisual Studio 2010, 2008, 2005, 2003 and 6.
  • Development and implementation experience inDelphi 5.0
  • Experience in usingCrystal Reports 7.0to11.0

Others

  • Experience with Software Development Processes & Models: Agile, Waterfall and V-Model
  • Ability to solve any programming tasks. Willing to shoulder challenges in technology.
  • Capability in debugging and optimizing programs with Delphi/Visual Studio.
  • Excellent capabilities in Mathematical Analysis.
  • Ability to undertake Team Works.
  • Capable of analyzing any process and formulating a solution.

Technical Skills

Programming Languages: C#.Net, VB.Net, JavaScript, VBA, T-SQL, PL/SQL
RDBMS & Tools:SQL Server 7/2000/2005/2008, Database Engine Tuning Advisor, SQL Profiler, MS Access
Reporting Tools:SSRS,PerformancePoint 2010,Excel Services 2010, Dashboard Designer, Crystal Reports 7.0 to 11.0
Microsoft Technologies:SSIS,SSAS,Microsoft SharePoint 2010, SQL Server Business Intelligence Development Studio 2008, Visual Studio 010/2008/2005, MS Visio, VB 6.0
Version Control: Visual Source Safe (VSS), Vault

Qualifications

Masters Degree in Computer Application (M.C.A.)
Post Graduate Diploma in Computer Application (PGDCA)
Bachelors of ScienceDegree in Statistics

Projects Experience

Client: Confidential, [Jan 2011 - Till Date]

ETL/BI Development Lead/Database Modeler

Environment: SQL Server 2008, SSIS, SSAS, SSRS, Visual Studio 2008, C#.NET, Microsoft SharePoint Designer 2010, PerformancePoint Dashboard Designer 2010, Excel Services 2010.
Responsibilities :

  • Analysis of file/feed formats from different Data Providers and prepare theData Modelfor PDV (Relational DB) and CDW (Star Schema).
  • Gather the report requirements from business users and design the system.
  • Data modeling –Kimball, star schema design
  • Build efficientSSIS packagesfor processing data feeds and load into relational DB and Warehouse DB (fact and dimension tables) with complex transformations such as type 1 and type 2 SCDs.
  • CreatesMS SSAS 2008cubes using the Unified Dimensional Model (UDM)
  • CreatesKPIs in the cube usingMDX
  • Develop and deliver reporting solutions usingMS SSRS 2008,PerformancePoint 2010andExcel Services 2010
  • Design and develop KPIs, Scorecards and Dashboards usingPerformancePoint Dashboard Designer
  • Design intranet website inMicrosoft SharePoint Designer 2010
  • Create efficient DB objects such asStore Procedures,ViewsandFunctions
  • Implement best practices to maintainoptimal performance.

Client: Confidential, [Jan 2009 – Dec 2010] Technical Lead/Database Modeler/Senior BI Developer

  • Captures data from source systems and translates it into reporting dimensions.
  • Position data for effective and consistent reporting and analytics.
  • Provide Standard Reports incorporating all data sources.
  • Provide ad-hoc reporting capability to allow select individuals the means to create datasets for additional analysis.

The DW has data marts from below business processes

  • Membership System
  • 3rd Party Universe (Population/Census Data and Jurisdiction File)
  • Retail (Merchandise, Cookie Sales and Nut Sales)
  • Fund Development (YourMembership.com, Raiser’s Edge/Donor Perfect Council Data and Personify Fund Development Module)

Environment: SQL Server 2008, IIS 6, SSIS, SSAS, SSRS, Crystal Reports 11
Responsibilities :

  • Analysis of Production system, Preparation of Design specification for the Data Warehouse based on the user requirements and Translation of Design Specification to theData Modelusing Visio.
  • Data modeling – Kimball, star schema design
  • Responsible for all ETL operations within group including client feeds, warehouse loads, and data extraction.
  • Build efficientSSIS packagesfor processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
  • CreatesMS SSAS 2008cubes using the Unified Dimensional Model (UDM)
  • CreatesKPIs in the cube usingMDX
  • Develop and deliver dynamic reporting solutions usingMS SSRS 2008andCrystal Reports
  • Design and developStore Procedures,Configuration Files,Views, andFunctions; implement best practices to maintainoptimal performance.
  • Identifying performance bottlenecks and tuning SQL queries and the Database optimization usingSQL Server ProfilerandDatabase engine Tuning Advisor(DTA)
  • Working with the database administrator to designdisaster recoveryprocesses

Client: Confidential, [Sep 2007 - Dec 2008] Module Lead/Senior BI Developer

Environment: SQL Server 2005, SSIS, SSRS, SSAS, ASP.NET, Visual Studio 2003, IIS 5.0, Crystal Reports 10.0
Responsibilities :

  • Worked inDatabase DesignandDatabase Optimizationin SQL Server 2005
  • Active Interaction with clients to understand business requirements.
  • Worked as a senior developer in creatingcomplex stored procedures,triggers,cursors,tables, andviewsand other SQL objects.
  • Involved in extracting the data usingSSISfrom OLTP to OLAP.
  • Designed high levelETLarchitecture for overall data transfer from the source server to the Enterprise Services Warehouse Migrated data from different sources including flat files, MS Access to SQL Server 2005 by using SSIS. Converting DTS packages intoSQL Server 2005 Integration Services.
  • UsedLookup, Merge Join, Conditional splitand other component usingSSIS.
  • Designed, developed and deployed reports usingSSRS.
  • Developed drill down and drill through reports usingSSRS.
  • Involved in creation ofStar SchemaandSnowflakedimensional schema.
  • Developed MIS reports usingVBAandExcelMacros
  • Involved inDatabase Migrationfrom SQL Server 2000 to 2005

Client: Confidential, [Sep 2006 - Aug 2007] Technical Lead/Senior BI Developer

The key activities defined to achieve the objectives are:

  • Implementation of new DW methodologies, logical architectures, tools, processes and controls for DW design, development and management
  • Implementation of a new BI infrastructure
  • Establishment of consistent ETL and Data Quality frameworks
  • Migration of rationalized existing BI data and content to the new BI infrastructure
  • Detailed Database, ETL & OLAP design

Environment: SQL Server 2005, IIS 5, SSIS, SSAS, SSRS, Crystal Reports 8.5
Responsibilities :

  • Worked inDatabase DesignandDatabase Optimizationin SQL Server 2005
  • Play the role of theData Modelerin the project by interacting closely with the Data architects and Business users at Sonoco and analyzing the different source systems in place at Sonoco to design the optimal data model for the Data-Warehouse.
  • Creatinglogical data modelsusing specialized modeling tools like Microsoft Visio based on the requirements identified.
  • Creating various database objects likestored procedures, functions, viewandtriggers
  • Coordinating with DBAs to create the databases in the Test and Production environments.
  • Designing theExtraction, TransformationandLoading(ETL) logic to load the Data-warehouse being designed from the different source systems usingSSIS 2005.
  • Creating canned reports usingSSRSandCrystal Reports

Client: Confidential, [Jan 2006 – Aug 2006] Technical Lead/Senior .NET Developer

Environment: ASP.Net 1.1, ADO.Net, C#.Net, JavaScript, SQL Server 2005, Visual Studio 2003, IIS 5.0, SSIS, Crystal Reports 8.5
Responsibilities:

  • Worked inDatabase designandDatabase Optimizationin SQL Server 2005
  • Developing the Web Forms usingASP.Net 2.0,ADO.NetandC#.Net
  • GUI design using Master Pages, Site Map, Tree View Controls, andCSS.
  • Developing Web Services inC#.Netto interact with Personify Application.
  • UsedJavaScriptfor Client side scripting
  • Writing & reviewingStored Procedures, Triggersand various database objects.
  • CreatingSSIS packagesand testing the complex business rules

Client: Confidential, [Jun 2005 – Dec 2005] Module Lead/Senior .Net Developer

Environment: ASP.Net 1.1, ADO.Net, C#.Net, JavaScript, SQL Server 2000, Visual Studio 2003, IIS 5.0, VB 6.0
Responsibilities :

  • Worked inDatabase DesignandDatabase Optimizationin SQL Server 2000
  • Developing the Web Forms usingASP.Net 1.1, ADO.NetandC#.Net
  • UsedJavaScriptfor Client side scripting
  • Worked with Infragistics controls.
  • Writing & reviewingstored procedures, triggersand various database objects.
  • CreatingDTS packagesfor batch processing
  • Developing various reports using Crystal Reports 8.5

Client: Confidential [Aug 2003 – May 2005] Team Lead/Data Molder/Senior Developer

Environment: Visual Basic 6.0, Crystal reports 8.0, VBA, SQL Server
2000, Analysis services and Replication
Responsibilities:

  • Involved inDatabase Design, writingStored Procedures, creating and managing IndexesandViewsinSQL Server 2000
  • Creating Windows forms usingVB 6.0
  • Created flexible reporting tool usingSSAS
  • Developed canned reports usingCrystal Reports 8.5
  • Configured theSQL Server Transaction Replicationbetween branches and HQ

Client: Confidential [Feb 2003 – Jul 2003] Team Leader/DBA/Senior Developer

Environment: Visual Basic 6.0, Crystal Reports 8, VBA, SQL Server
2000, Analysis services and DTS
Responsibilities:

  • Involved inDatabase Design, writing Stored Procedures, creating and managing IndexesandViewinSQL Server 2000
  • Creating Windows forms usingVB 6.0
  • Developed canned reports usingCrystal Reports 8.5
  • Configured theSQL Server Transaction Replicationbetween branches and HQ
  • Developed MIS reports usingVBAandExcelMacros
  • CreatedDTSpackages to read data from flat files and merge

Hire Now