We provide IT Staff Augmentation Services!

Sql Server Bi \ Ssis (etl) \ Ssrs \ Ssas Developer Resume

SUMMARY

  • 10+ years of IT experience in Data analysis, design, implementation and administration of BI solutions with Microsoft SQL server 2012/2008R 2/2008/2005/2000 in development, testing & production environments.
  • Extensive experience in BI suite using integration services (SSIS) for ETL (Extraction, Transformation & Loading), reporting services (SSRS) for creating different types of reports and analysis services (SSAS) for design and developing complex cubes
  • Proficient in using QlikView EXPRESSOR 2.3.1\3.6.0\3.10 Enterprise data integration ETL tool
  • Well versed with the knowledge of RDBMS, data warehouse i.e. OLTP & OLAP systems.
  • Expertise in creating Indexes( clustered, Non - clustered Views, indexed views, complex stored procedures, User defined functions, Common Table Expressions (CTE’s) 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 roles, authentication and 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
  • As a SSIS ETL Developer I have implemented SSIS Business Intelligence Life cycle such as SSIS packages Configurations (XML Configuration, SQL Server, Environment variable, Parent Package Variable), Deployment, Scheduling packages in Development, Test, Production environments
  • Experience in extraction, transformation and loading (ETL) of data flows using SSIS with complex integration of SQL Server tables, oracle, flat files, excel files, comma separated files (.CSV) sources, MS access files, MySQL 5.0 and IBM mainframe DB2 tables
  • Expert in writing T-SQL, working with DTS (Data transformation services) data cleansing, data scrubbing and data migration
  • 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
  • Hands on experience in writing SSIS script/script component task using C#, VB script for customized data manipulation of complex SSIS packages
  • Used Processing options like Process update, Process full, Process data in while creating SSIS package using Analysis services execute task
  • Created slowly changing dimensions (SCD) . Created various dimensions, Fact tables by understanding business requirement, managed SSIS data loads to Data marts on daily basis (delta loads)
  • 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
  • Installation of Pentaho Kettle EDI 5.1.0/5.1.1/5.1.2 Spoon Created Pentaho transformations. ktr files as per business requirements, then created. kjb jobs, Data load checks
  • Get File Name, Get row count, Get file name from result. Operators like Select values, Text input, Text output, Stream Look-up, Merge join, Filter, Modified Java script Value, Dummy (Do nothing) If Field value is null, Add constants, Calculator, Put a file with FTP, Start, Success, Simple Evaluation, SQL Script, Join Rows (Cartesian Product), Process result filenames from result, Email Notification
  • I have designed Pentaho ETL packages using dynamic variables, the purpose of these variable s was to migrate the packages form Dev to Test and Test to Prod without any changes
  • Designed/Developed/Configured/Deployment/Scheduling packages more than 150 packages to Dynamically passing multiple values in a for Variables in Pentaho ETL packages
  • Comparison of Data from SSIS Package to Converted Pentaho Kettle ETL Package by creating Specification documents, Step by Step approach for Qualitative (Using V-LookUp, Exact Match in Excel) test, Quantitative (Row counts operators) test, Performance test
  • Writing Test cases depending up on Data loads requirements such as Full Loads / Change Loads, Cumulative points / Change points)
  • Installation of QlikView EXPRESSOR 2.3 i.e. Illustrator, constructor, Processor, Repository on Development and production server
  • Installation of MySQL 5.5 database, Toad 4.6 for MySQL on Client terminals
  • Installation of Tortoise SVN 1.6.12 Subversion control on development and production servers
  • Installation of Perforce (P4V) Visual client /NTX 86/ 2012.2/527787 on development servers
  • Migration of QlikView Expressor 2.3 projects to Production servers
  • Administered QlikView Expressor 2.3 and Created users and assigned projects to QlikView Expressor 2.3 users
  • Accessed QlikView Expressor 2.3 production packages to Development server to keep sync between production and development up to date to maintain integrity
  • Migration of Production databases empty schema to development server as part of set up Development, Testing environment
  • Migration of QlikView Expressor 2.3 development projects to Production servers and from there moved to Rack Space on Cloud
  • Developed Lua scripts for production jobs, Ran Lua scripts using Lua escript, etask commands
  • Created vdx, Idx xml files, in-sql Idx xml files as per business requirement for QlikView Expressor 2.3 packages
  • Created drawing with Lookup, In-table, In-sql, transform, filter, collate, sort, decrypt, encrypt, out file, out-table, copy, joiner, generate record components
  • Wrote test cases for data quality check on development results data based on data analysis (qualitative, quantitative), Performance, to meet client requirement
  • Developed Lua files to execute the job, configuration, deployment of QlikView EXPRESSOR 2.3 packages, posting files from production server to FTP site outbound folder through automated process
  • Created success, failure email notification XML files, to keep inform stake holders, client account managers, third party vendors for their concerned clients
  • Created scheduler XML files, Scheduled jobs in SOS job scheduler
  • As SSRS Developer I have Created & formatted cross-tab, conditional, drill-down, drill through, top n, summary, form, sub reports, parameterized reports, interactive reports & custom reports
  • Created Ad hoc reports using Report builder 2.0/3.0 in SQL SERVER 2005/2008/2008 R2
  • Experience in providing SSRS server level, item level securities & accessibility to various reports in multi-user environment.
  • Implemented SSRS roles (Browser, Content Manager, System Administrator, My Reports, Publisher) for various Business reports in a multi-user environment
  • Expert in creating dashboards, scorecards and building reports using Report Portal 3.0, 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, source controls, problem solving skills and escalation procedures.
  • Performed backup/restore of database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
  • As a Developer I have implemented SSRS Business Intelligence Life cycle such as Configuration of Report Server Configuration, Deployment of reports, creating report subscription (Data Driven) in Development, Test, Production environments
  • Responsible for automation of maintenance jobs, SSRS subscriptions (Data Driven, Normal subscriptions), locks and index configurations.
  • Administering SQL Server securities, SQL Server automatic e-mail notification.
  • Managed SQL user logins, database user accounts, server roles, database roles, handled dead locks
  • Regularly monitored the system for bottlenecks (CPU, RAM, Disk I/O and Networking).
  • Excellent communication, analytical skills, self-learning abilities and leadership quality.
  • Installed Jasper server 4.7 server, iReport 4.7, administration of Jasper reports such as creating users, roles, assigning roles for users as per organization hierarchy
  • Developed many types of reports using iReport 4.0/4.5/4.7 studio
  • Developed many customized charts, color formatting by developing customized .jar class files
  • Deployed Jasper reports. jrxml file to Test and Production Server Jasper servers
  • Implemented roles such as Developer Role, Role Administration, Role Anonymous, Role Manager, Role Operators and securities as per Business user requirements (BRD)
  • Developing Jasper reports as per Business requirement document (BRD), Functional requirement document (FRD), and performing qualitative, quantitative test, performance tests
  • Deployment of Jasper reports as per reports as per Business requirement document (BRD), Functional requirement document (FRD), check for user accessibility.
  • Strong understanding and experience of designing dimensional models like Star Schema and Snowflake schema.
  • Expertise in Conceptual Data Modelling, Enterprise Data Modelling, Logical Data Modelling, Physical Data Modelling, Enterprise Data Warehouse Design, Data mart Design, Data Quality.
  • Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization, Data Modeling, Creating ER Diagrams using tools such as MS Visio.
  • Involved to planning and designing Cubes and building attribute relationships for optimal performance of Hierarchies and Fact Dimensions.
  • Strong experience in SQL Server 2005/2008/2008 R2/2012 with Business Intelligence in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).
  • Expertise in Database Design, Development for OLTP (Batch Processing, Online Processing), OLAP, ODS, ETL and Data Modeling.
  • Expertise in Configuring and managing data sources, data source views, cubes, dimensions, creating hierarchies
  • 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.

