Geetha Devaraj Email & Phone Number

London, United Kingdom

Responsibilities:• Used Ralph Kimball’s data warehouse methodologies (Star schema, Snow Flake schema , Conformed Dimensions and Dimensional Modelling).• Designed SQL Database, tables, functions, views, stored procedures ,constraints and created Sql agent jobs for daily data refresh.Designed database ,schema,tables,functions,views and sequences using Postgresql.• More than100 Dashboards/Reports designed and delivered to client. • Migrated databases and data from Lexis Nexis to AWS.Created automation scripts to compare schema and xml's.• Created technical design documentation.• Involved in day to day activities like SQL job scheduling and Qlik Sense daily refresh.• Developed iHub dashboards and reports as per client requirement• Experienced in SSIS packages to load the data from different sources using control flow tasks such as like Bulk insert, Expression Task, File system task, FTP task, Script task, Send Mail Task, DB check integrity task, CDC, Maintenance and For/for each loop tasks.• Created various transformations like Data conversions, Lookup, OLEDB command, Derived columns, Sort, Merge, Aggregate, Fuzzy lookup, Conditional split and Execute SQL task.• Designed dimension tables and fact tables .• Experienced in Multi-dimensional Objects (Cubes, Dimensions) using (SSAS). Written MDX Query to retrieve data within a cube and also used calculated member within a cube.• Created Hierarchies in Dimensional Modelling, Created Time Dimensions on OLAP Cubes using SSAS.• Developed Qlik sense dashboards for business needs.• Designed charts and pivot tables, tables , pie charts, filters and KPI’s as per business needs.• Developed Power BI Reports for better visualization. Developed Console application and web application using C# to extract the XML's and load into database.

London, United Kingdom

• Developed Multi-dimensional Objects (Cubes, Dimensions) using (SSAS). Written MDX Query to retrieve data within a cube and also used calculated member within a cube.• Designed Dimensional modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling, Created Time Dimensions on OLAP Cubes using SSAS.• Developed SSIS packages using control flow tasks such as like Bulk insert, Expression Task, File system task, FTP task, Script task, Send Mail Task, DB check integrity task, CDC, Maintenance and For/for each loop tasks.• Created various transformations like Data conversions, Lookup, OLEDB command, Derived columns, Sort, Merge, Aggregate, Fuzzy lookup, Conditional split and Execute SQL task.• Developed SSIS package using Sequence container, For each container and For loop container.• Loaded Initial load, Incremental load and daily load using SQL Agent job.• Created SQL Agent jobs for Backup, Restore, Shrink Logs, Initial Load, Incremental Load and Financial load controller.• Implementation of Microsoft Visual C# and DOTNET in script component of SSIS.• Developed SSIS transformations & Event Handlers for Error handling and Debugging for the Packages• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Designer• Transformed data from one server to other servers using tools like (BCP) in (SSIS) (2005/2008).• Experience in creating configuration files to deploy the SSIS packages across all environments.• Experienced TSQL - Stored procedures / User defined functions / Views / Triggers and performance tuning.• Performance Monitor for monitoring and tuning SSIS package .• Developed complex financial reports using Sub Reports, Charts, Matrix reports, Linked reports.• Developed various operational Adhoc, Drill-through and Drill-down reports using SSRS• Developed Power BI reports for better visualization.• Designed POWER PIVOT Table and produced Reports for Business users.

Monument Station,London

• Designed and developed full-scale reporting solutions for a multi-client environment using MS SQL Server SSRS, SSIS & SSAS. Translating the requirements to technical specs and converting them to Reports & Packages.• Created, implemented and maintained a reporting suite of over 33 standard reports using SSRS and Developed complex reporting solutions ,Interactive graphs were built . • Developed various operational Adhoc, Drill-through and Drill-down reports using SSRS• Developed complex financial reports using Sub Reports, Charts, Matrix reports, Linked reports.• Created Dashboards for financial sector using benchmark data to provide an analytical snapshot of point in time• Assembled and converted user requirements from multiple clients into our standard reporting solution• Provided MS SSRS 2008 training to clients in order for them to develop their own ad-hoc reports• Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS• Developed Reports for business end users using Report Builder with updating Statistics, Used Subscriptions • Utilized T-SQL on a daily basis in creating customs view for data and business analysis• Assisted with documentation and code deployments from Development, QA and Production environments.• Developed SSIS packages using control flow tasks such as like Bulk insert, Expression Task, File system task, FTP task, Script task, DB check integrity task, CDC, Maintenance, For/for each loop tasks.• Created various transformations like Data conversions, Lookup, OLEDB command, Derived columns, Sort, Merge, Aggregate, Fuzzy lookup, Conditional split, SQL task, Send Mail task etc...• Implementation of Microsoft Visual C# and DOTNET in script component of SSIS.• Developed SSIS transformations & Event Handlers for Error handling and Debugging for the Packages• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Designer.

Bank Station,London

