Post a Job Sign in

Seema M

SQL BI Developer

San Diego, CA

-

Work Experience

SQL Server BI Developer

XXXX
-
Louisville, KY
-

February 2012 to July 2013

Seema  
MS SQL BI Developer 
Ph: 205-538-2350  
Email: sql12127@gmail.com 
PROFESSIONAL SUMMARY 
Over 7+ years of IT Experience in Database Design, Development and Business Intelligence of Microsoft SQL Server 2000/2005/2008R2/2012 in Development, Test and Production Environments on various business domains like Healthcare, Banking and Insurance. 
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008 R2/2012. 
• Expert in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration. 
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment. 
• Created SQL Server reports using SQL Server Reporting Services (SSRS). 
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008R2). 
• Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert, BCP, Data Replication and DTS Packages. 
• Experience in logical, physical, and dimensional data modeling, data mapping, and data normalization, well verse in ERWIN. 
• Experience in OLAP, ODS, Snowflake schema, Star schema, ETL, MDX, Data mining, DBMS and Data Modeling. 
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008 
• Expertise in ETL tools like SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Insert, and BCP for OLTP and DSS (Data Mart/Data Warehouse) environment. 
• Created simple Reports using SSRS, ProClarity. 
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008R2. 
• Experience with SQL Admin activities such as Installation, Configuration, maintenance, support, backup, recovery, Log Shipping, Performance Tuning of SQL Server 
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2008 
• Worked on ProClarity to create OLAP data sets and queries are created directly from the Unified Dimensional Model. 
• Experience with Adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects 
• Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations. 
• Strong experience in writing stored procedures, functions, triggers in MS T-SQL building the packages, testing and implementing on production servers. 
• Created several Dashboards and Scorecards with Key Performance Indicators (KPIs) in SQL Server 2005 Analysis Services (SSAS) using ProClarity and published via Windows SharePoint Services. 
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS 
• Experience in ProClarity’s powerful visualization tools, including the Decomposition Tree, Perspective View and Performance Map, to drill down, cross drill, pivot, chart, and investigate data. 
 
EDUCATIONAL QUALIFICATION 
 
• Bachelor’s degree, Electronics and Communications, India. 
 
TECHNICAL SKILLS  
Databases SQL server 2000/2005/2008 R2/2012, MS Access  
Operating Systems DOS, Linux, Windows 2000/XP/Vista/7 
OLAP/Reporting Tools SSAS, (SSRS), MDX, Crystal Reports.  
ETL Tools SQL Server Integration Services (SSIS), SQL Server DTS, ETL Informatica. 
Other Tools Microsoft Visual Source Safe, Microsoft Office, MS Visio. 
Data Modeling Tools Microsoft Visio 2000/2003, Erwin, LiquidXML, JDBC, Dreamweaver, Macro Express, 
SQL Server Tools SQL server Management Studio, SQL server Query Analyzer, SQL server mail service , DBCC, BCP , SQL server profiler 
Programming languages C,SQL,PL/SQL,T-SQL,.NET,C#, C++, Java, Pascal, COBOL, Unix, Assembly( 8085,8086 ) 
Data Warehousing & BI SQL Server, Business Intelligence Studio, SSIS, SSAS, Access Manager, SQL Server 2008 Analysis Services and SQL Reporting services, DTS, ProClarity, PPS-2007, MOSSf 
 
PROJECT EXPERINCE  
XXXX, Louisville KY Feb 12 to till date 
SQL BI Developer/ SSIS/SSRS/SSAS Developer 
 
XXXX is an American managed health care company that markets and administers health insurance. With over 11.1 million customers in the United States, the company is the largest (by revenues) Fortune100 company headquartered in the Commonwealth of Kentucky 
 
