We provide IT Staff Augmentation Services!

Warehouse Developer Resume Profile

3.00/5 (Submit Your Rating)

PROFESSIONAL SUMMARY

  • 7 years of IT experience in analysis, design, implementation and administration of BI solutions with Microsoft SQL server 2008/2005/2000 in development, testing production.
  • Extensive experience in BI suite - using integration services SSIS for ETL Extraction, Transformation and Loading , reporting services SSRS for creating different types of reports and analysis services SSAS for design and developing complex cubes
  • Proficient in using EXPRESSOR 3.6.0 Enterprise data integration tool
  • Well versed with the knowledge of RDBMS, data warehouse i.e. OLTP OLAP systems.
  • Experience in extraction, transformation and loading ETL of data flows using SSIS with complex integration of SQL Server, oracle, flat file sources and IBM mainframe DB2
  • Expert in writing T-SQL, working with DTS Data transformation services data cleansing, data scrubbing and data migration
  • Expertise in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to facilitate efficient data manipulation to maintain data consistency
  • Sound knowledge of SQL server administrative skills including, backups, disaster recovery, database maintenance, user authorizations and database creation.
  • Expert in dimensional data modeling using SSAS and Erwin, cube partitioning, optimization, creating aggregations
  • Thorough understanding of Kimball/Inmon strategies, key performance indicators KPI Reports, and data mining structures
  • Created formatted cross-tab, conditional, drill-down, top n, summary, form, sub reports, Ad hoc reports, parameterized reports, interactive reports custom reports
  • Experience in providing SSRS server level, item level security accessibility to various reports in multi-user environment.
  • Expert in creating dashboards, scorecards and building reports using Report Portal 3.0, ProClarity, and Performance point server 2007
  • Exposure to all phases of software development life cycle SDLC with in-depth knowledge of agile methodology, enterprise reporting life cycle, SQL server migrations, change control rules, problem solving skills and escalation procedures.
  • Performed backup/restore of database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
  • Responsible for automation of maintenance jobs, locks and indexes configurations.
  • Administering SQL Server securities, SQL Server automatic e-mail notification.
  • Managed SQL user logins, database user accounts, server roles, database roles and handled dead lock
  • Regularly monitored the system for bottlenecks CPU, RAM, Disk I/O and Networking .
  • Excellent communication, analytical skills, self-learning abilities and leadership quality.

TECHNICAL SKILLS

  • DBMS/RDBMS : MS-SQL Server 2008R2/2005/2000 Oracle 10G/9i/8.0, T-SQL, PL/SQL, SQL Loader, MS Access, DB2/MVC, SAP 7.0
  • ETL : SQL Server Integration Services SSIS , Data Transformation Services
  • DTS , Oracle Warehouse Builder, T-SQL Stored Procedures
  • Languages : SQL, PL/SQL, C, C , .Net
  • Operating System's : Windows server 2003/XP/NT 6.0/98/Vista, RHEL 4.0/5.0
  • Tools : Toad 8.0, Visual Studio, OEM Database Control 10g , Rational Rose, Crystal Reports 10, ProClarity, Micro Strategy, Dunda's charts, UC4 Job Scheduling Tool, Pragmatic works tools i.e. DTS X-Change, Task Factory, BI documenter, Red gate tools i.e. Sql Compare, Sql Data Compare , Business Object XI 3.1,
  • SAP Business Explorer SAP BW 3.x Business Objects XI 3.1, SAP Business Explorer SAP BW 3.x , Bug Net Issue tracking Project management 0.9.142
  • Data Modeling : Erwin 7.1 Data modeler, Microsoft Visual Studio 2008, SSAS
  • Office Tools : MS Word, PowerPoint, Excel, Visio, MS One note
  • Domain Expertise : Supply Chain Data Management Systems SCDMS , Manufacturing, E-Insurance, Healthcare, Health Management Retail products, Brokerage Finance services
  • Source Control : Team foundation server 2010 TFS , Visual Source Safe 2005 VSS

Professional experience

Confidential

SQL Server BI/SSIS/SSRS/SSAS ETL Developer