TECHNICAL SKILLS

DBMS/RDBMS: MS-SQL Server 2012/2008R2/2005/2000, MySQL 5.5, Oracle 10G/9i/8.0, SQL Loader, MS Access, DB2/MVC, SAP 7.0, Teradata, Vertica

ETL Tools: SQL Server Integration Services (SSIS), SQL Server Import/Export wizard, Data Transformation Services (DTS), Pentaho 5.0/5.1.1/5.1.2 , QlikView EXPRESSOR 2.3/9/10

Report Tools: SQL Server Reporting Services (SSRS), Jasper Server 4.5/4.7/5.0, Microsoft Dynamics (AX)

Data Modelling: Erwin, SQL Server Analysis Services (SSAS)

Languages: T-SQL, PL/SQL, C, C#, VB scripts, Java Scripts, .Net

Operating System’s: Windows server 2012/2008/2003/ XP/NT 6.0/98/Vista, Windows 7/8, RHEL 4.0/5.0

Query Tools: Toad 4.6,SQL Server Management Studio (SSMS)

Job Scheduler Tools: SQL SERVER Agent, UC4 Job Scheduler, SOS Job Scheduler

Office Tools: MS Word, PowerPoint, Excel, Visio, MS One note

Domain Expertise: Wealth Management Financial services, Preventive Care / Performance based Health Management, Publishing, Medical devices Manufacturing, Healthcare Supply Chain Data Management Systems (HSCDM), E-Insurance, Healthcare

