Sindhu V

Sindhu V Email and Phone Number

Senior Manager Information Technology at Leonardo DRS Inc , Dallas , TX @ Texas, United States
Texas, United States
Sindhu V's Location
Dallas-Fort Worth Metroplex, United States, United States
About Sindhu V

• Over eight years of experience in analysis, design, development and implementation of software applications mainly in the field of Data warehousing and Database applications• Extensive experience 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• Strong knowledge of data integration concepts, data warehousing and Business Intelligence concepts• Exceptional background in database design, creation and maintenance• Experience in data configuration, performance tuning, troubleshooting and data transfer• Designing and developing ETL processes to enable initial loads and incremental processing, error and exception handling, restart ability and recovery, data cleansing, validation and monitoring • Experience in using SSIS to populate data by creating different SSIS packages for different data loading operations• Extensively used SSIS to transform data between MS SQL Servers and other legacy systems.• Hands on experience with developing, deploying and monitoring SSIS Packages including upgrading DTS to SSIS.• Complete understanding of logical and physical database design and strong knowledge of relational database management systems, dimensional data models, star schema and snowflake schema• Developed different types of Tabular Reports, Matrix Reports (Cross Tab or Pivot), Chart and Graphs, Reports that aggregate data, Reports containing parameters and group, Reports containing Totals and Subtotals, Drill-down reports and ad-hoc reports using SQL Server 2000/2005 Reporting Services. • Hands on experience with MS-SQL Server and T-SQL in constructing tables, stored procedures triggers, user defined functions, optimized indexes, views, user profiles, data integrity, and data dictionaries• Solid experience and outstanding knowledge of high availability SQL Server solutions

Sindhu V's Current Company Details
DRS Technologies Inc , Dallas , TX

Drs Technologies Inc , Dallas , Tx