• Experienced to replace the Existing warehouse to Current warehouse. Based on the client requirements developed new ETL packages and deployed.• Handled Solvency II reporting solutions project. Designed ETL Packages for Solvency II and delivered Reports as per their requirement. • Developed SSIS packages using control flow tasks such as like Bulk insert, Expression Task, File system task, FTP task, Script task, Send Mail Task, DB check integrity task, CDC, Maintenance and For/for each loop tasks.• Created various transformations like Data conversions, Lookup, OLEDB command, Derived columns, Sort, Merge, Aggregate, Fuzzy lookup, Conditional split and Execute SQL task.• Developed SSIS package using Sequence container, For each container and For loop container.• Deployed the ETL packages to SSIS catalog and created SQL Agent job.• Loaded Initial load, Incremental load and daily load using SQL Agent job.• Created SQL Agent jobs for Backup, Restore, Shrink Logs, Initial Load, Incremental Load and Financial load controller.• Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS• Utilized T-SQL on a daily basis in creating customs view for data and business analysis• Assisted with documentation and code deployments from Development, QA and Production environments.• Implementation of Microsoft Visual C# and DOTNET in script component of SSIS.• Developed SSIS transformations & Event Handlers for Error handling and Debugging for the Packages• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Designer• Transformed data from one server to other servers using tools like (BCP) in (SSIS) (2005/2008).• Experience in creating configuration files to deploy the SSIS packages across all environments.• Experienced TSQL - Stored procedures / User defined functions / Views / Triggers and performance tuning.• Performance Monitor for monitoring and tuning SSIS package .

Canary Wharf, London

• Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS• Performed Performance tuning on their existing packages and created the new packages based on their requirement.• Performance Tuning Highlights: Extracted the data in parallel which will help to reduce the overall ETL execution time. Extracted the required data from table or file. Used synchronous transformations and avoided the asynchronous transformation components. Optimum use of event in event handler. Configured the component properties for parallel execution. Validated the metadata entry and set delay validation. To improve the ETL performance converted all the numeric columns into appropriate data type.• Developed SSIS packages using control flow tasks such as like Bulk insert, Expression Task, File system task, FTP task, Script task, DB check integrity task, CDC, Maintenance, For/for each loop tasks.• Created various transformations like Data conversions, Lookup, OLEDB command, Derived columns, Sort, Merge, Aggregate, Fuzzy lookup, Conditional split, SQL task, Send Mail task etc...• Used Sequence container and For each container to most of the packages.• Used Execute process task , Execute package task ,Execute sql task , Transfer sql server object task and Script task(C# code) to most of the packages.• Implementation of Microsoft Visual C# and DOTNET in script component of SSIS.• Developed SSIS transformations & Event Handlers for Error handling and Debugging for the Packages• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Designer• Transformed data from one server to other servers using tools like (BCP) in (SSIS) (2005/2008).• Experience in creating configuration files to deploy the SSIS packages across all environments.• Experienced TSQL - Stored procedures / User defined functions / Views / Triggers and performance tuning.

Rainham Essex

• Responsible for gathering requirements, understanding the business specs, preparing technical Specs, converting to SSIS Packages.• Using different transformations like excel source, data conversions, lookup, OLEDB command, derived columns, OLEDB destination, etc.• Developed various packages using AGGREGATE, MERGE JOIN, PIVOT, DERIVED COLUMN, DATA CONVERSION, LOOKUP, MERGE, SORT, MULTICAST, UNION, CONDITIONAL SPLIT, SCD (Slowly Changing Dimension).• Created Event Handlers to Handling Errors and Debugging for the Packages.• Creating jobs for scheduling the SSIS packages.• Generated reports using SSRS report builder/manager.• Developed standard and Ad-Hoc reports such as drill down, parameterized reports, Matrix report, Cascaded reports and dash boards.• Experienced in developing the cubes on the Analytical Server and connecting the cube objects with various cubes.• Experienced Stored procedures / User defined functions and performance tuning.• Performance Monitor for monitoring and tuning SSIS package and SSRS report performance. • Experienced in Data Cleansing.• Experienced in SQL server administrative tasks like Database Backup, Recovery, Log shipping, mirroring, Replication, User and Roles creation and maintenance.• Involved in bug fixing and enhancements.• Experienced in designing, maintaining & tuning various RDBMS such as SQL Server 2012/2008/2005/2000.• Performance Monitor for monitoring and tuning MS SQL Server performance.

River Bank House , London

• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.• Experienced Stored procedures / User defined functions and performance tuning.• Actively involved in development, deployment and maintenance of SSIS packages, SSRS reports and SSAS cubes.• Involved on data migration from legacy systems to new SQL database.• Using different transformations like excel source, data conversions, lookup, OLEDB command, derived columns, OLEDB destination, etc.• Created packages using the data flow transformations such as like UNPIVOT, PIVOT, DERIVED COLUMN, DATA CONVERSION, LOOKUP, MERGE, SORT, MULTICAST, UNION, CONDITIONAL SPLIT, SCD (Slowly Changing Dimension).• Created Event Handlers to Handling Errors and Debugging for the Packages.• Creating jobs for scheduling the SSIS packages.• Generated reports using SSRS report builder/manager.• Created tabular, matrix, drill down, drill through, parameterized, cascaded, Indicator, Gauge and Ad-hoc reports using SSRS.• Experienced in developing the cubes on the Analytical Server and connecting the cube objects with various cubes.• Performance Monitor for monitoring and tuning SSIS package and SSRS report performance. • Worked with various development teams to understand their issues/requirement and provide the fixes.• Involved in bug fixing and enhancements.• Extensively performed the data analysis using T-SQL, MS-Excel and MS-Access.

Master Of Computer Applications (Mca), Computer Science, A

Master Of Computer Applications (M.C.A.), Computer Science