*Ganga G* *a...@netgentechnology.com*
*201 299 3902* * * *Summary* Ø Over 9 years of IT experience, which includes functional and technical expertise in *Business Intelligence*. Ø More than 7 years of extensive experience of *MS SQL server* with Business Intelligence in SQL server reporting services, SQL server Integrating services, SQL server analysis services (*SSAS, SSIS & SSRS*). Ø More than 2 years of extensive experience of MS* *SQL Data Base Administration (DBA). Ø Extensively worked with financial clients and have excellent knowledge in *Credit Risk area in *asset management. Dealt with *counterparties*, *equities, derivatives, treaties and insurance related parameters.* Ø Excellent technical and analytical skills with clear understanding of design goals of *Dimension Modeling* for *OLAP *and* Entity Relationship Modeling (ER Modeling)* for *OLTP and expertise in using with modeling tools Erwin and Visio**.* Ø Expertise in using *ETL* tools like *SQL Server Integration Services (SSIS),* *Data Transformation Services (DTS). *Expert in creating *dimensions, fact tables *required for designing* Cube *using SSAS. Ø Worked on Creating *Error Handlers for debugged* the packages in *SSIS.* Ø Demonstrated expertise in creating different type of reports like *parameterized reports, linked, drilldown, drill through, sub reports,dash boards using reporting tools like *using *Intellisys, SQL Server Reporting Services(SSRS).*** Ø Worked with *Quality Center* and *FogBugZ* tools for created tickets, bugs or new features.** Ø Worked in a team environment using *Team Foundation Server (TFS) *and*GIT. * Packages and Reports were checked-in and checked out after making changes. Ø Excellent experience in working with different *Control flow *and* Data flow tasks *and creating *packages * using SQL Server Integration Services ( *SSIS*). Ø Worked with BI objects such as Basic InfoCubes, ODS, Real-Time and Write-Optimized DSOs, MultiProviders, InfoSets (Info-providers), DataSources, InfoPackages, InfoSources, Transformations, Data Transfer Processes (DTPs). Ø 3+ years of experience in* WebForms *and applications usin*g ASP.NET *wit *h *C#,* AJAX* Ø Expertise with *T-SQL* in writing *complex queries*, *triggers, tables, user functions, views, indexes, partitions,* user profiles, relational database models, data dictionaries, and maintaining data integrity.** Ø Worked on creating *Transaction Logs* for storing the changes made while performing the *ETL* Ø Experience in developing and integrating a* *JDBC SAP adapter to a Composite Information Server for virtual data integration. Ø Experienced in data dictionary, Data source Enhancement, OLTP extraction data and loading. Ø Knowledgeable in programming using scripiting languages like *PERL *and *shell scripting.* Ø Expert in reporting using *Intellisys*, Reportrak, Crystal Reports, Business Explorer, and Web Application Designer. Experienced in implementing Queries, Calculated and Restricted Key figures/measures, variables, workbooks, security roles, web reports and profiles. Ø Handson experience in building ETL jobs using *Business Objects* Data Integrator. *AREAS OF EXPERTISE* *Category* *Technology* Database SQL Server 2000/2005/2008/2012 SQL DBA, T-SQL, Installation, Upgrade, & Migration Extracting, Transformation and Loading (ETL) SQL Server Integration Services (SSIS) and DTS SQL Server Reporting Services (SSRS) Hyperion Crystal Reports 10 SQL Server Analysis Services (SSAS) Hand on experience with SQL Server Replication, Log Shipping, Failover Clustering, Database Mirroring Operating Systems Windows Enterprise 2003/2000 Advanced Server/2000 Server/Windows 2000 Professional/Windows XP Professional, Windows Vista, Windows 7 Applications Erwin 3.5/4.1/7, Microsoft Visio Visual Studio 6.0/.NET/2005/2008/2010 Team Foundation Server Language C, ASP.NET, C#, HTML, XHTML, XML, CSS, PHP, JavaScript Protocols HTTP, TCP/IP, FTP Administering Database Engine Security, Managing SQL Servers, Managing Large Databases, Linked Server, High Availability, Importing Exporting Bulk Data, Backing up Restoring, Deploying Application Packages MS Office 2007, MS Office Excel, MS Power Point, Access *With Regards,* * * *Andy Jones* *Net Generation Technology LLC* *24 Celtic Way* *Parsipanny, NJ 07054.* *Phone: 201 299 3902*** *Email:a...@netgentechnology.com* -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-basis+unsubscr...@googlegroups.com. To post to this group, send email to sap-basis@googlegroups.com. Visit this group at http://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/groups/opt_out.