Senior Manager Information Technology at Leonardo DRS Inc , Dallas , TX
Texas, United States
Sindhu V Work Experience Details
  • Drs Technologies Inc , Dallas , Tx
    Drs Technologies Inc , Dallas , Tx
    Texas, United States
  • Drs Technologies Inc , Dallas , Tx
    Microsoft Bi (Ssis/Ssrs/Ssas) Developer
    Drs Technologies Inc , Dallas , Tx Sep 2012 - Present
    • Worked with the business users to understand their requirements analyzed the requirements to design and assist SSIS Integrations projects with multiple sources (Excel, txt, CSV, OLEDB) generate reports according to the requirements using SQL Server Reporting Services.• Designed E/R diagrams, Schema and database tables in SQL Server 2008.• Maintain and optimize the existing databases, monitor database performance and growth, performance tuning including updating statistics and rebuilding and reorganizing indexes.• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, and CSV files to datawarehouse.• Involved in configuring, deploying and scheduling SSIS packages across different environments. Developed SQL Server configurations for the SSIS packages.• Effectively use checkpoints and buffer size properties to improve package performance and implement package securities.• Design and Build reliable SSIS packages with detailed error handling and notification techniques to maintain integrity and notify responsible parties in the event of an error.• Developed and designed Operational reports, Financial Reports, Yield Reports, Flow Management Reports, Performance Reports using complex stored procedures, functional and views using Microsoft BI products for users within various areas of the organization.• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.• Build the data driven subscription for reports
  • Cb Richard Ellis Inc , Dallas , Tx
    .Net/ Sql Server Bi (Ssis/Ssrs/Ssas) Developer
    Cb Richard Ellis Inc , Dallas , Tx Nov 2011 - Aug 2012
    • Gathered and analyzed business requirements to design staging database and dimensional model for data warehouse.• Actively participated in team meetings to make decision on structure of staging and data warehouse and design of ETL process.• Created database projects for staging database and data warehouse in visual studio 2008, to store all related objects at one centralized location.• Designed the E/R diagram, schema and was involved in creation of several database objects such as Tables, Functions, Stored Procedures, UDF's, Indexes and Views in SQL Server 2008.• Designed 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.• Created complex ETL (SSIS) packages to pull financial data, lease management data, Transaction management date and work orders data from various sources such as JDE, ServiceInsight, Harborflex(Flat files, excel, CSVs) and load it into the Data Warehouse using ExecuteSQL Task, bulk insert task, data flow task, file system task, send mail task, and script task SSIS.• Built efficient SSIS packages for processing dimension and fact tables with complex transformations to accommodate Type I, II and III SCDs using Merge..
  • Health Texas Provider Network, Dallas, Tx
    Database Analyst/Sql Server Bi (Ssis/Ssrs/Ssas) Developer
    Health Texas Provider Network, Dallas, Tx Feb 2011 - Aug 2011
    • Work with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options.• Responsible for the management of an internal ticketing system. This involved resolving a wide range of issues from reporting to fixing bugs within databases.• Used Red Gate SQL Data Compare to quickly fix problems by restoring missing or damaged data to a single row, to keep an accurate history of all previous database records, to compare and synchronize data within SSMS.• Involved in conversion of existing projects from Mainframe to SQL Server using SSIS• Actively participated in developing logical design of database incorporating business logic and user requirements• Excellent back end skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes (clustered & non clustered), and Triggers• Conducted performance tuning on regular basis to improve performance of slow running queries and stored procedures• Designed and developed SSIS packages to load data into SQL database and archive files• Proficient in implementing all transformations available on the SSIS toolbox including Derived Columns, Pivot, Unpivot, Sort, Condition Split, Aggregate, Execute SQL Task, Execute Package Task, Script task and Script Component etc • Proficient in upgrading from DTS to SSIS packages, Logging, SQL Mail, Custom Control Flow, Auditing, Variables Deploying and Error Handling in SSIS• Used multiple transformations and integrations in SSIS to meet the business requirements by collecting data from heterogeneous sources like Excel, CSV, flat file, Text Format Data
  • Fujitsu Inc, Dallas, Tx
    Data Analyst/Sql Server Developer
    Fujitsu Inc, Dallas, Tx Jan 2009 - Dec 2010
    Responsibilities• Involved in translating the business requirements into technical specifications and source to target mapping documents• Developed and optimized database structures, stored procedures, SSIS packages and SSRS reports• Designed and coded the ETL process for data validation, data cleansing, reconciliation, restart ability, monitoring and error/exception handling.• Designed and developed SSIS packages to enable initial history data loads and incremental processing• Developed SSIS packages to validate the source files and ftp those files for further processing• Used SSIS to transform data extensively between SQL Server and other source systems.• Used various transformations like Sort, Multicast, Union All, Script Component, Conditional Split, Lookup, Merge Join, OLE DB Command and Aggregate to transform data.• Created and expanded SSIS packages based on specifications driven by changing business requirements• Developed different types of Tabular Reports, Matrix Reports (Cross Tab or Pivot), Chart and Graphs• Created reports using Global Variables, Expressions and Functions and report subscriptions using file share and email• Developed Drill-down reports, reports that aggregate data and ad-hoc reports using SQL Server 2005 Reporting Services. • Designed, created and distribute reports in multiple formats such as Excel, PDF, XML, HTML, TIFF and CSV using SQL Server 2005 Reporting Services.• Configured and deployed different reports in the Servers using SQL Server Reporting Services.• Managed different Reports using Browser-Based Report Manager and SQL Server Management Studio (SSMS) Based Report Manager.Environment: SQL Server 2005, SSIS, SSRS, Windows Enterprise Server 2003, Visual Studio 2005, VB.Net, ASP.Net
  • Tween Brands Inc, New Albany, Ohio
    Data Analyst/Sql Server Bi (Ssis/Ssrs/Ssas) Developer
    Tween Brands Inc, New Albany, Ohio Jun 2007 - Dec 2008
    Responsibilities• Gathered functional requirements and business requirements and written the technical specifications for building the EDW.• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler.• Converting SQL Server 2000 DTS packages to SQL Server 2005 SSIS packages.• Modifying the entire ETL process to accept new format flat files.• Designed and coded the ETL process for data validation, data cleansing, reconciliation, restart ability, monitoring and error/exception handling.• Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.• Used SSIS to transform data extensively between SQL Server and other source systems.• Monitored the existing SSIS jobs in production and fix any related issues.• Created and Designed a Multi Dimensional Analysis using SQL Server 2005 Analysis Services.• Created and Configured Cubes, Dimensions, Measures, MDX Queries, Data Source and Data Source Views using SQL Server 2005 Analysis Services.• Created logical and physical database design, data structures, and implemented databases.• Developed and optimized database structures and user-defined functions.• Developed trigger and stored procedures and enforced business rules via checks and constraints.• Troubleshoot and fix issues in existing cubes.• Monitor and Optimize cube performance to improve response time as needed.• Developed different types of Reports (Tabular, Matrix (Cross Tab or Pivot)) along with Chart and Graphs.Environment: SQL Server 2005, Windows Server 2003, Visual Studio 2005, VB.Net, ASP.Net
  • Hcl Technologies
    Sql Server Bi/Ssis/Ssrs/Ssas Etl Data Warehouse Developer
    Hcl Technologies Jan 2005 - Jun 2007
    Responsibilities• Developed and optimized database structures, stored procedures, views, triggers and user-defined functions• Developed, modified, and optimized complex queries to data retrieval and modification.• Involved in performance measurement and performance tuning for new databases and existing databases using SQL Analyzer and SQL Enterprise Manager.• Scheduled and monitored all maintenance activities of SQL Server 2000 including database consistency check, and index defragmentation.• Designed and developed DTS Packages to transfer data between servers, load data into database and archived data file from different DBMS.• Worked on improving the performance of DTS packages by using various performance techniques.• Used SQL Profiler for troubleshooting, monitoring, tuning of SQL Server and SQL code.• Managed the integration of data and monitored exceptions of highlight data from customers.• Monitored all databases status including CPU, memory, I/O, space Management, block, and dead lock.• Managed MS SQL Server (storage, memory, processing) and their dependencies/ performance bottlenecks.Environment: SQL Server 2000, Windows Enterprise Server 2003, C#, .NET, Rational Rose Enterprise, Erwin, Microsoft Visio 2000

Sindhu V Education Details

  • University Of Mumbai
    University Of Mumbai
    Commerce

Frequently Asked Questions about Sindhu V

What company does Sindhu V work for?

Sindhu V works for Drs Technologies Inc , Dallas , Tx

What is Sindhu V's role at the current company?

Sindhu V's current role is Senior Manager Information Technology at Leonardo DRS Inc , Dallas , TX.

What schools did Sindhu V attend?

Sindhu V attended University Of Mumbai.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.