Responsibilities: 
• Designed the business requirement collection approach based on the project scope and SDLC Methodology 
• Involved in installing and configuring SSRS 2008R2/2012. 
• Responsible for monitoring and tuning SSRS Report Performance.  
• Created User defined functions and stored procedures to meet the requirement. 
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports. 
• Deployed the SSIS Packages and created jobs for efficient running of the packages. 
• Involved in performance tuning and monitoring of T-SQL blocks. 
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity. 
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages 
• Identified and defined the Datasets for the report generation. 
• Migrated Crystal reports to SSRS 2008R2.  
• Designed, developed and deployed reports in MS SQL server environment using SSRS 2008R2. 
• Generated Sub-reports, Drill-Down, Drill - Through and Parameterized reports using SSRS 2008R2. 
• Generated Reports using Global Variables, Expressions and Functions for the reports. 
• Created ad-hoc reports with incorporated filters, sorting etc and presented them at the client side to note the changes they may need. 
• Created several SSIS packages for performing ETL operations to transform data from OLTP to OLAP systems. 
• Created several SSIS packages for performing ETL operations to transform data from a cube using MDX. 
• Involved in using Informatica transformations for loading data from source to destination.  
• Identified all the existing aggregations & calculations in the existing system using all the MDX queries used in the current system 
• Deployed reports on to the report manager and organized them in folders. 
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services. 
• Created standard Reports and Cross Tab Reports, Drill Down and Drill Through reports from data sources like SQL Server 2008 and IBM DB2. 
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).  
• Created UDM for CUBES in SSAS. 
• Generated pivot tables using the cube data in SSAS and delivered reports using SSRS by using the connection string as SSAS. 
• Experienced in developing and deploying SSAS cube. 
• Designed CUBES with Star Schema using SQL Server Analysis Services 2010 (SSAS). 
• Created complex Stored Procedures, triggers, functions, Indexes, Tables, Views and SQL joins for applications. 
• Developed reports from OLAP CUBES using ProClarity and SSRS. 
• Developed data interface layer using ASP.NET and C# for data access. 
• Involved in writing Query for generating drill down reports, identified and worked with the parameters to generate parameterized reports along with that extensively used global variables, expressions and functions. 
 
Environment: SQL Server Business Intelligence Development Studio 2005/2008R2/2012, T-SQL, Microsoft Visual Studio 2005, SQL Server Management Studio 2008, IBM DB2, C#, ASP.NET, Informatica, SQL Server SSAS/SSRS/SSIS, ETL, Aqua data 9.0, XML ,MS Excel. 
 
XXXX, OH Nov 10 to Jan 12 
SQL BI Developer 
 
Stucky Application software is being used by the Structured Finance Group of XXXX, in both Chicago and Cincinnati. Stucky’s Application is to track Commercial collateral on Asset Based Lending loans, monitor their Borrowing Based of Aging, Receivables and Inventory. William Stucky & Associates provided 2 software applications to the bank; Stuckynet & Stucky NTABL. Both systems have been used by the bank for over 5 years. 
 
Responsibilities: 
• Installed and Configured SQL Server 2008 enterprise edition per client request. 
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions in SQL Server.  
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008. 
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008R2. 
• Experience in creating SSIS packages using Active X scripts and with Error Handling. 
• Experience in enhancing and deploying the SSIS Packages from development server to production server. 
• Experience in using different transformations like fuzzy lookup, derived column transformations etc in SSIS packages. 
• Created SQL Server Integration Services (SSIS) packages to import data from heterogeneous data sources like Oracle 9i, SQL Server Text files (CSV, Xls, and XML). 
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers. 
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers 
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS 
• Developed Query for generating drill down reports in SSRS 2008.Prepared AD HOC reports through report builders. 
• Created shared dimension tables, measures, hierarchies, levels, CUBES and aggregations on MS OLAP/ Analysis Server (SSAS). 
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer. 
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube. 
• Experience in Creation and deployment of CUBES on SSAS. 
• Worked on ProClarity for creating, analyzing and deploying Reports.  
• Excellent knowledge in creating reports using SSRS. 
• Involved in creating different kinds of reports like tabular reports, matrix reports, sub-reports, drill down reports etc and deployed them to the report manager using SSRS. 
• Successfully deployed reports in various sources like XML, Web browser and PDF 
• Experience in integrating SharePoint Server with SSRS and deploying SSRS reports on to SharePoint Server. 
• Used Informatica for ETL process. 
• Involved in the design, development and implementation of web user interfaces using C#. NET, ASP.NET 
• Written a UNIX script for Central America Project to create the report for the database source. 
• Used ProClarity for analysis services in some cases. 
• Done performance tuning to optimize the run time. 
• Changed stored procedures according to the new hirearcy. 
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing and shrinking of databases and regular monitoring. 
• Created .net scripts to load data into Informix tables.  
• Configure backup/recovery strategy per client request. Full Backup database on specific time, transaction log backup using different check point per client request.  
• Involved on ProClarity’s powerful visualization tools, including the Decomposition Tree, Perspective View and Performance Map, to drill down, cross drill, pivot, chart, and investigate data. 
 
Environment: MS SQL Server 2008R2/2005, SQL SSAS,SSRS,SSIS,OLAP, MDX, T-SQL, SharePoint, Informatica, ETL, Windows 2000 Server, Windows NT Server, TSQL, ASP.NET, C#, ProClarity, XML, MS Visual Studio. NET, Unix, Informix. 
 