Responsibilities

  • Worked with Data architect and business users to understand business processes, document project requirements and translate them into functional specifications for BI reports and applications
  • Installation of Sql Server 2008 Standard edition and enabling SSIS/SSRS/SSAS on Analytical Development server
  • Installation, creation of users, Permissions, access and Security Control for various users, migration of all Production reports
  • Created individual SSIS packages to load dimensions, fact tables then created ETL Master package to load data in Data mart
  • Created SSIS Packages to load each dimensions, Fact tables, Then Configuring packages using XML, Sql Server, Parent package variable methods
  • Deployed SSIS Packages to MSDB under Integration Services Engine, Scheduling those SSIS package for incremental loading of Data mart
  • Used Processing options like Process update, Process full, Process data in while creating SSIS package using Analysis services execute task
  • Highly responsible for development and management of SSRS projects like creating drill through reports through Linked reports
  • Creating browsing permissions for each report like Item level, Group level securities options
  • Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
  • Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, Cache, for each loop, multi cast, Derived column , Data conversions, Merge, OLEDB Command, script task components
  • Created Self-service BI Reports by connecting Analysis service Cubes in Excel 2010
  • Created customized calculations like Current To Date CTD , Prior Current To Date PCTD , Quarter to Date QTD ,Prior Quarter to Date PQTD , Year to Date YTD , Prior Year to Date PYTD in Cube
  • Experience in creating reports using stored procedures. Involved in scheduling, creating snapshot and subscription for the reports and triggers to facilitate consistent data entry into the database.
  • Created SSRS report model projects in bi studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
  • Designed OLAP cubes with star schema and multiple partitions using SSAS
  • Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups
  • Environment: Microsoft SQL Server 2008 Enterprise edition SSIS/SSRS/SSAS, Windows server 2003, Windows 7, MS Excel 2010, Visual source safe 2005,

Confidential

SQL Server BI/SSIS/SSRS/SSAS ETL Developer

Responsibilities

  • Worked as a business analyst - gathering requirement from business users to understand business processes, document project requirements and translate them into functional and non-functional specifications for BI reports and applications, Keeping track of changes in requirements on daily basis
  • Installation of SQL Server 2008 R2 Enterprise edition and enabling Business Intelligence
  • Extracting data from SAP using Business Explorer SAP BW 3.x using VB work book style, Script task C code converting into normal excel sheets then loading data by using Foreachloop Container
  • Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups. Designed OLAP cubes with star schema and multiple partitions using SSAS
  • Migration Sql Server 2000 DTS packages in to Sql Server 2005/2008 using Pragmatic works DTS X-Change tool
  • Designed complex SSIS packages with error handling as well as using various data transformations like conditional split, fuzzy look up, multi cast, column conversion, fuzzy grouping.
  • Worked with tabular, matrix, gauges chart reports, drill down reports as well as interactive reports according to business requirements.
  • Designed SSIS packages Slowly changing dimensions SCD using 3rd party i.e. CozyRoc LLC Table difference component for best performance to optimize data load of 1.5 million rows in 4 mins
  • Testing Data Quality among result sets using Pragmatic works tools i.e. BI Documenter
  • Knowledge in designing and developing data warehouses, data marts and business intelligence using multi-dimensional models such as star schemas and snow flake schema for developing cubes using MDX.
  • Deploying SSRS Reports in Share point 2010 integration environment, allow the business users to interact to those reports and implement securities for sensitive reports
  • Assessing project driving factors through AJILE sprint and scrum sessions with MIS ETL Team
  • Creating tickets for issues, maintaining promotion request with the help of Bug Net Issue tracking Project management 0.9.142.
  • Built MDX queries and data mining expression DMX queries for analysis services reporting services.

Environment: Microsoft SQL Server 2008/2008 R2 Enterprise edition SP3, BIDS, SSMS, Windows NT 6.0, Share Point 2010, Performance Point 2010, SAP 7.0, Crystal Reports 10, Team Foundation Server TFS 2008/2010, Business Objects XI 3.1, SAP Business Explorer SAP BW 3.x , Pragmatic works tools i.e. DTS X-Change, BI documenter, Task Factory, Bug Net Issue tracking Project management 0.9.142

Confidential

SQL Server BI/SSIS/SSRS/SSAS ETL Developer