Source Control: Team foundation server 2010 (TFS), Visual Source Safe 2005 (VSS), Tortoise SVN 1.6.12, Perforce (P4V) Visual client /NTX86/ 2012.2/527787

PROFESSIONAL EXPERIENCE

Confidential

SQL Server BI \ SSIS (ETL) \ SSRS \ SSAS Developer

Responsibilities:

  • As a Lead BI Developer I have worked with 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
  • 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 Dundas’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.
  • Developed Business requirement (BRD), Functional requirement (FRD) documents, keep track of changes in BRD, FRD documents. Installation of Pervasive ETL data integrator 9.2
  • Installation of Sql Server 2014/2012/2008 R2 enterprise edition and enabling SSIS/SSRS/SSAS on Client machines, Development, Test & Production servers.
  • Designed complex SSIS packages with error handling as well as using various data transformations like conditional split, fuzzy look up, multi cast, data conversion, derived columns, Merge join, row counts, Oledb source, Oledb destination, Excel source, Oledb Command
  • Highly responsible for development and management of SSRS projects like creating drill through reports through Linked reports. Worked with tabular, matrix, gauges, Maps for Sales by region & chart reports, drill down reports as well as interactive reports according to business requirements.
  • Integrating data into/from different resources into Athena Databases systems for Insurance Claims and Claimants, Census, Biometric information
  • Generating reports from Athena Database resources using SSRS adhoc reporting features
  • Expertise in creating Indexes (clustered, Non-clustered Views, indexed views, complex stored procedures, User defined functions, Common Table Expressions (CTE’s) 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 roles, authentication and authorizations and database creation.
  • Performed Data dumps using MySQL Data dumps commands to create Development, Test, Production environments for newly initiated projects
  • Created SSRS inventory management reports, focused on findings to save company millions of dollars in Client members Performance Health management by providing Incentive, Claims, Biometrics file feeds. Identified high risk, Low risk, and Moderate risk members using SSRS dashboards. Created databases to track project management to help with managing contractor's projects, hours and billing. Created SSAS Cubes for analysis. Also created numerous SSRS reports to implement on the web for various business groups.
  • Created slowly changing dimensions (SCD). Created various dimensions, Fact tables by understanding business requirement, managed SSIS data loads to Data marts on daily basis (delta loads)
  • Hands on experience in writing SSIS script/script component task using C#, VB script for customized data manipulation of complex SSIS packages
  • As a Developer I have implemented SSIS Business Intelligence Life cycle such as SSIS packages Configurations (XML Configuration, SQL Server, Environment variable, Parent Package Variable), Deployment, Scheduling packages in Development, Test, Production environments
  • Created hierarchies and attributes as part of dimensional modelling.
  • Hands on experience in partition cubes as per business requirement to implement data integrity and securities among different groups of users
  • As a Developer I have implemented SSRS Business Intelligence Life cycle such as Configuration of Report server Configuration, Deployment of reports, creating report subscription ( Data Driven ) in Development, Test, Production environments

Environment: Windows server 2008/2010, MS Excel 2013/2016, Visual Studio 2013/2015, Power BI (Power query, Power Pivot), Power BI Dashboard, MS VISIO 2007, JIRA 5.1.6 Issue tracking and Project management module, Help desk software, Tortoise SVN 1.6.12, SVN Ankh, Notepad ++ v6.2, SQL Server BI Data tools, SQL Server 2014/2012/2008 R2 SSIS (ETL)/SSRS/SSAS Enterprise edition, Microsoft Dynamics (AX), JAMS Enterprise Job Scheduler

Confidential

SQL Server BI \SSIS (ETL) \ SSRS \ SSAS Developer

Responsibilities:

  • Developed Business requirement (BRD), Functional requirement (FRD) documents, keep track of changes in BRD, FRD documents. Installation of Pervasive ETL data integrator 9.2
  • Installation of Sql Server 2012/2008 R2/2005 enterprise edition and enabling SSIS/SSRS/SSAS on Client machines, Development, Test & Production servers.
  • Designed complex SSIS packages with error handling as well as using various data transformations like conditional split, fuzzy look up, multi cast, data conversion, derived columns, Merge join, row counts, Oledb source, Oledb destination, Excel source, Oledb Command
  • Highly responsible for development and management of SSRS projects like creating drill through reports through Linked reports. Worked with tabular, matrix, gauges, Maps for Sales by region & chart reports, drill down reports as well as interactive reports according to business requirements.
  • Integrating data into/from different resources into Athena Databases systems for Insurance Claims and Claimants, Census, Biometric information
  • Generating reports from Athena Database resources using SSRS adhoc reporting features
  • Expertise in creating Indexes (clustered, Non-clustered Views, indexed views, complex stored procedures, User defined functions, Common Table Expressions (CTE’s) 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 roles, authentication and authorizations and database creation.
  • Performed Data dumps using MySQL Data dumps commands to create Development, Test, Production environments for newly initiated projects
  • Created SSRS inventory management reports, focused on findings to save company millions of dollars in Client members Performance Health management by providing Incentive, Claims, Biometrics file feeds. Identified high risk, Low risk, and Moderate risk members using SSRS dashboards. Created databases to track project management to help with managing contractor's projects, hours and billing. Created SSAS Cubes for analysis. Also created numerous SSRS reports to implement on the web for various business groups.
  • Created slowly changing dimensions (SCD). Created various dimensions, Fact tables by understanding business requirement, managed SSIS data loads to Data marts on daily basis (delta loads)
  • Hands on experience in writing SSIS script/script component task using C#, VB script for customized data manipulation of complex SSIS packages
  • As a Developer I have implemented SSIS Business Intelligence Life cycle such as SSIS packages Configurations (XML Configuration, SQL Server, Environment variable, Parent Package Variable), Deployment, Scheduling packages in Development, Test, Production environments
  • Created hierarchies and attributes as part of dimensional modelling.
  • Hands on experience in partition cubes as per business requirement to implement data integrity and securities among different groups of users
  • As a Developer I have implemented SSRS Business Intelligence Life cycle such as Configuration of Report server Configuration, Deployment of reports, creating report subscription ( Data Driven ) in Development, Test, Production environments

Environment: Vertica Database, MySQL 5.5, QlikView EXPRESSOR 2.3\3.6\3.10 ETL data Integrator, Pervasive ETL data Integrator 9.2, Pentaho Kettle EDI 5.1.0/5.1.1/5.1.2 , Windows server 2008, Jasper server 4.0/4.5/4.7 server, iReport 4.7.1, Windows 7, MS Excel 2010, Perforce (P4V) Visual Client /NTX86/ 2012.2/527787 , MS VISIO 2007, JIRA 5.1.6 Issue tracking and Project management system, Help desk software, Tortoise SVN 1.6.12, Notepad ++ v6.2, Toad 4.6 for MySql, Jasper reports 4.0/4.5/4.7, SQL Server 2012/2008 R2 SSIS/SSRS/SSAS Enterprise edition, Microsoft Dynamics (AX)

Confidential

SQL Server BI \ SSIS (ETL)\ SSRS \ SSAS 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 Enterprise 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 Cubes using MDX
  • 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, Fogbugz

Hire Now