XXXX, NJ Aug 09 to Oct 10  
SQL BI Developer (SSAS/SSIS)  
 
XXXX is a leading international insurance organization serving customers in more than 130 countries. XXXX companies serve commercial, institutional, and individual customers through one of the most extensive worldwide property-casualty networks of any insurer. 
 
Responsibilities: 
• Involved in requirements gathering and dimensional modeling.  
• Worked on the file import framework process for the various flat files structures to get data imported into our database. 
• Provided support to off shore development team to simplify business requirements to queries for optimal performance.  
• Responsible for the data and metadata management and Business Intelligence (BI) solutions using Microsoft SQL Server 2008 Integration Services (SSIS), SQL Server Reporting Service (SSRS), and SQL Server Analysis Service (SSAS).  
• Designed CUBES with Star Schema using SQL Server Analysis Services 2008 (SSAS). 
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube. 
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and CUBES in Analysis Services (SSAS). 
• Created complex SSAS CUBES with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs. 
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers. 
• Developed Dimensions, Data source views, SSAS CUBES, deployed and processed SSAS objects, created SSAS storage and partitions and aggregations. 
• Used ProClarity for accessing and analyzing CUBES and dimensions, and also worked on integration of SharePoint with SSRS. 
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services. 
• Worked on ProClarity to create cost-effective reporting and analytical solutions. 
• Worked on Performance point server and created management reports. 
• Designed code versioning, archiving, and data definition tools for OLTP, B2B, and OLAP databases. 
• Created SQL Server Integration Services (SSIS) packages to import data from heterogeneous data sources like Oracle 9i, SQL Server Text files (CSV, Xls, and XML) 
• Created SSIS packages to clean and load data to data warehouse 
• Created SSIS Packages using Slowly Changing Dimensions, Pivot Transformation, Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse. 
• Performance Tuning the Stored Procedures used in SSIS Packages and SSRS Reports. 
• Used Performance Point Server to create reports, scorecards and dashboards. 
• Created the Stored Procedures, tables, Views depending upon the project requirement. 
• Have been involved in building deployment framework and scripts to deploy into different environment 
• Developed web based ASP.NET internet applications. 
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in Dev & UAT and created technical specs documents for all the enhancements. 
• Installation and configuration of SQL Server Reporting Services (SSRS) 2008. 
• Created tabular, matrix, chart, drilldown reports, parameterized according to business requirement using SSRS. 
• Created complex Stored Procedures for better performance to generate reports. 
• Used Visual Source Safe as Version Control Tool. 
 
Environment: Windows 2008, SQL Server 2008 R2, SSIS, SSRS, SSAS, MDX, OLAP, OLTP, Erwin, Performance Point Server, ETL, ASP.NET, C#, XML, SQL Server Configuration Utility, SQL Query Manager, ProClarity, MS Visual SourceSafe, Data Transformation Services T-SQL, SharePoint, MS Access, Visual Source Safe. 
 
XXXX, Woodbury, MN Sep 08 – Aug 09  
SQL SEVER SSIS/SSRS DEVELOPER  
 
XXXX deals with life insurance, which is basically two types, Term Insurance and Cash value Insurance. Both of them contain different terms depending on policy and pay benefit if anyone dies during the term and has protection for each premium. I also dealt with team leaders of various underwriting departments who needed help with reinsuring a form of non-proportional reinsurance that provides coverage for losses resulting from an accident or natural disaster involving more than one insured. 
 
Responsibilities: 
• Installing different hot fixes for deadlocks, blocking and indexes. 
• Monitored testing servers for long running stored procedures, queries using profiler and recommended clustered and non-clustered indexes using DTA. 
• Created DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS. 
• Experience in mapping multiple related systems. 
• Designed the system architecture that is used to structure, plan, and control the process of developing an information system 
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.  
• Used BCP command line utility to replicate a database. 
• Extensive experience in designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL Server. 
• Used Erwin tool to visualize complex data structures, inventory information assets and establish enterprise-wide standards for managing data. 
• Experience in migrating some of the DTS packages in to SSIS. 
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS 
• Used Recompile and with option query hints to avoid parameter sniffing problems. 
• Improved query performance by adding covered indexes, adding file groups.. 
• Creating and managing schema objects such as tables, views,joins,clusters, indexes,functions,procedures, triggers & maintaining Referential Integrity. 
• Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies. 
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).  
• Developed reports using SSRS 2005 and Crystal reports. Used table control, matrix control for cross tab reports.  
• Configured Reporting Services in SQL Server 2005. 
• Created standard Reports and Cross Tab Reports and Drill Through reports. 
• Generated Reports using Global Variables, Expressions and Functions for the reports. 
• Responsible for scheduling the subscription reports with the subscription report wizard. 
• Created different chart reports helped in analyzing perfmon counters using SSRS 2005. 
• Troubleshooting performance issues with Fragmentation using Profiler, System Monitor and DMV’s. 
• Configured nodes and virtual server to set up Active/Active Clustering. 
• Import Data from MS-Access Database and XML to SQL Server Database. 
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor 
• Involved in Installation, Configuration of SharePoint Form in Cluster Environment.  
 