Responsibilities

  • Worked with Business analyst, Data architect and business users to understand business processes, document project requirements and translate them into functional and non-functional specifications for BI reports and applications
  • Installation of Sql Server 2008 R2 Enterprise edition and enabling Business Intelligence SSIS/SSRS/SSAS
  • Conversion of Sql Server DTS 2000 to Sql Server SSIS 2008 Packages for Development, Testing, Production environments.
  • Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, lookups, aggregations, expressions, fuzzy look up, for each loop, multi cast, column conversion, fuzzy grouping, script components
  • Worked with tabular, matrix, gauges chart reports, drill down reports as well as interactive reports according to business requirements.
  • Developed SSIS Packages Customized C , VB logic in SSIS Script task, Script component to customize data formatting purpose
  • Assessing project driving factors through AJILE sprint/scrum sessions with MIS ETL Team
  • Creating promotion request plan documents, ETL standards templates to resolve issues for SSIS jobs
  • Designed and developed report with running value, interactive sorting as well as conditional formatting. Created sub-reports to present more detailed information about the summary.
  • Experience on created reports using stored procedure. Involved in scheduling, creating snapshot and subscription for the reports and triggers to facilitate consistent data entry into the database.
  • Created projected Front end, back end score card, best price financial reports for different metrics.
  • Solid knowledge in data warehouse and relational data modeling techniques using Erwin 7.1
  • Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups. Designed OLAP cubes with star schema and multiple partitions using SSAS
  • Migration Sql Server 2000 DTS packages in to Sql Server 2005/2008 using Pragmatic works DTS X-Change tool
  • Testing data quality among the result sets using Red gate tools i.e. Sql Data compare, Sql compare
  • Scheduled ETL packages using UC4 scheduling tool, which allows batch processing to be based upon event driven execution rather than time based execution, which allows for more efficient use of the designated batch-processing windows.

Environment: Microsoft SQL Server 2000/2005/2008/2008 R2 Enterprise edition SP3, BIDS, SSMS, Windows NT 6.0, Internet Information Server IIS , Red gate Inc tools i.e. Sql compare, Sql data compare , DB2/MVC, SAP 7.0, Pragmatic works DTS X-Change, Team Foundation Server TFS 2008/2010, UC4 Job Scheduler

Confidential

SQL Server BI/SSIS/SSRS/SSAS ETL Data Warehouse Developer

Responsibilities

  • Worked with Data architect and business users to understand business processes, document project requirements and translate them into functional specifications for BI reports and applications
  • Installation of Sql Server 2008 Standard edition and enabling SSIS/SSRS/SSAS on Analytical Development server
  • Installation, creation of users, Permissions, access and Security Control for various users, migration of all Production reports to Report Portal 3.0
  • Highly responsible for development and management of SSRS projects
  • Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
  • Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, fuzzy look up, for each loop, multi cast, column conversion, fuzzy grouping, script components
  • Designed and developed report with running value, interactive sorting as well as conditional formatting, Created sub-reports to present more detailed information about the summary.
  • Experience in creating reports using stored procedures. Involved in scheduling, creating snapshot and subscription for the reports and triggers to facilitate consistent data entry into the database.
  • Created SSRS report model projects in bi studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
  • Designed OLAP cubes with star schema and multiple partitions using SSAS
  • Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups

Environment: Microsoft SQL Server 2008 Standard edition, Windows server 2003, Internet Information Server IIS , MS Excel 2007, Report Portal 3.0, Visual source safe

Confidential

SQL Server BI/SSIS/SSRS/SSAS ETL Data Warehouse Developer

Responsibilities

  • Worked with project lead, analyst and business users to understand business processes, document project requirements and translate them into functional and non-functional specifications for BI reports and applications
  • Highly responsible for development and management of SSIS and SSRS projects
  • Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
  • Worked with Dunda's reporting for tabular reports, matrix reports, gauges chart reports, parameterized reports, sub reports, ad-hoc reports, drill down reports as well as interactive reports according to business requirements in time restricted environment using SQL server reporting services SSRS .
  • Experience on created reports using stored procedure. Involved in scheduling, creating snapshot and subscription for the reports.
  • Created projected income statements and other financial reports. Developed yearly, quarterly, monthly sales Reports, bench marking reports and commission reports
  • Created SSRS report model projects in bi studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
  • Created sub-reports to present more detailed information about the summary.
  • Developed stored procedures and triggers to facilitate consistent data entry into the database.
  • Created ad-hoc reports for unit team lead as requested and provide on-going analytical support for these requests.
  • Experience in Tuning SQL queries improving the performance of the Database.
  • Vast experience in creating maintenance plans, Jobs, Sending Alerts using SQL Mail.

Environment: Microsoft SQL Server 2008/2005 Enterprise edition, Oracle 10g, Teradata, Microsoft Visual studio, Windows server 2003, Internet Information Server IIS , MS Excel 2007

vices, MS Excel 2003/2007, MS Access 2003, Enterprise Manager, Management Studio, SQL Profiler and SSRS.

We'd love your feedback!