Environment: SQL Server 2000/2005, Enterprise Edition, SQL, T-SQL, Enterprise manager, SSRS 2005, SSIS 2005, MDX, Spotlight, MS SharePoint, MS Access 2000 & Windows2003/2000platform, C#,VB.NET,ASP.NET. 
 
Meta Software solutions (India) Nov 07 – Aug 08 
MS SQL Server Developer 
 
Meta Solutions is one of the major software corporations, which provide quality software development and information technology-related consulting services for the pharmaceutical and related health care industries.  
 
Responsibilities:  
• Worked as a developer on databases like MS SQL Server 2000, MS Access. 
• Tested to optimize the Stored Procedures and Triggers to be used in production. 
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project. 
• Designed and implemented the Logical and Physical model of the database using Erwin. 
• Planed, defined and designed data flow processes for data migration to the Data Warehouse using DTS. 
• Created Database Objects – Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles. 
• Developed complex T-SQL code for the application.  
• Worked in Enterprise Manager for job scheduling and batch queries. 
• Installed and maintained MS SQL Server 2000. 
• Monitored performance and optimized SQL queries for maximum efficiency.  
• Implemented fine tuning of database objects and server to ensure efficient data retrieval.  
• Managed and monitored the use of disk space.  
• Planned Backup strategy based on projects requirements.  
• Worked with DTS packages and MSOLAP Services. 
• Maintained the consistency of the client’s Database using DBCC. 
 
HDFC Bank Bangalore, India. Aug 06 – Oct 07  
SQL SERVER DEVELOPER/DBA  
 
HDFC Bank provides different financial services. The scope of the project that I worked on was to facilitate in the maintenance and development of the application, which supported personal banking on wealth management, asset management dealing with different types of accounts and services 
 
Responsibilities: 
• Upgraded SQL Server 7.0 to SQL Server 2000. Also Performed SQL Server 2000 Installation 
• Worked on Client/Server tools like SQL Server Query Analyzer to administer SQL Server 
• Created Database Maintenance Planner for improving the performance of SQL Server which covers Database Integrity Checks, Updated Database Statistics and Re-indexing 
• Planned the Complete Backing up of Database and Restored the Database from Disaster Recovery 
• Designed DTS Package, DTS Import/Export for Transferring data from Heterogeneous Database 
• Data migration (import & export - BCP) from Text to SQL Server 
• Clustered Server and Load balancing to maintain the Redundancy of Servers. 
• Configured IIS Server for the XML programming which was a new level of SQL 2000. 
• Configured Exchange Server for sending automatic mails to the respective people when a job failed or succeed 
 
Environment: Microsoft SQL Server 2000/7.0, Microsoft Windows 2000 Server, Microsoft Visual Basic and Microsoft Access 97/2000.

Education

Bachelors

Electronics & Communication Engineering Jawaharlal Nehru Technological University

Additional Information

Databases SQL server […] […] MS Access  
Operating Systems DOS, Linux, Windows […] 
OLAP/Reporting Tools SSAS, (SSRS), MDX, Crystal Reports.  
ETL Tools SQL Server Integration Services (SSIS), SQL Server DTS, ETL Informatica. 
Other Tools Microsoft Visual Source Safe, Microsoft Office, MS Visio. 
Data Modeling Tools Microsoft Visio […] Erwin, LiquidXML, JDBC, Dreamweaver, Macro Express, 
SQL Server Tools SQL server Management Studio, SQL server Query Analyzer, SQL server mail service , DBCC, BCP , SQL server profiler 
Programming languages C,SQL,PL/SQL,T-SQL,.NET,C#, C++, Java, Pascal, COBOL, Unix, Assembly( […] ) 
Data Warehousing & BI SQL Server, Business Intelligence Studio, SSIS, SSAS, Access Manager, SQL Server 2008 Analysis Services and SQL Reporting services, DTS, ProClarity, PPS-2007, MOSSf